PHP MySQL and Laravel course in Rawalpindi Islamabad

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

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    |     0321-9102942