Notes on SQL style: Many SQL queries are one long line of code. Most accomplished programmered recommend you break u every sql statement into more lines for maximum legibility. For ex.
Recommeded database permissions:
Web visitor: SELECT only
Contributor: SELECT, INSERT, and maybe UPDATE
Editor: SELECT, INSERT, UPDATE and maybe DELETE and maybe GRANT
DB Admin: SELECT, INSERT, UPDATE, DELETE, GRANT and DROP
Put the database variables you use infrequently in a non-Apache-readable directory and change the permissions when on the rare occassion you need to make changes.
mysqldump - u username -p databasename > dumpfilename.sql
If a query was an INSERT, UPDATE, DELETE, CREATE TABLE, or DROP TABLE and it returned TRUE then you can use mysql_affected_rows to see how many rows were changed by the query.
PHP 5 CMS Framework Development
by Martin Brampton
Packt Publishing, 2010
These are notes I made after reading this book. See more book notes