PHP is a general-purpose programming language originally designed for web development. PHP code may be executed with a command line interface (CLI), embedded into HTML code, or used in combination with various web template systems, web content management systems, and web frameworks. PHP is an open source server-side scripting language used for building dynamic websites. It stands for Personal Homepage. Its uses can be highly seen in websites with online forms, which needs interaction with servers. PHP can be embedded into HTML and can also be attached as an external script file to a webpage.

PHP/MySQL Development Training
PHP/MySQL Development Training

SQL is used with multi-user access, as open-source software and as commercial paid editions. Data definition, terminology and concepts, definition of data with SQL, data manipulation with SQL, advanced data manipulation, import, export, and transactions are covered with the syllabus of MySQL Course in Bangalore. Programming and programming support are the two divisions in which we see the learners. Students with interest over programming are advised with the latest programming courses and students with interest over non-programming are advised for database courses, automation courses, networking courses and designing courses.

We have a team of MySQL trainers and participants for their future help and assistance in subject. Our training will be focused on assisting in placements as well. We help our students in all possible ways to get the right industry knowledge to our students for getting a job of their interest.


Technologies:

  • HTML5 Basics
  • CSS
  • Javascripts
  • PHP
  • MySQL

Course Duration

6 months

Qualification

BCA, MCA, B.Sc, M.Sc, Diploma, B.E, B.Tech, M.Tech, and Equivalent


Career support

100% Job Guarantee

Job: In-house (TechManyata) or Client location or Placement in other IT company


Environment

Learn as an employee on real-time projects

Timing

Full Time: 8 hrs / 5 Days or Weekend


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 else if statements
  • Logical operators
  • Switch statements
Control Structures: Loops
  • While loops
  • For loops
  • For each 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
  • Unsettling 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 behavior
  • 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
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 PHP Mailer

Data Definition using SQL

  • Databases
  • Data Types
  • Tables
  • Constraints and Indexes
  • Views

Basic Data Manipulation using SQL

  • Recurring SQL Constructs
  • Adding data
  • Modifying data
  • Removing data
  • Searching data

Advanced Data Manipulation using SQL

  • Expressions
  • Grouping and Aggregate Functions
  • Joining Tables

Transactions

  • Transaction Concepts
  • SQL for working with Transaction

Import/Export

  • Tools for Import/Export
  • SQL for Import/Export