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

@ Carlito D. Dela Cruz Jr

Sir Carlito upon checking may reservation po kayo ng PHP and MYSQL schedule for Oct 27-31. Kinokontak ka po namin sa mobile number po nyo pero wala pa po kayong reply even sa email. Tuloy na po ang class sa Monday, Oct 27 from 9am to 3pm sa Buendia Makati. Thank you.
Sir/Mam pwede ko po bang ilipat ung reservation ko for PHP and SQL this week kasi 4 na ung student baka pwedeng sumabay na ko, pakitext nalang po ako, tsaka tanong ko narin po kung sure na para makapagfile ako ng leave sa work ko, thanks.
okay.. para kasing ngayon ko lang nakita.. nagvisit po kasi ko kahapon ata or nong isang araw di pa ganyan... may discount po ba na pwedeng maavail pag nag enroll?
@ Rod

Yes, nagtaas na po tayo ng tuition fee, Implemented last September 1. Thank you!
@ Dize

We already met the minimum participants for PHP and MySql schedule October 27, Monday 9AM TO 3PM at Buendia,Makati. Okay you may join. Thank you!
hi, ask ko lang sana kong bakit tumaas yong tuition fee niyo dito? diba 9000 lang kahapon? thanks

Just wanna ask kung ilang students na ang meron kayo as of today for php & mysql programming? pakicount niyo napo ako because I'm so sure to enroll naman po upon the start of class.
@ dize

Hindi po natuloy ung class due to lack of students. Reskedyul po ung training next week.

Just wanna ask kung tuloy ung sunday class tomorrow?
@ dize

Meron na po kayong reservation for PHP & MySQL ng every Sunday 9am to 3pm. Please wait for our final confirmation kung matutuloy po ang class natin on Sunday. Thank you.

I made a reservation last night. Parang hindi yata na count? Meron bang sunday class sa buendia branch?
@ Jhun

Yes, we will open for December schedule. Keep posted we will post soon in our website.
Do have PHP & mySQL short course schedule this coming December?

Can't enroll @ your October-November sched, I'm quite busy by that time.

@ paul

Okay Sir, noted. Thank you.
pls inform me if there will be any schedule for php/mysql, buendia branch : preferred sched is saturday or sunday. im a former student. pls contact me if there are already 2 students enrolled, so i can enroll to be the 3rd student, (since mininum student to start the course is 3).just call or text me.thank you

Espana, Manila 736-2032 / 736-5196 and Buendia, Makati 889-6042 to 43.
Good day!
I have seen the schedule of October 20, 2014 for Microsoft, may I know po d contact number
@ dize

Please keep posted din po sa upcoming schedule namin for November. For job assistance, you can send your resume at

Thank you.
ok po thank you for the information. please update me on the schedule for your November class. Last question po, meron ba kayong connections to some company where in pwedeng madeploy ang mga students from cnctc? especially php & mysql learners?
@ Carlito D. Dela Cruz Jr.

Hi, upon checking our system may reservation po kayo for October 13-17 schedule.We will advise you 2-3 days before the training if we got already the minimum 3 participants. Thank you.
@ dize

Yes, magkakaroon po tayo ng schedule for November. Reschedule po ang Sept 28 class ng October 05. P11,000 po ang course fee for installment basis, downpayment is P5,500 and remaining balance will be pay in the midway of the training.
sir i did not receive an email confirming i have signed up.

magkakaroon po ba kayo ng class for the month of November para sa php & mysql? just saw the schedule nagstart na pala today ung class. sayang d ako nakaabot. tyaka paano po ung payment kung installment ang bayad?
How to create a simple log in.. help
@ Micko

The course fee for PHP & MYSQL Programming is P10,500. We will have schedule for January 2015 and more. Please keep posted. Thank you.
I'm planning to enroll next year. how much would it cost me and when will the school will start the earliest?
@ Arnel

Inform po namin kyo 3 days before nung start date ng training.
naka reserved na kasi ako. ako yung pang #3. kelan namin malalaman kung mag start na yung class?
@ Joji Uri

We suggest you to take first the Visual Basic 6 Programming training for the beginners or for those who do not have programming knowledge/background.
@ Arnel

Possible po na matuloy na may 3 po na nakareserved. Pareserve nalang po online. Minimum of 3 participants po to start the class.
I do not have IT education but im really want to learn programming . As a begginer can I take this class?
matutuloy na kaya yung pang Sunday 9-3pm sa Makati?
@ jerome

Yes, pwede naman po.
Hi, ask ko lang po kung pwede po ba ako maging intern sa mga companies while taking this course?
@ jonathan

Kailangan makabuo ng 10 examinees bago magbigay ng date ng exam ang assessment center.
after the training course ba.. may TESDA assessment exam ba agad
@ mhikoy

We give certificate of completion after finishing the course. Thank you.
do you have a certificatioin after compliting the course thank you
@ Jem

After the training you will receive certificate of completion. Makakatanggap po kayo ng certificate from TESDA if you passed the assessment exam.
After training what certificate na magkakaroon? may tesda certificate dn ba?

Yes, definitely you can learn PHP and My SQL training in a short period of time, We focuses on actual hands-on training good for 5 meetings, Our training Instructor is well skilled and Certified in this field.
I don't have background in Visual Basic. I have some knowledge in programming but not well experienced in programming. I'd like to learn PHP & MySQL Programming. Is it possible that I can learn it in just a short period of time?
@ Roger C.

The course fee for PHP & MySQL Programming is P9,000 in cash.
Magkanu po ung training.wala aq knowledge regarding php, but i want to learn coz i want to develop an accouting software
@ james mcdonald

Sorry we don't have branch in Davao City.
do u have a series in davao city
@ aeg

Yes, magkakaroon po kami ng schedule for July Sunday, please keep posted for our upcoming schedules. Thank you.
Kindly inform me if there is a set Sunday and July schedule for Php MySQL Programming.
@ kaizen

Wala po kaming discount na inooffer so far.
Sir, pwede po magtanong if may discount kayong ino-offer??
Page 6 of 9 | << | First | 1 - 2 - 3 - 4 - 5 - 6 - 7 - 8 - 9 - | Last | >> |

CNCTC Live Chat Inquiry

Job Openings


Stay Informed Subscribe

Name *

Email *