SEMINAR RECORDING

The seminar recording covering the following topics is here http://khe2.adobeconnect.com/p4tqjg4fbqj/

Preliminaries

• Introductions and survey on programming knowledge
• What I expect from you
• Understand the syllabus
• Do the assigned readings
• Practice, practice, practice
• Read my announcements
• Do the work and participate!
• Have fun!!!!!
• What you can expect from me
• Timely communication
• Comprehensive grade feedback
• Information packed seminars
• Lots of support!
• Fun!!!
• How to Get help
• Virtual Office (I look there first and frequently)
• The PHP support site
• KUO Technology Center - link under Course Home
• Introduction to Web Development with PHP
• What is PHP and what can it do - or what can you do with it?
• What is MySQL?
• WAMP, LAMP, MAMP and the Web

This week's goals

• Download and install the W/L/MAMP servers
• Understand how to use it
• Create a Web page that displays your name using the PHP echo statement
• Project Demo

SEMINAR RECORDING

The seminar recording covering the following topics is here http://khe2.adobeconnect.com/p1tz7v47xh4/

Preliminaries

• READ the Unit announcements and REVIEW the seminar recording each week, a link to it is also located in a separate announcement.
• Follow my demonstrations in seminar - you can't go wrong if you do that!
• TEST, TEST, TEST your projects in the wamp services. You will lose significant points if your projects do not work.
• Submit a HELP TICKET (see below) if you need help troubleshooting and debugging to get your projects working. Do this BEFORE you submit a project and you'll be sure to ACE it!!
• READ my gradebook feedback!!! While I do not allow resubmissions (unless I ask for one), many projects build on prior ones, so be sure to make the corrections I point out where it applies!

Big do's and don'ts

• DO create a separate unit folder for each project in the www folder whether or not it contains only a single file. This will avoid your having a messy root folder in your www area.
• DO zip the entire unit folder for submitting to the dropbox.
• DON'T have spaces or non-alphanumeric characters in file, folder, variable or function names.
• DO treat all names, including files, folders, variables, and functions as CASE SENSITIVE (I recommend getting into the habit of using all lowercase letters. You never have to remember what and if you capitalized!).
• DON'T copy any code from the support site. You MUST learn to identify what each line of code is for in your own project.

This week's goals

• Create a simple html form containing one input box and a submit button.
• Understand the form action and method attributes.
• Understand form element names.
• Create a decision code block that echos out something different depending on the value entered into the form.
• Understand how the value gets passed from the form to the script using variables.
• $variables: a container that stores a value in memory for use in the application
• Naming variables
• Declaring and initializing variables
• Displaying variables
• Understand basic data types: string, numeric (integer, floating-point), boolean, array, NULL
• Understand basic operators:
• Arithmetic: +, -, *, /, %
• Assignment: =, +=, -=, *=, /=, %=
• Comparison and conditional: ==, ===, != or <>, !==, >, <, >=, <=
• Logical: && or AND, || or OR, XOR, !
• Understand basic decision control structures: if, if then else
• Project Demo

Seminar recording

The seminar recording covering the following topics is here http://khe2.adobeconnect.com/p3iy3mo7xq3/

Preliminaries - Designing for functionality

• Input - user enters data in html form displayed in browser (user interface)
• Process - the script:
  • "gets" or "posts" data
  • stores data in $variable "containers" for manipulation
  • manipulates the data
• Output - server sends the results back to the user's browser in html
• Store - permanently storing data (covered in later units)

Do's and Don'ts

• Do NOT hard code absolute paths to folders and files - make sure all files needed for a project are in that project folder including images, external CSS or JS files
• Be ABSOLUTELY sure that your form action is to the EXACT name of your php file
• Be ABSOLUTELY sure your form input names are EXACTLY what you are initializing your $variables to equal with $_POST, $_GET or $_REQUEST

This week's goals

• Understand common variable handling functions
• Use isset($variable) to check for a form value (does not work if value is = NULL)
• Use unset($variable) to unset the value
• Use empty($variable) to check for empty variable ("", 0 "0", NULL, FALSE, array() are all considered empty)
• Understand common string manipulation functions
• Use str_replace("stringtoreplace", "stringtoreplacewith", $variable) to replace strings
• Use strlen($variable) in an if statement to check for required length
• Use is_numeric($variable) in an if statement to check if the value is numeric
• Begin studying common errors and how to troubleshoot them
• Syntax - 10 common syntax errors: http://www.phpreferencebook.com/misc/php-errors-common-mistakes/
• Runtime (Later unit)
• Logic
• Project demo

