Backend Programming with PHP & MySQL

Name: Backend Programming with PHP & MySQL
Rating: 4.5 (13 reviews)

Understanding PHP and MySQL

Created bySheppa Kalunga

Last updated 8/2023

English

What you'll learn

What backend programming is
How to write SQL statements
How to connect frontend to backend
Database connections
Dynamic Web Development

Course content

3 sections • 33 lectures • 5h 4m total length

Introduction6:43
Learn PHP as a server-side language embedded in HTML for dynamic content, database operations, and access control. Gain an introduction to MySQL and SQL fundamentals.
XAMPP Installation5:46
Download and install XAMPP to run PHP and MySQL locally, then start Apache and MySQL from the control panel.
PHP Syntax7:27
Variables in PHP14:32
Learn to declare and print PHP variables with a leading dollar sign using echo; follow valid name rules—start with a letter or underscore—and use dot-concatenation for strings and line breaks.
Variable Scope9:58
Discover how variable scope works in PHP, exploring local, global, and static variables, and see how scope affects access inside and outside functions.
Data Types9:13
Explore PHP data types such as string, integer, and float, and learn how variables store different data, concatenate strings with the dot operator, and print results using echo.
Operators in php17:11
Explore PHP operators including arithmetic, logic, and comparison operators, and learn how to apply them with variables using echo, line breaks, and conditional statements.
If statements10:31
Master php control flow with if, else, and else if statements, using voting eligibility and grading examples to understand syntax, operators, and echo output.
Switch Statements5:15
Learn how to implement switch statements in PHP to map numbers to days of the week, using syntax with switch, cases, break, and a default clause.
Loops16:12
Functions10:36
Learn how to declare and call functions in PHP, pass arguments, and use return values with simple examples like printing text and adding numbers.
Form Handling 18:36
Explore form handling in PHP by comparing GET and POST methods, building a self-submitting form with action and method attributes, and printing submitted data using $_GET and $_POST.
Form Validation 15:23
Build an HTML form and validate user inputs with PHP, handling name, email, website, and gender radio options, and display errors such as invalid email, invalid username, or invalid password.
Form Validation 219:44
Validate and sanitize form input in a PHP and HTML form using the post method and a test_input function, with empty-field checks and error messages, then display the results.

Intro to MySQL5:27
Explore MySQL as a relational database system, learn tables with columns and rows, and practice essential SQL operations: select, insert, update, delete, create, alter, and drop via phpMyAdmin.
SQL & XAMPP11:08
Configure Apache and MySQL, access phpMyAdmin via localhost/phpMyAdmin, and create a database and a hospital table with patient_id, name, and address; learn to insert and view data using SQL.
SELECT & WHERE Statements9:09
Learn how to use the select statement to fetch specific columns or all fields from the hospital table, and apply the where clause to filter records by address or id.
Logic Operators10:51
Explore using and, or, and not operators in sql to filter data with a where clause, demonstrating how to uniquely match records by name, id, and address.
INSERT & ORDER_BY Statements9:42
Explore how to insert records into the hospital table using insert into and values, then sort results with order by name or patient ID in ascending or descending order.
UPDATE & DELETE Statements9:48
Update and delete records in MySQL using update, set, and where clauses on the hospital table, changing fields such as name and address for the patient id 11.
COUNT, AVG, SUM7:19
Explore how to use the count, avg, and sum functions in SQL with a sales table. The video demonstrates counting records, computing averages, and summing values, including handling nulls.
LIKE & WILDCARDS7:15
Explore the like operator in a where clause to search patterns with wildcards, including starts with, ends with, and contains, using a hospital table example.
Aliases3:28
Learn how MySQL aliases create temporary names for columns with the as keyword to improve readability. Aliases exist only for a query’s duration and do not affect the table schema.
MySQL CRUD14:31
Master MySQL create, read, update, delete concepts by creating and dropping databases and tables, and altering tables with add, drop, or change operations, including varchar and int columns and constraints.
Constraints2:07
Explore SQL constraints and how they enforce data rules for each column, including not null, unique, primary key, foreign key, default, and autoincrement, and learn table creation and alteration syntax.
NOT NULL3:53
Learn how the not null constraint in MySQL enforces mandatory fields by creating a person table with id, first name, and last name.
UNIQUE4:18
Explore the unique constraint in SQL and learn how it enforces distinct values in a column, with examples using ID, email, and NRC data and table creation.
PRIMARY KEY2:37
Define a primary key in a table to uniquely identify a row, enforcing unique and not null values on a column like id or employee number, and consider foreign keys.

DATABASE CONNECTION11:46
Demonstrate connecting a PHP front end to a MySQL database to enable four CRUD operations, using a connection.php script and phpMyAdmin on localhost.
CREAT & READ21:43
Create and read data in php and mysql by building a crud flow: add records, validate input, insert into users, and display all entries.
UPDATE OPERATION 110:04
Update operation 1 demonstrates editing existing database records via a PHP edit form, retrieving the target record by id with the get method, and preparing data for the subsequent update.
UPDATE OPERATION 25:40
Learn to perform the update operation in PHP by submitting the edit form, building an update query for the users table, and verifying the updated record.
DELETE OPERATION6:19
Execute a server-side delete operation in PHP and MySQL by reading an id from the get parameter, deleting from the users table, and returning to index.php.

Requirements

HTML, CSS and JavaScript

Description

Welcome to Backend Development with PHP and MySQL course! If you aspire to become a skilled backend developer or wish to enhance your web development skills, this comprehensive course is the perfect choice for you.

In this hands-on and practical course, you will learn how to build dynamic, interactive, and robust web applications using PHP and MySQL, two of the most popular technologies in the web development industry. Throughout this course, we will cover essential concepts, best practices, and real-world scenarios to empower you to create powerful and secure backend systems.

What you'll learn:

Fundamentals of PHP: We'll start from scratch, covering the basics of PHP, including variables, data types, functions, control structures, and object-oriented programming. By the end of this section, you'll be comfortable writing PHP code.
Working with Databases: You'll learn how to interact with MySQL, one of the most widely used relational database management systems. We'll cover database design, SQL queries, and how to connect PHP with MySQL to perform CRUD (Create, Read, Update, Delete) operations.
Handling Forms and User Input: Building dynamic web applications requires handling user input securely.
Deployment and Project Management: Learn how to deploy your PHP and MySQL applications to a web server, ensuring your projects are accessible to users worldwide.

Who this course is for:

Beginners in backend web development
Web developers who already know basics of frontend web development

Backend Programming with PHP & MySQL

What you'll learn

Explore related topics

Course content

Introduction14 lectures • 2hr 27min

MySQL14 lectures • 1hr 42min

CRUD OPERATIONS5 lectures • 56min

Requirements

Description

Who this course is for: