MySQL – Auto Delete Foreign keys data with Primary Key data
User table UserStaff Table
PHP – MySQL to CSV
The given PHP example takes a mysql query and turns it into a csv file that downloads automatically. Code Example:
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… (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:
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:
PHP – MySQL Processes Information
The given PHP example helps you to get the info of all mysql processes. Code Example:
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:
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:
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: