The MySQLi(MySQL Improved) is a relational database driver used in the PHP programming language to provide an interface with MySQL databases.
There are three main API options when considering connecting to a MySQL database server:
1. PHP's MySQL Extension
2. PHP's MySQLI Extension
3. PHP Data Objects (PDO)
Following is SQL Query for test the PHP Code:
The MySQLI extension supports dual interface procedural and object-oriented programming paradigm.
MySQL database connection with PHP's MySQLI driver using procedural programming.
MySQL database connection with PHP's MySQLI driver using object-oriented programming.
Following are MySQLI Functionalities.
1. An object-oriented interface
2. Supports server-side Prepared Statements
3. Supports Stored Procedures
4. Support for multiple statements
5. Support for transactions
6. Enhanced debugging support
7. Embedded server support
8. API supports Charsets
9. Result set contains metadata: It have information about table along with result.
Related Posts are Following:
1. Advanced MySQL Interview Questions and Answers for Experienced
2. How to delete MySQL Binary logs Files in Wamp Server?
3. SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 2269548 for key PRIMARY
4. Multiple column ordering in Zend Framework
5. Mysql Privileges - Types of privileages in MySql - How do I grant privileges in MySQL
6. Difference Between Primary Key And Unique Key And Foreign Key And Composite Key
7. Difference Between MyISAM and innoDB - MySQL
8. MySQL Functions - MySQL tutorial for beginners
9. mysqlsubqueries examples Scalar Subqueries Row Subqueries Column Subqueries Table Subqueries
10. Mysql FullText Search Examples
11. MySQL Constraint Example
12. MySQL Cascade Example
13. Mysql-Group-Concat
14. MySQL Expressions
15. MySQL Delete Table Example
16. Replace Table - Update Field, Move Records to another table MySQL
17. mysql insert syntax - Add records from another table - Copy Table from one table to another
18. Mysql Update Syntax - Update Multiple Records
19. What is Mysql
20. Mysql Console Commands - Export and Import database from command line