IS 337: Website Administration

Lecture for November 24: Even More SQL

+
-

Topics

Urlacher Shop

code handout

  • Unhappy path: What if cart is empty when checking out?
  • Sorting toggle
    • XML: done in PHP with *sort() functions.
    • SQL: toggle
      • Could do it in PHP.
      • Better in SQL with ORDER BY: optimized for sorting; SQL indexes
  • Saving user's preference toggle
    • Cookie or session?
  • Handling SQL injection: sqlite_escape_string($string)

Templating

Readings and Resources

Creative © 2007 Calvin College and Jeremy D. Frens.
This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 United States License.