PHP / MySQL Exercises

Activities, Handouts and Exercises

Activity – Introduction to PHP and MySQL – Web Server Scripting – Introductory Quiz

Activity – Introduction to PHP and MySQL – PHP Quiz

Activity – Introduction to PHP and MySQL – Try This Exercise 1 – Mixing PHP with HTML

Activity – Introduction to PHP and MySQL – Try This Exercise 2 – Building a Pounds to Dollars Convertor

Activity – Introduction to PHP and MySQL – Try This Exercise 3 – Handling Form Input

Activity – Introduction to PHP and MySQL – Try This Exercise 4 – Build an Interactive HTML Colour Sampler

Activity – Introduction to PHP and MySQL – Try This Exercise 5 – Testing Odd and Even Numbers

Activity – Introduction to PHP and MySQL – Try This Exercise 6 – Assigning Boy Scouts to Tents

Activity – Introduction to PHP and MySQL – Try This Exercise 7 – Building a Factorial Calculator

Activity – Introduction to PHP and MySQL – Self Test 1

Activity – Introduction to PHP and MySQL – Self Test 2

Activity – Introduction to PHP and MySQL – Self Test 3

Activity – Introduction to PHP and MySQL – Self Test 4

Activity – Introduction to PHP and MySQL – Self Test 5

Activity – Introduction to PHP and MySQL – Self Test 6

Activity – Introduction to PHP and MySQL – Self Test 7

Activity – Introduction to PHP and MySQL – Self Test 8

Activity – Introduction to PHP and MySQL – Self Test 9

Activity – Introduction to PHP and MySQL – Self Test 10

Activity – Introduction to PHP and MySQL – Self Test 11

Activity – Introduction to PHP and MySQL – Self Test 12

Handout – Introduction to PHP and MySQL – Why choose PHP?

Handout – Introduction to PHP and MySQL – What is a Dynamic Web Page?

Handout – Introduction to PHP and MySQL – How Web Servers Work, Internet Protocols TCP-IP and HTTP

Handout – Introduction to PHP and MySQL – Server-Side Scripting and Client-Side Scripting

Handout – Introduction to PHP and MySQL – Alternatives to ASP

Handout – Introduction to PHP and MySQL – Basic Development Concepts

Handout – Introduction to PHP and MySQL – Client-Side Scripting

Handout – Introduction to PHP and MySQL – How Scripting Languages Work

Handout – Introduction to PHP and MySQL – Introduction to Dynamic Web Content

Handout – Introduction to PHP and MySQL – Server Side Applications

Handout – Introduction to PHP and MySQL – Server-Side Languages in Use

Handout – Introduction to PHP and MySQL – Why use PHP and a look at the alternatives

Handout – Introduction to PHP and MySQL – Understanding Client-Server Architecture

Activity – Introduction to PHP and MySQL – Test Your Knowledge – Exercises 1

Activity – Introduction to PHP and MySQL – Test Your Knowledge – Exercises 2

Activity – Introduction to PHP and MySQL – Test Your Knowledge – Exercises 3

Activity – Introduction to PHP and MySQL – Test Your Knowledge – Questions 4

Activity – Introduction to PHP and MySQL – Test Your Knowledge – Questions 5

Actvity – Introduction to PHP and MySQL – Test Your Knowledge – Questions 6

Activity – Introduction to PHP and MySQL – Test Your Knowledge – Questions 7

Activity – Introduction to PHP and MySQL – Test Your Knowledge – Questions 8

Activity – Introduction to PHP and MySQL – Test Your Knowledge – Questions 9

Activity – Introduction to PHP and MySQL – Test Your Knowledge – Questions 10

Activity – Introduction to PHP and MySQL – Test Your Knowledge – Questions 11

Activity – Introduction to PHP and MySQL – Test Your Knowledge – Questions 12

Activity – Introduction to PHP and MySQL – Test Your Knowledge – Questions 13

PowerPoint – Introduction to PHP MySQL-Introduction-February 2016-short

PowerPoint – Introduction to PHP MySQL – Introduction – Using WAMP

Handout – Introduction to PHP and MySQL – Hypertext Preprocessor – PHP – A Web Server-Side Technology

PowerPoint – Introduction to PHP and MySQL – Using Variables, Statements and Operators

Activity – Introduction to PHP and MySQL – Using Variables, Statements and Operators

PowerPoint – Introduction to PHP and MySQL – Writing PHP Pages

Activity – Introduction to PHP and MySQL – Writing PHP Pages

Activity – Introduction to PHP and MySQL – Conditional Constructs with If

Activity – Introduction to PHP and MySQL – Exercise 1 – Adding a Greeting and Date and Time Stamps to a Page

Activity – Introduction to PHP and MySQL – Processing Data from Online Forms

Activity – Introduction to PHP and MySQL – Exercise 2 – Personalizing the Homepage for BLDC

Activity – Introduction to PHP and MySQL – Working with Cookies

Activity – Introduction to PHP and MySQL – Exercise 3 – Enhance the BLDC Home Page with Cookies

Activity – Introduction to PHP and MySQL – Maintaining State with Sessions

Activity – Introduction to PHP and MySQL – Exercise 4 – Building a Shopping Cart for BLDC

Introduction to PHP and MySQL – Understanding SQL Statements

Activity – Introduction to PHP and MySQL – How to Write PHP Scripts

Writing_Scripts_Files (Zipped file)

Activity – Introduction to PHP and MySQL – Making Statements – Control Structures

Activity – Introduction to PHP and MySQL – Working with Forms

foodbnr

Activity – Introduction to PHP and MySQL – Environment Variables

Handout – Introduction to PHP and MySQL – Understanding PHP error messages

Activity – Introduction to PHP and MySQL – PHP Error Handling

Activity – Introduction to PHP and MySQL – Server Date and Time

Activity – Introduction to PHP and MySQL – Saving Form Data to a Text File

Activity – Introduction to PHP and MySQL – Cookies and Sessions

Activity – Introduction to PHP and MySQL – Using Arrays

Activity – Introduction to PHP and MySQL – More Using Arrays

Handout – Introduction to PHP and MySQL – Using your File System

Activity – Introduction to PHP and MySQL – Random Number Generator

images for Random Number Generator (Zipped file)

Activity – Introduction to PHP and MySQL – Working with Files and Directories – Creating a PhotoGallery

PhotoGallery Images (Zipped file)

Activity – Introduction to PHP and MySQL – PHP and MySQL Together

Activity – Introduction to PHP and MySQL – PHP and MySQL Together – Part 1

Activity – Introduction to PHP and MySQL – Lee Office Supplies

Activity – Introduction to PHP and MySQL – Lee Office Supplies – Login System

Activity – Introduction to PHP and MySQL – User Authentication

create_table.txt (Change the file extension to .php)

Handout – Introduction to PHP and MySQL – PHP Functions for Working with MySQL

Handout – Introduction to PHP and MySQL – Web Server Scripting – Security Fundamentals

Activity – Introduction to PHP and MySQL – Witing Secure Code

Activity – Introduction to PHP and MySQL – Writing Secure Code – Magic Quotes, Removing Backslashes and Converting HTML into entities

Activity – Introduction to PHP and MySQL – A PHP Guestbook Application

Activity – Introduction to PHP and MySQL – Sample Application – News Publishing System

Activity – Introduction to PHP and MySQL – Mannerings Estate Agency

Activity – Introduction to PHP and MySQL – Mannerings Estate Agency – Suggested Solution

Activity – Introduction to PHP and MySQL – Frankoni Purchases Table

Activity – Introduction to PHP and MySQL – Activity – Frankoni Search Facility