PHP & MySQL Programming - KB0154
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..
- Upgrading Skills in the IT industry
- Network Security and Penetration Testing
- PC Monitor Troubleshooting & Repair - KB0130
- KB0135 - CISCO Voice Over IP (VOIP) Technology Module 1
- LAPTOP Servicing, Assembly, Hardware Troubleshooting and Repair - KB0102
- How to become a CCNA certified professional
- Visual Basic.Net Programming - KB0152
- Java Programming (J2SE/J2EE) - KB0153
- Monitoring and Troubleshooting Microsoft Exchange Server 2007 - KB5051
- Get a chance to win an HP Deskjet F2480 All in ONE printer!!
Inquiries
Page 1 of 8 | <<
| First |
1 -
2 -
3 -
4 -
5 -
6 -
7 -
8 -
| Last |
>> |
@ sandrei
Yes, additional Php 100 po para sa training manual. Thanks.
ganun po ba after ko mag enroll separate pa ung pag bili handout hindi pa po ba sya included sa enrollment fee.
@ Sandrei,
Kung enrolled na po kayo sa course pwde na po kyong bumili ng maual.
Hi
kung mag avail po ako ng handout or manual or some tutorial video na kau po mismo ang nag tuturo like usual na tinuturo nyo possible po ba yon kasi nedd ko talaga ng training especially ngaun kailangan ko sa current job ko salamat...
@ Sandrei
Sorry, but the available schedule for this course is every Saturday and Sunday only. Thanks
HI!
Im working in SAUDI ARABIA right and i am interested to enroll on PHP SQL programming but my time availability is only friday due to it is a weekend here in KSA any advise you can give to me. thanks!
@ michael
Yes, may schedule na po ng May nakapost na po dito sa website. Saturday 3-9pm/ May 25 to June 22, Saturday 3-9pm/ May 18 to June 15, 2013. Thanks.
SIR, ASK KO LANG PO KUNG MY SCHED NGAYON MAY
@ john erwin
Yes you will receive certificate of completion after finishing the course. Thanks.
meron po bang certificate to pag natapos .?
@ Ramil
Yes, magkakaroon po kami ng schedule for the month of July or August. please keep posted for the update. Thank You
Meron po bang training ng php MySQL at asp.net sa July or August? Yan lang po ang available kong time
@ arnel albis
Hindi na po. kasi nilipat po namin yung reservation niyo ng April 28, 2013. Thank you
@ arnel albis
Yes, ikaw po yung 1 reserved for April 28 Sunday 9-3pm. Thanks.
magpa-process ba ulit ako ng reservation for Sunday 9-3pm? nagawa ko na kasi before, e biglang na-delete yung sched. o ako yung 1 na nagpa reserve? thanks.
@ arnel
Okay, try po namin ulit mag-open ng every Sunday na schedule. Please wait for the update. Thank You
@ arnel
Meron na po ulit yung Sunday 9-3pm schedule sa Buendia Makati. Thanks.
sayang naman at na-delete yung pang sunday 9-3pm
@ Cris Acevedo
We are located at Rm 210 Dona Amparo Bldg., Espana Blvd. corner G. Tolentino St. Sampaloc Manila. We will open schedule that will start on May just keep posted. Thank you!
What is the exact address in Espana? Will there be a class that will start in May, preferably every Sat?
@ Ma. Eleanor Honrade
Yes, magkakaroon po kami ng schedule for the month of May. please keep posted for the update. Thank You
Is there any other schedule in Buendia, Makati? like, 1st week ng May ang start?
@ Carol
Please see this link on how the online training works http://www.cnctc.com.ph/blo... schedule of the training is on April 07 to May 05, 2013 every Sunday 3-9pm. Minimum of 3 participants to start the class.
any information how you conduct live online training - like how do you get the SW that you will need for programming, what time do have this training, etc.
@ nico ruelo
Good for five meetings lang po yung training. Thank You
ilang taon or months namin bubonuin tong course na to para matapos??
@ arnel
Okay, we will try to open every Saturday schedule 9-3pm at Buendia Makati. please keep posted for the update. Thank You
Hi, pwede bang magka roon ng training ng Saturday 9-3pm in Buendia, Makati? thanks.
@ estef
Yes, meron po kaming schedule on March 17, 2013 and April 20, 2013. please make your online reservation @ http://www.cnctc.edu.ph/res... Thank You
hi po! may sched po b this march or april? pls let me know
@ mary ann
Yes, after getting this course you will receive certificate of completion. Thank You
may certificate po ba after kunin tong course na to?
Hi I need online course for Java Programming (J2EE/J2EE) - KB0153 and PHP with MySQL Programming schedule during Friday 7:00 PM Phil. Time because I was working outside the country.
Thank you,
Novijohn B. Florentino
@ estef
Wala pa pong magumpisa na class bukas. Thank You
meron na po bang 2 enrolled for tomorrow?
@ estef
Kailangan pa po namin sila inform kung confirm po sila sa reservation nila. Please make your online reservation @ http://www.cnctc.edu.ph/res... para mainform po namin kayo kung tuloy po sa Feb. 16, 2013. Thank You
may dalawa na po ba na enrolled? ako na po pangatlo? sa saturday puede na po ba magsimula?
@ Echusen
Pag may 3 participants na po na nagconfirmed sa nakareserved pwede na pong magstart ang training. Thanks.
ask ko lang, kapag naka 3 participant na sure na ba agad na magstart yung training o possible pa din na mamove kahit nakumpleto na yung minimum required participant?
@ Echusen
Yes, po kung nagbayad kayo ng cash on the day of training 9,000 lang po bayaran ninyo. pero kung installment basis naman po additional 500. Thank You
ask ko lang, bale yung less 500 is kapag binayaran po ba ng buo sa first day or dapat before start ng training?
@ estef
Please wait for our final confirmation if the class will push through on Saturday.Thank You
tuloy po ba this saturday feb 10?
@ Paula
Yes, magkakaroon ng schedule for PHP & MySQL training this coming April. Please keep posted. Thank you.
magkakaron po ba ng schedule ng PHPandMySQL Training sa April?
@ RYS
Sorry Pero wala po kaming weekdays schedule. Thank You
wala po ba straight from monday to friday? kasi magastos pag every weekend, nasa mindanao po kasi ako..
@ estef
Hindi po natuloy yung training ngayon sa PHP prog. reschedule po nextweek Feb. 10, 2013 due to lack of participants. please make your online reservation @ http://www.cnctc.edu.ph/res... Thank You
magsisimula na po ba mamayang 3pm? saang branch po isa pa lang kasi ang nag-enrolled.? three ang kailangan db? Puede bang pumasok na ngayon tapos sa next meeting na ang bayad? promisory muna? di kasi ako prepared eh! now ko lang nabasa na meron na ngayon.
@ yannol
Unfortunately we're located only @ Espaņa Manila and Buendia Makati. Thank You
