PHP with MySQL
The server-side scripting language powering dynamic and interactive web applications.
Course Overview
Ranked as one of the Best Schools for Web Development
- Our founder, Henry N. Ong II, is recognized as the pioneer of CMS web development courses in the Philippines
- The only school that offers the most number of web development courses
- 1st school to offer WordPress, Joomla & Drupal Classes since 2006
- 1st school to offer Laravel Class since 2014
- 1st school to offer Bootstrap Class since 2014
- Globally Recognized Course Certificate
- Around 85% of government agencies and local government units take web Development classes from us
Frequently Asked Questions
- Basic Computer knowledge and Skills in PC or Mac.
- Should be proficient or experienced in using HTML5, CSS3 and Bootstrap 5
- Knowledge in JavaScript is an advantage but not required
- Certificate of course completion
- Training references (PDF)
- Exercise materials
- Some add-ons
- Free trainer consultation
- Unlimited Free Retakes
Unlimited Retakes = Unlimited Hours of Learning!
We understand that individuals have different learning styles and paces, that’s why we offer the opportunity to learn at your own speed. If you need more time to grasp a concept, you are welcome to come back and retake the class at no additional cost. We believe in providing students with the support they need to succeed.
To Avail: Finish the course to qualify for the unlimited refresher classes
Validity: 1 Year
- For beginners who want to learn how to program with PHP in order to create database driven web applications to integrate on a website.
- For aspiring Back-end Web Developers.
- People who want to create dynamic websites.
PHP is a server-side scripting language commonly used to create web applications. It stands for Hypertext Preprocessor and is often used in combination with other technologies such as HTML, CSS, and JavaScript to create dynamic and interactive websites. PHP code is executed on the server and the results are returned to the user’s browser as plain HTML. It’s also an open-source software and runs on various platforms such as Windows, Linux, and macOS.
PHP is a versatile language and can be used for a wide range of tasks. Some of the most common uses of PHP include:
Web Development: PHP is commonly used to create dynamic and interactive websites. It can be used to create anything from small personal blogs to large e-commerce websites and social media platforms.
Database Interaction: PHP can be used to interact with databases such as MySQL, MariaDB, and others. This allows developers to create applications that can retrieve, update, and store data in a database.
Server-side scripting: PHP can be used to create scripts that run on the server, such as form validation, sending emails, and image manipulation.
Command-line scripting: PHP can also be used to create command-line scripts, which can be run on the command prompt or terminal.
Desktop Application: PHP can be used to create desktop application using frameworks like ElectronPHP, PHP-GTK, and others.
APIs development: PHP can be used to create RESTful and SOAP web services, which can be consumed by other applications.
Machine Learning: PHP can be used to create Machine Learning applications using libraries like TensorFlow, PHP-ML, and others.
Cryptography: PHP provides inbuilt functions to handle cryptography and security-related tasks like password hashing, encryption, and decryption.
These are just a few examples of the many uses of PHP. As a widely-used and versatile language, it has many more capabilities.
HTML is used for creating the structure and content of a website, while CSS is used for styling and design. Understanding them helps you build the foundation of a webpage. PHP, on the other hand, is a server-side scripting language used for making websites dynamic and interactive. Knowing HTML and CSS first allows you to create static web pages, and then PHP empowers you to add functionality and interactivity to those pages, making your website more powerful and engaging.
Course Outline
Introduction to PHP
PHP Requirements
- Local Server
- Text Editor
- Web Browser
PHP Version
Basic Syntax
- PHP Code Block
- Opening and Closing Tag
- Display message using echo() and print()
Variables
Constants
- Arrays
- Index Array
- Associative Array
- Multidimensional Array
Loops
- For
- Foreach
- While
- Do while
Logical Statement
- … Else If….Else…. Statement
- Switch Case Break Statement
- Ternary Statement
Functions
- PHP Default Functions
- Custom Functions
- Basic Custom Function
- Custom Function with Arguments
- Custom Function with Returning Values
- Anonymous Functions
Introduction to OOP
- Classes
- Object
- Properties
- Methods
- Access Modifiers
- Constructors
- Inheritance
PHP SuperGlobals using
- $_POST
- $_GET
- $_SESSION
- $_COOKIE
- $_FILES
- $_REQUEST
- $_SERVER
MySQL Database
Creating Database
Creating Tables
- Editing Tables
- Using Single UNIQUE Columns
- Using Multiple UNIQUE Columns
Deleting Table
Drop Database
Exporting Database
Importing Database
SQL Syntax
- SELECT Clause
- INSERT Clause
- UPDATE Clause
- DELETE Clause
- WHERE Clause
- AND Clause
- ORDER BY Clause
- Using ALIASES
- Using AGGREGATE Functions
MySQL Connection
Inserting Record using HTML Form
Displaying record using SQL Select and PHP loop
Modifying display record using where and order by clause
Updating record using SQL Update
Deleting record using SQL Delete
Creating Pagenation Links
Uploading file
Removing uploaded file inside folder
Registration
Single Course Promo
Course Packages Promo
Promo Mechanics: Courses that are part of a Packaged Promo should be availed within the same month. Promo rates are subject to change without prior notice
HTML5, CSS3 with Bootstrap 5 + JavaScript Essentials
JavaScript Essentials + React JS Essentials
HTML5, CSS3 with Bootstrap 5 + PHP with MySQL
october 2024
fri04oct(oct 4)9:00 amsun06(oct 6)7:00 pmHTML5, CSS3 & BootstrapWeb DevelopmentPhysical Class
Time
4 (Friday) 9:00 am - 6 (Sunday) 7:00 pm
Organizer
Inventive Media
fri04oct(oct 4)9:00 ammon07(oct 7)7:00 pmLaravel 10 PHP FrameworkWeb DevelopmentPhysical Class
Time
4 (Friday) 9:00 am - 7 (Monday) 7:00 pm
Organizer
Inventive Media
sat05oct(oct 5)9:00 amsun06(oct 6)7:00 pmDrupal CMSWeb DevelopmentPhysical Class
Time
5 (Saturday) 9:00 am - 6 (Sunday) 7:00 pm
Organizer
Inventive Media
fri11oct(oct 11)9:00 amsun13(oct 13)7:00 pmJavaScript EssentialsWeb DevelopmentPhysical Class
Time
11 (Friday) 9:00 am - 13 (Sunday) 7:00 pm
Organizer
Inventive Media
fri11oct(oct 11)9:00 ammon14(oct 14)7:00 pmPHP with MySQLWeb DevelopmentPhysical Class
Time
11 (Friday) 9:00 am - 14 (Monday) 7:00 pm
Organizer
Inventive Media
sat12oct(oct 12)9:00 amsun13(oct 13)7:00 pmJoomla CMSWeb DevelopmentPhysical Class
Time
12 (Saturday) 9:00 am - 13 (Sunday) 7:00 pm
Organizer
Inventive Media
fri18oct(oct 18)9:00 amsun20(oct 20)7:00 pmReact JS EssentialsWeb DevelopmentPhysical Class
Time
18 (Friday) 9:00 am - 20 (Sunday) 7:00 pm
Organizer
Inventive Media
Time
18 (Friday) 9:00 am - 21 (Monday) 7:00 pm
Organizer
Inventive Media
fri18oct(oct 18)9:00 ammon21(oct 21)7:00 pmCodeIgniter PHP FrameworkWeb DevelopmentPhysical Class
Time
18 (Friday) 9:00 am - 21 (Monday) 7:00 pm
Organizer
Inventive Media
sat19oct(oct 19)9:00 amsun20(oct 20)7:00 pmWordPress CMSWeb DevelopmentPhysical Class
Time
19 (Saturday) 9:00 am - 20 (Sunday) 7:00 pm
Organizer
Inventive Media
fri25oct(oct 25)9:00 ammon28(oct 28)7:00 pmLaravel 10 PHP FrameworkWeb DevelopmentPhysical Class
Time
25 (Friday) 9:00 am - 28 (Monday) 7:00 pm
Organizer
Inventive Media
fri25oct(oct 25)9:00 ammon28(oct 28)7:00 pmDjango Python FrameworkProgramming LanguagePhysical Class
Time
25 (Friday) 9:00 am - 28 (Monday) 7:00 pm
Organizer
Inventive Media
Time
25 (Friday) 9:00 am - 28 (Monday) 7:00 pm
Organizer
Inventive Media
sat26oct(oct 26)9:00 amsun27(oct 27)7:00 pmWordPress Custom Themewith ElementorPhysical Class
Time
26 (Saturday) 9:00 am - 27 (Sunday) 7:00 pm
Organizer
Inventive Media
november 2024
fri08nov(nov 8)9:00 amsun10(nov 10)7:00 pmHTML5, CSS3 & BootstrapWeb DevelopmentPhysical Class
Time
8 (Friday) 9:00 am - 10 (Sunday) 7:00 pm
Organizer
Inventive Media
sat09nov(nov 9)1:32 amsun10(nov 10)1:32 amDrupal CMSWeb DevelopmentPhysical Class
Time
9 (Saturday) 1:32 am - 10 (Sunday) 1:32 am
Organizer
Inventive Media
fri15nov(nov 15)9:00 amsun17(nov 17)7:00 pmJavaScript EssentialsWeb DevelopmentPhysical Class
Time
15 (Friday) 9:00 am - 17 (Sunday) 7:00 pm
Organizer
Inventive Media
fri15nov(nov 15)9:00 ammon18(nov 18)7:00 pmPHP with MySQLWeb DevelopmentPhysical Class
Time
15 (Friday) 9:00 am - 18 (Monday) 7:00 pm
Organizer
Inventive Media
sat16nov(nov 16)9:00 amsun17(nov 17)7:00 pmJoomla CMSWeb DevelopmentPhysical Class
Time
16 (Saturday) 9:00 am - 17 (Sunday) 7:00 pm
Organizer
Inventive Media
fri22nov(nov 22)9:00 amsun24(nov 24)7:00 pmReact JS EssentialsWeb DevelopmentPhysical Class
Time
22 (Friday) 9:00 am - 24 (Sunday) 7:00 pm
Organizer
Inventive Media
fri22nov(nov 22)9:00 ammon25(nov 25)7:00 pmLaravel 10 PHP FrameworkWeb DevelopmentPhysical Class
Time
22 (Friday) 9:00 am - 25 (Monday) 7:00 pm
Organizer
Inventive Media
Time
22 (Friday) 9:00 am - 25 (Monday) 7:00 pm
Organizer
Inventive Media
Time
22 (Friday) 9:00 am - 25 (Monday) 7:00 pm
Organizer
Inventive Media
sat23nov(nov 23)9:00 amsun24(nov 24)7:00 pmWordPress CMSWeb DevelopmentPhysical Class
Time
23 (Saturday) 9:00 am - 24 (Sunday) 7:00 pm
Organizer
Inventive Media
Time
November 29 (Friday) 9:00 am - December 2 (Monday) 7:00 pm
Organizer
Inventive Media
fri29nov(nov 29)9:00 ammon02dec(dec 2)7:00 pmCodeIgniter PHP FrameworkWeb DevelopmentPhysical Class
Time
November 29 (Friday) 9:00 am - December 2 (Monday) 7:00 pm
Organizer
Inventive Media
sat30novsun01decWordPress Custom Themewith ElementorPhysical Class
Time
November 30 (Saturday) 9:00 am - December 1 (Sunday) 7:00 pm