What PHP/MySQL book would be good as a textbook? [closed]

Question

I'm possibly teaching an undergraduate PHP/MySQL course in the Fall and was wondering if anyone has any recommendations for good textbooks.

The books have to be geared towards a beginner/medium level (I'm assuming/hoping my students will have C++ and MsSQL classes prior to mine).

Topics I want to cover in PHP:

• Variables/Constants
• Conditionals
• Loops/Loop Control
• Functions
  • Strings
  • Arrays
  • Dates
  • Custom
• Form Data
• Session/Cookie/Server variables
• MySQL integration
  • Query/Error
  • Prepared Statements
  • MySQLi Class

In MySQL:

• Schema/Users/Tables/Columns/Rows
• Primary/Foreign/Constraints
• Data Types
• Queries
  • Select/Update/Insert/Delete/Truncate
  • Limit/Order By/Group By

Possibly deal with:

• Stored Procedures/Triggers
• Image Manipulation/Custom Classes

Answer 1

Welling & Thomson's PHP and MySQL Web Development is the gold standard:

http://www.amazon.com/PHP-MySQL-Development-Developers-Library/dp/0672329166/ref=pd_bbs_sr_1?ie=UTF8&s=books&qid=1236994701&sr=8-1

Answer 2

I don't know anyone who learned PHP from a book, just online tutorials or the PHP manual. I would say look on Amazon to find a book that covers the topics you want in your course.

Maybe like this. http://www.amazon.com/Beginning-PHP-MySQL-Novice-Professional/dp/1590598628/ref=pd_bbs_3?ie=UTF8&s=books&qid=1236970221&sr=8-3