We’re excited to note that in the Fall semester this year (2009) we’ll be offering not only the intro to web programming PHP/MySQL course (MGD 175) for a third time but also a second level course going deeper in PHP/MySQL and adding AJAX and jQuery integration instruction as well (PHP/AJAX – MGD 178 – 53487) which will be offered on Thursdays from 12:40 – 4:00pm.
And as if that’s not enough excitement, we’re trying the above mentioned intro to web programming with PHP/MySQL (MGD 175 – 54380) course as a night course on Thursday’s from 6pm – 9:40pm.
Come join us! Enroll today at http://frontrange.edu
Open Source Application ReviewAfter the mid-term we did a quick introduction to the concept of data in a database as tables (think worksheets in a spreadsheet document) consisting of columns and rows of data. We noted that each row is like a record in the database.
- Read Vaswani Chap 7 (pp 185-200).
- Begin to create a written or spreadsheet data model for your final project (work portfolio, client to-do list, or database enabled web contact form). List columns you think you’ll have, and then throw in a couple of rows of data as samples to see if you need to add columns.
- Begin to review your chosen opens source application type (see attached info page) and to prepare for your 3-5 minute presentation to the class.
Here’s the schedule for #3 presentations:
| Application Type |
Primary Solution |
Secondary Solutions
|
Assigned To |
Date |
| Sitemap Generation |
Google SMG |
|
Sandy McKee |
4/8/2009 |
| Wiki |
MediaWiki |
PhpWiki, DokuWiki, TikiWiki, WikkaWiki |
Jim Nicolaus |
4/15/2009 |
| CMS |
Drupal |
Joomla |
Nathan Foldan |
4/22/2009 |
| Blog |
WordPress |
Typepad, Moveable Type, Google Blogger |
Debra Veal |
4/29/2009 |
| Message Boards |
PhpBB |
vBulletin, UBB.threads, UseBB, Phorum |
Rudy Torres |
4/29/2009 |
| eCommerce |
ZenCart |
OS Commerce, Magento |
Chad Granoff |
5/6/2009 |
(See bottom of post for attachments of notes, examples, project assignments)
Wednesday, March 18, 2009 we covered the following in class:
Homework/Reading Assignments:
- Complete the In-class projects begun at end of class 3/18/2009. Email a working copy to me by 1pm 4/1/2009.
- Midterm (4/1/2009) Prep: Complete all questions in PHP: A Beginner’s Guide (Vaswani) Chapter Self Tests for chapters 1-4 and questions 1-3 for chapter 5′s Chapter Self Test.
PHP: A Beginner’s Guide (Vaswani) pgs 86-134.
As was indicated in class on 2/24/2009, now that everyone has his or her book we will get back to weekly quizes based on reading. To give us flexibility in class to move at the pace of the group, I’ll post the week’s reading assignment here on the class site by Thursday afternoons from this point forward. Here is this week’s reading assignment which is due before class (we will have a quiz).
PHP: A Beginner’s Guide (Vaswani) pgs 39-65.
Front Range Community College – Boulder County Campus
PHP/MySQL: Intro To Web Programming – Spring 2009
Assigned: February 25, 2009
Due: March 4, 2009
Assignment: Enhance web form begun in class on Feb 27, 2009
Your task is to enhance the web form you began work on in class by adding additional items to the form to gather data from the user and displaying those items when submitted on your process.php page correctly and placing both files in a new folder (project2) in your web space online.
Part One: Do some file management:
- Create a new folder named “project2″ in your web space at the same level in the directory structure as your “project1″ folder.
- Move your page containing your web form to the new project2 folder and rename the page “index.php”
- Move your process.php page to the project2 folder
Part Two: Enhance your index.php form so that it:
- Runs without producing any errors and warnings
- Is linked form your home page in your assignments section as “Contact Me” (linked to /project2 is preferred)
- Provides fields for users to input data as already configured in class.
- Firstname
- Email Address
- Gender
- Interests
- State
- Provides additional fields of your choosing which implement form input methods including but not limited to:
- an additional text field in the appropriate place for lastname
- at least one textarea (maybe a “Comments” section toward the bottom of the form)
- complete the states listing begun in class
- add additional interest choices which make sense with the others
Test your script at http://<yourserverdesignation>.frontrangephp.net/project2
Your process.php page should:
- Run without producing any errors and warnings
- Display data entered from your form.php page when the submit button is pressed on your form.php page
- Display all data collected in a format which is clearly readable and would make sense in a realistic situation
Front Range Community College – Boulder County Campus
PHP/MySQL: Intro To Web Programming – Spring 2009
January 28, 2009
Assignment 1: Fun With Variables and Operators
Project 1.1 Your Class Home Page
Your task is to create a home page with the file name index.php for yourself in your development space on the class webserver. Your home page should:
- Be accessible at http://s09firstinitiallastname.frontrangephp.net
- Include an <h1> title which displays your name (and other text if you like)
- Include an external CSS file which is used to style elements on your home page (use at least five different CSS style definitions)
- Include a list of links to your assignments (this will grow as the semester progresses)
- Include a separate list of links to any web sites that you have built in the past
Project 1.2 Two Simple PHP Tasks
Create a folder on your web server space named
project1Your task is to create two very simple PHP scripts on the server.
Your first script (1.2.1) is called info.php and should:
- Run without producing any errors or warnings
- Be linked from your home page in an assignments section. It is suggested to create a parent <li> element with the text “Project 1.2 Simple PHP – info.php” and link the “info.php” text to your info.php file on the web server
- Inside of info.php place the following php code (this should be the only text in your file):
<?php phpinfo(); ?>
- Upload the file to your project1 folder on the web server
- Try running your script at the following url http://<yourserverdesignation>.frontrangephp.net/project1/info.php
- You should see a list of info about the php installation on your server. If you see this and no errors, then you are good to go on.
Your second script (1.2.2) called hello.php should:
- Run without producing any errors or warnings
- Be linked from your home page in the assignments section
- Inside of hello.php build the standard HTML document tags and inside the BODY tag, write php code that prints the text “PHP is working” inside of <h1> tags.
- Test your script at http://<yourserverdesignation>.frontrangephp.net/project1/hello.php
Download Assignment 1 in PDF -MGD175100 Assignment 1
As we begin another semester at Boulder County’s Front Range Community College campus we’re excited to be offering the PHP/MySQL: Intro To Web Programming class for the second time. Based on some of the great learning we did during the first semester of this particular course a few changes are in order for this semester, but many of the methods and all the passion for producing prepared entry level PHP/MySQL programmers remains.
This site will be our primary source to communicate information about the course. We plan to post notes from class, assignment documents, and we’re dreaming up some other possible things that may help this semester’s site even more useful for those of you taking the course this semester.
So, welcome to the playground! Come join the fun.
