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


@ LORENA P. FLORITA

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 Visual.net, 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 http://www.jobs.cnctc.com.ph/

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

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
thanks
@ 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?
@ MSB

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??
@ 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 http://www.cnctc.edu.ph/reservation_form.php

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
Sir,

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.

Prescious
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?
Page 6 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 *