Basic Web Programming with The Computer Gal

This book is available in The Lifelong Learning Center bookstore or from Amazon by clicking the image.

The Computer Gal on Facebook
Ask to receive tips and handouts to your email.

Please note that this syllabus may be revised throughout the course, as I find new materials.

Course Objectives

To review and use basic programming structures and syntax: variables, functions, if statements, loops, function calls, passing variables and values, the importance of naming conventions in variables and functions
To understand basic database design
To set up a MySQL database in PHPMyAdmin
To be able to create and use simple MySQL queries and the resulting recordsets.
To create and document programming flow for pages that SELECT, INSERT, UPDATE and DELETE from a database
To understand the backend admin structure that accompanies a frontend, public, dynamic web page

Days	Topics	Web References
1	Review and Project Setup Topics Course overview Choose projects and plan functions Review echo and single or double quotes Review variables Review calculations
2	Plan and Create the Login Form Topics Plan and create the database table Plan and create the database table Plan the programming flow Create the form Program the login
3	Plan and Create the Add Form Topics
4	Plan and Create the List Page Topics
5	Plan and Create the Delete Form
6	Plan and Create the Edit Form
7	Plan and Create Pagination
8	Form Validation Understanding page states Programming logic - what steps do we need the program to do? Connecting to a database Getting data from the database - SELECT - what will you get for the image and how will you make it work? Using the data set on the page. Example: do you see the PHP code?
9	Feeding PHP Query Results into a Google Map
10	Is there anything besides PHP and JavaScript?