PHP-Assignments

CCV's CIS-2430 Web Programming using PHP - Fall 2016

Assignment01 Sept 6 due in approx 1 week, although it may take longer

Welcome https://www.youtube.com/watch?v=wCPl4gl-SQw
PHP_Assign01-14.doc https://sites.google.com/site/jilmactraining/web-app-programming/php-handouts
Read the Introduction and Chapter 1 from your Textbook
Research
- Introduction:
  - Introduce Yourself, Your Background & Goals and your Computer Systems
  - put this in an eMail to Jil@JilMac.com
Coding-Before & After it may take you several weeks to complete this assignment.
- Download the Source Code
  - phpmysql4_scripts.zip (175 KB, last modified May 1, 2012)
  - Eratta http://www.larryullman.com/books/php-and-mysql-for-dynamic-web-sites-visual-quickpro-guide-4th-edition/errata/
  - ========================
- Download & Setup your CLASSweb Student Server space.
- Note: this may take some time to set up. https://sites.google.com/site/jilmactraining/web-development/wd-Assignments/CLASSweb_ccv_edu
- To see what other students or JilMac have done - visit the PHP-Students page https://sites.google.com/site/jilmactraining/web-app-programming/php-student
  - If you have any questions give JilMac a call - leave your phone number, repeat it slowly, thank you

Chapter01 Examples running in CLASSweb.ccv.edu

comments.php http://jam08260.classweb.ccv.edu/PHP/Assignment01/ch01/comments.php

concat.php http://jam08260.classweb.ccv.edu/PHP/Assignment01/ch01/concat.php

constants.php http://jam08260.classweb.ccv.edu/PHP/Assignment01/ch01/constants.php

first.php http://jam08260.classweb.ccv.edu/PHP/Assignment01/ch01/first.php

numbers.php http://jam08260.classweb.ccv.edu/PHP/Assignment01/ch01/numbers.php

predefined.php http://jam08260.classweb.ccv.edu/PHP/Assignment01/ch01/quotes.php

quotes.php http://jam08260.classweb.ccv.edu/PHP/Assignment01/ch01/quotes.php

second.php http://jam08260.classweb.ccv.edu/PHP/Assignment01/ch01/second.php

strings.php http://jam08260.classweb.ccv.edu/PHP/Assignment01/ch01/strings.php

template.html http://jam08260.classweb.ccv.edu/PHP/Assignment01/ch01/template.html

=================================

Assignment02 Sept 13 due in approx 1 week

PHP_Assign02-14.doc

- Read the Chapter 2: Programming with PHP
- Research

PHP Tutorials - How do you find "What you need, When you need it" "Picking your own Teacher/Tutor"

Spend about 2 hours - identify resources that you would use in ADDITION to our text book.

Look over the official PHP website http://PHP.net

Find some YouTube Videos and/or tutorials.

Give me 200+ words what you learned.

- Coding-Before & After Note: it may take you several weeks to complete this assignment.

1st you need to set up your Student Server Space

https://sites.google.com/site/jilmactraining/web-development/wd-Assignments/CLASSweb_ccv_edu

JilMac reviews several types of Menus that students can use to set up their WebPage https://youtu.be/9MhP6l-1oSM

The ZIP file containing the Menus https://sites.google.com/site/jilmactraining/web-development/wd-Assignments/wd-assign03/Menu.zip?attredirects=0&d=1

PHP book Chapter 3 examples or internet equivalent

http://experts.adobeconnect.com/p27snvdp9fh

How computers work

https://www.youtube.com/watch?v=7_LPdttKXPc

Chapter02 Examples running in CLASSweb.ccv.edu

Form http://jam08260.classweb.ccv.edu/PHP/Assignment02/ch02/form.html this calls handle_form.php

Multi http://jam08260.classweb.ccv.edu/PHP/Assignment02/ch02/multi.php

Sorting http://jam08260.classweb.ccv.edu/PHP/Assignment02/ch02/sorting.php

Script_02_02 http://jam08260.classweb.ccv.edu/PHP/Assignment02/ch02/script_02_02/handle_form.php

after

