PHP & MySQL Training

PHP & MySQL course is offered by DSTARENA. DST Arena has been working in training, work research, and projects for the last 12+ years and has emerged as one of the leading institutes of Bhopal.

Syllabus:

• What is PHP
• How PHP better than other
• Benefits Of Using PHP MYSQL
• Server Client Environment
• Web Browse Web Server
• Installation & Configuration Files
• Development Concept
• How PHP Script Work
• PHP Syntax
• Write your First PHP Program
• Embed PHP In HTML/HTML In PHP
• PHP Data Type
• Variable In PHP
• Contents In PHP
• Operator In PHP
• Control Structure:
• If Statement
• .Else Statement
• ..If Else Statement
• Nested If Statement
• Switch Statement
• Looping Structure
• For Loop
• While Loop
• ..While Loop
• For each Loop
• Function
• What is function
• Syntax
• User-Defined Function
• System Defined Function
• Parameterized Function
• Parameterized Function
• Date & Time Function
• Hash Function
• Mail Function
• File Inclusion
• Include()
• Require()
• Array
• What is Array
• Syntax
• Associative Array
• Numeric Array
• Multi-Dimensional Array
• String Function
• Chr()
• strlen()
• strpos()
• strcmp()
• Working with File
• Opening File
• Reading File
• Writing File
• Closing File
• Appending File
• Uploading File
• OOPs Concept
• Class & Object
• Access Modifier
• Properties of Object
• Encapsulation and abstraction
• Inheritance
• Polymorphism
• Function overriding
• Abstract class
• State Management
• Creating Cookies
• Set Cookies
• Destroying Cookies
• Creating Session
• Set Session
• Destroying Session
• Error Handling & Exception
• Introduction to Error
• Try, catch, throw BlockHand
• What is Database?
• Understanding an RDBMS
• Understanding Tables, Record & Fields
• SQL Language
• Working with MYSQL Admin
• Working with PHP My Admin
• Types Data Type
• Creating Database & Tables
• Dropping Database & Tables
• Adding Fields
• Selecting Table
• Alerting Fields Properties
• MySQL Function in PHP
• Database Connections
• Managing Database Connections
• Performing Queries
• Closing Connection
• SQL Queries
• Create Database & Table
• Drop Database & Table
• Insert Record
• Select Record
• Deleting Record
• ModifyingRecord
• WHERE Clause
• Using Operators
• Sorting Records
• Eliminating Duplicates
• Grouping Records, Having Clause
• Joining Tables
• Sub queries
• Using Table And Column Aliases