PHP & MySQL - Certification Course for Beginners

Name: PHP & MySQL - Certification Course for Beginners
Rating: 4.2 (4601 reviews)

Learn to Build Database Driven Web Applications using PHP & MySQL

Created byYouAccel Training

Last updated 7/2019

English

What you'll learn

PHP Variables, Syntax, Variable Scope, Keywords
Echo vs. Print and Data Output
PHP Strings, Constants, Operators
PHP Conditional Statements
PHP Elseif, Switch, Statements
PHP Loops - While, For
PHP Functions
PHP Arrays, Multidimensional Arrays, Sorting Arrays
Working with Forms - Post vs. Get
PHP Server Side - Form Validation
Creating MySQL Databases
Database Administration with PhpMyAdmin
Administering Database Users, and Defining User Roles
SQL Statements - Select, Where, And, Or, Insert, Get Last ID
MySQL Prepared Statements and Multiple Record Insertion
PHP Isset
MySQL - Updating Records

Course content

2 sections • 57 lectures • 3h 15m total length

PHP Introduction3:03
PHP Preparation2:55
Launch your local testing server (WAMP or MAMP) to run PHP scripts, then store them in the web root (www) and organize sites in dedicated folders like p2p lessons.
PHP File Test2:20
Create and run a basic php file that outputs hello world in the browser, confirming local server configuration and saving the file as intro.php in the php lessons folder.
PHP Syntax5:37
Explore PHP syntax basics: placing code, echo statements, and comments, plus variable case sensitivity and how to surface error messages in the browser.
PHP Variables3:46
PHP Variable Scope3:15
Explore PHP variable scope by contrasting global and local scope, demonstrating how variables outside functions are inaccessible inside functions, and how echoes trigger undefined variable errors.
PHP Global Keyword2:03
PHP Static Keyword1:45
Explore how PHP's static keyword lets a local variable retain its value between function calls, shown by test function that initializes x to 10 and outputs 10, 11, 12, 13.
PHP Echo vs Print4:01
PHP Data Types5:46
PHP Objects2:58
PHP Strings1:50
PHP Constants3:04
Understand php constants, identifiers for fixed values that cannot change and are global across a script; create them with the defined function, and choose case sensitive or case insensitive names.
PHP Operators8:52
PHP Conditional Statements2:32
PHP ElseIf Statement3:11
PHP Switch Statement1:45
Identify how a switch statement compares an expression to predefined cases and executes the matching block, outputting messages like 'you drive a Volvo' or 'you don't drive' when no match.
PHP While Loops4:34
PHP For Loops1:40
Explore how to use the PHP for loop with its three parameters to repeat code a set number of times, and apply foreach to iterate arrays like a car list.
PHP Functions3:29
PHP Functions Continued1:49
PHP Arrays4:51
PHP Multidimensional Arrays1:59
PHP Sorting Arrays2:51
PHP Superglobal Variables2:10
Explore PHP superglobals, built-in variables always available, and how a function's global variable can be accessed outside it, plus server superglobals reveal headers, script locations, and the host name.
PHP Forms Introduction4:06
PHP POST vs GET Basics5:24
PHP Form Output and Validation9:36
PHP Form Required Fields4:40
PHP Validation Continued1:45

Introduction to MySQL Databases2:40
Introduction PhpMyAdmin2:35
PhpMyAdmin Interface Overview1:12
MySQL Security and Root Superuser5:02
Secure MySQL by setting strong passwords for all route users, restricting privileges, and updating config.inc.php to maintain access after password changes.
MySQL Creating a Database and Table5:24
MySQL Creating a New User5:33
Learn how to create a new MySQL user, assign database- or table-specific privileges, avoid global privileges, set host restrictions, and configure data, structure, and administration privileges.
MySQL Database and Table Specific Privileges3:05
MySQL Modifying and Deleting a Table4:30
MySQL Modifying and Deleting a Database4:07
Introduction to SQL1:35
Explore how sql, or structured query language, communicates with relational database management systems using phpmyadmin to create tables, add records, and modify users, with cross-database compatibility.
SQL Statements in PhpMyAdmin4:05
Connect to MySQL Database using PHP5:02
Connect to the database using mysqli in PHP. Build dynamic, database-driven sites by embedding SQL statements to retrieve, insert, update, and delete records.
MySQL Database - Import Data1:43
SQL Select2:27
SQL Distinct Keyword1:45
Apply the distinct keyword in a select statement to output only unique values from the users table, eliminating duplicates and displaying only the first name.
SQL Where Clause1:40
Learn to filter data with the sql where clause by crafting select statements that extract records meeting a condition, such as a first name or id, using proper quote syntax.
SQL And Operator1:42
SQL Or Operator1:01
SQL Order By1:36
MySQL Insert Into6:29
MySQL Get Last ID1:27
Demonstrate retrieving the last inserted or updated ID with the Get last ID function, echoing it after a successful insert, and verifying the value in phpMyAdmin.
MySQL Insert Multiple Records1:44
MySQL Prepared Statements2:45
MySQL Delete Records7:49
PHP Header Function1:17
Apply the PHP header function to automatically redirect after a deletion, replacing echo with a location header to return to delete.php and avoid manual back navigation.
PHP Isset2:35
MySQL Update Records7:07

Requirements

Basic Computer Skills

Description

Welcome to the PHP & MySQL Certification Course for Beginners.

This course offers a comprehensive guide to learning how to code in PHP. We also explore integrating MySQL Databases into your PHP Projects for dynamic, user driven functionality.

We start with PHP basics, including variable declaration and data output. The lessons then transition into working with objects, conditional statements, loops, functions, arrays, form validation, sorting, and much more.

After the PHP Section, students learn to unleash the true power of dynamic page development with MySQL database integration. We start with table creation and user management. From there we progress into commonly used SQL statements for database administration. Students are also taught how to create database connections and to execute SQL statements directly from PHP scripts. Our coding style keeps script security, and execution efficiency in mind at all times.

If you are interested in embarking into the world of PHP Development with Database integration, don’t wait another second. Enrol today in this exciting new course.

What you'll learn - Overview:

PHP Variables, Syntax, Variable Scope, Keywords
Echo vs. Print and Data Output
PHP Strings, Constants, Operators
PHP Conditional Statements
PHP Elseif, Switch, Statements
PHP Loops - While, For
PHP Functions
PHP Arrays, Multidimensional Arrays, Sorting Arrays
Working with Forms - Post vs. Get
PHP Server Side - Form Validation
Creating MySQL Databases
Database Administration with PhpMyAdmin
Administering Database Users, and Defining User Roles
SQL Statements - Select, Where, And, Or, Insert, Get Last ID
MySQL Prepared Statements and Multiple Record Insertion
PHP Isset
MySQL - Updating Records

Who this course is for:

Beginner developers who are interested in learning the foundations of PHP.
Students who want to integrate MySQL Databases into their PHP Web Applications.
Students who want to learn to code in PHP.
Students who want to learn how to execute SQL Statements, directly from PHP.

PHP & MySQL - Certification Course for Beginners

What you'll learn

Explore related topics

Course content

PHP Development30 lectures • 1hr 48min

MySQL Database Integration27 lectures • 1hr 28min

Requirements

Description

Who this course is for: