PHP MySQL and Laravel

PHP MySQL and Laravel Course Fees

Fee (on lumpsum): PKR. 30,000/-
Fee (in installments): PKR. 36,000/-
Duration: 3 Month
Installments: 3
Class Per Week: 5
Weekend Course: Not Available
Starting Date: 22-Apr-2024

PHP MySQL and Laravel Class Timing

Morning Classes
  • 9:00 to 10:00
  • 10:00 to 11:00
  • 11:00 to 12:00
  • 12:00 to 01:00
Evening Classes
  • 02:00 to 03:00
  • 03:00 to 04:00
  • 04:00 to 05:00
  • 05:00 to 06:00
  • 06:00 to 07:00

↑ Top

Teacher Profile

best computer institute in rawalpindi. Sir Ishtiaq A. Khan

With 19 years of working experience along with 16years 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. His students are serving in different Govt. and Private sector organizations around the globe. Many of his students are currently running their own software houses and computer institutes in Rawalpindi, Islamabad, Peshawar, Swat, Lahore and other major cities of Pakistan and Afghanistan.

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
  • Punjab College
  • and many others
There are other teachers in the faculty. Teacher may be other then Ishtiaq A. Khan

PHP MySQL and Laravel course in Islamabad Pakistan

Apply Online Teacher Profile More Courses...

The best computer institute in Rawalpindi Islamabad Pakistan to start learning PHP. This PHP MySQL Laravel course is specially designed for those who have good understanding of Front end web designing. As we all know that freelancing is the best way to start earning while studying in university or doing some other job. This freelancing related php 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 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

Best Computer Courses for freelancing in Rawalpindi Pakistan 2024

AutoCAD at masia the best computer institute in islamabad rawalpindi
AutoCAD is a comprehensive introduction to creating 2D and 3D drawings. The course focuses on basic drafting techniques and is structured to suit users across a broad range of industries specially Civil Engineering. You can also get freelancing jobs with AutoCAD
Full Stack Web Developer at masia the best computer institute in islamabad rawalpindi
Internship based training of web development. The goal of this full stack web developer course is to give you all required skills and make you able to start your web development career in 6 months.
Graphics Designing  at masia the best computer institute in islamabad rawalpindi
Graphics Designing with Digital Marketing is the best course to start your freelancing career in Rawalpindi Islamabad & earn from home. We focus on both, printing press & freelancing
Adobe Photoshop at masia the best computer institute in islamabad rawalpindi
The best and easy photoshop course for new freelancers. Adobe Photoshop is a photo editing tool. You can fix photos, give effects and enhance lighting etc
Python at masia the best computer institute in islamabad rawalpindi
Python is a high level, interpreted and general purpose language. Because of its simple and easy to use syntax its the best choice for new comers to programming field.
Six Months Courses at masia the best computer institute in islamabad rawalpindi
Get two certificates. One certificate will be awarded for course completion and another for doing internship. Wait no more to start learning today and become a professional in 6 months
Web Designing Front End at masia the best computer institute in islamabad rawalpindi
Best for starting online earning in web designing. Leading to UI/UX designing. This computer course includes HTML 5, CSS 3, JavaScript, Bootstrap, jQuery & SEO techniques in Rawalpindi Islamabad Pakistan
C Sharp Visual Programming at masia the best computer institute in islamabad rawalpindi
Specially designed for university students in Pakistan. C Sharp is widely used for desktop application development as well as web development. You will also learn basic SQL Server for our database need during the course. C# is an object-oriented programming language from Microsoft and ECMA that is based on C++ with elements from Visual Basic and Java.
ASP.NET at masia the best computer institute in islamabad rawalpindi
ASP.NET is used to develop websites on dot net frame work. You will also learn basic SQL Server for our database need during the course. C# is an object-oriented programming language from Microsoft and ECMA that is based on C++ with elements from Visual Basic and Java.
Laravel Framework at masia the best computer institute in islamabad rawalpindi
Get Freelancing job with this Laravel course. Laravel is best PHP framework for web development and web applications following the model–view–controller architectural pattern and based on Symfony. Laravel at MASIA Institute is a training designed for PHP programmers.
Adobe Illustrator at masia the best computer institute in islamabad rawalpindi
Adobe Illustrator is a program used by artists & graphics designer to create vector art. This course covers logos banners brochures social media & printing press
Certificate in IT at masia the best computer institute in islamabad rawalpindi
Best computer institute in rawalpindi for 6 months course. This course is specially designed for non IT professionals and beginners. You will be learning complete Office Automation + Graphics Designing + Programming Fundamentals all in one course.
C plus plus at masia the best computer institute in islamabad rawalpindi
C plus plus is the starting course for Software Development and Software Engineering. This course is specially designed for University and College students.
Basic IT | MS Office at masia the best computer institute in islamabad rawalpindi
Microsoft Office is the best for beginners in computer science. You can also do freelance work and data entry jobs after this course. From writing letters, applications and memos to advance level of techniques in Microsoft Excel for accounting and graphs.
Corel Draw at masia the best computer institute in islamabad rawalpindi
Corel Draw is a vector graphics application. Its mostly used for printing and publishing purpose. You can create calendars visiting cards books leaflets brochures
Java Programming at masia the best computer institute in islamabad rawalpindi
JAVA course is designed for students who are interested in learning the hottest programming language. This course is leading to Android Apps Development
Android Apps at masia the best computer institute in islamabad rawalpindi
Android apps development is a fastest growing field of programming. If you have working knowledge of basic Java programming, you can start learning Android.
PHP MySQL and Laravel at masia the best computer institute in islamabad rawalpindi
MASIA Institute is now combining PHP MySQL & Laravel in one course. Its the best to start freelancing in web development in Rawalpindi Islamabad