w3docs logo
  1. Snippets
    2. ›
  2. MySQL

How-to articles, tricks, and solutions about MYSQL

Docker MYSQL '[2002] Connection refused'

The '[2002] Connection refused' error in Docker when trying to connect to a MySQL container typically indicates that the MySQL server is not running or is not accessible on the network.

php symfony MySQL docker

error in your SQL syntax; check the manual that corresponds to your MySQL server

This error message is indicating that there is a problem with the SQL syntax used in the query.

php apache MySQL ubuntu-server

Error when preparing a multiple insert query

There are a few things that could cause an error when preparing a multiple insert query in PHP.

php MySQL pdo

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

Executing multiple SQL queries in one statement with PHP

In PHP, you can execute multiple SQL queries in one statement by using the mysqli_multi_query() function.

php MySQL

Export MySQL database using PHP

To export a MySQL database using PHP, you can use the mysqldump command-line utility or the mysqli extension.

php MySQL backup

Fatal error: [] operator not supported for strings

This error is usually caused when you are trying to use the square brackets [] to access a character in a string, but this is not supported in PHP.

php MySQL

How can I count the numbers of rows that a MySQL query returned?

You can use the mysqli_num_rows() function to count the number of rows that a MySQL query returned in PHP.

php MySQL

How can I employ "if exists" for creating or dropping an index in MySQL?

In MySQL, you can use the "IF EXISTS" clause when creating or dropping an index to prevent an error from occurring if the index does not exist.

php MySQL indexing

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