Book a Free Demo / Get Full Program Details

PHP And MySQL

MySQL™ and PHP are two of the most popular open source technologies to emerge over the past two decades. PHP is a powerful scripting language for writing server-side Web applications. MySQL is an open-source relational database management system that uses Structured Query Language (SQL). Together, these two technologies provide you with a powerful platform for building database-driven Web applications and websites.

If you want to build a career as a PHP & MySQL developer, you need to enroll for a PHP and MySQL course/classes.

For pursuing such a course forPHP and MySQL training , look no further than Hrishi Computer Education . We are one of the top institutes in Mumbai north (Vasai, Virar, Palghar) region offering courses in all popular programming languages.

During this course, students will be provided hands-on training on how to build an entire dynamic website, thus ensuring that they have the necessary experience, skills and confidence to build dynamic websites later on. Students will also learn how to write commands in SQL to query and modify the MySQL database. Other topics include gathering and processing information from forms, 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.