
Download Required Files
Fix the admin dashboard error by aligning the main ports in the comfy control panel with the port in your config, then save to reach the dashboard.
Learn to download and install a local server stack (Apache, MySQL, PHP), start services, configure ports to avoid conflicts, and test apps via localhost.
Explore free and paid code editors like brackets and Notepad++, and install essential plugins such as Emmet and the W3C validation tool to streamline HTML development.
Start your local server and open the dashboard, link a working files folder for live preview, and create a test file to confirm the server communicates with the browser.
Explore php basics, its open-source server scripting, and how to set up a local server, test environment, and handle forms with database interactions.
Master PHP syntax by placing code inside the PHP tag and using echo to display text or numbers. End statements with semicolons and use // for single-line comments.
Explore PHP variables, including dynamic vs static values and strings or integers, and use logical and comparison operators to evaluate conditions and control flow.
Learn how to implement conditional statements using if, else, and else if to execute actions based on conditions, with PHP examples for login redirects and age-based access.
Explore PHP arrays by distinguishing indexed and associative arrays. Learn how to declare variables, assign single or multiple values, and access data using indices or custom keys.
Define three string and three integer variables, create an associative array, and apply if-else logic to enforce age 18 to 49, then echo the second value.
Learn how to use loops in PHP to iterate through database data with foreach, handling arrays and key value pairs efficiently.
Explore what functions are in PHP, how to define a function as a block of statements, and how to call it with arguments or parameters to execute tasks.
Learn how to include and require PHP files to access variables and functions across pages, compare include and require, and use superglobals and sessions to share data.
Explore how super globals like $_POST, $_GET, and $_SERVER enable form data processing in PHP, including method choices, file handling, and secure data flow for database web apps.
Validate and sanitize user input from GET and POST data using trim and filter functions to prevent invalid data and cross-site scripting.
Master string concatenation in PHP and JavaScript by joining values with the correct operators, using quotes and variables, and echoing the results to display inputs such as emails.
Develop a PHP backend for a customer form using superglobals, sanitization, and validation; implement a session to persist username and email, and create length-check function to display data for support.
Explore object oriented programming by starting with objects and their properties, using examples like a computer, customer, and shopping cart, and illustrate inheritance of properties from classes.
Learn how objects in object oriented programming encapsulate properties and functions within a class, and how instantiation creates new objects from a class.
Learn how a class in PHP is a template that holds properties and methods; create objects from a class using the new keyword.
Learn how to define properties and methods in a PHP class, access them with $this->, and instantiate objects to build simple car examples with name, speed, and type.
Explore how public, private, and protected access modifiers control property and method access from outside and inside a class, using objects.
Learn how static properties and methods in PHP let you access class data without instantiation, using the scope resolution operator and self to reference class members.
Learn how class inheritance in PHP enables a child class to inherit properties and methods from a parent class, override members, and manage access with public, private, and protected modifiers.
Explore PHP construct and destruct methods, showing how __construct runs automatically when a class is instantiated and __destruct closes resources, such as a database connection.
Learn how to implement exception handling in PHP using an exception class to store and retrieve error messages with try-catch blocks and the getMessage method, including database connection errors.
Explore PHP object-oriented design by building a class with properties and static members, a welcome method, a secret word validator of eight characters, and a child class extending it.
Explore MySQL basics with phpMyAdmin, navigate databases and tables, and learn to create databases and use forms to post and fetch data via PHP with PDO.
Learn to create a database and tables in phpMyAdmin, define id, email, password, and full name fields with appropriate data types and autoincrement, and plan before implementation.
Test database connections in PHP using the manual mysqli approach and PDO with try-catch, using localhost, username, password, and database name. Review sql syntax for select, insert, and update.
Learn to insert and update data in a MySQL database using PHP, building insert statements with proper column order and values, managing a separate connection file, and executing updates.
Learn to select, update, and delete user records in PHP with MySQL. Build queries, fetch results as associative arrays, and manage connections and where clauses for precise data manipulation.
Display database data by looping through results with a while loop, fetch associative arrays, and render full name and email in an HTML table using PHP and PDO.
Explore how the PDO database abstraction layer enables connections via the Peter class using a DSN, host, port, username, password, and optional settings.
Explore how the PDO class handles prepared statements, uses prepare to create statements, executes them, and retrieves the last insert id to confirm success.
Learn how the PDO statement class uses prepared statements with bindValue and execute to securely fetch user records by id or email.
Explore how to execute prepared PDO statements in PHP, bind values, handle success with fetch methods, and manage errors using the exception class for secure database interactions.
Develop a PHP database class using PDO, with properties for host, user, password, and database, plus methods to connect, execute statements, and fetch all data; test the connection.
Create reusable database helper functions in a PHP PDO-based web app, instantiate the database connection, and streamline queries with prepare, bindValue, execute, fetch, fetchAll, and lastInsertId to return results.
Demonstrates performing CRUD functionalities using PDO in a PHP web app, including fetching multiple records, iterating results, and inserting new users with bound values.
Learn to build a bootstrap form, submit it via a secure post script, and clean and validate inputs using trimming and filter functions to ensure safe data handling.
Learn how to collect form data, validate inputs like email, password, and full name, and securely insert them into a MySQL database using PHP PDO with bindValue and execute.
Learn to fetch data from the database and display it in the update user form, with a registration form layout and the user id passed via query string.
Update data into the database using a PHP form by fetching the user id with GET, binding form fields, and submitting via AJAX for seamless updates.
Explore how Ajax uses the XMLHttpRequest object to send, receive, and post data to server-side PHP scripts in the background, enabling dynamic updates without page refresh.
Explore jQuery ajax .ajax() and .post() methods to send data to a server script, using data, serialize, and form handling to interact with PHP and MySQL databases.
Learn how to create functions for jQuery ajax .ajax() calls to fetch a single user from a database using a PHP backend, display a welcome message, and post data securely.
Explore how to submit a form with jQuery AJAX .post(), sending serialized data to a PHP processor, prevent the page refresh, and reset the form after a successful AJAX submission.
Download the building up files to assemble a PHP database web app, review the project structure, front-end and admin folders, and prepare to implement the back-end scripts and reusable functions.
Create a database table in phpAdmin with fields id (int 11, primary key, auto_increment), full_name, email, password, sex, and image_path as varchar fields.
Create and use helper functions in PHP to trim and sanitize input, validate emails, and redirect. Implement session-based error messages and a password hashing utility in procedural code.
There's no need for me to write too much here. Doing something you love doesn't make you a teacher and showing people what you are doing doesn't make you a teacher either. Teaching is an art, teaching is a profession. There're lots of videos out there but only few will teach you. I'm a teacher. I want to teach you to understand and do things by yourself. This course goes straight to the point. If you want to learn how to use PHP, AJAX, OOP and PDO to build a Web Application (Database), then, I recommend this course.
You will learn and understand how to use:
PHP to build web applications
OOP to create methods (functions) to save you lots of code typing (Don't Repeat Yourself - DRY).
AJAX to post data and display data from a database without refreshing your page or browser.
PHP Data Object (PDO) to establish very secured connections to database servers and avoid SQL Injections.
We shall be creating a real application to get you the practical knowledge on your finger tips.
This course is for anyone from beginners to IT Professionals who want to jump start and skip all the too many confusing explanations to go right into the real world of Web Programming with PHP.
Don't make the mistakes I made, You cannot learn everything in PHP, even the developers of PHP don't know everything because it's a community of contributors. What you need to know is to master the important concepts that will give you the confidence to build your own apps. And as soon as you get to that level of confidence, you will start learning and adding to you skills all the time and that is exactly what we shall be doing in this course.
I have a teaching methodology that works when it comes to programming; I explain the concepts, teach you how to use it, and I show you when to use it.
Some Comments
From Jaiyaramakrishnan Mahendran
this course was subscribed to give it to a 6th grader to learn php, as introduction to computers and website development, the student feels absolutely comfortable with the lectures because concepts are heavily emphasized in this course followed by syntax of the language, well done author, i wish my son can learn something during this summer break and starts web development as a skill
From Tjasa Flis
I loved this course! The instructor really takes the time to explain everything in detail. And also by repeating himself I remembered what he said and was able to wrote my own code by the end of the course, so I really learnt a lot! Also when I had any questions the instructor answered promptly and clearly!