w3docs logo
  1. Snippets
    2. ›
  2. MySQL

How-to articles, tricks, and solutions about MYSQL

How to display a date as iso 8601 format with PHP

You can use the date() function in PHP to display a date in ISO 8601 format.

php date MySQL date-format time-format

How to get ID of the last updated row in MySQL?

To get the ID of the last inserted row, you can use the LAST_INSERT_ID() function.

php MySQL

How to get primary key of table?

To get the primary key of a table in PHP, you can use the SHOW KEYS SQL statement to retrieve information about the keys (including the primary key) of a table.

php MySQL primary-key

How to include a PHP variable inside a MySQL statement

To include a PHP variable inside a MySQL statement, you need to use prepared statements with bound parameters.

php string sql MySQL variables

How to print exact sql query in zend framework ?

In Zend Framework, you can use the Zend_Db_Select object's __toString() method to print the exact SQL query that will be executed.

php MySQL zend-framework zend-db

How to properly set up a PDO connection

To set up a PDO connection, you will need to do the following:

php class sql MySQL pdo

How to resolve ambiguous column names when retrieving results?

When retrieving results in PHP and encountering ambiguous column names, you can use table aliases to specify which table the column belongs to.

php sql MySQL mysql-error-1052

How to separate DATE and TIME from DATETIME in MySQL?

You can use the DATE() and TIME() functions to extract the date and time parts of a DATETIME value in MySQL.

php sql datetime MySQL

How to store file name in database, with other info while uploading image to server using PHP?

To store the file name in a database along with other information while uploading an image to a server using PHP, you can follow these steps:

php database MySQL file-upload image-processing

How to use multiple databases in Laravel

Using multiple databases in Laravel is quite easy.

php database MySQL laravel