Create Project Site Interactivity on your Website (Index)

New Index page on dedicated server!

Time to use JavaScript and a few little design principles...

Now that we've been coding in JavaScript and building Web pages, it's time to create your own (website). Choose a multi-column layout and build a page of your own design. Then, utilize several JavaScripts on your pages. A jQuery slideshow is required in a precontent section.

Make your page dynamic. You're no longer just a Web Designer, but a Web Developer. That's awesome (I just gave birth to you).

Also, we want to start thinking about design principles, so we need to learn a little about it. Remember to use color theory in selecting your Web page colors, and think about your typography (fonts). I suggest you use your fonts in images, not CSS just yet.

I want you familiar certain fonts, so we will go over those. Here are resources you will need:

Readings On Design:

Just Creative Design
Life Hacker Design

Readings On Typography:

Interactive Typography
Designzzz
Typography.com
Five Simple Steps
Google Fonts API
Typography Best Practices
New Options for Web Fonts

Explore Fonts:

Font Squirrel
DaFont

Watch:
Vignette 1 - Font Fight
Vignette 2 - Font Conference

We need to be familiar with these fonts. Look them up!

On Color Theory:

Color Matters
Color Wheel Image
Color Wheel Scheme Generator

Requirements for this assignment:

• Multi-Column Layout
• Use a Precontent Div
• jQuery Slideshow
• wrapper background image
• Use typography tips and fancy font
• Use color theory

Modify Your Website (index)

JavaScript Cascading Menu + Navigation using jQuery

EXTRA CREDIT
Add and configure a multi-level cascading menu.

Add Positioned Div images

Read: PHP

Create PHP Sandbox for Demos and practice

Required: All future php assignments must be customized and styled. Adapt the programming structure (code) to something new. Use graphics when possible.

In order to grade your PHP assignments, I must be able to see your code. Please create two pages for each PHP assignment as follows:

Your assignment031.php file will include a link to your working php code file. In addition, I will show you how to show the source of print.php in your assignment031.php file using the show_source(); function.

Code assignment031.php | print.php

PHP - Printing - print("hello"); or echo "hello";

Notes:

• You can use print for html - print("<br />");
• Use the dot to concatinate - print("I love" . $her);
• Use escape character \ to print quotations

PHP - Variables - $teacher="Chagoyan";

Variables start with a dollar sign $

PHP - Comments -

//This is a single line comment

/*This is a
multiple line
comment */

#This is another form of single line comment

PHP - Constants - define("TIP_RATE", .15);

Some variables never or rarely change. Define them.

PHP - Datatypes - Boolean, Integer, Double, and String.

10 is an integer
1.25 is a double (float)
"Coalnga" is a string
1 or 0 are booleans (true or false)

PHP - Includes

Split your assignment030b (index page) Website into multiple files using the php include statement. Your page should be composed of six files.

index.php
sec_topnavigation.php
sec_leftcolumn.php
sec_rightcolumn.php
sec_bottomnavigation.php
sec_footer

PHP - Includes

Create three additional pages for your assignment053 (index page) on a topic that interests you.

Remember to remove heights from columns and add the minimum height hack before making the new pages!

PHP - Math Operators

+, -, *, /, and %

Programming Structures

PHP - If

PHP - Comparison

PHP - Else

PHP - While Loops

PHP - Do While Loops

PHP - Break

PHP - Switch

PHP - Arrays

PHP - ForEach

Passing data from one page to another

PHP - HTML Controls (200 pts.)

Databases Overview

Creating Tables
Fields and Datatypes

Using Microsoft Access

Activity 1 - Access It!

Celebrity Addresses

Acitivity 6 Access It!

NASCAR

MDB | HTML

Activity 8 Access It!

Jobs

MDB | HTML

Acitivity 6 Access It!

Database Overview

Creating Queries
Select Queries using NASCAR

Query 1 - TOP 10 WINNINGS

Query 2 - ROOKIE DRIVERS

Activity 17 Access It!

PGA Tour

MDB | HTML

Creating Tables - MySQL

MySQL - Create Table

Using your own username and password, connect to MySQL, select the database, and create the Celebrity Address table.

- Use phpMyAdmin within your dedicated server account.

Celebrity Addresses

Creating Queries - Access

Using CHSAlumniDB

Demo - Creating Queries

Create/Export the following queries:

Query 1: How many gifted children have criminal parents?

Query 2: Provide a list of alumni who earn more than $30,000 in descending order by earnings.

Query 3: How many children are suffering because their parents didn't go to college and, as a result, make less than $20,000.

Query 4: Who makes the most money and what is their career?

Query 5: What do non high school graduates drive?

Include all the fields that make the query meaningful! Remember, export as HTML and link to the query results and your .MDB file..

Selecting Data - MySQL

Celebrity Addresses

Creating Queries - MySQL

Query1 | Query2 | Query3