pHP and MYSQL - essentials

The PHP with MySQL training course will provide Delegates with the skills and knowledge necessary to create dynamic database-driven websites. This course Includes demonstrations and hands-on exercises in class along with programming notes.

The PHP with MySQL class is suitable for those who have a working knowledge of HTML.

By attending PHP with MySQL workshop, Delegates will learn 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

COURSE AGENDA

  • Validating usernames and passwords with those stored in a database
  • Declaring a function
  • Calling a function
  • Returning a value from a function
  • Reading data from a database
  • Searching with SQL
  • Using loops to display multiple records
  • Creating a table with alternating row colors
  • Database backup tools
  • Writing to a text file
  • Magic Quotes and Stripslashes
  • File permissions
  • Writing to a database
  • Creating a table in a database
  • MySQL Datatypes
  • Why PHP is so popular
  • Use of different headers
  • Security and preventing server abuse
  • Using PHP to create HTML
  • Escaping characters
  • Comments
  • Displaying PHP variables as HTML
  • Receiving variables from a form and displaying them in the browserA
  • Conditional tests
  • Exiting out of PHP