->

PHP with MySQL Beyond the Basics

PHP with MySQL Beyond the Basics
Author: Kevin Skoglund
Level: Intermediate | Duration: 10h 27m | Released date: Mar 25, 2009
Homepage

In PHP with MySQL Beyond the Basics, expert instructor Kevin Skoglund introduces powerful PHP programming techniques using object-oriented programming (OOP). Both novice and experienced PHP developers will benefit from the efficient, well-organized, reusable, and easy-to-understand code that OOP offers. Kevin shows how OOP techniques can streamline database queries, help manage sessions, and simplify user logins. While building a real-world web application, Kevin also includes practical advice on topics ranging from structuring code to logging user actions. Exercise files accompany the course.



Topics include:

    Defining and using classes, methods, and attributes
    Understanding class inheritance and access modifiers
    Working with files and directories
    Uploading files to a server via forms
    Sending emails with PHP
    Using pagination and View templates

    Introduction
        Welcome
        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
    Conclusion
        Goodbye
    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

Letitbit Download Links:
PHP with MySQL Beyond the Basics
For America
RapidGator Download Links:

PHP with MySQL Beyond the Basics


 TO MAC USERS: If RAR password doesn't work, use this archive program: 

RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


 TO WIN USERS: If RAR password doesn't work, use this archive program: 

Latest Winrar  and extract password protected files without error.


 Lynder   |  

#1  

am tanx .............................
17 January 2013 03:41
  |    |  

Information
Members of Guests cannot leave comments.




rss