Follow Us:

PHP and MySql Training in Chennai


Course Duration

40 HOURS
Sign in with Facebook Sign in with Facebook

About PHP and MySql

PHP is a server-side scripting language designed for web development but also used as a general-purpose programming language. PHP code can be simply mixed with HTML code, or it can be used in combination with various templating engines and web frameworks. PHP code is usually processed by a PHP interpreter, which is usually implemented as a web server’s native module or a Common Gateway Interface (CGI) executable. After the PHP code is interpreted and executed, the web server sends resulting output to its client, usually in form of a part of the generated web page.

Course Contents

PHP and MySql
    Core PHP+MYSQL(Level -1) Introduction:
  • What is PHP
  • PHP is better than its alternatives
  • Hardware and Software requirements
  • What a PHP Script Looks Like
  • Advantages of PHP
  • Getting Started With PHP:
  • How PHP scripts work
  • Basic PHP syntax
  • PHP data types
  • PHP Variables
  • Operators in PHP
  • Conditional Statements
  • Loops (If, If else and Switch)
  • SuperGlobals:
  • $_GET
  • $_POST
  • $_REQUEST
  • $_FILES
  • $_SESSION
  • $_COOKIES
  • $_SERVER
  • $_ENV
  • String Manipulation:
  • String Variables in PHP
  • The Concatenation Operator
  • The strlen() function
  • The strpos() function
  • Joining and Splitting String
  • Comparing String
  • Working with array:
  • Types of Arrays
  • Creating Arrays
  • Accessing Arrays
  • Single-Dimensional Arrays
  • Multidimensional Arrays
  • PHP Function:
  • User-Defined Functions
  • Inbuilt functions
  • Working with Forms
  • Designing a Form
  • $_GET and $_POST
  • HTML and PHP code
  • User Input
  • Form Validation
  • MYSQL Database (Level -1): MYSQL Database Working with PHPMyAdmin Working with PHPMyAdmin
  • What is Database Working with PHPMyAdmin Delete Record
  • Database Models Creating Databases Update Record
  • Tables, Records, and Fields Database Engines View Record
  • SQL Language Datatypes in MySQL Drop Database/Tables
  • MySQL Command-Line Creating Fields Primary / Foreign Keys
  • Unique Key Insert Record
  • Advanced PHP Programming (Level -2) Cookies
  • What is a Cookie
  • Cookie Syntax
  • How to Create a Cookie
  • Storing data in Cookies
  • How to Retrieve a Cookie Value
  • How to Delete a Cookie
  • PHP File Upload
  • Create an Upload-File Form
  • Create the Upload Script
  • Restrictions on Upload
  • Saving the Uploaded File
  • PHP File Handling:
  • Opening a File
  • Closing a File
  • Check End-of-file
  • Reading a File Line by Line
  • Reading a File Character by Character
  • Session:
  • What is Session
  • Creating Sessions
  • Storing a Session Variable
  • Destroying a Session
  • Classes & Object
  • Object oriented concepts
  • Define a class
  • Class attributes
  • An object
  • Creating an Object
  • Object properties
  • Object Methods
  • Object constructors and destructors
  • Static Method
  • Class Inheritance
  • Abstract Class
  • Implement Inheritance
  • Intergration to SQL with PHP Application (Level-2) SQL PHP MysQL Integration with SQL
  • Basics of SQL How to PHP MySQL Integration Works?
  • SQL Syntax Creating a database connection
  • CRUD Operations Selecting the DB
  • Insert Command Inserting data in database
  • Retrieving data from Database Inserting data with a File
  • Retrieving data with specific criteria retrieving all records
  • Updating records retrieving specific record
  • Alter table structure searching the records
  • Deleting the records updating records
  • Dropping tables eleting the records
Register Now

You will Learn How To :


Course Benefits :

Register Now

Please use the form below to make your career excellent.