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

@ Anita E. Gorgnio

Yes, we have open schedule for Sun 9-3pm/June 01 to June 29, 2014.
Do you have schedule in Php MySql Programming this coming June 2014 every Sunday?
@ paul

Meron po tayong open schedule for every Saturday and every Sunday. Please go to this link to make a course reservation

Thank you.
sat or sunday sched pls
@ Prescious

Yes we have PHP and MySQL training that offers from basic to Advance programming. Let me ask first our training manager how much would be the cost and available trainer in your location(Bataan). Thank you

I’m a VB6 programmer and my company wants me to shift from VB6 to PHP and MySQL. They prefer that the training should be in a boot camp manner (from Basics to Higher Level) here in our place located at Kamaya Pt. Alas-asin, Mariveles, Bataan. There would be a maximum of 5 delegates. If this is the case, how much would the training cost? Kindly send a proposal with complete course outline, pricing and regarding this training.
Thank you very much.

hi po nagstart na po ba ung sa buendia?
@ christian

Yes Sir, or atleast meron po kayong knowledge sa basic ng programming. Yes open po kami ng weekends Saturday at Sunday 9am to 3pm.
hi po gusto ko po magtake ng php course nyo . ask ko lang kung need pa ba talga magtake ng prerequisite nyo? open po ba office nyo sa week end magiinquire po sana ako sa buendia branch nyo.
@ jeff

Yes po.
object oriented approach po b ang turo nyo ? thanks
@ felix

Minimum of 3 participants to start the class.
how many person require to open in 1 week class for this course?
@ coehiei19

Try po namin makapag open just keep posted lang po. Thanks
Hi Sir, inquire lang po ako if meroon schedule for this course on June 1 - July 2, 2014 (M-F), sa buendia makati?
@ Joseph

Hindi po gagamit ng ibang framework yung PHP core lang po. Thanks
Anung framework yung gagamitin sa trainning?
guys Pa reserve nmn kayo sa Buendia, Espana
M to F 9-3pm 04-28-2014 05-02-2014 :D
@ marife. nag pa reserve na po ako m to friday 9-3pm. basic to advanced po ba ito ?

pareserve n guys. :)
@ Marife Monsanto

You can enroll this course as long as you have basic understanding in any programming language.
Good evening, question about the pre requisites, I'm actually interested to study intro to database management system can I apply for PHP & MySQL Programming for now?
@ Paul

Wala po tayong pasok sa PHP & MySQL Programming sa April 19, 2014 ma mumove po ang schedule ng April 26, 2014. Thank you.
pls text me if matutuloy po sa april 19 buendia.
5 na po naka reserve e. ito po muna uunahin ko.thanks

naka reserve po ako sa PC/Lan and ASP web.
@ Luzvimin

No Ma'am, the said schedule is moving for April 26, 2014. Thank you.
Hi there! just want to ask if class of Sat 9-3pm will really start on April 19 black saturday?
Gud PM. sure na po ba na start of training for April sat 9-3pm will be on April 26 coz 19 will fall on holiday?.. ty
@ Heitan

Kaya po short term course because we focuses on Actual Hands-on training, more on activities and laboratory. Thank you!
bakit poh in short period lng yung teachung nyo
@ Luzvimin T. Jerez

Imomove po the following week ung start ng training.
#Wala Pasok pag Holiday

so wala po pasok sa April 19 (umpisa) kasi po black saturday un.
@ Luzvimin T. Jerez

Wala pasok pagholiday po.
dreamweaver po ba gagamitin dito?
Me pasok po ba pag nataon holiday ang saturday?
@ vlademir

Sorry, but were located only here at españa manila and buendia makati. Thank You
Meron po ba dito sa cebu ng offer ninyo..
@ Marc

Please pareserve po online para mainform ka namin 3 days before kung aling schedule ung magstart. Minimum of 3 participants bago magstart ang class.
Sir/Ma'am tanong lang po kung sure na po ba yung training na mag start sa march 15 yung sa buendia, makati po at march 16 sa espana? o maghihintay pa po ng ibang mag eenroll para po mag start?
@ Christian

Saan nyo po preferred magtraining? Meron kaming open schedule on March 10 both Espana and Buendia, Makati and every Saturday March 15 in Buendia, Makati and every Sunday March 09 in Espana, Manila. Pareserve po online.
Kilan po start ng Training?

pwede ba zero knowledge about programming dito po?
@ gio

Sakay kayo ng bus going to ayala, lrt leveriza then baba kayo Marconi St. mismo.
paano po pumunta sa makati branch nyo?

i will be coming from taft via mrt edsa

thanks po
@ Meriam

Yes po pwde see this link to reserve online
Pwede papo b magpareserve ngayon?

Yes nagbibigay kami ng certificate after the training.
@ Jo & Gizelle

Yes po pwede basta may basic knowledge kayo sa Visual Basic 6 Programming or Some understanding of programming concepts, and HTLM.
Can i enrol kahit zero knowledge sa PHP? Gusto ko po kasi talaga matuto. Thanks
@ Arnel Palero

Wala po kaming branch sa Sta. Rosa Laguna, located lang po kami sa España Manila and Buendia Makati. Thanks.
Page 7 of 9 | << | First | 1 - 2 - 3 - 4 - 5 - 6 - 7 - 8 - 9 - | Last | >> |

CNCTC Live Chat Inquiry

Job Openings


Stay Informed Subscribe

Name *

Email *