Apply Online

PHP MySQL Course Details

Fee Range:
PKR. 16,000/- to 18,000/-

6 Month(s)


Class Per Week:

Weekend Course:
Available on Saturday Sunday

Starting Date:

PHP MySQL Class Timing

Classes 4 / 5 Days a week

Morning Classes
  • 8:00 to 9:00
  • 9:00 to 10:00
  • 10:00 to 11:00
  • 11:00 to 12:00
  • 12:00 to 1:00
Evening Classes
  • 2:00 to 3:00
  • 3:00 to 4:00
  • 4:00 to 5:00
  • 5:00 to 6:00
  • 6:00 to 7:00

Teacher Profile

With 15 years of working experience along with 11years of teaching experience, Sir Ishtiaq Ahmad Khan has trained 1000s of students since 2007. Sir Ishtiaq Ahmad Khan is leading our team of graphics designers and web developers.

Sir Ishtiaq had provided training workshops in different Govt. and private sector organizations. Some of these organizations are:

  • UNHCR Islamabad
  • University of Peshawar
  • IBMS, Agricultural University Peshawar
  • and many others
There are other teachers in the faculty. Teacher may be other then Sir Ishtiaq Ahmad Khan

PHP MySQL course in Rawalpindi Pakistan

Teacher Profile More Courses...

Web designing and php programming is a fast growing field in Rawalpindi and Islamabad. More technologies are introduced rapidly and we need to keep ourselves up-to-date to compete with others in the market.
We at MASIA Insitute offer you guaranteed expert level training in website designing, development, php and laravel. You will become a professional full stack web developer in the given duration and will be able to freelance or join any software house as a web developer.

This web development course is specially designed for University students in Pakistan. Most of university students are worried about their final year project as well as their career selection. This course is the best start of your career. Your first university project is the most important thing in your practical life. If you do it in a right way, you open doors to the right path.

PHP MySQL Course Contents / Syllabus

The key elements of this course are:

  1. Javascript
  2. JSON
  3. Vue.js basic programming
  4. Object Oriented Programming in PHP
  5. Laravel

PHP Core Programming

  • History of PHP
  • Comparison with dynamic content alternatives (Perl, CGI, ASP, JSP, Servlets , CGI, etc)
  • Tools and set up (web browser/server, editor, libraries, etc)
  • Create a basic PHP Script
  • Opening and Closing tags

Getting user input in PHP 

  • Self-Referring Forms
  • Selecting alternatives
  • Generate HTTP headers
  • Generating HTTP redirects
  • Pass variables via the URL
  • Debugging Tips
  • Where to find documentation
  • Taking User Input from Forms
  • 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, $_POST or $_GET
  • Using hidden fields
  • Calling pages from themselves using forms
  • Quoting HTML entities in user input

Variables and Expressions

  • Identifiers
  • Data Types (integers, floats, strings and booleans)
  • Type juggling
  • Creating Variables
  • Variable assignment
  • Variable Scope
  • Namespaces
  • User-defined Constants
  • String constants, variable interpolation into strings
  • Array & Function interpolation
  • HTTP environment variables
  • Magic Constants GLOBALS array
  • Variable References

PHP Operators

  • Arithmetic Operators
  • Logical Operators
  • Relational (Comparison) Operators
  • The Identity Operator
  • The Assignment Operators
  • Increment & Decrement Operators
  • Error Suppression Operator
  • The Conditional (Ternary) Operator
  • The Default Operator
  • Execution Operators
  • Other Operators
  • Assignment Operators
  • Operator Precedence and Associativity

Conditional Tests and Events in PHP

  • True and False if
  • Comparing Strings and Numbers else and elseif
  • Hierarchical conditions (nested if statements)
  • The ? : Operator
  • Comparing for equality or identity
  • The switch / case statement
  • Alternative Syntax for Control Structures

PHP Flow Control

  • Loops while do ... while for break and continue goto exit

Advance Configuration of Web Server

  • The language level settings in php.ini file
  • Database Server configuration file my.ini
  • Web Server settings using httpd.conf

User Defined Functions in PHP

  • 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
  • Variable function calls

Storing Data in Arrays 

  • What are arrays?
  • How and when to use arrays
  • Indexing arrays, numeric and hashes
  • Initializing 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

MySQL and phpMyAdmin

  • The MySQL Console
  • Working through phpMyAdmin
  • Structured Query Language
  • SQL Clauses
  • Selecting data from multiple tables using SQL INNER Joins
  • Different Calculations in SQL Queries
  • Database Backup and Restore
  • Duplicating / Renaming and other Database operations
  • Customizing phpMyAdmin configuration files

Handling Databases with PHP

  • Different database APIs
  • Error-handling strategies
  • CRUD operations
  • Connection/disconnection to the database, log in/log out
  • Escaping strings in SQL statements
  • Including common access functions
  • Executing simple SQL queries 
  • Building HTML tables using SQL Queries
  • Avoiding SQL Injection attacks
  • An Insight to Smart Programming

String Manipulation in PHP

  1. Substring and operators
  2. Case conversion, trimming
  3. Adding & removing backslashes
  4. String functions

Sessions and Cookies in PHP

  • What is a session?
  • Understanding the session variables
  • Create a session variable
  • Register and modify session variables
  • Putting session IDs in pages
  • Good Practice with sessions and PHP
  • Cookie properties
  • Setting a cookie in PHP
  • Retrieving cookies
  • Expiring/Deleting cookies
  • Drawbacks to cookies
  • Using cookies well
  • Testing for cookie support
  • Sessions without cookies
  • Cookie Security Issues

File and Directory Access Using PHP

  1. Opening files, local and remote
  2. Reading & writing
  3. Finding file metadata: size, ownership, modification time
  4. Handling file permissions
  5. Handling file ownership
  6. Copying, Renaming and Deleting Files
  7. File locking
  8. Opening and reading directories
  9. 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)

Sending Email 

  • Sending simple text email
  • Sending multi part email - MIME

Project Planning in PHP MySQL

  • How to plan and start your project
  • Tips for good programming practice
  • How to complete you project decently
  • Deployment

Projects in PHP 

  • Any University Students Projects developed in PHP
  • Professional File Manager using File System (no database)
  • WordPress based website
  • Content Management System
    • Complete CMS using core 
    • Responsive Website Design (RWD)
    • Custom Fonts
    • Pages (add / edit / delete / suspend)
    • Sub Pages (add / edit / delete / suspend / move)
    • Image Galleries (add / edit / delete / suspend)
    • News (add / edit / delete / suspend)
    • Staff (add / edit / delete / suspend)
    • Feedback form (send email)
    • Pagination
    • Search System
    • SQL Injection protection
    • And more . . .
  • Shopping Cart

cPanel and Uploading

  • Basic working of cPanel
  • Uploading Website
  • Creating Email IDs
  • Checking website metrics


Method of Delivery

  • Lecture = 25%
  • Computer Lab = 75%

Award Criteria

Students will be awarded certificate from MASIA soft, if fulfill the following minimum requirements:

  • Attendance in Web Development Class = 75%
  • Marks in Website Development Project = 80%

Grading System

Students Grades are calculated from assignments, classwork and the final project.

Appeal Process

If not satisfied with the obtained marks you can write to

Internship opportunity for university students.

for details call:  0314-5110085    |     0321-9102942