PHP MySQL functionsThere are many PHP functions which works in MySQL to execute queries. PHP & MySQL has became most popular web scripting language in internet today because of these functions and flexibility of PHP program. There are many popular scripts for forums, content management, classified programs, e-commerce sites etc runs in PHP scripts by using MySQL database. To manage these scripts we use these PHP functions.
We will discuss these functions in detail with examples to make it simple to understand.
How many rows or records get updated or deleted or affected by a given query.
Adding one incremented auto number to each record once added.
Closing one open connection to MySQL database.
Connecting string to store userid and password and database name to connect to MySQL
Create a database in MySQL
List the name of all databases in MySQL
Associated error number of each mysql query
Error message after executing a query
we can get the type of field with all other details about the field
get the length of data used in all fields of a record
get the row of data from a MySQL table
getting the field flags associated with the field.
Type of field used in MySQL table.
Get the auto increment id of the last inserted record
List of database in MySQL
List of tables present in a database
Number of fields present in a query or in a table
Getting the total number of rows in a query or in a table
Persistence connection to MySQL database from PHP script
Function to execute any query statement in MySQL database