Course Overview
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
FAQ
FAQ area empty
Course curriculum
-
PHP Introduction
Xem trước -
PHP Preparation
Xem trước -
PHP File Test
Xem trước -
PHP Syntax
Xem trước -
PHP Variables
Xem trước -
PHP Variable Scope
Xem trước -
PHP Global Keyword
Xem trước -
PHP Static Keyword
Xem trước -
PHP Echo vs Print
Xem trước -
PHP Data Types
Xem trước -
PHP Objects
Xem trước -
PHP Strings
Xem trước -
PHP Constants
Xem trước -
PHP Operators
Xem trước -
PHP Conditional Statements
Xem trước -
PHP ElseIf Statement
Xem trước -
PHP Switch Statement
Xem trước -
PHP While Loops
Xem trước -
PHP For Loops
Xem trước -
PHP Functions
Xem trước -
PHP Functions Continued
Xem trước -
PHP Arrays
Xem trước -
PHP Multidimensional Arrays
Xem trước -
PHP Sorting Arrays
Xem trước -
PHP Superglobal Variables
Xem trước -
PHP Forms Introduction
Xem trước -
PHP POST vs GET Basics
Xem trước -
PHP Form Output and Validation
Xem trước -
PHP Form Required Fields
Xem trước -
PHP Validation Continued
Xem trước
-
Introduction to MySQL Databases
Xem trước -
Introduction PhpMyAdmin
Xem trước -
PhpMyAdmin Interface Overview
Xem trước -
MySQL Security and Root Superuser
Xem trước -
MySQL Creating a Database and Table
Xem trước -
MySQL Creating a New User
Xem trước -
MySQL Database and Table Specific Privileges
Xem trước -
MySQL Modifying and Deleting a Table
Xem trước -
MySQL Modifying and Deleting a Database
Xem trước -
Introduction to SQL
Xem trước -
SQL Statements in PhpMyAdmin
Xem trước -
Connect to MySQL Database using PHP
Xem trước -
MySQL Database - Import Data
Xem trước -
SQL Select
Xem trước -
SQL Distinct Keyword
Xem trước -
SQL Where Clause
Xem trước -
SQL And Operator
Xem trước -
SQL Or Operator
Xem trước -
SQL Order By
Xem trước -
MySQL Insert Into
Xem trước -
MySQL Get Last ID
Xem trước -
MySQL Insert Multiple Records
Xem trước -
MySQL Prepared Statements
Xem trước -
MySQL Delete Records
Xem trước -
PHP Header Function
Xem trước -
PHP Isset
Xem trước -
MySQL Update Records
Xem trước
Requirment
-
Basic Computer Skills
Outcomes
-
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
0 Student
24 Courses
0 review