Seminar recording

The seminar recording covering the following topics is here http://khe2.adobeconnect.com/p73z2zhr3os/

Preliminaries - Review

• What is the role of HTML forms in PHP applications?
• How do you set up a form for a PHP script to process the form data on submit?
• How do you know when to use parentheses ( ), curly braces { } and square brackets [ ]?

HINT: Think functions and their arguments, control structures, and array indexes

• When do you use the semi-colon ; and what does it mean to the interpreter?

This week's goals

• Create a database for the guestbook
• Create a simple application to populate the database with a guest record
• Project Demo

Seminar recording

The seminar recording covering the following topics is here http://khe2.adobeconnect.com/p9p77kn6hlc/

Preliminaries - Review of Common Errors

• Parse errors - look at the lines ABOVE the line referenced in the error.
• Too many or not enough ( ), [ ] , or { }
• Mismatched ( }. [ ) or other combination or ' with "
• Missing ' " or ;
• Undefined index/offset errors - compare names used in the forms with those used in your script.
• Using lower case when you need upper case or vice versa (everything is case sensitive).
• Using a different name in your form than you do with your script - remember file names MUST be exactly as referenced as well.
• Trying to post more index offsets than the form actually has.
• A word on copying and pasting code from websites, pdfs and other files.

This Week's Goals

• Copy unit 4 files/folders into unit 5 folder (already done to save time).
• Download styles_unit5.zip from Doc Sharing and replace styles.css.
• Show phpmyadmin table contents of the doe database.
• Demo unit 5 prior to making changes by adding a guest (as unit 4).
• Demo newdemos unit 5 to show the additions.
• Show existing code in guestbook.php in Dreamweaver.
• Make the additions.
  • Edit header.php by adding menu system.
  • Write showguests.php.
  • Test and debug.

Seminar recording

The seminar recording covering the following topics is here http://khe2.adobeconnect.com/p8vs1zln246/

This Week's Goals

• If need be, modify showguests.php to make sure Delete links to the deleteguest.php script and uses the GET method to pass the applicable guestid to that script.
• Write the deleteguest.php script. Include a form that prompts the user to confirm deletion of the record.
• Write a brief paper detailing what you've learned so far in the class and how you might use the knowledge in the future.
• Project demo

Seminar recording

The seminar recording covering the following topics is here http://khe2.adobeconnect.com/p7lp4v9x2ru/

This Week's Goals

• Modify guestbook.php to prevent guest from signing twice.
• Create deleteguest.php script.
• Project demo

Seminar recording

The seminar recording covering the following topics is here http://khe2.adobeconnect.com/p4cq10tvndf/

Reminders

• Only one more seminar after tonight!
• Final project is due the last Sunday of the term (if seminar is on Wed, add 20 days).
• If you do nothing else project wise, be sure to do Unit 10 - it is worth 160 points!!

This Week's Goals

1. Create a login form and script
2. Create a menu for authorized user
3. Modify unit 7 scripts and incorporate session tracking
4. Script the flow control logic to handle results
5. Script the browser output

• The seminar recording covering the following topics is here http://khe2.adobeconnect.com/p7bf2ozsu1q/

Reminders

• Last seminar!
• Final project is due the last Sunday of the term (if seminar is on Wed, add 20 days).
• If you do nothing else project wise, be sure to do Unit 10 - it is worth 100 points!!

Project Instructions

Install WAMP

From the website http://www.wampserver.com/en/download.php you will download the latest copy of the WAMP software. The download location should be noted. When the download is complete you will double click on the file (or choose Run from the dialog box). The installer will prompt you to accept the license (click ok). It will then choose the location for the software to the default location of c:\wamp (click ok). It will create a shortcut folder in your start menu (click ok). The Auto Start option will load WAMP each time you boot your machine it should probably be unchecked. The install will now proceed.

Upon completion of the install, you will find a new folder in your C drive, named wamp. Upon opening that folder you will find a folder named 'www'. This is the root folder of your web server. To start the Server, click on Start>Programs>WAMP Server>Start WAMP Server. This begins a process that will show in the system tray (lower right of taskbar) as a 'dial'. You may click on the dial and select 'localhost' and you will see the default 'index' page for your server.

A video tutorial is available in the Reading section of this unit, named SavingFilesinWAMP.

Note: http://localhost/ is equivalent to http://127.0.0.1 used in your book.

Create Your First Script

