Welcome to the PHP Tutorial Site

Take your time! There is quite a bit of information here to digest. If you feel confused and not sure about what you are doing then smile because that means that learning is taking place. Before you begin you will need to have a FTP account set up that you can access. You will also need some FTP software to upload your code to the web server for testing. Start with the PHP lessons. Do those in order. When you finish the PHP lessons you will need a MySQL database set up for you so that you can start the MySQL portion of the lessons. Check with Prevost to make sure that your Database is all set up and ready to go.

 

forms

PHP Exercises

php_1 - PHP Basics

php_2 - Variables and Strings Intro

php 3 - HTML forms with PHP Variables (text)

php 4 - HTML forms with PHP Variables (numbers)

php 5 - Conditionals and Operators

php 6 - Random Numbers and Images

php 7 - Loops

php 8 - Arrays

MySQL Exercises

mysql 1 - Creating a Table

mysql 2 - Populating theTable with a PHP script

mysql 3 - Populating the Table with an HTML form

mysql 4 - Outputting the data

mysql 5 - Formatting the data

mysql 6 - Selecting Individual Records

mysql 7 - Updating Individual Records

mysql 8 - Deleting Individual Records

 

NEW!!


Password Protection. Create your table using this php code.

Final Project:

Once you have completed all the lessons above you will need to complete a final project that will demonstrate your knowledge of PHP and MySQL. The exercises above will have given you all the information to create a basic useful php application.

For your final project you will need to create a table on your database. You will need to create a form that will update the database. You will also need to be able to change records on the database and delete records from the database. You will need 7 documents. Each is described below.

createtable.php- Connects to the server contacts the database and creates the table on the database.

form.php-This is an html form that gathers the information that will be sent to the database.

formprocess.php -Grabs the information from the form and connects to the database and inserts the info into the table.

update.php - This works with the display.php. When you enter a record number and hit submit the record number is sent to this page which shows all the info for that record and allows you to change the information.

update2.php- this php takes the updated info from update.php and sends the changes to the database.

delete.php- This works with the display.php. When you enter a record number in the window and hit submit it sends the number to delete.php which connects to the database and deletes the record from the table.

display.php- displays the database. Also has field for changing a record or deleting a record.

 

 

.