PHP – MySQL

PHP – MySQL to CSV

The given PHP example takes a mysql query and turns it into a csv file that downloads automatically. Code Example:

Read more »

PHP – Class MySQL Database Queries

This PHP class can execute MySQL database queries using arrays. It can connect to a MySQL database and execute SELECT queries retrieving the results as associative arrays. The class can also execute INSERT or UPDATE queries taking arrays of field values. It can also execute DELETE queries. Code Example:...

Read more »

PHP – Delete Data from MySQL database

The given PHP example helps you to delete the data from MySQL database against a specific Id. Code Example:

Read more »

PHP – Get the number of affected rows by the last INSERT, UPDATE, REPLACE or DELETE query.

The given PHP example helps you to get the number of affected rows by the last INSERT, UPDATE, REPLACE or DELETE query associated with link_identifier. Code Example:

Read more »

PHP – MySQL Processes Information

The given PHP example helps you to get the info of all mysql processes. Code Example:

Read more »

PHP – Display All Rows and Fields of a Table

The given PHP example helps you to display all the rows and the fields of a table. Code Example:

Read more »

PHP – Tables and Fields Info

The given PHP example helps you to get the info of all tables and the fields of a database. Code Example:

Read more »

PHP – Get MySQL Server Info

The give PHP example helps you to get the useful info about the MySQL server. This could be: 1: MySQL server information. 2: MySQL host information. 3: MySQL client information. 4: Print all MySQL status value. Code Example:

Read more »

PHP – List All Tables of a Database

The given PHP example helps you to list the all tables of a database. Code Example:

Read more »

PHP – Table Data Insert

The given PHP example helps you to add the new records into a database table. Code Example:

Read more »

PHP – Create a Database in MySQL

The given PHP example helps you to create a database in MySQL. Code Example:

Read more »

PHP – Listing the Databases Available in a Connection

The given PHP example helps you to listing the databases available in a connection. Code Example:

Read more »

PHP – Connect to MySQL Database

The given PHP example helps you to make a connection with MySQL Database and then get the record form a table. Code Example:

Read more »