Learn how to use PHP & MySQL from beginner level to advanced techniques which is taught by experienced working professionals. With our PHP & MySQL Training in Bangalore you’ll learn concepts in expert level with practical manner.
PHP is widely known as Best Web Specific language in industry. Our PHP Training syllabus covers best practices and project based training in Bangalore. Besant Technologies is always supports open source languages much more compared to other premium languages.
PHP is a general purpose scripting language which originally developed from C, C++ by Rasmus Ledorf in the year of 1994. From initial public release PHP gained rapid market value because of its simple and easy to use approach. In PHP 5.0 it started to support OOP. So, its market share keeps increasing in these years.
Our way of PHP Training in Bangalore is fully concentration on practical oriented training with live projects. Every topic is covered with perfect examples and exercises. We cover MySQL as primary supporting RDBMS in this course. Because of PHP + MySQL combination there are several live examples are available in this industry.
Our project is focused on creating a complete Content Management System using PHP and MySQL from scratch.
Course Name | PHP MySQL |
Category | Scripting Language & Web Development |
Venue | Besant Technologies |
Official URL | PHP MySQL Training |
Demo Classes | At Your Convenience |
Training Methodology | 10% Theory & 90% Practical |
Course Duration | 30-40 Hours |
Class Availability | Weekdays & Weekends |
For Demo Class | Email ID – besanttech@gmail.com |
PHP & MySQL Course Syllabus
Introduction of Web & PHP
- What is PHP?
- The history of PHP
- Why choose PHP?
- Installation overview
First Steps
- Embedding PHP code on a page
- Outputting dynamic text
- The operational trail
- Inserting code comments
Exploring Data Types
- Variables
- Strings
- String functions
- Numbers part one: Integers
- Numbers part two: Floating points
- Arrays
- Associative arrays
- Array functions
- Booleans
- NULL and empty
- Type juggling and casting
- Constants
Control Structures: Logical Expressions
- If statements
- Else and elseif statements
- Logical operators
- Switch statements
Control Structures: Loops
- While loops
- For loops
- Foreach loops
- Continue
- Break
- Understanding array pointers
User-Defined Functions
- Defining functions
- Function arguments
- Returning values from a function
- Multiple return values
- Scope and global variables
- Setting default argument values
Debugging
- Common problems
- Warnings and errors
- Debugging and troubleshooting
Building Web Pages with PHP
- Links and URLs
- Using GET values
- Encoding GET values
- Encoding for HTML
- Including and requiring files
- Modifying headers
- Page redirection
- Output buffering
Working with Forms and Form Data
- Building forms
- Detecting form submissions
- Single-page form processing
- Validating form values
- Problems with validation logic
- Displaying validation errors
- Custom validation functions
- Single-page form with validations
Working with Cookies and Sessions
- Working with cookies
- Setting cookie values
- Reading cookie values
- Unsetting cookie values
- Working with sessions
MySQL Basics
- MySQL introduction
- Creating a database
- Creating a database table
- CRUD in MySQL
- Populating a MySQL database
- Relational database tables
- Populating the relational table
Using PHP to Access MySQL
- Database APIs in PHP
- Connecting to MySQL with PHP
- Retrieving data from MySQL
- Working with retrieved data
- Creating records with PHP
- Updating and deleting records with PHP
- SQL injection
- Escaping strings for MySQL
- Introducing prepared statements
Building a Content Management System (CMS)
- Blueprinting the application
- Building the CMS database
- Establishing your work area
- Creating and styling the first page
- Making page assets reusable
- Connecting the application to the database
Using Site Navigation to Choose Content
- Adding pages to the navigation subjects
- Refactoring the navigation
- Selecting pages from the navigation
- Highlighting the current page
- Moving the navigation to a function
Application CRUD
- Finding a subject in the database
- Refactoring the page selection
- Creating a new subject form
- Processing form values and adding subjects
- Passing data in the session
- Validating form values
- Creating an edit subject form
- Using single-page submission
- Deleting a subject
- Cleaning up
- Assignment: Pages CRUD
- Assignment results: Pages CRUD
Building the Public Area
- The public appearance
- Using a context for conditional code
- Adding a default subject behaviour
- The public content area
- Protecting page visibility
Regulating Page Access
- User authentication overview
- Admin CRUD
- Encrypting passwords
- Salting passwords
- Adding password encryption to CMS
- New PHP password functions
- Creating a login system
- Checking for authorization
- Creating a logout page
Advanced PHP Techniques
- Using variable variables
- Applying more array functions
- Building dates and times: Epoch/Unix
- Formatting dates and times: Strings and SQL
- Setting server and request variables
- Establishing global and static variable scope
- Making a reference assignment
- Using references as function arguments
- Using references as function return values
Introduction to Object-Oriented Programming (OOP)
- Introducing the concept and basics of OOP
- Defining classes
- Defining class methods
- Instantiating a class
- Referencing an instance
- Defining class properties
OOP in Practice
- Understanding class inheritance
- Setting access modifiers
- Using setters and getters
- Working with the static modifier
- Reviewing the scope resolution operator
- Referencing the Parent class
- Using constructors and destructors
- Cloning objects
- Comparing objects
Working with Files and Directories
- File system basics
- Understanding file permissions
- Setting file permissions
- PHP permissions
- Accessing files
- Writing to files
- Deleting files
- Moving the file pointer
- Reading files
- Examining file details
- Working with directories
- Viewing directory content
Sending Emails
- Configuring PHP for email
- Sending email with mail()
- Using headers
- Reviewing SMTP
- Using PHPMailer
For PHP & MySQL Materials – Download Now
You can find the Latest PHP & MySQL Interview Questions