MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

PHP with MySQL Beyond the Basics

Course Summary

Shows how OOP techniques can streamline database queries, help manage sessions, and simplify user logins.       

  • +

    Course Syllabus

       Using the exercise files
    1. Installation and Project Setup
       PHP and MySQL installation
       Project setup
    2. Intermediate PHP Techniques
       Using variable variables
       Applying more array functions
       Building dates and times: Epoch/Unix
       Formatting dates and times: Strings and SQL
       Setting server and request variables
       Establishing global and static variable scope
       Making a reference assignment
       Using references as function arguments
       Using references as function return values
    3. Introduction to Object-Oriented Programming (OOP)
       Introducing the concept and basics of OOP
       Defining classes
       Defining class methods
       Instantiating a class
       Referencing an instance
       Defining class properties
    4. OOP in Practice
       Understanding class inheritance
       Setting access modifiers
       Using setters and getters
       Working with the static modifier
       Reviewing the scope resolution operator
       Referencing the Parent class
       Using constructors and destructors
       Cloning objects
       Comparing objects
    5. Photo Gallery Project Setup
       Overview of the project
       Creating project and asset directories
       Creating a MySQL database
    6. Foundations of an OOP Project
       Creating the MySQL Database class
       Adding queries to the MySQL Database class
       Using the database object
       How OOP is an improvement
       Creating a User class
       Instantiating user objects
       Revising find methods to instantiate
       Autoload: The undeclared object safety net
       Creating the Session class
       Logging in using the Session class
       Initializing files and path constants
       Using path content for layout
       Late static binding
    7. Working with Files and Directories
       File system basics
       Understanding file permissions
       Setting file permissions
       PHP permissions
       Accessing files
       Writing to files
       Deleting files
       Moving the file pointer
       Reading files
       Examining file details
       Working with directories
       Viewing directory content
       Creating a log file: Assignment
       Creating a log file: Solution
    8. Uploading Files
       Configuring PHP for file uploads
       Sending files as form data
       Inspecting uploaded files
       Uploading errors
       Moving uploaded files
    9. Completing the User Class
       Remaining user CRUD
       Creating users
       Updating users
       Deleting users
       Abstracting the database table name
       Abstracting the attributes
       Finding the database attributes
    10. The Photograph Class
       Starting the Photograph class
       Coding the Photograph class
       Saving photographs
       Uploading photographs
       Listing photographs
       Storing messages in the Session class
       Deleting photographs
       Displaying photographs in the public area
    11. The Comment Class
       Creating the Comment class
       Building the comment form
       Listing comments
       Reviewing comments in the staff area
    12. Pagination
       Understanding the concepts behind pagination
       Using LIMIT, OFFSET, and COUNT
       Finding the pagination variables
       Using the Pagination class
       Paginating photographs
       Using pagination links
    13. Sending Emails
       Configuring PHP for email
       Sending email with mail()
       Using headers
       Reviewing SMTP
       Using PHPMailer
       Building notification for new comments
    14. Templating and Code Organization
       Using MVC architecture
       Simple templating
       Using the Smarty PHP templating engine
       Building PHP libraries and frameworks
    Appendix: PHP Installation and Configuration Assistance
       Installing on Mac 10.4 (Tiger)
       Installing on Mac 10.5 (Leopard)
       Configuring a Mac
       The text editor on Mac
       phpMyAdmin installation on Mac
       Installing on Windows
       Configuring on Windows
       The text editor on Windows
       MySQL basics: phpMyAdmin


Course Fee:
USD 25

Course Type:


Course Status:



11 - 12 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top