Main Menu

Credit Cards

Our Partners

Authorized Pearson Vue Test Center





PHP & MySQL Programming




This hands-on course provides the knowledge necessary to design and develop dynamic, database-driven web pages using PHP and MySQL. PHP is a server-side scripting language written for the web, quick to learn, and easy to deploy. Students discover how to connect to a MySQL database, and perform hands-on practice creating database-driven HTML forms and reports.


  • Develop PHP scripts that perform decision making and looping tasks
  • Develop PHP scripts that integrate with a WWW server
  • Understand how to interact with a database
  • Communicate with a database using PHP
  • Work with XML data


Visual Basic 6 Programming or Some understanding of programming concepts, HTML, and experience working with a DBMS is recommended prior to attending this course.


Chapter 1: Introduction to PHP

  • PHP role in the WWW
  • Language fundamentals

Chapter 2: PHP Basics

  • PHP Data types
  • Storing & retrieving information in variables
  • Basic operations with variables
  • Variable rules

Chapter 3: Decision making in PHP

  • Comparison operators
  • The if construct
  • The while construct
  • The for construct

Chapter 4: Arrays and PHP

  • Working with arrays
  • Sorting arrays
  • Other array related functions
  • Multi-dimensional arrays

Chapter 5: Re-using PHP code

Chapter 6: Functions

  • Declaring functions
  • Passing data by reference
  • Including code in scripts
  • Variable scope in PHP

Chapter 7: PHP and the WWW server

  • Working with web forms
  • PHP POST & GET form elements
  • Embedding forms with PHP code
  • Validating form data
  • Preventing spoofed submissions
  • Guidelines for secure PHP
  • Understanding magic quotes
  • Setting default values in forms
  • Processing uploaded files
  • Retrieving & Sorting uploaded files

Chapter 8: Working with databases and PEAR MDB2

  • A brief history of databases
  • Relational database concepts
  • Database tables
  • Using the CREATE TABLE statement

Chapter 9: SQL Data types

  • Integer data types
  • Floating point data types
  • Character data types
  • Other SQL data types
  • SQL column modifiers
  • Understanding SERIAL and AUTO_INCREMENT column options
  • Table & database naming syntax

Chapter 10: Manipulating data in SQL

  • The SELECT statement
  • Overall SELECT syntax
  • Selecting values to display
  • Restricting selections using the WHERE clause
  • Using ORDER BY to sort query results
  • Using LIMIT to limit result sets
  • The INSERT statement
  • The UPDATE Statement
  • The DELETE and TRUNCATE TABLE statements
  • Leveraging existing code using PEAR & PECL

Chapter 11: Accessing databases using PHP

  • USing PEAR's MDB2 class
  • Creating a Data Source Name (DSN)
  • Setting connection options & connecting to the database
  • Executing SQL statements
  • Executing prepared statements
  • Multiple statement execution
  • Retrieving information about queries (metadata)
  • Transactions and queries
  • Retrieving data from a database
  • Single-step queries

Chapter 12 Managing web sessions

  • Using PHP session handling
  • PHP cookie handling
  • Handling date & time in PHP
  • Displaying dates & times
  • Parsing a date or time
  • Generating relative times

Chapter 13: Working with files in PHP

  • Reading & writing files with PHP
  • File permissions
  • Handling errors

Chapter 14: Working With XML Data In PHP

  • Understanding XML
  • RSS Feeds

Chapter 15: Debugging Php Code

  • PHP Error handling
  • PHP debugging tools
  • Suppressing errors


with FREE Flowing Coffee


Other Short Courses..

What do you think?

Leave a Question



Page 2 of 9 | << | First | 1 - 2 - 3 - 4 - 5 - 6 - 7 - 8 - 9 - | Last | >> |

@ Richard Lorilla

Hello, open pa po ang enrollment ng April kapag hindi nameet ang minimum of 3 participants ang susunod po na schedule sa May na. Salamat.

Pwede b sa May n kayo start para kasama na ako. Hindi p kasi me pwede ng April. Thank you.
@ Richard Lorilla

Kulang nalang po ng isang participant sa Espana, Manila.

This is richard. may I know kung ilan p po ang kulang para mag start class. by May po kc gusto ko n magstart.. Thank you.
@ Richard Lorilla

