Learn how to create dynamic database-driven websites using PHP and MySQL – the fastest-growing scripting language in the world. The course includes demonstrations and hands-on exercises in class along with programming notes.
Course Content
Background and History of PHP
Incorporating PHP into HTML
- Using PHP to create HTML
- Escaping characters
- Comments
- Displaying PHP variables as HTML
- Receiving variables from a form and displaying them in the browser
- Conditional tests
- Exiting out of PHP
Sending Email from a Web Page
- Use of different headers
- Security and preventing server abuse
Embedded “Include” and “Require” Files
- Making life easy and your designs consistent
Exporting Data
- Writing to a text file
- Magic Quotes and Stripslashes
- File permissions
- Writing to a database
- Creating a table in a database
- MySQL Datatypes
Importing Data
- Reading data from a database
- Searching with SQL
- Using loops to display multiple records
- Creating a table with alternating row colours
- Database backup tools
Creating Re-useable Functions
- Declaring a function
- Calling a function
- Returning a value from a function
Password Protecting Pages and Data
- Validating usernames and passwords with those stored in a database
Troubleshooting, Further REading and Exploration
- PHP and Flash
- Useful websites
Course Delivery
Presenter taught computer based training. Learning Techniques include:
- Demonstrations and hands-on exercises in class
- Programming notes
Course Outcomes
By the end of this course, participants will be able to:
- Discuss the concepts of PHP
- Create PHP web pages
- Develop a database-driven PHP application
- Seek solutions to any PHP problems and further their knowledge
Suitable for
This course is suitable for those who have a working knowledge of HTML.
Assessment
The knowledge and skill level of students varies from class to class. Consequently in some classes it may not be possible to cover all the topics listed on this outline in equal depth. A certificate of attendance is issued upon completion.
Centre for Continuing Education
Directions
Centre for Continuing Education
160 Missenden Road
Newtown
2042
Centre for Continuing Education
Directions
For directions from your location, enter your address in the Directions from field above the map shown below, then click the Get Directions button.
For University of Sydney campus maps and guides, visit sydney.edu.au/maps.
Public Transport
For public transport information visit 131500.com.au or phone TransportInfo on 131500.
Other Information
Secure Parking is available through the RPAH Medical Centre located on the corner of Missenden Road and Carillon Avenue (entry to the car park is via Elizabeth Street, off Carillion Avenue). Parking is available on weekdays only between the hours of 7:00AM – 7:00PM at a rate of $38/day or $9/day after validating your ticket at CCE’s reception. All CCE participants who validate their tickets at reception are required to park their vehicles on Level B3. If the validated ticket does not register in the car park’s ticketing machine, cancel the transaction then reinsert your ticket into the ticketing machine until the $9 fee appears.
Parking costs and parking arrangements for University of Sydney facilities are available here.
