14 Years Of Excellence
An ISO 9001:2015 Certified Company

PHP and MYSQL

PHP & MYSQL Course contents

HTML (Hypertext Markup Language)

  • Introduction to HTML
  • Basic structure of HTML
  • Formatting tags in HTML
  • Working with Table Tags

PHPSCRIPT

  • Introduction to PHPScript
  • Looping statement in PHPScript
  • Working with Predefined functions
  • Maintaining Validations in PHPScript
  • Working with Different types of Mouse Events
  • Miscellaneous

PHP

  • PHP’s role in the WWW
  • Language fundamentals
  • PHP Basics
  • Variable rules
  • Storing & retrieving information in variables
  • Decision making in PHP
  • Comparison operators
  • The if construct
  • The while construct
  • The for construct
  • Working with arrays
  • Functions
  • Declaring functions
  • Passing data by reference
  • Variable scope in PHP
  • Working with web forms
  • PHP POST & GET form elements
  • Embedding forms with PHP code
  • Validating form data
  • Guidelines for secure PHP
  • Understanding magic quotes
  • Setting default values in forms
  • Processing uploaded files
  • Retrieving uploaded files
  • PHP session handling
  • PHP cookie handling
  • Handling date & time
  • Working with files in PHP
  • Reading & writing files with PHP
  • Handling errors

MySQL

  • A brief history of databases
  • Relational database concepts
  • Database tables
  • MySQL Data types
  • Introduction to P HPMyadmin
  • Creating and Checking Tables
  • Auto increment and Primary Keys
  • Inserting Values into Tables

Mini Project with PHP and MySQL

  • Creation of database and required tables using PHPMyadmin.
  • Creation of required templates, pages and managing site using IDEDreamweaver.
  • Keeping structure, style and behavior of created pages apart.
  • Creating login and logout pages for maintaining sessions.
  • Creating forms to insert data into address book-personal details, image

etc.

  • Creating page to view the data from address book.
  • Adding PHPScript for form validation.
  • Adding server side validation.
  • Adding mouse events like mouseout and mouseover dynamically.
  • Creating page to edit or delete the records in the address book.
  • Creating page to enable searching the address book.

Introduction to Ajax

  • What is ajax
  • Connecting to server using PHPScript
  • Downloading data behind scenes
  • Modifying web pages on the fly
  • Creating an XMLHttpRequest Object in different browsers
  • Checking the XMLHttpRequest Object’s readyState property
  • Checking the XMLHttpRequest Object’s status property
  • Getting Your Data With the XMLHttpRequest Object
  • Problems creating an XMLHttpRequest Object
  • Fetching Text Data From the server
  • Using the text data received through XMLHttpRequest

Address:

#7-20, 4th Floor,
Kamala Land Mark,
Beside Konark Theater,
Dilsukh Nagar,
Hyderabad - 500 060.
Telangana State, INDIA.

Landline:

040 - 6625 2272
040 - 6625 2273
040 - 6625 2274

Mobile:

+91 - 93999 74756
+91 - 903 006 1377
+91 - 939 249 1377
+91 - 9059 511 485

E-Mail:

info.svgroups@gmail.com
team@svinfotech.in
jobs@svinfotech.in
director@svinfotech.in