Web Scripting With PHP

    Learn Php & MySQL

    Introduction to PHP

    • Discuss the history of PHP
    • Identify the need of PHP
    • Learn about PHP tools and setup
    • Write a simple PHP script
    • Learn about user I/O
    • Use PHP to generate HTTP headers
    • Pass variable via URL

    Form Handling in PHP

    • Use the GET method
    • Use the POST method
    • Retrieve data from forms using the form method
    • Use the hidden fields

    Using Variables and Expressions in PHP

    • Define identifiers
    • List the data types
    • Use variables and constants
    • Define scope of variables
    • Use the HTTP environment variables
    • Use the assignment operator
    • Use local variables
    • Use global variables
    • Use static variables

    PHP Operators

    • Use Arithmetic operators
    • Use Logical operators
    • Use rational operators
    • Use Bitwise operators
    • Use Assignment operators
    • Use String operators
    • Use Increment and Decrement operators

    Conditional Statements in PHP

    • Use the If statement
    • Use the Switch statement
    • Use the Ternary (?) operator

    Flow Control in PHP

    • Use Loops
    • Use Jump statements
    • Define a function
    • Use built-in PHP functions
    • Create a user- defined function
    • Pass arguments to a function
    • Return values from a function
    • Use a recursive function

    Working with Arrays

    • Define an array
    • Create and use arrays
    • Merge arrays
    • Use single and multidimensional arrays
    • Use array- related functions

    Handling Databases with PHP

    • Discuss about Database APIs
    • Connect to the database
    • Use data access functions
    • Perform SQL queries using PHP
    • Build HTML tables using SQL queries

    Working with Cookies

    • Set a cookie
    • Retrieve a cookie in PHP
    • Delete a cookie
    • Identify problems with cookies

    Session Management in PHP

    • Define a session
    • Work with the session
    • Start the session
    • Register the session
    • End the session
    • Work with the php.ini file

    Handling E-mail with PHP

    • Send e-mails
    • Attach files with e-mails
    • Explain the OOP concepts
    • Explain inheritances
    • Create classes
    • Create constructors
    • Create and use objects

    Database Handling using MySQL

    Introduction to MySQL as an open source Database

    • List the advantages of MySQL over other RDBMA
    • Differentiate MySQL with other RDBMS.
    • List the advantage of PHP in MySQL.

    Installing and Configuring MySQL

    • Evaluate various distributing options to MySQL.
    • Install MySQL on Windows Platform
    • Install MySQL on Linux platform
    • Configuring MySQL using scripts
    • Initializing MySQL at the startup
    • Install MySQL
    • Configure MySQL using customization scripts

    Using MySQL

    • Create a database
    • Explain a data type
    • Identify the different types of data
    • Create a table
    • Explain the use of Normalization
    • Identify the different forms of Normalization
    • Explain the concepts of Indexes and Referential Integrity

    Implementing the SQL queries using MySQL-1

    • View and alter the database
    • Retrieve data from a table
    • Modify the table definitions
    • Delete table definitions
    • Modify the database
    • Use Select command
    • Use Select command with WHERE clause
    • Modify the table structure
    • Drop the table

    Implementing the SQL queries using MySQL-II

    • Work with Keys
    • Work with Indexes
    • Manipulate tables
    • Manipulate tables with INSERT, MANIPULATE, UPDATE and DELETE
    • Using Order BY
    • Using the Group By Command

    Using Joins

    • Know the basic concepts and reason behind joining tables
    • Use Equi-join
    • Use Outer- join
    • Use self-join
    • Use multiple Select queries in a single Select query
    • Use UNION with the query

    Using Basic Functions in MySQL

    • Use GROUP BY and HAVING clause in MySQL queries
    • Use the Mathematical functions
    • Use the date functions
    • Use String information function
    • Use the system information functions

    Controlling and Managing MySQL database

    • Create User Account
    • Allocate appropriate privileges to users
    • Alter privileges
    • Using GRANT command to assign privileges to user
    • Using REVOKE command to alter privileges granted to users