Internet
Courses /
Web Development
Series:
Web Application Development using
PHP & MySQL
(WEBPHPMSQL)
This is a 66-hour instructor-led course which provides participants with practical skills required to build Web applications using the PHP & MySQL. It covers major topics in PHP (PHP Hypertext Preprocessor) scripting and MySQL database development on an Apache Web server using HTML Web development environment
Target
Audience
This course is
intended for those who want to provide transactional capabilities to their
Web sites. |
·
Understanding of programming
concepts.
·
Understanding of database
concepts.
Topics
Part1:
The Basics of
PHP
(22 Hrs /
Rs.4000/=)
|
1. Introduction IntroducingApache,Php,mysql Installing Apache,Php,Mysql Configuring Apache for Php
|
2.Php Basics Syntax rules Escaping characters Reserved words Variable Data types Functions Function arguments Multiple arguments Variable scope Multiple arguments |
3. Performing Operations Arithmetic operators Logical operators Assignment operators Comparison operators Conditional operators
|
4. Making Statements Conditional if statement If else statement Switch statement For loop While loop Do-while loop Interrupting loops Return statements
|
|
5. Using arrays Creating an array Changing array elements Listing array elements Getting the array size Adding and removing array elements Array keys and values One base indexing Manipulating arrays
|
|
|
|
Part 2:
Advanced PHP
(22Hrs /
Rs.4000/=)
|
6. Generating dynamic content Identifying browser platform Server date and time Time specific content Random number generator Getting form values Displaying submitted values String manipulation Reloading a page Browser redirection |
7. File handling with Php Displaying directory files Coping and renaming files Deleting files Opening and closing files Reading files Writing files Logging visitor details Enabling file uploads Creating and upload form Creating an upload script Uploading a file
|
8. Data persistence Introducing cookies Set a cookie Access limitation Introducing sessions Starting session Session without cookies Setting session persistence Cookies or session
|
9.E-mail with Php Sending plain text E-mail Sending html E-mail Creating an attachment form Sending attachment with E-mail
|
Part 3:
PHP and My SQL
(22Hrs /
4000/=)
|
10. Getting started with Mysql Introducing databases Exploring database tables Creating new database Creating database table SQL data types Inserting table data Altering an existing table Updating records Deleting data, tables and databases SQL Queries
|
11. Php and Mysql together Creating Mysql user and password Connecting a user to Mysql Listing databases Listing table names Creating a database Deleting a database Creating a database table Inserting table data Altering tables Retrieving data from a table
|
