Yesterday in class we covered these three things:
- Review of Khan Academy’s “More advanced SQL queries” (slides)
- Step by step, how jQuery Ajax operates in the Shoutbox project (slides)
- How to use PHP’s
mysqli_commands and prepared statements to prevent SQL injection attacks (Google doc — we covered pages 1–7)
We also got our first look at the Sock Market database app, which serves as an example for your Assignment 2.
The slides from the previous week cover the first part of Khan Academy’s SQL course, which introduces the essential
INSERT INTO and
SELECT FROM commands.