PHP with MySQL

Course Description

PHP scripting language and MySql database are the most popular open-source development tools used to build robust and scalable websites or internet/ intranet applications. PHP is a server-side scripting language and a powerful tool for building dynamic and interactive web pages. PHP is widely used, versatile runs faster and more efficiently. MySQL is an open-source database server designed based on a relational database management system (RDBMS) and handles large database connections. MySql is popular for its fast processing, reliability, flexibility and easy usage. 

A combination of PHP and MySql offers a wide range of web application development. Even non-technical candidates can also easily develop web applications with combo PHP script and Mysql database. There is always a demand for open source technologies like PHP, Mysql in the IT industry. Developers always need to get updated with the latest versions of the technologies to sustain in the IT job market.

Hachion PHP with MySql online tutorial curated by industry professionals from scratch. Php and Mysql course content covers all basic and advanced concepts. Beginners who want to develop web applications can easily learn the PHP with MySQL course to gain practical knowledge and hands-on experience with real-time projects. 

Course Fee : 250.7 USD

PHP with MySQL Learners from Hachion: 68
Course Schedule

Would you like to make your own schedule? Reschedule

Choose the best training mode which suits to your requirement
Live online training

USD 250.7

Training Fee: USD 313.3 20% Discount

  • Live interactive online training
  • Daily Assignments and Lab exercises
  • Resume and certification guidance
  • Mock interview and live project assistance
  • Resume marketing and job assistance
Mentoring mode training
  • Live interactive online training
  • Daily Assignments and Lab exercises
  • Resume and certification guidance
  • Mock interview and live project assistance
  • Resume marketing and job assistance
Live online training and internship
  • Live interactive online training
  • Daily Assignments and Lab exercises
  • Resume and certification guidance
  • Mock interview and live project assistance
  • Resume marketing and job assistance

