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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.