PHP with MySQL Training Tutorial Series

Topics include:
– What is PHP?
– Installing and configuring PHP and MySQL
– Exploring data types
– Controlling code with logical expressions and loops
– Using PHP’s built-in functions
– Writing custom functions
– Building dynamic webpages
– Working with forms and form data
– Using cookies and sessions to store data
– Connecting to MySQL with PHP
– Creating and editing database records
– Building a content management system
– Adding user authentication

PHP with MySQL Beyond the Basics:
In PHP with MySQL Beyond the Basics, the 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 of 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

PHP with MySQL Training: 1 The Basics
PHP is a popular programming language and the foundation of many smart, data-driven websites. This comprehensive course from Kevin Skoglund helps developers learn to use PHP to build interconnected webpages with dynamic content that can pass data between pages. Learn how PHP can simplify the creation of forms, read and validate form data, and display errors. Kevin also covers the basics of MySQL and how to use PHP to efficiently and securely interact with a database to store and retrieve data. Throughout the course, he provides practical advice and offers examples of best practices.

Topics include:
– Organizing project files
– Including and requiring files
– Working with URL parameters
– Encoding dynamic content
– Modifying headers and page redirection
– Creating forms and processing form data
– MySQL basics
– Using PHP to access database tables
– Creating, reading, updating, and deleting Database records with PHP
– Validating data
– Preventing SQL injection

PHP with MySQL Training: 2 Build a CMS
This course-the second installment in a series-builds is the core of PHP with MySQL and teaches the intermediate concepts needed to develop real-world web applications while creating a working content management system. Kevin Skoglund shows how to create dynamic navigation to allow public users to browse different pages of database-driven content. He demonstrates how to hide content from the public and write functions that are context sensitive and use argument options for conditional behavior. He shows how to implement user authentication and use PHP’s built-in password functions to securely regulate page access. Finally, he shows how the related database tables can become nested resources by modifying and scoping functions. Along the way, Kevin provides practical advice and suggests examples of best practices.

Topics include:
– Creating a content management system
– Building dynamic content navigation
– Using context and function options for conditional behavior
– Hiding content from the public view
– Insecure direct object reference
– Allowing HTML in
dinamical content – Previewing content in public context
– Working with cookies and sessions
– Storing status messages in the session
– Secure user authentication (login / logout)
– Regulating page access
– Nesting related resources
– Managed ordered list automatically