Blog

• Discuss the history of PHP
• Identify the need for PHP
• Learn about PHP tools and setup
• Write a simple PHP script
• Learn about User 10
• Use PHP to generate HTTP headers
• Pass variables via URL
• Use the GET method
• Use the POST method
• Retrieve data from forms using the Form methods
• Use the hidden fields
• Define Identifiers
• Lists the data types
• Use variables and constants.
• Define the scope of variables
• Use Arithmetic operators
• Use Logical operators
• Use Relational operators
• Use Bitwise operators
• Use Assignment operators
• Use String operators
• Use the If statement
• Use the Switch statement
• Use the Ternary (?) operator
• 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
• Define an array
• Create and use arrays
• Merge arrays
• Use single and multidimensional arrays
• Use array-related functions
• Discuss about Database APIs
• Connect to the database
• Use data access functions
• Perform SQL queries using PHP
• Build HTML tables using SQL queries
• Set a cookie
• Retrieve a cookie in PHP
• Delete a cookie
• Identify problems with cookies
• Define a session
• Work with the session
• Start the session
• Register the session
• End the session
• Work with the php.ini file
• Send e-mails

Attach files with e-mails

• Explain the OOP concepts
• Explain inheritances
• Create classes
• Create constructors
• Create and use objects

MY SOL

• List the advantages of MySQL over other RDBMS
• Differentiate MySQL with other RDBMS
• List the advantage of PHP in MySQL
• Discuss the licensing of open source software

• Evaluate various distributing options of MySQL
• Install MySQL on Windows platform
• Install MySQL on Linux platform
• Configuring MySQL. using scripts
• Initializing MySQL at the startup

• 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

• View and Alter the database
• Retrieve data from a table
• Modify the table definitions
• Delete table definitions

• Work with keys
• Work with indexes
• Manipulate tables
• Using ORDER BY
• Know the basic concept 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

• Create User Account
• Allocate appropriate privileges to users
• Alter privileges
• Control user access to the database with the help of privileges