We will post our May schedule soon on our website. Keep posted. You can make your reservation online through this link

I'm planning to enroll, preferred schedule is on May 2017 every Saturday 3-9pm. Please advise me, thank you.
@ Krishna Mae Chua

Yes magkakaroon kami ng schedule by the month of June. Ipopost namin ang schedule soon dito sa aming website.

may class po ba available ng June 1st week?
May record na po ako na naging student. Thank you
@ ginne rose paragsa

30 hours duration ng course good for 5 meetings. Yes, yung buong course outline kasama na po sa fee.
@ Buboy

Yes, we will post our next schedule soon. Keep posted.
Hi. Ilang weekends lahat bago matapos ang training. Does all chapter is included in the fee?
Are there any upcoming schedule for PHP and mysql programming?
@ Elizabeth Francisco

Yes, classes is only available every Saturday and Sunday.
Are classes only in the weekends?
@ igie

We will try to open weekday schedule. Keep posted for the updates.
will you be able to have weekday class for php and sql programming?
@ Irish

Hindi po required. May desktop dito na pwede ninyong gamitin for the training.
@ Mar

We will give you the certificate of completion on the last day of the class.
@ Reagan

Wala po kaming laravel training.

Required ba na magkaron muna ng laptop before taking this course? Mine is not working.
Hi do we get a certificate after finishing this course?
Laravel training meron po ba?
@ Louis

Version 5.6
what version of PHP is used for this course?
@ Saima L. Limpao

You have to take the PC Troubleshooting and PC Networking course para sa CSS NCII exam.
hi.. gud day, ano po ba ang requirements para maka take ng exam para sa NC 2.
@ Kim

Pwede pa pong magbayad even on the day ng training. Pakihintay nalang po ang aming text or tawag kung tuloy na po ang class.
Hi! Hanggang kelan po pwede magbayad for schedule na mag-start this october 9?
@ Oliver dela Paz

Yes, maoopen po kami ng September schedule. Ipopost namin soon dito sa aming website. Keep posted.
meron ba kayo sched ng September para sa C3 or web development.
@ xane

24 hours po ang course duration ng training good for 5 meetings.
6 months po ba pagaaralan nito?
@ sheila

Hi, you can pay the course fee on the day itself or before the start of the class. Thank you.
hello po..nagpareserve po ako now kelan po ako magbabayad ng downpayment, sa start na po ba ng class or need ko pa pumunta sa office para magbayad?
@ tiago

Minimum of 3 participants bago magstart ang class.
Hello, tuloy pa din po training kahit 2 lang po nagpareserve for the class? Thank you
@ rcd

Our Branch office is located at Rm 208 UPY Bldg., Gil Puyat Ave. (formerly Buendia Ave) corner Marconi St. Palanan Makati City.
good day saan po ung location sa buendia, makati?
@ Roldan Acabal

Yes, you can enroll in PHP AND MYSQL Programming as long as you already have basic programming background/knowledge.
Hi, i'm interested for this mySQL programming and PHP. I'm not an IT person but I do have some basic programming fundamental way back in college. Is it possible to enroll.
@ vans

Kailangan may basic knowledge kayo sa any programming language or HTML.
Okay lang po ba na kahit zero knowledge before enroll ng php & mysql? Or need kahit basic lang? Thank you
@ anj

Yes, we have every Saturday and Sunday schedule in Buendia, Makati.
Preferred schedule is weekend in Makati. Thanks!
@ naneth

Fee is 10500 pesos each course.
Just would like to inquire if the course fee which is 10,500 pesos is already for all the programming courses? or for EACH programming course?

Please advise. Thanks.
@ Angeline Mendoza

May I ask your prefer schedule is it for weekday or weekend. Thanks.
Hi. May I know the schedule for July? We are interested to enroll for PHP & MySQL Training. Thanks!
@ Neil

Wala po hindi po kasama sa course outline.
Page 2 of 9 | << | First | 1 - 2 - 3 - 4 - 5 - 6 - 7 - 8 - 9 - | Last | >> |

CNCTC Live Chat Inquiry

Job Openings


Stay Informed Subscribe

Name *

Email *