YoVDO

PHP with MySQL Essential Training: 1 The Basics

Offered By: LinkedIn Learning

Tags

PHP Courses Web Development Courses SQL Courses MySQL Courses CRUD Operations Courses Data Validation Courses HTML Forms Courses SQL Injection Prevention Courses

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
1. Start a Database-Driven Project
  • Blueprint the application
  • Establish your work area
  • Create and style the first page
  • Include and require files
  • Make page assets reusable
2. Build Web Pages with PHP
  • Links and URLs
  • Use URL parameters
  • Default values for URL parameters
  • Encode URL parameters
  • Encode for HTML
  • Challenge: Add pages
  • Solution: Add pages
3. Headers and Redirects
  • Modify headers
  • Page redirection
  • Output buffering
4. Build Forms with PHP
  • Build forms
  • Use form parameters
  • Detect form submission
  • Single-page form processing
  • Challenge: Add forms
  • Solution: Add forms
5. MySQL Basics
  • 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
6. Use PHP to Access MySQL
  • Database APIs in PHP
  • Connect to MySQL with PHP
  • Retrieve data
  • Work with retrieved data
  • Error handling
  • Challenge: List pages
  • Solution: List pages
7. CRUD with PHP
  • 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
8. Validate Data with PHP
  • Common data validation types
  • Validate form values
  • Display validation errors
  • Problems with validation logic
  • Challenge: Validations
  • Solution: Validations
9. Prevent SQL Injection
  • Understand SQL injection
  • Sanitize data for SQL
  • Delimit data values
  • Prepared statements
Conclusion
  • Next steps

Taught by

Kevin Skoglund

Related Courses

Introduction to Databases
Meta via Coursera
Web Development
Udacity
Introduction to Data Science
University of Washington via Coursera
Datenmanagement mit SQL
openHPI
Sabermetrics 101: Introduction to Baseball Analytics
Boston University via edX