Snippets
MySQL

How-to articles, tricks, and solutions about MYSQL

How to Check if a Record Exists in a MySQL Database

In this tutorial, we are going to represent to you two handy options of how to check if a record exists in the database with PHP.

php database MySQL

How to Convert MySQL Data to JSON with PHP

If you wonder how to find a proper way of converting MySQL data to JSON format using PHP, then you are in the right place. Read on and check the example.

php json MySQL json_encode

How to count and group by in yii2

In Yii2, you can use the count() and groupBy() methods in the query builder to count and group the results of a query, respectively.

How to create a foreign key in phpmyadmin

To create a foreign key in PHPMyAdmin, follow these steps:

php database MySQL phpmyadmin

How to create virtual column using MySQL SELECT?

To create a virtual column using a MySQL SELECT statement, you can use the AS keyword to assign a name to an expression in the SELECT statement.

php select 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

In PHP with PDO, how to check the final SQL parametrized query?

In PHP with PDO, you can use the debugDumpParams() method on a prepared statement object to view the final SQL parametrized query.

php MySQL pdo prepared-statement

Increment value in MySQL update query

To increment a value in a MySQL update query using PHP, you can use the += operator.

php sql MySQL sql-update

Insert data into multiple tables using one form

To insert data into multiple tables using one form in PHP, you can use a single SQL statement with multiple INSERT INTO clauses, or you can use multiple individual SQL statements, one for each table.

php MySQL

Installing specific package version with pip

To install a specific version of a package with pip, you can use the pip install command followed by the package name and the desired version number.

MySQL python pip pypi mysql-python

Invoking a PHP script from a MySQL trigger

It is possible to invoke a PHP script from a MySQL trigger by using the system() function in the trigger's body.

php MySQL triggers

java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)

A java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) error typically indicates that the MySQL server is unable to authenticate the user with the provided username and password.

java MySQL exception jdbc connection

Laravel Delete Query Builder

In Laravel, you can use the Query Builder to delete records from a database table.

php MySQL laravel-4

Laravel Eloquent LEFT JOIN WHERE NULL

In Laravel, you can use the leftJoin method on a query builder instance to perform a left join, and then use the whereNull method to only include records where a column from the right-hand table is null:

php MySQL laravel laravel-4 eloquent

Laravel Migration table already exists, but I want to add new not the older

If you have an existing table in your database that you want to add new columns to using a Laravel migration, you can use the Schema::table method to modify the existing table.

php MySQL laravel

Laravel: getting a single value from a MySQL query

To get a single value from a MySQL query in Laravel, you can use the value method on a query builder instance.

php sql MySQL laravel

1 2 3 4