This course is the continuation of our previous Intro to PHP and MySQL course.


Learning Objectives

In this course, you will learn the following:

  • How to manipulate strings in PHP using the built-in functions
  • Using SQL to SELECT, INSERT, UPDATE and DELETE data from tables
  • Using the phpMyAdmin utility to administer the MySQL database
  • Using PHP to manipulate files
  • Identifying and handling the three main types of errors that can occur when programming with PHP




Topics and Subtopics

Here is the course outline:

1. Introduction to PHP

  • Basic Syntax
  • Sending Data to the Web Browser
  • Writing Comments
  • What Are Variables?
  • Introducing Strings
  • Concatenating Strings
  • Introducing Numbers
  • Introducing Constants
  • Single vs. Double Quotation Marks
  • Basic Debugging Steps

2. Programming with PHP

  • Creating an HTML Form
  • Handling an HTML Form
  • Conditionals and Operators
  • Validating Form Data
  • Introducing Arrays
  • For and While Loops

3. Creating Dynamic Web Sites

  • Including Multiple Files
  • Handling HTML Forms, Revisited
  • Making Sticky Forms
  • Creating Your Own Functions

4. Introduction to MySQL

  • Naming Database Elements
  • Choosing Your Column Types
  • Choosing Other Column Properties
  • Accessing MySQL

5. Introduction to SQL

  • Creating Databases and Tables
  • Inserting Records
  • Selecting Data
  • Using Conditionals
  • Using LIKE and NOT LIKE
  • Sorting Query Results
  • Limiting Query Results
  • Updating Data
  • Deleting Data
  • Using Functions

6. Database Design

  • Normalization
  • Creating Indexes
  • Using Different Table Types
  • Languages and MySQL
  • Time Zones and MySQL
  • Foreign Key Constraints

7. Advanced SQL and MySQL

  • Performing Joins
  • Grouping Selected Results
  • Advanced Selections
  • Performing FULLTEXT Searches
  • Optimizing Queries
  • Performing Transactions
  • Database Encryption

8. Error Handling and Debugging

  • Error Types and Basic Debugging
  • Displaying PHP Errors
  • Adjusting Error Reporting in PHP
  • Creating Custom Error Handlers
  • PHP Debugging Techniques
  • SQL and MySQL Debugging Techniques

9. Using PHP with MySQL

  • Modifying the Template
  • Connecting to MySQL
  • Executing Simple Queries
  • Retrieving Query Results
  • Ensuring Secure SQL
  • Counting Returned Records
  • Updating Records with PHP

10. Common Programming Techniques

  • Sending Values to a Script
  • Using Hidden Form Inputs
  • Editing Existing Records
  • Paginating Query Results
  • Making Sortable Displays




Requirements

Basic knowledge of PHP and MySQL or the following classes is required:



Related Courses



Complete Training Bundle

If you are serious about learning web design and development, you should enroll in our Web Design and Development Training Bundle. This bundle covers all essential and practical topics related to web development. For $290 monthly subscription, you can have access to 300+ hours of hands-on project-based training covering all courses related to web development like JavaScript, PHP, JavaScript frameworks like React or Angular and many more. Click here to learn more.



Private Tutoring Classes

To take skills you learn from this course to the next level, taking the following tutoring classes are highly recommended. It is also a great opportunity to discuss your questions and problems related to this course with an experienced instructor:



What Is Next?

After finishing this course, you can enroll in any of following classes:



Recommended Free Courses

If you are new to the IT or programming, we suggest the following free courses:


Choose a Pricing Option