Main Menu

Credit Cards

Our Partners


Authorized Pearson Vue Test Center



TESDA

Contest

  

Hands On IT TRAINING

PHP & MySQL Programming


26


COURSE DURATION: 30 hrs

COURSE DESCRIPTION:

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.

COURSE OUTCOMES:

  • 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

RECOMMENDED PRE-REQUISITES

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

COURSE OUTLINE

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


COURSE FEE :

with FREE Flowing Coffee
 

SCHEDULES :
       


Other Short Courses..


What do you think?

Leave a Question

 



Inquiries

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


@ Katherine Joelle

Minimum of 3 participants po bago magstart ang class. Inform po namin kayo before Feb 02 kung tuloy o hindi po ang class.
so how can i get started? i really want to be a hero in the field of computer.
Hello po!

Meron po bang open na programming course sa Summer?
Hi po, tuloy po ba yung class sa Feb.2 Espana branch? Thank you :)
@ Aries Balagon

Thank you for your interest. The course duration of this training is 30 hrs good for 5 meetings. Thank you.
Hi,
Im interested to enroll for this training. How many weeks it will take for this training?
Thanks.
@ Mary Mel Alvarez

Ma'am wala pa pong pirma ung certificate ninyo. Please follow up next week.
Hello po, how can we get certificate of completion for this training? We just finished this one po last December 20, Espana Branch.
@ David

Hindi po kasama ang CSS sa training. Sa ngayon mga pa po tayong CSS training. Thank you!
Sir kasama po ba sa training ang web desisgning using CSS.. yung as in paggawa na ng buong website?
@ Glecy Montablan

Yes, magkakaroon po kami ng schedule next year 2015 for PHP & MySQL training. Please keep posted. Thank you.
@ Jun Fernandez

Hopefully Sir matuloy po. Antay lang po tayo ng makakasama nyo. Thank you.
Hello po, Meron na po ba kayong upcoming sked sa 2015, mga February po sana..
sana po sure na yung class next week. (dec 1-5)
@ Nathan

Pag nameet na po natin minimum of 3 participants pwede na po natin start ang class. Thank you.
OK po salamat po mam kasi naka reserve na po ako ng sched ng dec 7 - jan 11 kung pede po sana mga 2 days before ng jan 12 ang end ng training kasi po pabalik na ako nun ng jan 12, 2015
@ Nathan

Magoopen po kaming ng Dec. 15 to Dec 19, 2014 schedule, Monday to Friday from 9am to 3pm.
Xa nga po pala 1 month vacation lang po kasi ako balik na po ako ng jan 12, 2015 any advise
maraming salamat po, anong araw po ang pasok at oras
@ Nathan

Yes po pwede. Gawa po kayo ng reservation nyo thru this link http://www.cnctc.edu.ph/reservation_form.php
Hi! pwede po ba ako humabol sa sched nio na december ill be in the philippines on december 9, 2014 need ko kasi maunawaan mabuti sql server for database.
3 kami magcclassmates ng basic web from another school interested mag enroll ng PHP MYSQL. Available sched namin 3 is 6-9PM MWF kaya niyo mag-open?
@ Bernie

Available schedule po namin ay Monday to Friday 9am to 3pm. Thank you.
sana magopen kayo PHP & MySQL or Java ng MWF 3pm-9pm
@ ecarg cyrish

Meron pong open schedule sa Espana Manila for Saturday 9am to 3pm/ November 15 to December 13. For course reservation, please see this link http://www.cnctc.edu.ph/reservation_form.php

Thank you.
..wla po bang sched na every saturday lng? 9-3pm? conflict po kc sa sched ng Mon-Fri.. thanks po,
@ armand p rodriguez

I'm sorry but we don't have training for Linux Apache MySql Php (LAMP).
@ Pher

Ok po magoopen po kami ng morning skedyul. Keep posted.
Sir magkakaroon pa po ba nung schedule before every saturday na pang morning? Gusto ko po sana kasi i-enroll etong subject na ito kaya lang yun lang yung available time ko..
bakit po walang klase kanina yung para sa kapon sana? sabi kasi noong isang sabado, linggo nalang daw klase.
May i ask if you have a training schedule that would cater the Linux Apache MySql Php (LAMP) package? how much it cost per participant? thanks.
@ Carlito D. Dela Cruz Jr.

Ok. See you tomorrow.
@ efren

Ok po inform namin kayo.
cge po ma'm punta nalang ako ng Monday, thanks.
hi, pwede bang if ma confirm ang sched makontak ako b4 sat kasi kukuha pa ako plane ticket. tanx.
@ 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
Hi,

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.
Hi,

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.
Hi,

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.

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

  
CNCTC Live Chat Inquiry

Job Openings

Subscribe

Stay Informed Subscribe

Name *

Email *