PHP And MySQL

PHP or "PHP: Hypertext Preprocessor" is a widely-used Open Source general-purpose scripting language that is especially suited for Web development and can be embedded into HTML. Its syntax draws upon C, Java, and Perl, and is easy to learn.

The main goal of the language is to allow web developers to write dynamically generated web pages quickly, but you can do much more with PHP.

MySQL is a RDBMS (Relational database management system). We use such a system in order to store, retrieve and manage data related to our applications.

Apache is an Open Source web server in wide usage. A web-server is required to host a web-application (webpage) on a remote server and is responsible for processing the request from the client, who wants to access the application (or webpage).

Course Content:

• Datatypes And Variable Declaration
• How To Display Output
• Operators and types of operator
• Conditional Constructs (If, Else, Switch Etc....)
• Looping Constructs (For, While, Do-While Etc...)
• Arrays And Foreach Loop
• String Datatime Functions
• Code Reuse (Include & Require Statements)
• Functions
• OOPS in PHP
• Exception Handling
• Overview of MYSQL
• SQL Queries
• Introduction to MySQL
• Advantages /Features of MySQL
• Queries using MySQL performing create ,select ,update, delete etc
• Design View in MySQL
• Various Constraints in MySQL ( Primary Key, Unique Key, Foreign Key, NULL/Not Null Constraint)
• Various Function in MySQL
• Export/Import Data using MySQL
• Database Programming using PHP/MYSQL
• Insertion of records using MYSQL
• Admin Login Form using sessions.
• Select records using MYSQL
• EDIT/Delete records using MYSQL
• Search Records with respect to various criteria like ID , Name , Date Wise etc
• Use of Session
• cookies