Centre for Continuing Education

PHP & MySQL Course: Level 1

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

Learn Web Development the smart way with Web Development training courses at CCE, the University of Sydney.

This PHP and MySQL course will provide you with the skills and knowledge necessary to create dynamic database-driven websites using both PHP – the fastest-growing scripting language in the world, and MySQL – the world’s most popular open source database. After all, Facebook, Wikipedia and WordPress were all built on PHP and MySQL. This PHP and MySQL course will be delivered as a practical workshop which includes demonstrations and hands-on exercises in class, along with programming notes.

Outcomes

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.

Content

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. Learning techniques include:

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

Materials

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 completion.

Features

  • $50 repeat class - Conditions apply
  • Expert trainer
  • Dedicated computer for every student
  • Small class size
  • Statement of completion

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>This PHP and MySQL course will provide you with the skills and knowledge necessary to create dynamic database-driven websites using both PHP –

...
PHP & MySQL Course: Level 1

<p>{block name:“Course Tagline - Web Development”}</p><p>This PHP and MySQL course will provide you with the skills and knowledge necessary to create dynamic database-driven websites using both PHP –

...