The primary objectives of this course are the following:
The student will develop an intermediate level proficiency in the use of HTML, Javascript, PHP and mySQL as applied to accessing databases over the world-wide web. The student will be able to use these development tools together to develop interactive web-based applications that access databases. Applications developed in the course will utilize graphic images, tables, forms, frames, client and server-side programming and database interfaces in a interactive GUI environment.

The Course Computing Environment

1. Email
2. Course Web Pages
3. Class Accounts on the student server.
4. Using FTP
5. Submitting your work - homework, assignments, etc.

An Overview of Web Serving and Surfing

The Basics and More

Web servers

Web clients (browsers)

HTML

Your web directories

VBScript and JavaScript

CGI programming

HTML

The Basic HTML tags

• Document templates
  • HEAD, TITLE
  • BODY
  • A Standard Ending
• Basic text formatting
  • Text styles - sizes, fonts, colors, alignment, etc.
  • Lists - unordered, ordered, styles
• Identifying resources
  • Anchors and Names
  • URLs
  • links
• Using graphic images - the basics
  • Inserting and aligning images
  • Background images
  • Image links

Intermediate HTML

• Doing more with graphic images
  • Transparent images
  • Animated images
  • Client side image maps - another example, A tour of Lynchburg College
• Formatting with Tables, Frames, etc
• Collecting information from the user using Forms
  • Form controls and their properties
  • Formatting forms using tables

Style Sheets

• Cascading style sheets and their properties
• JavaScript style sheets and their properties

JavaScript

Overview

• An object oriented programming language within HTML
  • Data types
  • Literals
  • Operators
  • Statements
• A scripting language for HTML
• Writing a first JavaScript

Objects in JavaScript and HTML

• Classes and Objects
• Properties
• Methods
• Events

Functions and parameters

Event Handling

Database design

The .mdb file

Tables, Fields and Recordsets in Access

Stored Procedures/Queries in Access

Relationships

An Introduction to SQL

Procedural vs. Nonprocedural Programming

Tables, Fields and Recordsets

Queries

SQL syntax

The PHP Programming Language

Web Access to Databases Using PHP and mySQL

The concept.

Installation

Using the tools

Grading :
The standard 10 point grading scale will be used.
(i.e. 90-100 = A, 80-89 = B, 70-79 = C, 60-69 = D, below 60 = F)
THERE WILL BE NO CURVE. You will always know approximately how you are doing in the course by applying the above factors to your grades to date.

Important notes:

1. If you are having trouble with the course come to me for help right away - DO NOT WAIT.
2. You are responsible for attending class, completing assignments on time, taking tests when scheduled, knowing the College's grading policies, knowing course withdrawal dates and making up all missed work.
3. As always, the honor code is in full effect. You may NOT collaborate on tests. You may NOT collaborate on projects and programs except as instructed by me. If you are ever in doubt of whether or not an action constitutes an honor violation ask me beforehand.
4. Class participation on your part is an excellent means of making our classes more interesting and demonstrating to me your knowledge of and interest in the subject matter.

Required Materials:
PHP and MySQL Web Development by Luke Welling and Laura Thomson.
The publisher is Sams Publishing
Internet Explorer version 6.0 or above.

Recommended Materials:

PHP and mySQL installation files

HTML 4 reference

Cascading Style Sheets reference

Javascript reference

The College will make reasonable accommodations for persons with appropriately documented disabilities. Students should notify the Support Services Coordinator, located in the Academic Advising Office on the second floor of Hall Campus Center, and provide documentation of their disability in order to be considered eligible for accommodation. Students are encouraged to do this as soon as possible prior to or at the beginning of each semester, so their needs can be arranged in a timely fashion. It is the student’s responsibility to notify the professor once accommodations are approved by the Support Services Coordinator. Accommodations in individual classes will be effective when the student provides the professor with a copy of their Accommodation Memo.

---

Top of this page         Home page