|mysqli||MySQL Improved Extension |
This provides both an object oriented interface and a procedural (simple function call) interface.
|PDO||PHP Data Objects |
This makes your code database independent. Using this you can change from MySQL to another database type without having to change you code. (We all know that isn't true, but it is a nice thought.)
|classic||This uses function calls, no objects - I have described it below so you can use it if you have to, but it is deprecated and should not be used for new designs|
Connecting to the database
The constants simplify moving the database from a development system to a production system on another computer - only one file has to change. Typically, the user name and password will be different for security reasons. In addition, the prefix test_ will be removed from the database name.
Closing the database connection
Main page goes here