Database with PHP

Connection

Singleton pattern is used for database connection

Insert, update and delete

In the add-update-delete_user.php file, the code can be used for update and delete.

Prepared Statement

In the add-update-delete_user_prepared.php file, the code can be used for update and delete.

Selection

An example in select_users.php.
Select and viewing the result in a table.
There is a comment shows how to use SELECT query like the prepared statement.