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

Upon completion of this PHP and MySQL training course, participants should be able to:

  1. Discuss the concepts of PHP and its advantages over other languages.
  2. Use HTML form elements that work with any server-side language.
  3. Create a PHP web page that is unique to each visitor.
  4. Validate user input.
  5. Create, back up and restore a MySQL database.
  6. Perform various MySQL database queries.
  7. Create a search engine.
  8. Create, sign up and login to a password-protected site.
  9. Hack a site and prevent others hacking theirs.
  10. Create dynamically-generated tables.
  11. Use PHP-driven dynamic content in HTML5 animations.
  12. Seek solutions to any PHP problems and further their knowledge.

Content

This PHP and MySQL training course covers the following topics:

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.

Troubleshooting, Further Reading and Exploration

  • PHP, HTML5 and CSS3

Intended Audience

This PHP and MySQL training course is suitable for those who have a working knowledge of HTML.

Delivery Style

This PHP and MySQL training course is delivered as presenter-taught computer-based training. Learning techniques include:

  • Demonstrations and hands-on exercises in class
  • Programming notes

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

  • Free repeat class - Conditions apply
  • Free USB flash drive
  • Expert trainer
  • Dedicated computer for every student
  • Small class size
  • Student notes – yours to keep
  • 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.

$574 Limited GST free
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 PHP – the

...
$574 Limited GST free
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 PHP – the

...
$574 Limited GST free
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 PHP – the

...
If there isn't a class to suit you, please join the waiting list.