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..
- Managing Messaging Security Using Microsoft Exchange Server 2007 - KB5049
- MS-Word, Excel, Powerpoint and Internet - KB0100
- Recovering Messaging Servers and Databases Using Microsoft Exchange Server 2007 - KB5050
- LPIC-2 Advanced Level Linux Professional Bootcamp - KB0144
- Microsoft MCP 2003 Training - Windows Server 2003 Active Directory Infrastructure
- KB0137 - CIPT - Cisco IP Telephony (CISCO CALLMANAGER 4.0.1 sr2) - Module3
- Implementing and Managing Microsoft Exchange Server 2003 - KB0284
- Active Server Pages (ASP) - Web Programming - KB0156
- Cisco 1 and 2 Routers and Routing Technology - KB0112
- CCNA Voice - Cisco Certified Network Associate Voice bootcamp - KB0135
Inquiries
Page 1 of 5 | <<
| First |
1 -
2 -
3 -
4 -
5 -
| Last |
>> |
@ AJ Noguerra
Our next schedule is on May 26, 2012. magoopen po kami ng schedule namin for the month of June.Please keep posted. Thank You
Hi sir/mam,
ask ko lang po what's your next schedule after may 19,2012 to jun 16, 2012 sa Espanya Manila. im looking for a slot po for the month of June.
thank you!
IS THERE ANY EXAM?...ON JOB TRAINING AND DIRECT EMPLOYMENT ON THIS COURSE?
TRULY,
jtalamanph12@yahoo.com
@ Analiza Tejada
Yes, magkakaroon po kami ng next schedule after ng 05/13/12~06/10/12. please wait for the update. Thank You
I mean schedule next to 05/13/12~06/10/12.
May susunod pa po bang schedule?
pwede po ba i adjust yung starting sched, may 15 kc payday namin, d aq kakapag bayad agad kung may 13 mag start, gusto q sana mag enroll d2
@ Analiza Tejada
Our next schedule is on May 13, 2012/9-3pm at buendia makati and May 12, 2012/3-9pm at Espana manila open for enrollment. Thank You
May I know when is the next batch of this course? And regarding its prerequisites, do we really need to enroll VB first before taking PHP & MySQL Programming course?
@ emmans
This training will take for 5 consecutive Sundays.
hello po.. so mga 3 sessions lang po ba yan? kasi po nakalagay sundays so 3 sundays lang po?
@ emman
You can send your resume @ jobs.cnctc.com.ph
Thank you.
sir/ mam.. may endorsement po ba ito after training? ung if qualified ka, mkakapag work kna base sa position na tinuro nyu.. answer please po..
gud afternoon! update lang po tuloy po ba yung pag open nyo ng sched this may? may mga nag pa reserved na po ba? baka kasi ako lang mag isa thanks! ^^
@ Wendell
Yes mag-oopen po kami ng schedule this coming May. please keep posted on our website. Thank You
Good morning maam/sir I'm Wendell from q.c sana po mag open kyo ng starting date na march sa Espana, and sorry for newbie question may training certificate po ba to? thank you..
Good morning maam/sir I'm Wendell from q.c sana po mag open kyo ng starting date na march sa Espana, and sorry for newbie question may training certificate po ba to? thank you..
@ silas
Okay, try po namin mag-open ng schedule from 5-13-2012 to 6-10-2012 dito po sa espana manila. please keep posted on our website. Thank You.
wala po bang schedule na naka base sa espana? from 5-13-2012 to 6-10-2012?
@ jerome
ang next schedule na po namin ay sa April 28, 2012 for Espana manila schedule then April 01, 2012 naman po dito sa Buendia MAkati. Thank you
Good Morning po, My name is vincent and I am a AMOS BS database controller I would like to ask if this will be okay as a pre requiaite for this course since AMOS Business Suite is a SQL programming language also...please confirm..thanks=)
gaano po ba kalawak ang kailangan sa DBMS and VB experience para maintindihan ang php and mysql?
hi, this is jerome, i would like to ask the schedule for march, please reply on my email , thanks
@ Chin
Kelangan may knowledge po kayo in any programming languages para di po kayo mahirapan for taking PHP & MySQL.
Hi, i want to enroll din, would it be very difficult ba to understand php&mysql w/out taking "visual basic 6"?? Gusto ko lang kasi ma master ang wordpress since its using php .
:(
@ Bobet S. Ortua
Yes, tuloy na po bukas feb. 26/9am yung training dito po sa Buendia makati. Thank you
Hi, count me in...as the sched pushes thru, I will be there this snday, feb 26, at 9:00am....
@ Alex Gil Tumala
Please go to this link for course reservation http://www.cnctc.com.ph/res...
Thank you.
pano po mag pareserve for the feb 26 schedule? mag paapreserve po ako sir
@ Bobet Ortua
Yes you can attend the class in Buendia Makati and Espa馻 Manila as long as the schedule will be push thru. We need at least 3 participants to start the class.
Good morning....
I am very interested with this course, I have reserved for it. Unfortunately, we have a family gathering on March 3-4....Is it possible that I enroll in the Makati Branch for the Feb26-Mar25 Sunday sched, attend the first session in Makati, skip Mar4 sched in Makati, attend Mar10 sched in Manila, then finish the course from Mar11 to Mar 25 in Makati....
Hope you can accomodate this sched....
Thank you and look forward to hearing from you soonest....
Regards
Bobet
@ Mark Alvin Nava
Sun9-3pm/Feb. 26 to March 25, 2012 is our open enrollment and for the next schedule please keep posted. Thank you.
kailan po ung susunod na batch?
@ francis
Yes magstart na po ngayon jan. 21/3-9pm ang course na ito sa espana manila matatapos po sa February 18, 2012. Thank you
HI, nag start na po kayo bukas.eh hanggang kelan naman po yun matatapos? thanks!
I'm also interested to enrol this course however there is a Visual Basic 6 and HTML programming prerequisites. Would it be very difficult to understand PHP&MySQL without taking VB6 and HTML?
@ PANCHO
Yes magkakaron po kami ng shedule sa February. Please wait for the update. Thank you.
HI MERON PA KAYONG SCHED THIS COMMING FEB?
@ dex
Yes Sir confirm na po ang class sa Sunday/9-3pm. Thanks.
tuloy ba ngayong linggo ang klase sa Buendia?
@ Jun
Yes Sir pwede po. Sige po enroll na lang po kayo bukas sa Espa馻 office. Magstart po bukas ang class ng 3-9pm. See you tomorrow. Thank you.
Sir,
Tanong ko lang po kung pwede pa humabol sa Nov 26 class ng Php and SQL. If so, bukas na rin po sana ako mag-e-enroll.
@ Gerald
Confirm na po sir bukas yung Php and MySql prog. dito sa espana manila nov. 19, 2011 from 3pm-9pm po. Thank You!
@ Gerald
Okay sir inform nalang po namin kayo kung tuloy po sa sat. yes po you can create a webpage with database after getting this course. Thank you!
So 1 nlng kulang kulang para mag start n sa sat ang klase. Sana makapagstart n sa Sat. After this class, will i be able to create a webpage, a webpage with database?
@ antonette
yes pwede po, How many participants will join the seminar? Please email us at cnctcinc@yahoo.com.Thank you!
our school is requiring to conduct seminars po, pwede po bang makapagseminar kami dyan mismo sa inyo???? php po sana ang gusto namin...
@ Ghe
Sir san po kayo nakareserve sa espana manila ba o sa buendia makati? Thank you
Reserve me for Sat 3-9pm class (11-05-2011 ). sana may mag enroll ding iba
@ ian
Yes meron pong certification exam after course completion.
may certification poba after course completion???
