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. ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access