

MODI TRAINING INSTITUTE
PHP/MY SQL

PHP/MY SQL
INSTALLATION
- Introduction PHP and Mysql
- PHP Installation
- MySQL Installation
- Apache Installation.
- XAMPP and WAMPP Installation
PHP BASICS
- Embedding PHP in HTML
- Embedding HTML in PHP
- Introduction Variable
- Using variables
- Understanding Data Types
- Using Operators
- Writing Statements and Comments
- Using Conditional Statements
- If(), else if() and else if condition
- Statement
ARRAYS AND CUSTOM FUNCTIONS
- Creating an Array
- Modifying Array Elements
- Processing Arrays with Loops
- Grouping Form Selections with Arrays
- Using Array Functions
- Creating User-Defined Functions
- Defining and Invoking Functions
CREATING BASIC PROGRAMS WITH PHP
- Reading and Writing Files
- Reading Data from a File
- Writing Data to a File
- Testing File Attributes.
- Managing Sessions and Using Session
- Variables
- Creating a Session and Registering Session Variables
- Destroying a Session
- Storing Data in Cookies
- Setting Cookies
- Retrieving Cookie Data
- Dealing with Dates and Times
- Executing External Programs
EDITING RECORDS AND PERFORMING QUERIES
- Inserting Records
- Editing and Deleting Records
- Performing Queries
- Retrieving Specific Columns
- Filtering Records with a WHERE Clause
- Using Operators
- Sorting Records and Eliminating Duplicates
- Limiting Results
- Using Built-In Functions
- Grouping Records
- Joining Tables
- Using Subqueries
- Using Table and Column Aliases
USING PHP WITH MYSQL
- Managing Database Connections
- Performing Queries
- Processing Result Sets
- Queries Which Return Data
- Queries That Alter Data
- Handling Errors
- Using Ancillary Functions
CREATING FORMS WITH HTML
- HTML Basics
- Creating Forms with HTML
VALIDATIONS WITH JAVASCRIPT
- Introduction to Java Scripting
- Types of Java Scripts
- Variables, operators, loops
- Using Objects, Events
- Common java script functions
- Using JavaScript in Dreamweaver
- Java Script Validations
Duration: 3 Months