Main Menu

Our Partners


Authorized Pearson Vue Test Center



TESDA
Live Online Training


Live CCNA Remote lab

Contest

  

CNCTC Articles - Excellence in IT TRAINING

Training Course For Programming MySQL And PHP

by: Cresencio Daffon Jr. | 17 Feb, 2011 17:40:29

Article Word Count: | Viewed: times


For people who are done studying programming course for Visual Basic 6 or concepts of programming, Hypertext Markup Language, and Data Base Management System working experience and still like to pursue studying a course that gives necessary knowledge on developing and designing Web pages which are database-driven with the use of MySQL and PHP then you need to enroll for a 30-hour PHP & MySQL Programming training.

The training will be consisting of how to develop scripts of PHP that perform looping tasks and decision making; develop scripts of PHP that integrate with the server of World Wide Web; understanding database interaction; PHP usage for database communication; and working with XML data.

The course training topics has 15 chapters beginning with PHP introduction covering role of PHP in World Wide Web and fundamentals of Language.

Second chapter is regarding Basics of PHP discussing data types of PHP followed by variable information storing and retrieval then variables basic operations and variable rules.

The third chapter is about PHP decision making starting with operators of comparison followed by if construct then while construct and for construct.

Fourth chapter is regarding PHP and Arrays covering arrays working followed by arrays sorting then related functions of other array and arrays which are multi-dimensional.

The fifth chapter is about PHP code re-using.

Chapter six tackles about Functions starting with declaring of functions followed by reference passing data then scripts code including and PHP variable scope.

The seventh chapter is regarding server of World Wide Web and PHP with the first topic covering web forms working followed by form elements and PHP post then PHP code embedding forms; form data validation; spoofed submissions prevention; secure PHP guidelines; magic quotes understanding; forms default values setting; uploaded files processing; and uploaded files retrieving & sorting.

Eighth chapter tackles about databases and PEAR MDB2 Working beginning with databases brief history followed by database concepts which are relational then tables of database and create table statement using.

Chapter nine is about Data types of Structured Query Language that starts with data types of integer followed by data types of floating point then data types of character and data types of other Structured Query Language; column modifiers of Structured Query Language; column options of AUTO_INCREMENT and SERIAL understanding; and naming syntax of table & database.

The tenth chapter will discuss about Structured Query Language data manipulation which begins with statement of SELECT followed by SELECT syntax which is overall then displaying selected values; WHERE clause selections restriction; sort query results using ORDER BY; limit result sets using LIMIT; statement of INSERT; statement of UPDATE; statements of DELETE and TRUNCATE TABLE; and PEAR & PECL used for leveraging existing code.

Chapter eleven is about PHP usage for accessing databases and the discussion will start with PEAR's MDB2 class usage followed by Data Source Name creation then database connection and connection options setting up and Structured Query Language statements execution; prepared statements execution; executing multiple statement; queries (metadata) information retrieval; and queries for single-step.

The twelfth chapter is regarding Web sessions management beginning with session handling using PHP followed by handling PHP cookie then PHP time & date handling; times & dates; time or date parsing; and relative times generating.

Chapter 13 is PHP files working starting with PHP files writing & reading followed by permissions and errors handling.

The second to the last chapter is about PHP eXtensible Markup Language data working covering eXtensible Markup Language understanding and feeds of Really Simple Syndication.

The fifteenth chapter is focusing on PHP code debugging that covers handling error and debugging tools of PHP then errors suppression.

For more details, click the link below this article:

 

http://www.cnctc.com.ph/blogs/item/2009/11/php--mysql-programming---kb0154


Protected by Copyscape Originality Checker





Other Related Topics..
« Prev item - Next Item »
---------------------------------------------


What do you think?

Leave comment

This item is closed, it's not possible to add new comments to it or to vote on it

Comments

No comments yet. You can be the first!

  
CNCTC Live Chat Inquiry

Job Openings

Subscribe

Stay Informed Subscribe

Name *

Email *