Practical Understanding of PHP and MySQL

Learn to understand the core of PHP and MySQL. Take the full course and Build a Database Web App

Created byPaul Amissah

Last updated 7/2016

English

English [Auto],

What you'll learn

Understand the Practical uses of PHP
Learn to understand PHP Basics
Conceptualize abstract text and convert to PHP codes

Course content

4 sections • 24 lectures • 5h 32m total length

Downloading and Installing Local Server12:35
Setup your xampp server and configure it so that it doesn't conflict with any other application on your computer
Admin Dashboard Error Solution3:33
Downloading and Installing Code Editor & plugins11:12
Install and configure code editors and important plugins for your web application development
Setting up the Environment Final Step8:48
Test you web development environment to ensure you are good to go with your development

PHP Introductions9:37
Explore PHP as an open source scripting language and its dynamic capabilities. Learn to set up a local server, work with PHP syntax, and handle forms and database interactions.
Syntax – open, echo, string9:21
Understand the very first things to do in your web development environment
PHP Variables, Logical & Comparison Operators14:55
Statement – if, else, elseif14:57
Explore conditional statements in PHP, including if, else, and else if, with practical examples on redirection, login checks, and session-based logic.
Array – Indexed, Associative19:23
Explore indexed and associative arrays in PHP by defining variables, assigning single or multiple values, and accessing elements through numeric indices or custom keys for database results.
Exercise 1 with Solution And Explanation19:34
The successful completion of this exercise proves that you have understood the basis of PHP

Loops – foreach11:34
Functions and Arguments13:46
Learn how a function wraps a block of statements, how to define and call it, and how arguments are passed for tasks like user authentication, including naming conventions.
Include & Super Global18:21
Learn how to include and require PHP files, access variables across pages with global and super globals, and manage user data with sessions for dynamic web applications.
Super Globals $_SERVER, $_POST $GET16:07
Filters – Validate and Sanitize13:13
Echo & Concatenation17:31
Exercise 2 with Solution And Explanation19:56
The successful completion of this exercise proves that you have understood the Advance uses of PHP

Overview of MySQL9:18
Learn to connect PHP to a MySQL database, create databases and tables, and post or fetch data with forms. Explore the interface for browse, insert, and export operations.
Creating Database and Tables10:00
Connecting to Database and SQL Syntax & Functions17:50
Learn to establish connections to database servers from your scripts
Inserting / Updating Data19:33
Selecting / Deleting Data16:09
Looping through your results and Displaying it19:44
Summary5:38
Learn practical PHP and MySQL by building a live database web app using Piru for secure connections and AJAX for real-time updates, including registration, login, forms, image handling, and email.

Requirements

Computer with Internet connection

Description

Having thought for over 10 years at college level, I bring to you what is missing for free. To gain or acquire knowledge, you need to understand the concept of the topic, how it's used and when to use it. Most teachers are not doing that. Teaching is an art, it involves more than just taking screen shots or videos of what you are doing and telling people to do it with you.

Teaching involve explanations. You may follow an instructor to build a very cool app but would you be able to do it again by yourself? Only if you understood. You need to understand a topic before you can practice how it's used, but if you used it without understanding it, then you are not learning it. Take this course and learn to understand PHP. Convert abstract text to programmable meanings.

Anyone from beginner can take this course.

If the speed is too slow for you depending on your region, use the speed function change the level that is best for you.

Thank you for considering this course.

Some Comments:

From Vivian

I feel he makes it as simple as possible so I can understand what he is trying to say.

Who this course is for:

People who are New to PHP
People who want to really understand PHP

Practical Understanding of PHP and MySQL

What you'll learn

Explore related topics

Course content

Section 1: Server and Web Development Environment4 lectures • 36min

Section 2: PHP Basics6 lectures • 1hr 28min

Section 3: PHP Advance7 lectures • 1hr 50min

Section 4 – MySQL Database Creation | phpmyadmin7 lectures • 1hr 38min

Requirements

Description

Who this course is for: