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 :