Using a text editor (I recommend using Dreamweaver), create a simple PHP program, named myLastName.php mylastname.php (use your actual lastname: e.g. marrs.php, use all lower case and do not use spaces or any non-alphanumeric characters in file and folder names). The PHP program should echo your full name in H1 tags. See the examples for Unit 1 on the PHP support site here http://php.skillbuilderblocks.com/. Create a subfolder named unit01 in the www folder in the WAMP area. Save the file in that subfolder. Make sure WAMP is running and all services are turned on. Click the WAMP icon in the system tray and click Localhost to test the script (Localhost opens your default browser at this address: http://localhost/). Scroll down the page and under Your Projects, click the unit01 folder to open it and click the file that is listed there.

Be sure to refer to the rubrics for details on what's expected to earn full points!

Project Demo

BROWSER OUTPUT (http://localhost/unit01/marrs.php) WITH WAMP SERVICES RUNNING

Adding comments to your code

Note that comments will not appear in the outputted results

The following examples both display the text string in the echo statement in the HTML <h4> format.

HTML embedded in PHP

Hello World!

PHP embedded in HTML

Hello World!

The code the produces the output above(screenshot)

Project Instructions

1. Create a simple html form containing one input box and a submit button.
2. Understand the form action and method attributes.
3. Understand form element names.
4. Create an decision code block that echos out something different depending on the value entered into the form.
5. Zip the unit01 folder that contains your PHP file and your DB export and submit it in the drop box.
6. Attach the zip to the Dropbox.

Be sure to refer to the rubrics for details on what's expected to earn full points!

Project Demo

Project Instructions

1. Create a form that has four input fields named word1, word2, word3, and word4 (NOTE: I recommend using all lower case), as well as Reset and Submit buttons.
2. In the same file, create a script that validates the following
• All four words are entered
• All four words are between 4 and 7 characters long
3. Once all of the words have been validated, use the strtoupper() and str_shuffle() functions to produce four jumbled set of letters.
4. Part of the exercise is created for you: Exercise 4-1 on page 222-224
5. Save the file as unit03.php in a folder named unit03 in the www folder of the wamp servers.
6. Test the project by going to http://localhost/unit03/unit03.php making sure your wamp servers are turned on.
7. When your project is fully functional zip your unit03 folder and attach it to the dropbox.

Be sure to refer to the rubrics for details on what's expected to earn full points!

Project Demo

Project Flowchart

Project Instructions

1. Create one html document containing two forms.
   • One that adds contacts and writes them to a text file.
   • One that displays the contents of the text file.
2. Write the add script
   • Use fopen() with the "a" argument to append the file.
   • Concatenate each input value as a comma separated string ending with new line "\n" or carriage return and new line "\r\n" depending on the platform. TIP: Start your string with last name to be able to sort on last name in unit 5
   • Use fwrite() to write the string to the text file.
   • Use fclose() to close the text file when finished.
3. Write the display script
   • Check to see if the file_exists() before trying to open it.
   • Use file() to open the file and read the data into an array.
   • Use a for loop to iterate through the lines in the file. Your first line of code in the for loop needs to explode (separate) each line in the text file on commas. Then use one or more echo statements to echo each data value in each row.

Be sure to refer to the rubrics for details on what's expected to earn full points!

Project Demo

Project Instructions

This week you'll build on what you did in unit 4. The objective is to work on consistent layout and learn how to sort the data read from the text file alphabetically by last name.

1. Copy your unit 4 files into the unit05 folder
• contacts.html - contains the two forms. One for adding a contact to the file and one that displays the contents of that file.
• Modify contacts.html file so the state element is a drop-down select box - download the state codes here select_box_states.zip.
• Follow the steps below to modify addcontacts.php and showcontacts.php
2. Modify addcontacts.php
• Make sure the string you build to write to the file starts with $lname because the sort does so on index [0]
• Modify the $lname variable to = ucfirst(strtolower($_POST['lname'])) so it capitalizes the first letter and makes all subsequent letters lowercase
• Do the same thing to $fname
• Add the following string functions appropriately: is_numeric(); strlen(); substr();
3. Modify showcontacts.php
• Add the sort() function in the appropriate place - it needs to sort alphabetically by last name prior to the for loop
4. Focus on layout and format. Part of your grade is on consistency of your design.

NOTE: This week's project is worth 100 points, so give it your all!!

Be sure to refer to the rubrics for details on what's expected to earn full points!

Project Demo

Project Instructions

This is the database you'll use for the remainder of the term through the final project. Use phpMyAdmin in your wamp services to create your database and tables. Please DO NOT make any changes to the root password or the privileges table as described in your book.

1. Launch phpMyAdmin
2. Create the database naming it your actual lastname (i.e. marrs). Please use all lower case.
3. Create a table and name it contacts. Again, use all lower case. Set it up so that it has 9 fields data typed as follows:
• contactid int 4 not null auto_increment primary key
• fname varchar 25
• lname varchar 25
• address varchar 50
• city varchar 25
• state varchar 2
• zip int 5
• area int 3
• phone varchar 8
4. Insert at least one contact into the contacts table.
5. Create a table named users (lower case). This will be the source for validating the user in later units. Set it up so that it has 2 fields data typed as follows:
• username varchar 10 primary key
• password varchar 10
6. Insert at least one user into the users table with username of user1 and password of password1
7. IMPORTANT STEP! Click the database name and click Export to export the schema to a file. It should be named yourlastname.sql (i.e. marrs.sql). Let's look at the sql dump. (NOTE: I will need this dump for all future units!)
8. Use the form from Unit 5 containing all of the fields needed for contacts - copy and paste it into your unit06 folder.
9. Write a 2-3 page report and include the following (you may do this in Word or HTML):
• A description of the above tasks and explanation of reasons for them.
• Your contacts form, (the actual form or a screenshot) and a description of how it relates to the contacts table.
• The purpose of the users table and how it differs from the privileges table.
• The reason for the selection of the primary keys.
• The sql dump that provides evidence that you performed the tasks (I will need the sql dump every unit from here on).
NOTE: Screen shots are insufficient!
• How you plan to validate data entered by users (specify which tables and fields should be validated and what about them needs validating).
• A description of security issues that should be considered.
• Make sure you spell and grammar check your report.
• References properly cited.
10. Make sure you save the form, the paper, and the .sql dump in your unit06 folder, zip the folder and attach it to the dropbox.

Be sure to refer to the rubrics for details on what's expected to earn full points!

Project Demo

• Your form from unit 5 that adds a contact.
• Your Word file containing your design document.
• The .sql file you exported from phpMyAdmin after completing all of the database tasks.
It should look like the following:


Screenshot of the sql dump. Please include the actual file in your zipped project.

Project Instructions

MySQL and PHP

1. Initialize database values using the default host, user, and password and connect to your database.
• $host = "localhost";
• $user = "root";
• $pw = "";
• $db = "marrs";
2. Make the database connection using php syntax.
$connect = mysqli_connect($host, $user, $pw, $db) or die(mysqli_err($connect));
3. Initialize the variable for the $table to be queried.
4. Initialize the variable to establish the $connection.
5. Initialize the variable containing the SQL $query.
6. Initialize the variable to hold the $results of the query.
7. Script the flow control logic to handle the results.
8. Script the browser output.
9. Close the $connection.

Create/Modify Needed Files

1. Copy your contacts.html file from unit05 folder to a unit07 folder and rename it to contacts.php (so php scripts will work in it). Do NOT copy the php or txt files, they are irrelevant.
2. Modify the page by adding a php code block that connects to the database.
3. Modify your addcontacts form as follows:
• Delete the input text for state.
• Replace it with a select element and populate it with applicable state abbreviations or names.
4. Modify your showcontacts form so that it allows users to show contacts from all states or from a specific state.
• Add a select dropdown box and add options for all and for each state.
• Create the state options using php and mysql to get the states in the contacts table (the list will open show states that exist).
5. Save the modified forms page.
6. Write the addcontacts.php script and save it in the unit07 folder.
7. Write the showcontacts.php script and save it in the unit07 folder.
8. Add contacts using the form. Add several from different states.
9. Test and debug.

Be sure to refer to the rubrics for details on what's expected to earn full points!

Project Demo

Project Instructions

This project builds on Unit 7 and creates the foundation for Unit 9 and 10. (TIP: if your Unit 8 is fully built, you'll only have to modify your files for the remaining units.)

1. Create your unit08 folder and copy your unit 7 files into it (include external CSS).
2. Make sure you have inserted several records from different states in the contacts table and at least one record in the users table in your database.
3. Create index.html (home page) containing a form that allows the user to login. The form needs a text input for username and one for password along with a submit button. The script that it calls (login.php) will verify that the user exists in the users table. Redirection is accomplished with the following function: header('Location:admin.html');
4. Write the login.php script that redirect the user to admin.php that has a menu of administrative options:
   • Add a Contact (addcontact.php)
   • View Contacts (viewcontacts.php from Unit 7 - optionally view all or by state)
   • Add an Authorized User (adduser.php)
• NOTE: Each of the above is a separate form containing only a submit button that calls the appropriate script.
5. Create connect.php that contains the code needed to connect to the database. Use the include statement to include that file in each script that needs to make a connection. Using this option minimizes redundant coding.
6. Modify addcontact.php so the addcontact form and script are in a single file (merge addcontact form from contacts.html form into addcontact.php). Validate that all fields have been filled in.
7. Modify showcontacts.php so the showcontacts forms and script are in a single file (merge showcontacts form from contacts.html form into showcontacts.php).Validate that all fields have been filled in.
8. Once the forms from contacts.html are merged with the applicable script, delete contacts.html from your unit08 folder. Do not submit it with your project.
9. Create adduser.php containing the form and script for adding an authorized user to the users table (adduser.php). Validate that all fields have been filled in. The adduser.php script also needs to make sure that the username entered does not already exist in the user table. While you will only insert the username and a single password in the table, the form needs two password inputs uniquely named to validate they have both been entered exactly the same.
10. All pages should provide a user with a means to navigate back to the admin.php page and should provide user friendly output in the event validation fails. Once validation is successful, the scripts will insert the record into the applicable table in your database.
11. All html output should have a consistent look, feel, and layout.
12. Test and debug.
13. To submit this project you must export your database sql dump and save it to your databasename.sql file. Be sure to save it in your unit08 folder and zip the entire folder.

Be sure to refer to the rubrics for details on what's expected to earn full points!

Project Demo

Project Instructions

This project builds on Unit 8 and creates the foundation for Unit 10. (TIP: if your Unit 8 is fully built, you'll only have to modify your files for the remaining units.)

1. Create your unit09 folder and copy your unit 8 files into it (include external CSS).
2. Make sure you have inserted several records from different states in the contacts table and at least one record in the users table in your database.
3. Modify the admin page by adding the form(s) for edit and/or delete contact.
4. All pages should provide a user with a means to navigate back to the admin.php page and should provide user friendly output in the event validation fails. Once validation is successful, the scripts will insert the record into the applicable table in your database.
5. All html output should have a consistent look, feel, and layout.
6. Test and debug.
7. To submit this project you must export your database sql dump and save it to your databasename.sql file. Be sure to save it in your unit09 folder and zip the entire folder.

Be sure to refer to the rubrics for details on what's expected to earn full points!

Project Instructions

This project builds on Unit 9. (TIP: if your Unit 9 is fully built, you'll only have to modify your files for this unit.)

1. Create your unit10 folder and copy your unit 9 files into it (include external CSS).
2. Modify the admin page by adding the form(s) for edit and/or delete contact.
3. If you haven't already, add the script to edit and/or delete functions.
4. All pages should provide a user with a means to navigate back to the admin.php page and should provide user friendly output in the event validation fails. Once validation is successful, the scripts will insert the record into the applicable table in your database.
5. All html output should have a consistent look, feel, and layout.
6. Test and debug.
7. To submit this project you must export your database sql dump and save it to your databasename.sql file. Be sure to save it in your unit10 folder and zip the entire folder.

Be sure to refer to the rubrics for details on what's expected to earn full points!

PHP is a server side language, meaning whenever the browser encounters <?php, called the php delimiter, the browser passes control to the server which then processes all code up until the server encounters the ?>, at which point the server passes control back to the browser. There are a few key things you need to know about server side code

• You cannot view php source code in the browser, only client side code (i.e. html, CSS, javascript, XML).
• Both client and server side are written in plain text, so you can use php echo or print statements to embed client side code along with content that the browser will render exactly the same as if you wrote it in the client side language.
• The php language is interpreted by the server, meaning it reads from left to right line by line. This also means, unlike compiled languages, errors are detected at runtime. The code will continue to execute unless the interpreter encounters the ending delimiter as stated above or it encounters an error. Learn to embrace errors and pay attention to line numbers. If you have an error on line 10 of 30 lines of code, simply fixing that error doesn't mean there aren't additional errors on one or more subsequent lines. The good news is the higher the line number an error occurs on, the closer you are to flawlessly running code.
• The line number referenced in a php error message means the error actually occurred on a line above that. More on errors and troubleshooting them later.

Study the unit 1 demo screenshot and see if you can identify the points at which the browser or the server controls the flow.

How to Export a Database in phpMyAdmin