Centre for Continuing Education

PHP & MySQL Course: Level 1

Web development. Create and maintain fast, secure and exciting websites.

COVID-19 update: arrangement of our courses

We are now delivering courses both online and in-person. Please check the delivery format for each class before you enrol.

Please note that course materials for all classes (excluding prescribed textbooks) are shared electronically within 48 hours of a course starting. Printing is not available.

This PHP and MySQL course will provide you with the skills and knowledge necessary to create dynamic database-driven websites using both PHP – one of the most popular programming languages, and MySQL – the world’s most popular open source database. After all, Facebook, Wikipedia and WordPress were all built on PHP and MySQL.

This course will be delivered as a practical workshop which includes demonstrations and hands-on exercises in class, along with programming notes.


By the end of this course, you should be able to:

  • discuss the concepts of PHP and its advantages over other languages
  • use HTML form elements that work with any server-side language
  • create a PHP web page that is unique to each visitor
  • validate user input
  • create, back up and restore a MySQL database
  • perform various MySQL database queries
  • create a search engine
  • create, sign up and login to a password-protected site
  • hack a site and prevent others hacking theirs
  • create dynamically-generated tables
  • customise the theme for a WordPress site
  • use PHP-driven dynamic content in HTML5 animations
  • seek solutions to any PHP problems and further your knowledge.


Background and history of PHP

  • Why PHP is so popular?

Incorporating PHP into HTML

  • Using PHP to create HTML
  • Escaping characters
  • Comments

Processing form data

  • Displaying PHP variables as HTML
  • Receiving variables from a form and displaying them in the browser

Validating form data

  • 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

Hacking a site and preventing others from hacking yours

  • Attack and defence with SQL injection

The PHP behind WordPress

  • Customising a WordPress theme

Troubleshooting, further reading and exploration

  • PHP, HTML5 and CSS3

Intended audience

Suitable for those who have a working knowledge of HTML.

Delivery style

Delivered as presenter-taught computer-based training in a computer lab. Learning techniques include:

  • demonstrations and hands-on exercises in class
  • programming notes.


Please bring along a Windows USB flash drive if you would like to make an electronic copy of course materials. You are also welcome to use an alternative storage space to copy files.

Course 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 Statement of Completion is issued upon course completion.


  • $50 repeat class - Conditions apply
  • Expert trainer
  • Small class size
  • CCE Statement of Completion

Apply for the IT repeat discount.

What others say.

  • Absolutely fantastic stuff! The tutor delivered great content with style and enthusiasm. I would definitely enrol in any future offerings that this tutor may be teaching.

  • The course tutor was extremely thorough with the explanations and delivered the course extremely well. Definitely would do another course with this tutor.

  • Good course, good tutor. The full day format is pretty intense but because it is only two days, it is manageable. Overall I enjoyed the experience and thank you for running these short courses.

  • I enjoyed the refreshing style of delivery where the course was taught with practical applications delivered as a demonstration and not death by Powerpoint. Thanks.

PHP & MySQL Course: Level 1

<p>{block name:“Course Tagline - Web Development”}</p><p>{block name:“Block - COVID 19 updates”}</p><p>This PHP and MySQL course will provide you with the skills and knowledge necessary to create


What others say.

  • The tutor was very engaging. I really enjoyed the course.
We acknowledge the tradition of custodianship and law of the Country on which the University of Sydney campuses stand. We pay our respects to those who have cared and continue to care for the Country.