Web Dev Intensive

Discussions

Basic PHP-related:

• Persistent data
• Passing data with forms
• Sending email in PHP
• Uploading files to a server

MySQL database-related:

• Intro to relational databases
• More info about databases
• Examples of SQL CRUD commands
• Using phpMyAdmin to administer a database
• Making timestamps user-friendly
• A simple CMS for SQL CRUD

Examples

Basic PHP-related:

• Sending an email in PHP
• Cookies – A very simple example of setting and getting a cookie in one page
• Cookies – getting and setting a cookie in two different pages
• Passing data with forms – using the GET method or the POST method
• Combination of passing data with a form and then storing it in a cookie (use this page to test the value stored in the cookie)
• Passing data with the query string of a link
• uploading a file to the server

MySQL database-related:

• SQL CRUD (create, read, update, delete)
• A simple CMS for SQL CRUD
• A slightly more sophisticated CMS for SQL CRUD
• Blog example

In-class assignment

Basic PHP-related:

• Passing data assignment.  This assignment covers all the core topics of PHP except database integration, such as include files and passing data from one page to the next using forms, links, and cookies.

MySQL database-related:

• Database assignment.  Take your e-commerce PHP multidimensional array assignment from last week and change the PHP so that the products are coming from a database table of products.  If you haven’t finished the last assignment, do that first.  See this overview of setting up database tables using phpMyAdmin.  You will be integrating your own code with the read aspect of my SQL CRUD commands post and example files above.  If you get finished early, continue on to the assignment below.

Homework assignment

• Read through the Tizag MySQL tutorials… be aware that the way this site tells you how to Connect, Setup, Administer, and Create tables in your database is not how we are doing it in this class.  We are using our phpMyAdmin tool to do these things for us, which makes  life easier.  See the discussion about using phpMyAdmin to administer a database towards the top of this page.
• Message board assignment
• Advanced assignment (optional)