PHP & MySQL Server Side Development

Introduction   ~   PHP   ~   PHP Hosting   ~   MySQL   ~   PHP/MySQL   ~  Accessibility   ~   Resources

PHP
  Description The Code Show! Tasks
1 The "Hello World" script "Hello World" Do it 1
2 Code to generate PHP configuration info Get PHP config info Do it 2
3 Mixing It! 1 2 1 2  
4 Variables and operators      
5 Forms Handling
Visitor enters their name in a form which is sent using "GET" to a welcome page

1. Form
2. Welcome page

 Do it 3a
5 Visitor enters their name in a form which is sent using "POST" to a welcome page 1. Form
2. Welcome page		 Do it
6 More info about forms handling 2. Strip slashes Do it 3b
7 Control Structures
Normally PHP statements are executed in order - but there are times when you want to change this. 		if
if... else
while
for
comparisons & logic
1 2
Do It		  
7 Email email code   3c
8 Clever Mixing! - how to build a table on the fly build table. Do it
Do it		 4.
5.
9 Multipurpose pages multi-page Do it 6
10 Cookies session
persistant		 Do it
Do it 		 
11 Includes main ~ inc.file Do it 7
12 Arrays For
Each 		For
Each		 8
13 File handling Price list 1
Price list 2		 1
2

9
10
13 Tracking Visitors - a fun (yet important) diversion PHP tracker
Another example
Javascript tracker 		   
14 Functions   10½ 10½
15 Sessions Page1   Page2 Do it 11
16 Major Task - password protected secure site passwordgate 1
2		 12
17 Generating a "random" password     13
We have now covered enough PHP to be able to create a full e-commerce shopping cart system
(or just about any other web application you choose) but as such systems would normally be linked to an online database, we will get to grips with MySQL first...

MySQL
  Description     Tasks
20 Getting started with MySQL      
21 Creating a table
Inserting rows in (adding data to) a table
Amending rows		      
22 Security - backup and restore tables     14
23

Selecting data
Conditional queries using Where

     15
24 Modifying a table      
25 Sorting the results of a SELECT      
26 Summary and Grouping information      
26 The SELECT statement in a nutshell!      
27 Relational Databases     16
28 Integrity and constraints     17
29      
30 More clever stuff - IN and AS     18
         

PHP~MySQL
  Description The Code Show! Tasks
40 Reminder of the principles      
41 Connecting to your database      
42 Handling a "result set" + get table names get table names do it 19.
43 Querying a table. display customer table do it 20
44 Querying 2 or more tables - and manipulating the result set   do it 21
45 Security issues - database connection      
46 Using a form to add rows to a table   do it  
47 Validation of form data - incl natty little error handling function!   do it  
48 Using a form to amend rows in a table   do it  
49 A bit of a coming together of ideas      
         

Other Stuff
60 Frames...... yuck!   do it  
61 Style Sheets.
Defining classes		 HTML for page   22

Accessibility
70 What's it all about?      
71 The whole scenario!      
72 XHTML     A
73 CSS.     B
74 Validation     C
75 Other accessibility issues      
76 JavaScript right click "Save target as..."
functions1.htm
events1.htm
clicks.htm
average.htm
   
77 JavaScript form validation   Example 24
78 DHTML - Using JavaScript to manipulate the DOM right click "Save target as..."
nodes.htm
style.htm
expand.htm
slide.htm
scroll.htm 		  25
79 Dynamic Menus      

Resources
         
       
       
 

We have taken the care to create an interoperable Web page, as shown by these logos/links:
Valid XHTML 1.0 Strict Valid CSS!