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


@ Edwin

Hello. Open po ang enrollment at minimum of 3 participants ang kailangan para mag push through ang class. Pagawa po ng reservation sa link na ito http://www.cnctc.edu.ph/reservation_form.php

Thank you.
Hi po. Kelan po start? Tentative po ba yang sched dan? Or may minimum head count po bago mag start. Pa advise naman po. Thank you
@ Emy

Yes, pwede po kayong mag-enroll sa course na ito kahit non IT graduate as long as may basic programming knowledge/background.
pwede po ba kahit graduate ka ng ibang course non related sa programming or IT?
@ Paulene

Currently, we don't have available weekday schedule but we will try to open soon. Please keep in touch for any updates. Thank you.
Do you have classes from Tuesday to Thursday?
@ Neil

Our Branch office is located @Rm 208 UPY Bldg., Gil Puyat Ave. (formerly Buendia Ave) corner Marconi St. Palanan Makati City
Ano po exact address for Buendia, Makati Branch ?
@ Marko

Yes, we will provide computers for all students.
Are there PCs provided for the students?
@ Daryl

Kung wala po kayong background sa any programming language. Ienroll ninyo muna ung Visual Basic 6.0 programming.
Hi po, gusto ko po sana matuto at mag enroll para sa programming courses nio. ano po ba ung dapat na unang una kong dapat ienroll?
@ ROI

Our Main office is located @ Rm 210 Dona Amparo Bldg., Espana Blvd. corner G. Tolentino St. Sampaloc Manila. Yes, meron pong open ng Saturday 3-9pm. Thanks.
ANUNG ADDRESS NIYO PO SA ESPANA?
TAPOS PAG SATURDAY PO BA EH MAY PASOK NG 3 PM TO 9 PM?
KUNG MAG EENROL PO BA AKO JAN EH, MAY WORK PO AKO SA SAMPALOC MANILA, ANG OUT KO SA SATURDAY EH 5PM. PWEDE DIN PO BANG PUMASOK SA LATE SA 3PM
@ John Mark

Hi, meron po kaming training ng Advanced MS Excel cover ang macros and please see this link http://www.cnctc.edu.ph/courses/item/ms-excel-2013-2016
Hello po.. Meron ba kayong short courses for macro ng excel.. Or VBA..
@ Mark Jacob

Pwede po as long as meron siyang knowledge sa prerequisite ng course.
hi po, Kahit po ba Hs grad ka lang dito, para namn po makasama koyong kapatid ko.Ako po graduate ng CompScie kaya may alam po ako, pero gusto ko pong mag-aral ng PHP and My SQL ulit at para ma master ko.
@ Errold

Our new schedules coming up soon. Please keep in touch. Thank you.
Who do you want to gift for nike on field jersey? Get value into
the page: china wholesale jerseys free shipping
May I ask when will be the next schedule for PHP & MySQL Programming? Thank you
@ Jerald

Currently, we don't have available MWF schedule.
@ Arnold Palanog

Thank you for your interest. Please keep in touch on the website for the updates of the schedule. Thank you.
I am interested to Enroll in this course: PHP and MySql Programmin. However, the schedule will not allow me to. Do you have other scheduled dates for the same course?

Thank you.
Do you have schedule for the month of august MWF? . Thank you
@ Doraisa A. Jawad

Meron pong training fee ang aming PHP AND MYSQL Programming cost P10,500 cash.
@ Moses Majiya

Thank you for your interest. Yes, you can take our short courses in PHP AND MYSQL and JAVA Programming. We will post soon schedules for 2018. Please keep posted. Thank you.
May bayad po ba kapag mag enrol sa tesda?
am interested in the programming courses but I would like to participate in mid 2018. Is it possible to attend more than a single course? am interested in PHP & MySQL as well as Java programming. If so what are the start dates and duration for 2018
@ Richard Lorilla

Please see schedule below.

Espana, Manila

Sat 3-9pm 05-06-2017 to 06-03-2017
Sun 3-9pm 05-07-2017 to 06-04-2017
@ Allan D Baclayon

Ok noted.
Hi,

Im going to have reservation this month(May) but ubfortunately the scheduled available for espana is 4/30/2017. I want to know when will have scheduled for May. Thank yoy...
Good Day!

May we ask if your good office could send us a Letter of Invitation for a Training on PHP and MySQL Programming for us to arrange an Itinerary of Travel on the schedule available for the month of July.

Thank you very much for your reply.
@ Richard Lorilla

Hello, open pa po ang enrollment ng April kapag hindi nameet ang minimum of 3 participants ang susunod po na schedule sa May na. Salamat.
Hi,

Pwede b sa May n kayo start para kasama na ako. Hindi p kasi me pwede ng April. Thank you.
@ Richard Lorilla

Kulang nalang po ng isang participant sa Espana, Manila.
Hi,

This is richard. may I know kung ilan p po ang kulang para mag start class. by May po kc gusto ko n magstart.. Thank you.
@ Richard Lorilla

We will post our May schedule soon on our website. Keep posted. You can make your reservation online through this link http://www.cnctc.edu.ph/reservation_form.php
Hi,

I'm planning to enroll, preferred schedule is on May 2017 every Saturday 3-9pm. Please advise me, thank you.
@ Krishna Mae Chua

Yes magkakaroon kami ng schedule by the month of June. Ipopost namin ang schedule soon dito sa aming website.
hello,

may class po ba available ng June 1st week?
May record na po ako na naging student. Thank you
@ ginne rose paragsa

30 hours duration ng course good for 5 meetings. Yes, yung buong course outline kasama na po sa fee.
@ Buboy

Yes, we will post our next schedule soon. Keep posted.
Hi. Ilang weekends lahat bago matapos ang training. Does all chapter is included in the fee?
Are there any upcoming schedule for PHP and mysql programming?
@ Elizabeth Francisco

Yes, classes is only available every Saturday and Sunday.
Hello,
Are classes only in the weekends?
@ igie

We will try to open weekday schedule. Keep posted for the updates.
will you be able to have weekday class for php and sql programming?
@ Irish

Hindi po required. May desktop dito na pwede ninyong gamitin for the training.
Page 1 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 *