php mysql training course philippines image banner

This is a Basic to Advance Course in PHP and MySQL

PHP is the most powerful and widely-used open source server-side scripting language for building database driven dynamic websites.

PHP is used by 81.7% of all websites that are on the internet. Here are just a few of the popular websites running on PHP: Google, Facebook, Apple, Yahoo!, Wikipedia, Digg, SitePoint, Amazon, Ebay, YouTube, Flickr, iStockPhoto, Tumblr, Joomla, WordPress, Drupal, Magento

MySQL is the most popular Open Source SQL database management system that is especially suited to work together with PHP for building dynamic websites and web applications.

Why Train with Us?

  • The Pioneer of CMS Web Development Training in the Philippines

    This is where it all started… Our C.E.O/Founder “Henry N. Ong II“ is highly recognized as the pioneer of CMS Web Development Training in the Philippines, and Inventive Media has been offering CMS courses since 2006.

  • Unmatched Credibility and Experience

    About 85% of Government Websites running on CMS got their training from us, such agencies includes: Malacanang, PHIVOLCS, NEDA, DOE, LTO, PNP, Philippine Navy, PCSO, PAGCOR, Bureau of Immigration, etc.

  • The Most Complete CMS School in the Philippines

    The only training center that offers a wide range of CMS Web Development courses (Joomla, WordPress, Drupal, Magento, PrestaShop & osCommerce)

  • Unlimited Free Refresher Course

    In-line with our mission statement, students who have previously attended this course are automatically entitled to a refresher course free of charge.

    Limitation: The refresher course is limited only to the same course & course version that you have taken.
    Validity: 1 year

  • Basic computer knowledge and skills in Mac or PC
  • Must be proficient in both HTML and CSS
  • Certificate of Course Completion
  • References Materials (PDF)
  • Software Evaluation Copy
  • Other Add-ons

Course Outline

Hypertext Preprocessor

  1. Introduction to PHP
  2. PHP Requirements
    • Local Server
    • Text Editor
    • Web Browser
  3. PHP Version
  4. Basic Syntax
    • PHP Code Block
    • Opening and Closing Tag
    • Display message using echo() and print()
  5. Variables
  6. Constants
  7. Arrays
    • Index Array
    • Associative Array
    • Multidimensional Array
  8. Loops
    • For
    • Foreach
    • While
    • Do while
  9. Logical Statement
    • … Else If….Else…. Statement
    • Switch Case Break Statement
    • Ternary Statement
  10. Functions
    • PHP Default Functions
    • Custom Functions
    • Basic Custom Function
    • Custom Function with Arguments
    • Custom Function with Returning Values
    • Anonymous Functions
  11. Introduction to OOP
    • Classes
    • Object
    • Properties
    • Methods
    • Access Modifiers
    • Constructors
    • Inheritance
  12. PHP SuperGlobals using
    • $_POST
    • $_GET
    • $_SESSION
    • $_COOKIE
    • $_FILES
    • $_REQUEST
    • $_SERVER

MySQL Database

  1. Creating Database
  2. Creating Tables
  3. Editing Tables
    • Using Single UNIQUE Columns
    • Using Multiple UNIQUE Columns
  4. Deleting Table
  5. Drop Database
  6. Exporting Database
  7. Importing Database
  8. SQL Syntax
    • SELECT Clause
    • INSERT Clause
    • UPDATE Clause
    • DELETE Clause
    • WHERE Clause
    • AND Clause
    • ORDER BY Clause
    • Using ALIASES
    • Using AGGREGATE Functions
  9. MySQL Connection
  10. Inserting Record using HTML Form
  11. Displaying record using SQL Select and PHP loop
  12. Modifying display record using where and order by clause
  13. Updating record using SQL Update
  14. Deleting record using SQL Delete
  15. Creating Pagenation Links
  16. Uploading file
  17. Removing uploaded file inside folder

Course Fee: P10,000

Returning Student Discount

Less: P2,000

New Student Discount

Less: P1,500

Click to Register

Choose a schedule to join from the available schedules posted in the right sidebar of this page

Please wait...
Categories: Courses and Web Development.