Address : 279/1, New Railway Road Gurgaon
Call us : 99 10 192 454 | 98 11 170 798
Email: usflindia@gmail.com

"Speak a new language
so that the world
will be a new world."

PHP/ MySql Course

PHP LANGUAGE BASICS


  1. Syntax
  2. Quotes
  3. Comments
  4. Special Characters
  5. Data Types
  6. Precedence
  7. Symbols

PHP IDENTIFIERS


  1. Variables
  2. Constants
  3. Arrays

PHP CONTROL FLOW BASICS


  1. Operators
  2. if..else, elseif and switch statement
  3. Loops (for, while, do..while, foreach)

PHP FUNCTIONAL BASICS


  1. Functions
  2. Functions with parameters

FILE HANDLING


  1. PHP Open/Read
  2. PHP Create/Write
  3. PHP Open/Write
  4. PHP File Upload

PHP WEB CONCEPTS


  1. Client/Server Communications
  2. How to embed PHP into HTML
  3. How to embed HTML into PHP
  4. Cookies
  5. Sessions
  6. $_GET and $_POST

PHP DATABASE BASICS


  1. Introduction to Relationship Databases
  2. Keywords and Statements in SQL
  3. Using PHP Functions with the MySQL Data Engine

DEVELOPING PHP APPS


  1. Organizing a Concept Solution
  2. Creating a Program Skeleton
  3. Defining Error Checking Requirements
  4. Introduction to Application Security

My SQL Contents

MySQL Course Content


  1. A brief history of databases
  2. Relational database concepts
  3. Database tables
  4. MySQL Data types
  5. Introduction to PHPMyadmin
  6. Creating and Checking Tables
  7. Auto_increment and Primary Keys
  8. Inserting Values into Tables

Mini Project with PHP and MySQL


  1. Creation of database using PHPMyadmin
  2. Creation of tables using PHPMyadmin
  3. Creation of required templates, pages and managing site
  4. Keeping structure, style and behavior of created pages apart
  5. Creating login and logout pages
  6. Creating forms to insert data into address book-personal details, image etc
  7. Creating page to view the data from address book
  8. Adding PHPScript for form validation
  9. Adding server side validation
  10. Adding mouse events like mouseout and mouseover dynamically
  11. Creating page to edit or delete the records in the address book
  12. Creating page to enable searching the address book

Introduction to Ajax


  1. Connecting to server using PHPScript
  2. Downloading data behind scenes
  3. Modifying web pages on the fly
  4. Creating an XMLHttpRequest Object in different browsers
  5. Checking the XMLHttpRequest Object's readyState property
  6. Checking the XMLHttpRequest Object's status property
  7. Getting Your Data With the XMLHttpRequest Object
  8. Problems creating an XMLHttpRequest Object
  9. Fetching Text Data From the server
  10. Using the text data received through XMLHttpRequest

your interest

Universal School