PHP - Working with MySQL Database in PHP

A collection of tutorials to answer many frequently asked questions on how to Work with MySQL Database in PHP. Clear explanations and tutorial exercises are provided on connecting and selecting MySQL database, creating and dropping tables, inserting, updating, and deleting rows, selecting and looping through data rows, searching by key words, setting auto-increment IDs. Topics included in this collection are:

Installing MySQL Server in PHP

Using MySQL Command Line Interface in PHP

Information Needed for MySQL Connection in PHP

Connecting to a MySQL Server in PHP

Creating a Database in PHP

Selecting an Existing Database in PHP

Running a SQL Statement in PHP

Creating a Table in PHP

Number of Rows Affected by a SQL Statement in PHP

Inserting Data into a Table in PHP

Inserting Rows Based on SELECT Statement in PHP

What Is a Result Set Object in PHP

Looping through Returning Rows from a Query in PHP

Updating Existing Rows in PHP

Deleting Existing Rows in PHP

Quoting Text Values in PHP

Quoting Date and Time Values in PHP

Performing Key Word Search in PHP

Querying Multiple Tables Jointly in PHP

Setting ID Column as Auto-Incremented in PHP

Retrieving the Last Auto Increment ID in PHP

⇒⇒PHP Tutorials

2016-10-22, 466👍, 0💬