Learning PHP & MySQL

To the Bottom of the Page

Links to online resources:

• Online MySQL reference manual & other documents from the official MySQL website
• Online PHP reference manual & more the official PHP website

Tools needed to access PHP & MySQL support on the Computer Science OS X server

• First of all, you need an account to access the OS X server. If you are a Computer Science major or minor or a Biola student taking related computer science course, you’ll get one.
• Read the “how to” explanations here carefully to regarding the software tools needed to access the PHP & MySQL support.

Very basics of MySQL: creating tables, adding records, submitting queries

Lab #2: First exposure to MySQL server.

Lab #3: More exposure to MySQL.

Lab #4: Using subqueries.

Very basics of web programming

Lab #5.1: Using FileZilla, PuTTY, phpMyAdmin to set up a simple web page and a simple MySQL table all under your own account on the CS X server.

Lab #5.2: Using FileZilla, PuTTY, phpMyAdmin to set up a simple online bookstore on the CS X server.

Lab #6: Try your own on the basics of HTML, user input through HTML forms, and processing of input through PHP.

Lab #7: Try your own for using web pages and PHP scripts to process user input through forms and interact with MySQL.

Basic authentication in PHP

• Try the following pages secret.php (passwords encoded in the script, try user and pass), secretDB.php (passwords stored in a table created by this sql script ), http.php (using PHP basic authentication)
• Read Chapter 16 of PHP-MySQL Web Development for explanation of the details.
• Read the related PHP scripts and web pages from the book 1.

To the Top of the Page