What it is?

Throughout our DPS program we used different tools to create databases we generated code for them and now we are learning about the use of dynamic Web 2.0 applications and communication tools in education. Web 2.0 is something we touch, feel and look at every day in our web activities.However, when we are working with Web 2.0 we are just looking at an image created for us.Going further then just to look at a superficial image of a Web 2.0 construct,I came up with an idea to take an internal look an X-ray, at/of the backbone of Web 2.0 the interactivityand see what makes the interactivity happen? Answering this question will create a connection between the two DPS courses( Databases and Web 2.0). The easiest way to see a dynamic website alive is to analyze its building blocks which are explained in my Ning video cast.Interactivity is realized basically throughout a set of tools.First HTML and PHP code are combined in a web application.A server will hold the web application.Special code like PHP, will realize dynamical of the application. A data base will hold the dynamically filled content.Here is "my first database" created with php MyAdmin.
This website contain some basic interactions to a database.Contains a relationship of one to many tables
http://www.lmiraj.com/

What it does?

XAMPP

XAMPP is a web development tool that lets you locally test the functionality of your dynamic web applications that interact with a data base.
XAMPP is available for mac and windows from apachefriends.org wesite.Follow the tutorial below to download and install it.
To create and administer MySql databases with phpMyAdmin follow the following tutorials:
  1. Familiarizing yourself with phpMyAdmin
  2. Creating tables in a MySQL database with phpMyAdmin
  3. Deleting tables in a MySQL database with phpMyAdmin
  4. Inserting fields into a MySQL database table using phpMyAdmin
  5. Modifying fields in a MySQL database table using phpMyAdmin
  6. Deleting fields in a MySQL database table using phpMyAdmin
  7. Exporting MySQL databases and tables using phpMyAdmin
  8. Importing MySQL databases and tables using phpMyAdmin
  9. Running SQL queries on a MySQL database using phpMyAdmin
  10. Renaming MySQL database tables using phpMyAdmin
  11. Searching through a MySQL database using phpMyAdmin
  12. Copying a MySQL database using phpMyAdmin

Data bases tables

http://db.grussell.org/sql3.html
http://db.grussell.org/sql2.html
http://sqlzoo.net/
http://sqlzoo.net/1.htm
http://databases.about.com/od/careers/l/aajoins1.htm

Creating Database-driven Websites with PHP&MySQL

by Jochen Rode
**Setting up a database**
Preparing a MySQL database
**Interacting with a database**
Connecting to a database
**Resources**

Connecting to a data base PHP easy steps

Beginning PHP MySQL Web Development
http://mln-web.cs.odu.edu/~mln/code/ch03.htm
http://www.phpeasystep.com/mysql/6.html

1) Date Picker
http://fundisom.com/phparadise/php/forms/datepicker

PHP Builder
http://www.phpbuilder.com/board/showthread.php?p=10902960

PHP Manual
http://www.php.net/manual/en/

http://www.scribd.com/doc/3442652/ajay1kumar1-PHP6-MYSQL0111

FOR LOOPS: Select name=Year or select name="dateYY"
http://www.php.net/for

For Loop
http://www.fundisom.com/phparadise/php/forms/keep_selected_combobox

Get more code from
http://www.fundisom.com/phparadise/

2) Change Site Background color daily Using PHP Dynamically
http://www.weberdev.com/get_example-4676.html

PHP are great for processing input forms ...
http://phpjournal.blogspot.com/

3) PHP Script Tips - Understanding and Managing Cookies
http://dev.fyicenter.com/faq/php/php_managing_cookies.php

4) http://aelinik.free.fr/php.htm

5) http://www.peachpit.com/articles/article.aspx?p=483799