Course Content

  • Introduction To PHP 

  • History of PHP

  • Comparison with dynamic content alternatives (Perl, CGI, ASP, JSP, Servlets, CGI, etc)

  • PHP tools and set up (web browser/server, editor, libraries, etc)

  • Create a basic PHP Script

  • Opening and Closing tags

  • PHP as a command line or batch language

  • Taking user input (HTML forms)

  • Self Referring Forms

  • Selecting alternatives

  • Use PHP to generate HTTP headers

  • Generating HTTP redirects

  • Pass PHP variables via the URL

  • Debugging Tips

  • Where to find PHP documentation

  • Creating forms with PHP

  • Security Protection from Cross Site Scripting

  • Using the form GET method

  • Using the form POST method

  • Obtaining data from forms through variables$_REQUEST,$_POSTor$_GET?

  • Using hidden fields

  • Secure Web Forms (HTTPS and SSL)

  • Calling pages from themselves using forms

  • Quoting HTML entities in user input

  • Identifiers

  • Data Types (integers, floats, strings and booleans)

  • Type juggling

  • Text constants, interpolation (strings, arrays, objects, functions), here & now documents

  • Creating Variables

  • Variable assignment

  • Variable Scope

  • Namespaces

  • User-defined Constants

  • String constants,variable interpolation into strings

  • Array, Object&Function interpolation

  • HTTP environment variables

  • Magic ConstantsGLOBALSarray

  • Variable References

  • PHP Operators

  • Arithmetic Operators

  • Logical Operators

  • Relational (Comparison) Operators

  • The Identity Operator

  • The Assignment Operators

  • Increment & Decrement Operators

  • Bitwise Operators

  • Error Suppression Operator

  • The Conditional (Ternary) Operator

  • The Default Operator

  • Execution Operators

  • Other Operators

  • Assignment Operators

  • Operator Precedence and Associativity

  • True and Falseif

  • Comparing Strings and Numberselseandelseif

  • Hierarchical conditions (nestedifstatements)

  • The? :Operator

  • Comparing for equality or identity

  • The switch/case statement

  • Alternative Syntax for Control Structures

  • PHP Flow Control

  • Loopswhiledo

  • Thephp.inifile

  • Module Vs CGI Usageregister_globals

  • Control of error logging

  • Control of resource limits

  • Commonly set configurations

  • File system securitysafe_mode and open_basedir

  • PHP4 compatibility in PHP5

  • A glance at upcoming PHP6

  • PHP Functions

  • Purpose of functions

  • Built-in functions

  • Declaring functions

  • Functions Arguments

  • Default Arguments

  • Arguments - Call by Reference

  • Return

  • Returning References

  • Variable Scope (global vs local)

  • Static variables

  • Recursion include and require

  • What are arrays?

  • How and when to use arrays

  • Indexing arrays, numeric and hashes

  • Initialising arrays

  • Using foreach

  • Add/remove elements from arrays

  • One-dimensional arrays

  • Multi-dimensional arrays

  • References to array elements

  • Arrays in forms

  • Array operators

  • Array related functions

  • Handling Databases With PHP

  • Error-handling Stratagies

  • Connection/disconnection to the database, log in/log out

  • Escaping strings in SQL statements

  • Including common access functions

  • Doing simple SQL queries via PHP

  • Building HTML tables using SQL Queries

  • Avoiding SQL Injection attacks

  • Access to: MySql, MySqli, Oracle and MS-SQL

  • Using PEAR DB

  • Using PHP Data Objects - PDO

  • An Insight to Smart Programming

  • Substring and [] operators

  • Case conversion, trimming

  • Formatting output data withsprintf

  • Adding & removing backslashes

  • Regular expressions

  • Metacharacters: character classes,repetitions

  • Regular Expression Examples

  • Alternation and Grouping

  • What is a session?

  • Dependencies on thephp.ini file

  • Understanding PHP session variables

  • Create a PHP session variable

  • Register and modify PHP session variables

  • Putting PHP session IDs in pages

  • Good Practise with sessions and PHP

  • Cookie properties

  • Setting a cookie in PHP

  • Retrieving PHP cookies

  • Expiring/Deleting PHP cookies

  • Drawbacks to cookies

  • Using cookies well

  • Testing for cookie support

  • Sessions without cookies

  • Cookie Security Issues

  • Opening files, local and remote

  • Reading & writing and moving about in filesfflush(),file(),fpassthru(),readfile()

  • PHP portability on different Operating Systems

  • Finding file metadata: size, ownership, modification time

  • Handling file permissions

  • Handling file ownership

  • Copying, Renaming and Deleting Files

  • File locking

  • Opening and reading directories

  • File uploads from the browser/user

  • Other I/O Issues In PHP

  • Getting IP addresses from visitors

  • Getting referring URLs from visitors

  • Environment variables

  • Showing different content to different browsers (IE, Netscape, Firefox, Mozilla, Opera, etc)

  • Handling HTTP and MIME headers

  • Object basics

  • Classes in PHP

  • PHP4 - constructors

  • PHP5 - constructors and destructors

  • Inheritance

  • Accessing instance data and functions__sleepand__wakeup__autoload

  • Class constants

  • PHP5 OO Additions,type hints,foreach,__autoload

  • PHP 5.4— instantiate & member access

  • Objects: Assignments and Referencestry,throwcatchexception handling

  • PECL quick tour

  • APC - Alternative PHP Cache

  • Xdebug - debugging and profiling

  • PEAR installation and quick tour

  • PEAR Config

  • PEAR Log

  • PEAR Auth (login)

  • PEAR HTML_QuickForm2

  • Smarty Templates

  • Smarty and HTML_QuickForm2

  • Smarty and QuickForm2 help with security

  • Handling Email With PHP

  • Sending email

  • Sending multi part email-MIME

  • Accessing mail boxes – IMAP and POP

  • Graphics basics,referencing a PHP scrip in an IMG tag

  • Image MIME type

  • Basic examples,line/box drawing

  • Creation from an existing image

  • Image copying and resizing

  • Drawing text on images

  • True Type fonts

  • Simple project-2 table database

  • Project skeleton

  • Configuration:test&live sites

  • Structure of web program

  • Smarty templates for the project

  • Structure of a Smarty template

  • Example Smarty template

  • Firefox Add-ons:Web Developer,Firebug,YSlow

  • Using rsync to copy test to live

  • Putting It All Together-Database

  • The database behind the application

  • Designing the database

  • Metadata management

  • Entity-relationship (ER) diagrams

  • ER Diagram example

  • Data Modelling tools

  • Users to access the database

  • Creating the databases and tables

  • Creating test data

  • Displaying data from the database

  • Outline of data display function

  • Example list display function

  • Displaying a list with Smarty

  • More succinct use of SQL

  • QLWHEREclauses

  • Combine tests in a WHERE clause

  • SQL:grouping and Ordering of results


  • Displaying long lists in pages withLIMIT

  • Showing lists a page at a time

  • Implementing pages in Smarty Templates

  • Making Smarty and SQL play well

  • Choosing items from a list

  • Big picture

  • Multiple items chosen at once

  • One item only to be chosen

  • One item with selectaction onChange:auto submit the form

  • Greying out options

  • Searching in a list

  • What to do with something chosen

  • Creating & editing data

  • Creating & editing are much the same

  • Use the same names everywhere

  • outline use of a HTML_QuickForm2form

  • Adding fields to the form

  • Field validation

  • Validation types

  • Smarty Template withHTML_QuickForm2

  • Form validation and processing

  • Display of validation errors

  • Other issues

  • Version control

  • Audit trail

  • security and access control

  • Performance

  • Styling and accessibility

PHP with MySQL Training FAQs


Hachion's PHP with MySQL training program covers from basic to advanced concepts in PHP. Our course curriculum is designed by industry experts in IT industry. We provide 100% job assistance with certification guidance

We provide 100% job assistance to the Hachion students, once they complete the course. We also provide resume writing, mock interviews, and resume marketing services as part of our job assistance program.

We offer three modes of training in PHP with the MySQL Online Training Program.

  • Self Placed
  • Mentorship
  • Instructor-Led

There are no prerequisites to join this course.

The average salary for a PHP Developer is $88,106 per year in the United States.

Related Courses

You can start working with
one of my associated companies in IT Industry