Blog 1

EA Games - Blog Entry

1. What did we do?
2. What did you learn

Brain Storm

Keywords:

crunch, portfolio, teams, community, system development life cycle, inspiration...

JavaScript - getElementByID - Lotto Numbers
Update targetDiv with .innerHTML

Generate 6 numbers by using a for() loop

Demo (as intro)

example

External .js Script

To create external javascripts use:

<script language="javascript" type="text/javascript" src="changedivs.js">

</script>

JavaScript - getElementByID - Lotto Numbers
Update targetDiv with .innerHTML

Use button to update numbers!

Generate 6 numbers by using a for() loop, one if () statement, a function, and a button

example

External .js Script

To create external javascripts use:

<script language="javascript" type="text/javascript" src="changedivs.js">

</script>

JavaScript - getElementByID - Change Span

Changeing innerHTML

External .js Script

JavaScript - getElementByID - Change Span

Changing Styles with JavaScript

External .js Script

JavaScript - getElementByID - Hide Divs and Show Divs (show divs on your own for credit)

Using visibility property

External .js Script

JavaScript - getElementByID - Hide Table

External .js Script

Challenge Assignment #1- 100 pts -

Note: Some of this scripts require an older or no Doctype. Try the html5 Doctype...

Using Premade JavaScripts - Dynamic Drive

Utilize 5 JavaScripts

Demo:

bouncing image demo (For IE the body must have a height)

Open the included .js files. Play with configuration settings and the image

Example: bouncing image demo (One of yours)

Writing in a div

Hello World

Waiting for the DOM to load using $(document).ready( )

Ready Event

(Often used when jQuery is included in the head section)

Method Chaining with .css

Method Chaining with .css (multiple changes)

Fade Out

Fade Out and Fade In

Slide Toggle

Putting it all together

Demo Zip File

This keyword

events

.mouseover() | .mouseout()

toggleClass

.click() event

jQuery UI (User Interface)

jQuery UI Download

Demo

Challenge Assignment #2 - 100 pts -

Using the jQuery Framework - jQuery

Utilize 4 plug-ins

Demo:

angrybirds

Example: slidesow (One of yours)

.animate() Tutorial

Community Business Website Project
Part 1 - Template (200 points)

Informational Website

Partner Project

Create a one page design for an approved local business.

Read:

Forbes: How To Build A Killer Small Business Web Site
eHow: How to Build a Business Website
About.com: How to Create a Small Business Website That Works

Also check out competitor Websites. It will give you ideas.

Select a local business from Coalinga or Huron. You must obtain general information to start such as:

Available Domain Names
Logos
Official Colors
Slogans
Business Cards
Contact Information
Services Provided
Products Sold
Flyers
Pamphlets
Photographs

Use all the skills you have learned thus far.

CHECKLIST

Assignment requirements for this assignment are:

1. Project file is named index.html (not project01.html)
2. Use the css reset (advanced version)
3. Use the height hack for growing columns
4. Use OPTIMIZED images (.jpg, .gif, or .png when needed)
5. Complex Layout. No one, two or three column layouts.
6. Background Images such as:
1. Container background image
2. Header background image
3. Wrapper background image
4. Content background image
5. Footer background image
7. Use a favicon
8. Use JavaScript
9. Use jQuery (Slideshow required)
10. include all contact information: Address, Phone, Fax, Email
11. use a form
12. Add meta tags (see my source and look at the top meta tags)
13. *Include .php - (include statement for sections)
    

* This project is for educational purposes only. The site will be hosted temporarily on our Web server for testing purposes.

Audio

Video

Layout

Menu (optional)

css3menu.com

Contact Form

jotform.com

Read: PHP

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

Assignment 033a

Index Page Update

PHP - Includes

Demo

Split your index page into multiple files using the php include statement. Your page should be composed of up to six files.

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

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)

Index Page Update

PHP - Includes

Create two additional pages for your web site on topics that interests you.

PHP - Math Operators

+, -, *, /, and %

PHP - If

PHP - Comparison

PHP - Else

PHP - For Loops

PHP - While Loops

PHP - Do While Loops

PHP - Break

PHP - Switch

PHP - Arrays

PHP - ForEach

Assignment 047

Passing data from one page to another

PHP - HTML Controls (200 pts.)

Assignment 048

Index Page Update

Assignment 049

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