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

@ chris

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

Bale 2 gives po ang pagbabayad, 5500 ang down payment then sa midway ng training yung remaining balance.
regarding sa prerequesite, kelangan ba talaga may alam na or kahit walang knowledge? interested po sana ako.
Kung installment ung bayad magdodown ng 5,500 then 1,100 per day? at my iba pa bang schedule this august?
@ Anthony

We offer short term courses most of our courses is 30 hours duration only.
course duration is too short , if there is long course I will consider taking it again .
@ Cristian To-ong

Hindi po tuloy ung class ngaun due to lack of students. Resked po next week.
Tuloy po ba yung class tomorrow?
@ Dan Boyce Samillano

Yes we have one on one training, fee is 31,500 pesos in cash.
Do you provide training on one on one basis - PHP programming. The objective is at the of the training I can program a payroll software. If yes how much is the fee?

@ tirex

Yes, Metro Manila lang po, located kami sa Espana, Manila and Buendia, Makati. Wala po kaming branch sa Ilocos region o sa Cordillera region.
sa Metro Manila lang po bato? wala ba sa Ilocos region o sa Cordillera region po, gaya po ng BAGUIO city?
@ takishima

Yes po once a week lang ang training. Pili po kayo kung every Saturday or Sunday ang kukunin po ninyo.
Kapag po ba saturday or sunday class ang kinuha. every saturday or sunday lang ang class?
@ Elijah

Yes po magkakaroon po kami ng schedule for August or October. Ipopost po namin sa website soon. Keep posted.
ho, will you have classes on the future months too?
magkakaron po ba kayo ng training in August or October
@ Ervin

Yes meron po kayong makukuhang certificate of completion after the training.
meron po ba tong certificate?
tuloy po ba ung klase sa Sunday? 9-3pm Buendia, Makati.
@ linalyn cajandab

Enrollment is still open. We advise you to make a reservation on our website through this link then we will inform you 2 days before of the training if minimum of 3 participants are met.

Thank you.
When will the classes start in Buendia? I intend to enroll for this course.
@ Linalyn Cajandab

Yes, we do have Saturday schedule from 9am to 3pm in Espana, Manila and Sunday from 9am to 3pm in Buendia, Makati.
Please reply to my e-mail asap, so that I can arrange my sched.

thank you
Do you have Sunday class sched 9 am to 3pm? or Saturday 9am to 3pm as published before? I am interested to enroll. please consider this as my reservation. thanks.
@ Julius Cabero

Yes po open ang online programming course namin.
@ Dominick

Hindi po pwede kung sino po ung mageenrol dun po ipapangalan ang resibo.
meron po ba kayong online courses on programming?
Hi, pwede po ba ipangalan sa sister ko ang official receipt para magamit sa educational loan/reimbursement?
@ Hermie

From Cubao to Makati Sakay lang kayo ng LRT 2 then baba ng Recto Station, sakay kayo ulit ng LRT 1 going then baba ka sa Gil Puyat station, from LRT walking distance going to marconi St. located kame sa UPY building along Gil Puyat ave.Thank you!

From Cubao to Espana,Manila sakay lang po kayo ng jeep going to quiapo then baba kayo ng Morayta katabi lang namen ang MCDO, located kame sa Dona Amparo Building.
Hi, pano po pumunta sa venue, mula cubao, both sa Espaņa at makati.
salamat po. God bless
@ Germaine

Pwede na po kayong magenroll sa PHP & MySQL may knowledge naman na po kayo sa HTML.
ganun po ba. required tlga un sir? konti lng kc knowledge ko sa HTML e.
@ Germaine

Kailangan po may knowledge kayo sa HTML.
@ ray

From 9am to 5pm po ang office hour namin. Kaya po 9am ang start ng class.
can I take the training for Php and MySQL kahit wala akong backround?
Hi Pwede 8 to 12 training daily dito. I will pay the minimum 3 head.
@ Nicholas Puy

Hi Sir, Keep posted lang po tayo, Soon mag oopen na po kami for the Month of April.

Thank you!

I am interested in doing the course PHP & MySQL in April 6th - 10th 2015.
@ Majo

Yes, magoopen pa po kami ng next schedule for this course. Keep posted.
Hi After for po ng March 23,2015 to April 18, 2015 may next na class pa po?
@ Just

Wala pong bayad ang reservation. Pwede na po kayong gumawa ng reservation ninyo check this link
Hi ask ko lang, how much yung reservation? mag enroll sana ako ng php and mysql. kaso puro basic lang pag dating sa OOP di ko na aalam.
@ Chen

Please make your reservation online hindi na po kailangan magdala ng Laptop may mga pc naman na pwede nyong gamitin. We have Monday to Friday, every Saturday and Sunday schedule. Fee is 10500 in cash.
Hi I'm interested to enroll po...Ask ko lang po. Do I need to bring my own laptop ..pls. email na rin po the details and schedules ty po...
@ dan

Hello Good day! We advise you to take Visual Basic 6.0 Programming. Please see this link

Thank you.
Hi good day! i just want to ask, what course/training that teaches basic computer programming. im a nurse, and i want to learn something new. Thank you!
@ remigius obioma

Just want to ask if what area of IT Training will you be interested in, Network administration or Programming?
@ Elex

Yes, meron po kaming programming courses sa summer. Post po namin ung mga schedules soon. keep posted.
Page 4 of 9 | << | First | 1 - 2 - 3 - 4 - 5 - 6 - 7 - 8 - 9 - | Last | >> |

CNCTC Live Chat Inquiry

Job Openings


Stay Informed Subscribe

Name *

Email *