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

Managing Big Data with MySQL
Duke University via Coursera
Database Management Essentials
University of Colorado System via Coursera
Business Metrics for Data-Driven Companies
Duke University via Coursera
Bases de données relationnelles : Comprendre pour maîtriser
Inria (French Institute for Research in Computer Science and Automation) via France Université Numerique
Базы данных (Databases)
Saint Petersburg State University via Coursera