Snippets
mysqli

How-to articles, tricks, and solutions about MYSQLI

Codeigniter: fatal error call to undefined function mysqli_init()

Here's an example of how the error might appear in a Codeigniter application:

php mysqli codeigniter

Commands out of sync; you can't run this command now

The "Commands out of sync; you can't run this command now" error in PHP usually occurs when you have called a MySQL function in an incorrect order.

php sql MySQL mysqli

Example of how to use bind_result vs get_result

The mysqli_stmt::bind_result() method binds variables to a prepared statement for result storage.

php MySQL mysqli prepared-statement

Fatal error: Call to undefined function mysqli_connect()

This error message indicates that the mysqli_connect() function is not defined.

php mysqli

get array of rows with mysqli result

You can use the mysqli_fetch_assoc() function to retrieve an associative array of a single row from a result set, and use a loop to iterate through the result set and store each row in an array.

php mysqli

Headers and client library minor version mismatch

If you are seeing this error message in PHP, it may be caused by a mismatch between the version of the PHP client library that you are using and the version of the API that it is trying to access.

php ubuntu mysqli warnings

How can I enable the MySQLi extension in PHP 7?

To enable the MySQLi extension in PHP 7, you need to follow these steps.

php MySQL php-7 mysqli

How do I display a MySQL error in PHP for a long query that depends on the user input?

To display a MySQL error in PHP for a long query that depends on user input, you can use the mysqli_error() function.

php MySQL mysqli

How to install MySQLi on MacOS

To install MySQLi on a Mac, you will first need to install the MySQL database server on your machine.

php macos mysqli

mysqli or PDO - what are the pros and cons?

mysqli and PDO are both PHP extensions used for interacting with databases.

php MySQL pdo mysqli database-abstraction

1 2 > >>