Tagged articles
MySQLi
29 articles · Page 1 of 1
This guide shows how to use PHP's mysqli_num_rows function to obtain the number of rows returned by a MySQL query, including connection setup, error handling, executing a SELECT statement, retrieving the count, and important considerations when the query fails.
MySQLiRow Countdatabase
0 likes · 3 min read

This guide shows how to connect to a MySQL database in PHP, execute a SELECT query, and use the mysqli_num_rows function to obtain the number of rows returned, including error handling and proper connection closure.
MySQLidatabasemysqli_num_rows
0 likes · 3 min read

This guide explains why closing MySQL connection pools in PHP is essential for performance, describes the basics of connection pooling, and provides step‑by‑step code examples for creating, using, and safely releasing connections, including a destructor‑based cleanup method.
BackendMySQLMySQLi
0 likes · 5 min read

This guide shows how to use PHP's mysqli_num_rows function to retrieve the number of rows returned by a MySQL query, including a complete example that connects to the database, runs a SELECT statement, checks for errors, obtains the row count, and closes the connection.
MySQLiPHPRow Count
0 likes · 3 min read

Learn how to establish, use, and close MySQL database connections in PHP with detailed MySQLi and PDO examples, covering object‑oriented syntax, prepared statements, error handling, and best practices for secure and efficient backend development.
Database ConnectionMySQLMySQLi
0 likes · 4 min read

Learn how to use PHP’s mysqli_num_rows function to retrieve the number of rows returned by a MySQL query, with a complete example that shows connecting to the database, executing a SELECT statement, handling errors, and outputting the row count.
MySQLiRow Countdatabase
0 likes · 3 min read

This tutorial walks you through establishing MySQL connections in PHP using both the mysqli extension and PDO, covering procedural and object‑oriented code, prepared statements, error handling, and proper connection closure for robust backend development.
BackendMySQLMySQLi
0 likes · 4 min read

This tutorial demonstrates how to connect to a MySQL database in PHP using mysqli_connect, execute queries with mysqli_query, and retrieve each row as an associative array using mysqli_fetch_assoc, providing complete code examples and a full script for efficient backend data handling.
MySQLMySQLiPHP
0 likes · 4 min read

This article explains how to use PHP's mysqli_num_rows function to retrieve the number of rows returned by a MySQL query, providing a step‑by‑step example that connects to the database, executes a SELECT statement, checks for errors, and outputs the row count.
MySQLiPHPdatabase
0 likes · 3 min read

This article demonstrates how to use PHP's mysqli_num_rows function to retrieve the number of rows returned by a MySQL query, including a complete example that connects to the database, executes a SELECT statement, checks for errors, obtains the row count, and outputs the result.
MySQLiPHPdatabase
0 likes · 3 min read

This article explains how to use PHP's mysqli_query function to perform MySQL operations such as SELECT, INSERT, UPDATE, and DELETE, providing a step‑by‑step example that creates a database connection, executes a SELECT query, processes results, and closes the connection.
MySQLMySQLiSQL
0 likes · 5 min read

This article explains how to connect to a MySQL database using mysqli in PHP, execute a SELECT query, and retrieve each row with the mysqli_fetch_assoc function, providing complete example code and notes on handling results and closing the connection.
MySQLiPHPdatabase
0 likes · 3 min read

This article demonstrates how to connect to a MySQL database using mysqli, execute SELECT queries, and retrieve results row by row with the mysqli_fetch_assoc function in PHP, providing complete code examples for connection, querying, result iteration, and proper resource cleanup.
MySQLMySQLiPHP
0 likes · 4 min read

This article explains how to use PHP's mysqli_num_rows function to retrieve the number of rows in a MySQL result set, providing a complete example that connects to a database, executes a query, checks for errors, obtains the row count, and outputs it.
MySQLMySQLiPHP
0 likes · 4 min read

This article explains how to use PHP's mysqli_query function to connect to a MySQL database, execute SELECT, INSERT, UPDATE, and DELETE statements, and process results, including a complete example code snippet demonstrating connection, query execution, result handling, and cleanup.
BackendMySQLiquery
0 likes · 4 min read

This article explains how the PHP mysqli_query function can be used to run SELECT, INSERT, UPDATE, and DELETE statements against a MySQL database, provides a complete example with connection handling, error checking, result processing, and highlights related fetching functions.
BackendMySQLiquery
0 likes · 4 min read

This article explains how to connect to a MySQL database in PHP, execute a SELECT query, and use the mysqli_fetch_assoc function to fetch rows as associative arrays, including sample code and notes on handling multiple rows and error checking.
BackendMySQLiassociative array
0 likes · 4 min read

This article explains how to connect to a MySQL database with mysqli_connect, execute queries using mysqli_query, and fetch each row as an associative array with mysqli_fetch_assoc, providing a complete PHP code example and best‑practice tips.
BackendMySQLiPHP
0 likes · 4 min read

This tutorial explains how to connect to a MySQL database using PHP's mysqli extension, execute queries, and retrieve results with mysqli_fetch_assoc, providing step-by-step code examples for connection, querying, and a complete script.
MySQLMySQLiSQL
0 likes · 4 min read

This article explains how to use PHP's mysqli_query function to perform MySQL operations such as SELECT, INSERT, UPDATE, and DELETE, including a full example that creates a connection, runs a query, processes results, and closes the connection.
BackendMySQLiPHP
0 likes · 4 min read

This tutorial explains how to connect to a MySQL database using PHP's mysqli extension, execute queries with mysqli_query, and retrieve each row with mysqli_fetch_assoc, providing complete code examples and a full script for efficient database handling.
MySQLMySQLiPHP
0 likes · 4 min read

This article explains how to use PHP's mysqli_num_rows function to retrieve the number of rows returned by a MySQL query, including a complete example with connection handling, error checking, and output of the row count.
MySQLMySQLiPHP
0 likes · 3 min read

This article explains how to connect to a MySQL database with PHP, execute a SELECT query, and use the mysqli_fetch_assoc function to fetch rows as associative arrays, including code examples and best‑practice notes for handling multiple rows.
BackendMySQLiTutorial
0 likes · 4 min read

This tutorial explains how to connect PHP to databases using both mysqli and PDO, covering connection setup, error handling, executing queries, and properly closing the connection, with complete code examples for each method.
Database ConnectionMySQLMySQLi
0 likes · 4 min read

This tutorial explains how to create a MySQL database on a Linux system using PHP's mysqli extension, covering prerequisite installations, establishing a connection to the MySQL server, and executing SQL statements to create the database, with complete code examples and instructions for customizing credentials.
BackendMySQLidatabase
0 likes · 4 min read

This article explains how to set the correct character encoding for web pages and demonstrates PHP functions such as meta charset, iconv, urlencode/urldecode, and mysqli_real_escape_string with practical code examples to ensure proper display and safe database insertion.
IConvMySQLiPHP
0 likes · 5 min read

This article explains how PHP can connect to various databases, execute queries, fetch results, insert or update records, close connections, handle errors, and address security concerns, providing code examples for both MySQLi and PDO extensions.
MySQLiPDOPHP
0 likes · 5 min read

The article explains why directly concatenating user input into SQL queries leads to injection vulnerabilities and demonstrates how to secure PHP database operations using input validation, escaping functions, and prepared statements with MySQLi and PDO, while comparing related sanitization functions.
MySQLiPDOPHP
0 likes · 5 min read

This article explains how to use PHP's mysqli extension to establish and close MySQL connections, handle connection errors, perform CRUD operations, process query results, execute multiple statements, and manage transactions, providing code examples for each step.
BackendCRUDMySQL
0 likes · 8 min read
