PHP with MySQL Essential Training: 1 The Basics
Offered By: LinkedIn Learning
Course Description
Overview
Learn how to build dynamic, data-driven webpages using PHP with MySQL.
Syllabus
Introduction
- PHP with MySQL Essential Training: The Basics
- How to use the exercise files
- Blueprint the application
- Establish your work area
- Create and style the first page
- Include and require files
- Make page assets reusable
- Links and URLs
- Use URL parameters
- Default values for URL parameters
- Encode URL parameters
- Encode for HTML
- Challenge: Add pages
- Solution: Add pages
- Modify headers
- Page redirection
- Output buffering
- Build forms
- Use form parameters
- Detect form submission
- Single-page form processing
- Challenge: Add forms
- Solution: Add forms
- MySQL introduction
- Create a database
- Create a database table
- CRUD in MySQL
- Populate a MySQL table
- Relational database tables
- Challenge: Pages table
- Solution: Pages table
- Database APIs in PHP
- Connect to MySQL with PHP
- Retrieve data
- Work with retrieved data
- Error handling
- Challenge: List pages
- Solution: List pages
- Find a single record
- Use form data to create records
- Use form data to update records
- Form options from database data
- Delete a record
- Challenge: Pages CRUD
- Solution: Pages CRUD
- Common data validation types
- Validate form values
- Display validation errors
- Problems with validation logic
- Challenge: Validations
- Solution: Validations
- Understand SQL injection
- Sanitize data for SQL
- Delimit data values
- Prepared statements
- Next steps
Taught by
Kevin Skoglund
Related Courses
Software as a ServiceUniversity of California, Berkeley via Coursera Intro to Computer Science
University of Virginia via Udacity Web Development
Udacity Software Engineering for SaaS
University of California, Berkeley via Coursera CS50's Introduction to Computer Science
Harvard University via edX