Script_02_03 http://jam08260.classweb.ccv.edu/PHP/Assignment02/ch02/script_02_03/handle_form.php

Script_02_04 http://jam08260.classweb.ccv.edu/PHP/Assignment02/ch02/script_02_04/handle_form.php

Script_02_06 http://jam08260.classweb.ccv.edu/PHP/Assignment02/ch02/script_02_06/calendar.php This is a calendar

Other example http://jam08260.classweb.ccv.edu/PHP/Assignment02/OtherExample

=================================

Assignment03 Sept 20 due in approx 1 week

PHP_Assign03-14.doc

Read the Chapter 3: Creating Dynamic Web Sites
Research - Research Google Chrome's Developer Tools
- Spend about 2 hours - identify resources that you would use in ADDITION to our text book. Ex. W3Schools.com,
- Find some YouTube Videos and/or tutorials.
- Give me 200+ words what you learned.
Coding-Before & After Note: it may take you several weeks to complete this assignment.
- Chapter 3 examples or internet or equivalent
- ---------------------------------
- PHP book Previous CHAT: 2/11/2013: http://experts.adobeconnect.com/p94mud8u77b/
- http://jam08260.classweb.ccv.edu/PHP/Assignment03/ch03

Chapter03 Examples running in CLASSweb.ccv.edu

when there is no file specified - this server runs index.html

http://jam08260.classweb.ccv.edu/PHP/Assignment03/ch03

index.php http://jam08260.classweb.ccv.edu/PHP/Assignment03/ch03/index.php

index.html http://jam08260.classweb.ccv.edu/PHP/Assignment03/ch03/index.html

Let's add these links

HEADER http://jam08260.classweb.ccv.edu/PHP/Assignment03/ch03/script_03_04/

Calculator http://jam08260.classweb.ccv.edu/PHP/Assignment03/ch03/script_03_05/calculator.php

Calculator http://jam08260.classweb.ccv.edu/PHP/Assignment03/ch03/script_03_06/calculator.php

Calculator http://jam08260.classweb.ccv.edu/PHP/Assignment03/ch03/script_03_08/calculator.php

Calculator http://jam08260.classweb.ccv.edu/PHP/Assignment03/ch03/script_03_09/calculator.php

=================================

Assignment04 Sept 27 due in approx 1 week

PHP_Assign04-14.doc

Skim Chapters 4, 5 - there are not code examples but ... there is MySQL code in file: sql.sql
- Download the sql.sql file from the phpmysqlq_scripts zip file and review it.
Research
- Research MySQL & SQL what is the difference between them?
- Spend about 2 hours - identify resources that you would use in ADDITION to our text book.
- Look over W3Schools MySQL http://www.w3schools.com/sql/sql_intro.asp
  - Find some YouTube Videos and/or tutorials.
  - Give me 200+ words what you learned.
Coding-Before & After
- Update your Menu, Break out the Header, Navigation and Footer into separate .php files
- Previous CHAT: 2/18/2013: http://experts.adobeconnect.com/p2z39fqehd6
  - We Reviewed the first example in Chapter 5.
  - The examples in Chapter 4 and 5 are similar because they all use a Data Entry Form. Each focuses on on how to "do things" with different types of data.

=================================

Assignment05 Oct 04 due in approx 1 week

Read the Chapter 6 Database Design and 7 Advanced SQL & MySQL
Research
- Look over the official MySQL website http://MySQL.com
- Spend about 2 hours - identify resources that you would use in ADDITION to our text book.
- Find some YouTube Videos and/or tutorials.
- Give me 200+ words what you learned.
Coding-Before & After
- - 3 examples from anywhere. You may want to spend time on the SQL DOM in http://W3Schools.com/sql
  - Unless you have created a Local Host (Extra Credit) the only place you can run the SQL is in W3Schools.com
  - Note: Chapters 4-7 the SQL will be loaded into your database and will be available to use in future chapters.

=================================

Assignment06 Oct 11 due in approx 1 week

