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


pwedeng walk in reg na lang para sa jan 25-29 classes?
@ Martin Ella Jr.

Yes, magkakaroon po ng schedule for Feb. and March sa Buendia Makati. Please keep posted. Thank you.
Meron po bang schedule sa Feb.at March sa Buendia campus?
@ mean

Inform po namin kyo within the day kung tuloy po ang class bukas.
tuloy na po ung dec5 to jan 9 on buendia?kc nkareserved aq last week saturday dapat.and namove xa..
@ Mean

Meron pong every Saturday schedule sa Buendia, Makati on December 05 to January 09, 2016 from 9am to 3pm.
hi po kelan po start ng class in Buendia for saturday schedule?
@ Noordin S. Gampal

Please see this link to make a reservation online http://www.cnctc.edu.ph/reservation_form.php
@ mean

Yes po.
Hi, gusto ko po mag enrol and pa reserve for the short term sa visual basic programing and mysql course...
yan na o ba final sked nyo for december weekend in buendia?
@ ed

Magkakaroon po kami ng December schedule. Ipopost po namin soon. Please visit po ang aming website for the updates.
wala pa po bang december weekend schedule in Buendia Makati po..
@ Dahlia Ituralde

Espana, Manila Tel. Nos. 736-2032 / 736-5196, Buendia, Makati 8896042 to 43. Meron po kami Monday to Friday from 9am to 3pm on Dec 7 to 11, 2015 and Dec 14 to 18, 2015 at every Sunday 9am to 3pm on Nov 29 to Jan 3, 2016
May contact number ba kayo? my daughter will enroll in php&mysql programming kaya lang di siya nakaabot. when is your next schedule? thanks..
@ BRNARD

Ang Webpage design using dreamweaver is more on design aspects-htlm, css at javacript sa PHP & MySql programming naman is web development, programming functionalities at databases. Kung wala kang basic knowledge in any programming language unahin nyo po ang Webpage design using dreamweaver then PHP & MySQL.
@ Louie

Hindi po kasama sa topic ang pag gamit ng framework, Laravel or code igniter
Anu po ba ang pag kakaiba ng wepage design using dreamweaver compare to PHP My Sql programming? connected po ba 2? anu dapat mauna sa kanila?
Magtuturo din po ba kayo kung pano gumagamit ng framework. Laravel or code igniter for example.
@ Me

Yes magkakaroon kami ng schedule for December. Ipopost namin soon.
hi magkakaron ng sched on december weekends?
@ tom Nambiar

We don't have branch in Cebu. We are located only at Espana, Manila and Buendia, Makati.
do you have any other branches in Philippine?i mean in Cebu or any other place.
I don't live in Philippine so its difficult to attend 3 weekends, at the most two sundays will be fine. or advise if any other place where I can join.
@ tom Nambiar

You can take the weekdays schedule for PHP & MySQL but for Webpage design training the schedule is every weekend only. Minimum of 3 participants to start the class.
I see you have web page design course of 24hours. can you make good time table so that I can complete both course in a span of two weeks?i don't see any connecting schedule at the moment. please advise.
do you have webpage design course?
@ tom Nambiar

We suggest you to take first the Webpage Design course before taking up PHP & MySQL training.
no idea of HTML either, I did programming course long time ago, but I never used. I know how it works but never tried. can I still join?
@ tom Nambiar

Yes, you can join the class but at least you have knowledge in HTML.
I would like to join for php and my sql course but I dont have any knowledge of visual basic 6 I am very beginner.. is it possible to join to this course. please advise.
hi, I would like to join for php and my sql course but I dont have any visual basic knowledge. can I join?
@ mean

Hi, magkakaroon po kami ng schedule this coming month of December. Please keep posted. Thank you.
hello po merun po ba sked this coming december for php and sql?
@ Peter

Hindi po natuloy ang class ngayon kulang ng participants. Marereschedule ang class on Nov 08, 2015.
Tuloy po ba yung 10-25-2015 sa espana?
@ Paul

Unfortunately wala po kaming OJT para sa PHP and MySQL Programming course. Thank you.
Ask ko lang po kung pwde kong gaweng OJT to ? or tumatanggap po kayo ng OJT kahit po may training fee, salamat po
@ Jonald Ray

Yes tuloy na po ang class.
Tuloy po sched for 10-03 9-3PM? @ Buendia?
HOW TO CREATE SQL?
XCBCXVBCNVB M
HOW TO CREATE A DATABASE?
finish program download
@ ervin

Hindi po tuloy ang PHP and MYSQL class ng August 17-21 due to lack of participants, reschedule po ng August 24-28. Thanks.
any update for aug 17 sched?
@ kichii

We suggest to enroll first in Webpage Design then you can enroll next for PHP and MySQL Programming. Thanks.
I have zero knowledge in programming. But I really want to learn PHP and SQL . Am I qualified to enroll?
@ Valerie Anne Castuera

The fee for the PHP & MySQL training is 10500 pesos in cash. Maybe you browse our old website. Please check our updated website www.cnctc.edu.ph
Hi. I'm just checking this page like 10minutes ago and the fee was just P9000. Then after I refreshed it, it is now P10,500? What happened?

Thank you for your quick response.
Page 3 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 *