Intermediate PHP with MySQL

     This course examines the issues associated with the development of a dynamic web page. Emphasis is placed on using the power of PHP to link to server side databases (MySQL), files, and directories for creating pages that mine data about past user interactions. Taking data from a user can be a security issue if your code is insecure. This course will examine functions and techniques essential for securing your system while providing a rich user experience. Best practices for development of the page are covered to provide guidelines while creating a dynamic web page. A web appliaction is developed as the student progresses through each chapter.

Topics Covered

  • Creating a User Interface
    • Determine the purpose of your page
    • Knowing your user
    • Design and layout
    • What tools you will use
    • Helping users
  • Database Access with PHP
    • Connecting to a database
    • Creating a database query
    • Displaying data
    • Inserting, Deleting, and updating data
    • Using transactions
    • Closing database connections
  • Error Handling and Debugging
    • Sources of errors
    • How errors are output
    • PHP error codes
    • Working with errors
    • Php.ini settings for Error handling
    • Exception error handling
    • Debugging techniques
  • Security
    • Designing for security
    • Identifying threats
    • Securing PHP source code
    • Securing SQL on input
    • Securing server access
  • Data validation
    • PHP string cleaning functions
    • Validation with Regular Expressions
  • Accessing files and directories
    • Opening files
    • Reading files
    • Writing to files
    • Closing files
    • Changing permissions
    • Reading directory contents
    • Security considerations
  • Uploading/Downloading files
    • How uploading works
    • Configuring PHP for uploading
    • Modifying Forms to allow uploading
    • Error codes for file uploads
    • Limiting upload file size
    • Security considerations
  • Cookies and Session Management
    • How cookies work
    • How Sessions work
    • Controllong a Session
    • Using a Named Session
    • Cleaning up after a Session

Audience:

     This course is designed for the Web developer who is ready to take their web page up a notch. By tying the content of the page to a database, the user experiences a more personal and richly rewarding interaction and the developer knows their data is secure during this interaction.

Prerequisites:

Benefits:

     The student will be able to design dynamic web pages linked to a database, process and evaluate PHP error messages, troubleshoot the design process, and secure their system.

Furnished Materials:

  • PC Workstation for use during training
  • Student Manual

Recommended Follow-On Course

Length:

  • 4 Days

Price:

  • $1,995

Training Dates:

Sign Up