Read the Chapter 8 Error Handling and Debugging & Appendix A
Research PHP debuggers and MySql debuggers
- Spend about 2 hours - identify resources that you would use in ADDITION to our text book.
- Find some YouTube Videos and/or tutorials.
- Give me 200+ words what you learned.
Coding-Before & After
- 3 examples from Chapter 8 Note: it may take you several weeks to complete this assignment.
---------------------------------
- Previous CHAT: 2/25/2013 from PHP only book:
- http://experts.adobeconnect.com/p75154jp58x/
- We reviewed page 98-99, 100 & 103 code examples
- Previous CHAT: 3/4/2013 from PHP only book::

- - - - http://experts.adobeconnect.com/p66nc3lr32n/
        We reviewed pages 115 - 150 all of Chapter 6
        If, elseIF, Validation, Loops & more!

=================================

Assignment07 Oct 18 due in approx 1 week

Read the Chapter 9 Using PHP with MySQL and Chapter 10 Common Programming Techniques
Research PHP Forms - why are they the heart of an interactive system?
- Spend about 2 hours - identify resources that you would use in ADDITION to our text book.
- Find some YouTube Videos and/or tutorials.
- Give me 200+ words what you learned.
Coding-Before & After
- 3 examples from Chapters 9 & 10 Note: it may take you several weeks to complete this assignment.

03/07/2016

https://youtu.be/UOrTC5KJYkc

Chapter 09 - Accessing the Database using PHP

Chapter 10 - Code Examples

=================================

Assignment08 Oct 25 due in approx 1 week

Read the Chapters 11 Web Application Development and Chapter 12 Cookies & Sessions
Research
- Research WordPress the most common CMS: Download it, Unzip it, how is it set up, what are the folders, can you follow the PHP Includes. Spend some solid time looking at the WordPress file system from the file layout perspective. What is the difference between Wordpress.com and Wordpress.org.
- Spend about 2 hours - identify resources that you would use in ADDITION to our text book.
- Find some YouTube Videos and/or tutorials.
- Give me 200+ words what you learned.
Coding-Before & After
- Chapters 11 & 12 Note: it may take you several weeks to complete this assignment.
  - Chapter 11 script 11.4 images.php line 14
  - You had to manually create an ../uploads directory - where the uploaded files will reside.
  - If there is no uploads directory or it is not in the correct path - the program will tell you the file can't be uploaded.
Previous CHAT: 3/11/2013 from the PHP only book: Chap 7 - Arrays http://experts.adobeconnect.com/p1jc6gcfca7

=================================

Assignment09 Nov 1 due in approx 1 week

Read the Chapters 13 Security Methods and Chapter 14 Pearl-Compatible Regular Expressions
Research
- Shared Web Hosts that give you access to PHP, MySQL and also has an install for WordPress. I am picking these components because that is what we will be using. However ... keep in mind - that you may need different types of servers from time to time. Suppose you had to research ASP - what would that Shared Web Host look like. Or if you wanted to have Python instead of PHP.
- Spend about 2 hours - identify resources that you would use in ADDITION to our text book.
- Find some YouTube Videos and/or tutorials.
- Give me 200+ words what you learned.
Coding-Before & After
- Chapters 13 & 14 Note: it may take you several weeks to complete this assignment.

=================================

Assignment10 Nov 08 due in approx 1 week

Read the Chapter 15 Introducing jQuery
Research
- jQuery
- Spend about 2 hours - identify resources that you would use in ADDITION to our text book.
- Find some YouTube Videos and/or tutorials.
- Give me 200+ words what you learned.
Coding-Before & After Chapter 15 Note: it may take you several weeks to complete this assignment.

=================================

Assignment11 Nov 15 due in approx 1 week

Read the Chapter 16 OOP Primer____
Research
- What is OOP - Object Oriented Programming
- Spend about 2 hours - identify resources that you would use in ADDITION to our text book.
- Find some YouTube Videos and/or tutorials.
- Give me 200+ words what you learned.
Coding-Before & After
- Chapter 16 Note: it may take you several weeks to complete this assignment.

=================================

Assignment12 Nov 22 due in approx 1 week

