PHP with MySQL Essential Training: 1 The Basics

 Home || News || Stories || Installer

Course details

• 5h 52m
• Beginner
• Updated: 8/16/2021

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 which 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 fundamentals 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.

Learning objectives

• 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

Introduction to PHP Programming | PHP Tutorial | PHP For Beginners 

| Learn PHP Programming: RMT TECH (currently uploading)

1. Welcome

2. How to use exercise files

1.  Blueprint The Application 

2. Establish your work area

3. Create and Style the First Page 

4. Include and Require Files

5. Make page assets reusable

1. Links and URLs

2. Use URL Parameters

3.  Default values for URL parameters

4. Encode URL Parameters

5. Encode for HTML

6. Challenge: Add Pages

7. Solution: Add Pages 

1. Modify Headers

2.  Page Redirection

3. Output buffering 

1. Build forms 

2. Use form parameters

3. Detect form submission 

4. Single-page form processing 

5. Challenge: add forms 

6. Solution: add forms 

1.  MySQL introduction 

2. Create a database 

3. Create a database Table 

4. CRUD in MySQL 

5. Populate a MySQL Table 

6. Relational Database Tables

7. Challenge: Page Table 

8.  Solution: Page Table 

1. Database APIs in PHP

2.  Connect to mysql with php

3. Retrieve data

4. Work with retrieved data

5. Erorr handling

6. Solution

1. Find a single record

2. Use form data to create records

3.  Use form data to update records

4. Form options from database data

5. Delete a record

6. Challenge Pages CRUD

7.  Solution

1. Common data validation types

2. Validate from values

3. Display validation errors

4. Problems with validation logic

5. Challenge validations

6. Solution

1.  Understand SQL injection

2. Sanitize data for SQL

3. Delimit data values

4. Prepared statement

5. Next steps