PHP MySQL and Laravel course in Islamabad Pakistan

Apply Online Teacher Profile More Courses...

Male Female

Our PHP MySQL Laravel course is meticulously crafted for individuals with a strong foundation in front-end web design, offering a seamless transition into the world of back-end development. But what sets MASIA Institute apart isn't just its exceptional curriculum—it's the unparalleled mentorship provided by industry veteran Sir Ishtiaq Ahmad Khan.

Why Choose MASIA Institute for Your PHP Journey?

MASIA Institute is renowned for its commitment to excellence in education and its dedication to shaping the next generation of web developers. Our PHP MySQL Laravel course is tailored to meet the demands of today's dynamic job market, equipping students with the skills and knowledge needed to succeed in the field of web development. With a focus on hands-on learning and real-world applications, MASIA Institute ensures that students graduate with the confidence and expertise to tackle any challenge that comes their way.

Unlocking Opportunities Through Freelancing

Freelancing has become increasingly popular as a means of earning income while pursuing education or other professional endeavors. MASIA Institute recognizes the importance of freelancing as a stepping stone to success, which is why our PHP web development course is specifically designed to prepare students for the world of freelancing. With practical assignments and real-world projects, students gain invaluable experience that sets them apart in the competitive freelance market.

Empowering University Students for Success

University students often face uncertainty when it comes to their final year projects and career prospects. MASIA Institute aims to alleviate these concerns by providing students with the tools and support they need to excel. Our PHP MySQL Laravel course serves as a springboard for students' careers, offering them the opportunity to showcase their skills and creativity through their final year projects. With MASIA Institute's guidance, students can turn their university projects into gateways to success.

Recommendation: Sir Ishtiaq Ahmad Khan as Your Mentor

To further enhance your learning experience and accelerate your career growth, consider enlisting the mentorship of Sir Ishtiaq Ahmad Khan. With over 18 years of experience in the IT industry, Sir Ishtiaq Ahmad Khan brings a wealth of knowledge and expertise to the table. As a mentor, he can provide valuable insights and guidance that complement your education at MASIA Institute, helping you navigate the complexities of the industry and achieve your goals.

In conclusion, MASIA Institute offers a comprehensive PHP MySQL Laravel course that is tailored to meet the needs of aspiring web developers. With a focus on practical skills, freelancing opportunities, and personalized mentorship from Sir Ishtiaq Ahmad Khan, MASIA Institute provides students with the tools and support they need to succeed in today's competitive job market. Take the first step towards a fulfilling career in web development by enrolling in the PHP MySQL Laravel course at MASIA Institute and harnessing the guidance of Sir Ishtiaq Ahmad Khan as your mentor.

PHP MySQL Course Contents and Syllabus

The key elements of this freelancing course are:

1. Wamp Server Configuration

2. Core Programming in PHP

3. Object Oriented Programming in PHP

4. MySQL Database

5. Building a custom CMS

6. Building a custom Shopping Cart

7. Laravel Framework

8. Internship

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)
• 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

 

Laravel Course Contents / Syllabus

Introduction

• Installation of Laravel
• Composer
• Artisan
• Virtual Host
• Model View Controller

Laravel Fundamentals

• Model explained
• View explained
• Controllers explained
• Brief use of Artisan
• Encryption
• Session

Blade Template Engine

• Template engine basics
• Use of template with examples
• Variables, Loops, Conditional statements etc

Database - Laravel Migrations

• Creating Migrations
• Droping Migrations
• Migrating and Rollback

Environment configurations

• Adding columns to existing tables using migrations
• Inserting data
• Reading Data
• Updating Data
• Deleting Data
• Database – Eloquent / ORM

Project in Laravel

• Custom CMS in Laravel

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 complaint@masia.pk

Internship opportunity for university students.



for details call:  0314-5110085