Learn how to issue basic mySQL queries using PHP and how to properly validate SQL queries before issuing them to the database server to prevent possible attacks or unauthorized access

Learn how to print all data in a mySQL table into a neat HTML table to be displayed in your web browser. You do not even need to know the individual field names in the mySQL table, just provide the mySQL table to use and the process is complete. Easy to understand and can be adapted by you to suit your needs.

The author writes: Whilst working on the automatic production of web statistics - came across the following problem: "How do I get relational data from an Hierarchical structure?" It didn't take long to realize - I'd have to use PHP to talk to LDAP, pull off records & upload into a series of tables, using the cn as primary key. Which then could be queried relationally. Pulling off large, queries and repeatedly transcending LDAP trees is pretty slow - so I built my LDAP to SQL engine, by flattening dns into table names. Then used PHP scripts to query & produce daily snap shots.

What is MySQL? How does it work? : And how do you work with it? This tutorial is a great place to get started using PHP & MySQL. Includes some code samples, explaination and resources.

shows you how to generate a table with alternating row colours from a MySQL databse.

Learn how to make pagination ([1][2][3]) with some lines of code, very explained.

This article provides a comparison of three popular table editor libraries and applications. Namely, the TableEditor Library (available form phpguru.org), phpMyEdit and dbPerceptor.

Here is how to work with Excel files and PHP.

This comprehensive mysql tutorials touches on Starting a Session with MySQL,Executing SQL Statements against a MySQL database and demonstrating how a SELECT SQL statement is executed against the selected database. features full code and examples.

This script is a real world application that shows how to use MySQL with PHP. You can learn from the step by step commented php source code how to build a php program that uses MySQL to keep a database of your books. Program functions implemented include, saving a new record, listing of records for user selection, selection of a record and displaying its details, updating a record, deleting a record and searching for records. Once you have learned the techniques used in this program, you can build any php-mysql based programs.