Introduction to PHP and MySQL
Developers familiar with Dreamweaver, HTML or CSS concepts can use PHP and MySQL database to create dynamic websites. Learn to configure dynamic sites, write commands and create galleries.
Quick Facts
Duration: 4 Days
Class Size: 10
Level: Beg / Int
Times: 9.00am to 5.00pm approx
About the Course
During this 4 day course, participants will step through how to build an entire dynamic website, ensuring that they have the necessary experience, skills and confidence to build a dynamic website later on. Students will learn how to install and configure the Apache, PHP, and MySQL software, and write commands in Structured Query Language (SQL) to query and modify the MySQL database. Other topics include gathering and processing information from forms, file uploading, online galleries and password-protection.
Who should do this course?
This course is intended for anyone looking to create code a database-driven website using PHP and MySQL.
Prerequisites
Participants should have already completed the Dreamweaver CS4: Website Development course or have the equivalent experience and understanding of HTML and CSS.
Course Units
- Unit 1: Introducing the Course
- - Getting familiar with the course methodology and format
- - Understanding the course objectives and pre-requisites
- - Why PHP and MySQL?
|
- Unit 2: Installing the Software
- - Installing Notepad (text editor) and WinMerge (file comparison utility)
- - Installing Apache
- - Installing PHP
- - Configuring Apache to work with PHP and testing PHP
- - Checking your PHP settings
|
- Unit 3: Writing PHP Scripts
- - Using variables
- - Commenting scripts
- - Using arrays to store multiple values
- - Using quotes correctly
- - Loops and functions
- - Displaying PHP output
|
- Unit 4: Using Includes to Streamline your Workload
- - Including content from other files
- - Identifying the current page with PHP
- - Creating pages with variable content
- - Dealing with missing include files
- - Displaying a random image
- - Using includes securely
|
- Unit 5: Bringing Forms to Life
- - Gathering information from a form with PHP
- - Sending email from a form
- - Validating user input
- - Handling multiple choice form elements
- - Redirecting to another page
|
- Unit 6: Uploading Files
- - Checking that your server supports uploads
- - Creating an upload directory
- - Checking filenames
- - Refusing large files
- - Restricting file types
- - Preventing files from being overwritten
|
- Unit 7: Managing Files with PHP
- - Checking that PHP has the necessary permissions
- - Reading files in a single operation
- - Read/write operations
- - Replacing content in a file
- - Appending content to a file
- - Exploring the file system
|
- Unit 8: Generating Thumbnail Images
- - PHP's image manipulation functions
- - Generating a scaled down version of an image
- - Resizing an image automatically on upload
- - Giving each thumbnail a unique name
|
- Unit 9 : Simple Login and Multipage Forms
- - Session management with PHP
- - Creating and destroying session variables
- - Using sessions to restrict authentication
- - Setting a session time limit
- - Passing information through multipage forms
|
- Unit 10: Setting up MySQL and phpMyAdmin
- - Installing and configuring MySQL
- - Installing and configuring phpMyAdmin
- - Launching phpMyAdmin
- - Installing the MySQL GUI Tools
|
- Unit 11: Getting Started with the MySQL Database
- - Introduction to database management
- - Setting up the MySQL database
- - Creating MySQL user accounts
- - Connecting to MySQL with PHP
- - Finding the number of records in a database query
- - Displaying the results of a query
|
- Unit 12: Creating a Dynamic Online Gallery
- - Planning the image gallery
- - Passing information with a query string
- - Displaying database results in a multicolumn table
- - Selecting subsets of records
- - Navigating through long record sets
|
- Unit 13: Managing Content
- - Safeguarding your data from SQL injection attacks
- - Writing SQL queries
- - Setting up a content management system
- - Creating the necessary database table
- - Inserting, updating, and deleting records
|
- Unit 14: Solutions to Common PHP/MySQL Problems
- - Extracting characters, words, paragraphs, and sentences from text
- - Manipulating dates
- - Working with multiple database tables
- - Finding records with no matching foreign key
- - Using lookup tables to resolve many-to-many relationships
- - Deleting records with dependent foreign keys
|
- Unit 15: Securing your Website from Intruders
- - Encrypting methods
- - Using one-way and two-way encryption
- - Registering new users
- - Updating user details
|
Upcoming Courses
|
Sydney
Level 11, 32 Walker Street
North Sydney
View map
|
- Date:
- 18-21 Oct 10
- 30 Nov - 03 Dec 10
|
|
Melbourne
Level 12, 379 Collins Street
Melbourne
View map
|
- Date:
- 18-21 Oct 10
|
|
Brisbane
C/- Training Choice, Mezzanine Level, 88 Creek Street
Brisbane
View map
|
- Date:
- 14-17 Dec 10
|
|
Canberra
C/- Training Choice, Level 4, 54 Marcus Clarke Street
Canberra
View map
|
Date: upon demand
|
|
Adelaide
C/- Mindfull Computer & Seminar, Level 4, 74 Pirie Street
Adelaide
View map
|
Date: upon demand
|
|
Perth
C/- Training Choice, Level 7, 105 St Georges Terrace
Perth
View map
|
Date: upon demand
|
Duration: 4 Days
Class Size: 10
Level: Beg / Int
Times: 9.00am to 5.00pm approx