Book a Free Demo / Get Full Program Details

PHP And MySQL

MySQL and PHP are widely-used open source technologies for building database-driven web applications. PHP is a powerful server-side scripting language, while MySQL is a robust relational database management system using SQL.

For a career as a PHP & MySQL developer, consider enrolling in Hrishi Computer Education. Located in Mumbai North (Vasai, Virar, Palghar), this institute offers top-notch courses in popular programming languages. The PHP and MySQL course includes hands-on training to build dynamic websites, SQL command writing, form data processing, file uploading, relational database design, and password protection.

COURSE DURATION

3 Months

WEEKLY

6 days/ 1 ½ Hours

Download Brochure

View Details

Given below is the complete syllabus for our PHP & MySQL Course:

Introduction to PHP

1
  • Evaluation of PHP
  • Basic Syntax
  • Defining variable and constant
  • PHP Data type
  • Operator and Expression

Handling Html Form with PHP

2
  • Capturing Form Data
  • Dealing with Multi-value filed
  • Generating File uploaded form
  • Redirecting a form after submission

Decisions and loop

3
  • Making Decisions
  • Doing Repetitive task with looping
  • Mixing Decisions and looping with Html

Function

4
  • What is a function
  • Define a function
  • Call by value and Call by reference
  • Recursive function

String

5
  • Creating and accessing String
  • Searching & Replacing String
  • Formatting String
  • String Related Library function

Array

6
  • Anatomy of an Array
  • Creating index based and Associative array
  • Accessing array Element
  • Looping with Index based array
  • Looping with associative array using each() and foreach()
  • Some useful Library function

Working with file and Directories

7
  • Understanding file& directory
  • Opening and closing a file
  • Coping, renaming and deleting a file
  • Working with directories
  • Building a text editor
  • File Uploading & Downloading

State management

8
  • Using query string(URL rewriting)
  • Using Hidden field
  • Using cookies
  • Using session

String matching with regular expression

9
  • What is regular expression
  • Pattern matching in Php
  • Replacing text
  • Splitting a string with a Regular Expression

Generating Images with PHP

10
  • Basics of computer Graphics
  • Creating Image
  • Manipulating Image
  • Using text in Image

Advance PHP Introduction to OOPS

11
  • Introduction
  • Objects
  • Declaring a class
  • The new keyword and constructor
  • Destructor
  • Access method and properties using $this variable
  • Public ,private, protected properties and methods
  • Static properties and method
  • Class constant
  • Inheritance & code reusability
  • Polymorphism
  • Parent:: & self:: keyword
  • Instance of operator
  • Abstract method and class
  • Interface Final

Exception Handling

12
  • Understanding Exception and error
  • Try, catch, throw

Database Connectivity with MySql

13
  • Introduction to RDBMS
  • Connection with MySql Database
  • Performing basic database operation(DML) (Insert, Delete, Update, Select)
  • Setting query parameter
  • Executing query
  • Join (Cross joins, Inner joins, Outer Joins, Self joins)

Project Work

14


WHAT STUDENT SAYS ABOUT US?

Book a Free Demo / Get Full-Programme Details

HRISHI Computer Education, one of the leading IT/ Computer Education Institutes in Vasai-Virar, is run under the visionary leadership of Mrs. Surekha Bhosale.