Generating Query Results

Now that the database has been created in MySQL, I can write the PHP scripts that will interface with it. First, I'll identify my particular needs here, then explain four database concepts—join, alias, order by, and limit—with which you may or may not be familiar. Most PHP programmers understand the basics of accessing a database but less about the particulars of the database itself. I'm focusing in this section on the capabilities of SQL and the DBMS because using the built-in power of your DBMS can improve the performance and overall quality of your Web application.

My needs for accessing this database are simple: I would like to be able to enter new books and browse through the books that have already been entered. ...

Get PHP Advanced for the World Wide Web: Visual QuickPro Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.