CIT 252 Home
Web Database ASP/Access - PHP/MySql

Section WC801 Call # 26620 3 credit hours Thur 7:30-10:20 PM
West Charleston Campus Room C-114 Instructor: Charles Muench
Phone 616-6736 Cell 327-7201 E-mail:ccsn.muench@cox.net

CIT  252-B Web Database Class Schedule

  1. Introductions and administrative details, PC Lab procedures, getting started
  2. You need a CCSN Student Network Account which you can also get from the computer lab
  3. Be sure to study the Class Links item about HTML Tags The Beginning.
  4. We will watch the WS_FTP Video about Uploading your files to your web site account.
  5. Lab Time to start to work on Assignment #2 which is due next week.
  6. Setting up your ASP web site at citweb.ccsn.net .
  7. See Assignment 1.
  8. Review of FTP Upload Procedures and how they work with the citweb.ccsn.net Web Server
  9. Modifying your first HTML file and uploading it to your web space.
  10. Review of ASP pages and how they work with Html pages.
  11. Review of IIS and how they work with ASP pages and the schools Computers.
  12. Review of HomeSite and how they work with ASP pages and IIS on the schools Computers.
  1. READ Day 1, 2, and 3 in E-Commerce Programing with ASP
  2. See Assignment #2.
  3. Review Request Object for both Get and Post Methods and how they work with Forms and ASP pages.
  4. Review Response Object and how it works with HTML and ASP pages.
  5. Review Request Object to get browser and Server variables.
  6. Review Cookies, Session and Application Variables of ASP pages.
  7. Review Global.asa files and it use with ASP pages.
  1. READ Day 4, and 5 in E-Commerce Programing with ASP
  2. READ Lessons 1, 2, 3, and 4 in SQL in 10 Minutes
  3. See Assignment #3
  4. Review the #Include Directive of ASP pages.
  5. Review the Error, Redirect, and Transfer commands of ASP pages.
  6. Review the File Access Component of ASP.
  7. Review the Access Database and relations to ASP pages.
  8. Create an Access Database for E-Commerce ASP pages.
  9. Review the SELECT, WHERE, and ORDER BY commands of SQL.
  10. How to Connect to a ACCESS Database with ASP pages.
  11. How to UPDATE a Database with ASP pages.
  12. How to ADDNEW to a Database with ASP pages.
  1. READ Day 6, and 7 in E-Commerce Programing with ASP
  2. READ Lessons 5, 6, 7, 8, and 9 in SQL in 10 Minutes
  3. See Assignment #4
  4. How to Retrieve a Record from a Database with ASP.
  5. How to Display the Data with ASP pages.
  6. How to Create a Database Search with ASP pages.
  7. Review the AND, OR, and MATH Functions commands of SQL.
  1. READ Day 8, and 9 in E-Commerce Programing with ASP
  2. READ Lessons 14, 15, 16, and 17 in SQL in 10 Minutes
  3. See Assignment #5
  4. How to Create a Customer Login page using a Database.
  5. How to Validate Customer Data.
  6. How to generate Friendly Error pages.
  7. How to use SSL for secure data transfers.
  8. How to use Session Variables with a shopping cart.
  9. How to create a shopping cart using a Database.
  10. Review the INSERT, UPDATE, DELETE, and CREATE TABLE commands of SQL.
  1. READ Day 10, and 11 in E-Commerce Programing with ASP
  2. See Assignment #6
  3. How to Create a Customer Checkout page.
  4. How to Process the Customer Orders.
  5. How to Authorize Credit Cards.
  1. READ Day 12, and 17 in E-Commerce Programming with ASP
  2. See Assignment #7
  3. How to Create a Customer Tracking system.
  4. How to Remotely Administer your Database of Customers and Products.
  1. READ Chapter 1, and 2 in PHP 5 in easy steps
  2. PHP and MySQL working together.
  3. How to Create a MySQL Database of Customers and Products.
  4. See Mid-Term Exam
  5. Mid Term Exam (160 POINTS).
  6. Create your Mid term Exam ( Assignment 8 ) and have it uploaded to your site.
  7. Complete, the midterm for this week.
  8. Mid Term is due today.
  9. You are required to Present your Project to the whole Class Today (30 POINTS).

NO CLASS - Spring Break

  1. READ Chapter 3, and 4 in PHP 5 in easy steps
  2. See Assignment #9
  3. Arithmetic and other Operators.
  4. Conditional Statements in PHP
  1. READ Chapter 5, and 6 in PHP 5 in easy steps
  2. See Assignment #10
  3. Using Arrays.
  4. Creating dynamic pages from MySql databases .
  1. READ Chapter 7 in PHP 5 in easy steps
  2. See Assignment #11
  3. How to use PHP to handles your system files.
  4. How to sort your image files.
  5. How to upload images or files with PHP.
  1. READ Chapter 8 in PHP 5 in easy steps
  2. See Assignment #12
  3. How to Create a Data Persistence for Customer Tracking.
  4. That is the Question? - Cookies or Sessions.
  1. READ Chapter 9 in PHP 5 in easy steps
  2. See Assignment #13
  3. How to send e-mail using PHP.
  4. What is required to send E-Mail from your server.
  1. READ Chapter 10, and 11 in PHP 5 in easy steps
  2. See Assignment #14
  3. Putting it all together with MySql.
  4. Your Final Project.
  1. READ Chapter 12, and 13 in PHP 5 in easy steps
  2. See Assignment #15
  3. How to create a guest book.
  4. How to manage your data remotely.
  1. Final Exam (200 POINTS).
  2. Create your Final Exam Project and have it uploaded to your site.
  3. You are required to Present your Project to the whole Class Today (40 POINTS).
  4. You are required to have a return link from your Final Exam Project to your index page.
  5. If the final exam is not ready today you will get 0 for your final since the grades must be turned in on Friday.