Read the Chapter 17 Example Message Board
Research
- What is a Message Board - what are it's characteristics, why are Message Boards important?
- Spend about 2 hours - identify resources that you would use in ADDITION to our text book.
- Find some YouTube Videos and/or tutorials.
- Give me 200+ words what you learned.
Coding-Before & After Chapter 17 Note: it may take you several weeks to complete this assignment.

=================================

Assignment13 Nov 29 due in approx 1 week

Read the Chapter 18 Example - User Registration
Research
- What is a Registration System?
- Where does security fit into a Registration System?
- Spend about 2 hours - identify resources that you would use in ADDITION to our text book.
- Find some YouTube Videos and/or tutorials.
- Give me 200+ words what you learned.
Coding-Before & After Chapter 18 Note: it may take you several weeks to complete this assignment.

=================================

Assignment14 Dec 06 due in approx 1 week

Read the Chapter 19 Example- E-Commerce
Research
- What is E-Commerce?
- Why is it important to purchase a good package with security?
- NOTE: JilMac does NOT recommend writing your own Shopping cart! this is just CONCEPTS - and contains NO SECURITY!
- Appendix A: Installation
- Note1: in this class I will NOT be using a WAMP, LAMP, XAMP, etc. We will be FTPing the files to our WebServer.
- Students who have taken the SQL and/or Linux class may want to use this appendix.
- Note2: Students may want to set up their own shared web host - this can be included in their Project.
Coding-Before & After Chapter 19 Note: it may take you several weeks to complete this assignment.
- - Here is my working eCommerce site http://jam08260.classweb.ccv.edu/PHP/Assignment14/ch19after
  - To add an Artist http://jam08260.classweb.ccv.edu/PHP/Assignment14/ch19after/admin/add_artist.php
  - To add a Print http://jam08260.classweb.ccv.edu/PHP/Assignment14/ch19after/admin/add_print.php
  - What had to be changed to get the add_print.php in Chapter 19 page 618 & 619 to work is LINE 30 - the path to the folder uploads.
  - Some of this was discussed in Chapter 11 script 11.4 images.php line 14
  - You had to manually create an ../uploads directory - where the uploaded files will reside.
  - If there is no uploads directory or it is not in the correct path - the program will tell you the file can't be uploaded.
  - The same is true for our add_print.php because we have to UPLOAD files to this folder. Although ... depending ... where you put the upload folder - and your path - it may be the same folder or you could have separate folders for separate assignments. I'll leave that to you.
  - Line 30's path is ../../uploads because the add_print is in the admin directory. The ../ equates to going UP 1 directory/folder ../../ is doing UP 2 directories/folders.
We will be using the Web Server, students who are ready can setup their own Shared Web Host. Students who was to incorporate a LAMP, WAMP, XAMP can do this as part of their project
Appendix A: Installation and Configuration
Previous CHAT:
5/13/2013 http://experts.adobeconnect.com/p8v2cj56uu7/
Last Chat of Semester

=================================

Project Dec 13 All work that you want included in your grade needs to be on your Shared Web Host by: Sun, Dec 18th at 11:59pm

We will be using the Web Server, students who are ready can setup their own Shared Web Host. Students who want to incorporate a LAMP, WAMP, XAMP can do this as part of their project
Appendix A: Installation and Configuration

Using the Console from Nate:

https://developers.google.com/chrome-developer-tools/docs/console

Links:

Google Developers (Android): http://developer.android.com Training http://developer.android.com/training

Free eBook for PHP & Oracle Database http://www.oracle.com/technetwork/topics/php/underground-php-oracle-manual-098250.html

Design a WordPress Plug-in in 5 minutes http://designfestival.com/design-a-wordpress-plugin-in-five-minutes-or-less/?utm_medium=email&utm_campaign=DesignFestival+January+16th+2013&utm_content=DesignFestival+January+16th+2013+Version+A+CID_b26c014ad3c0d76b54fd0f390f83c183&utm_source=Newsletter&utm_term=Design%20a%20WordPress%20Plugin%20in%20Five%20Minutes%20or%20Less

SettingUp MySQL Database from C Panel

Page updated

Google Sites

Report abuse