PHP & MySQL (Web Development) Tutorial in Urdu

Today’s world is of marketing and advertisements, Website is the cheapest and professional way of marketing of any business or product in all over the world. Therefore demand of web development increasing day by day. If you want to become a web developer, you should learn PHP (A web scripting language) and MySQL (a database used along with PHP). Unfortunately in Pakistan, many of internet users don’t understand English language clearly therefore they don’t get benefit from English Video tutrials and E-books written by professionals on web development and on PHP. So I decided to share a Complete tutorial of web development using PHP and MySQL in Urdu.

PHP and MySQL Urdu Tutorial

I will give a link of tutorial at the end of this post. First we explore the course content of this tutorial here. All lessons will be available in Urdu. So don’t worry about English skills.

Course Contents of PHP Tutorial in Urdu

Lesson #1 : Introduction to PHP and Web Development :

  • What is PHP ?
  • History of PHP
  • What is MySQL ?
  • Why we use PHP and MySQL for web application development ?
  • Its awesome working
  • Connectivity with databases
  • Built-in Libraries
  • Easy to Use
  • Free of Cost
  • Object Oriented approach in PHP (OOP in Urdu)
  • Sources availability
  • Supports¬†availability

Lesson #2 : Installations and Creating Environment for PHP

  • Server installation (Wamp or Xamp)
  • Editor Install (Notepad++ OR Dreamweaver)
  • How PHP server internally works?
  • Remove Conflicts from other Software like Skype or antiviruses.

Lesson #3 : Operators, Variables and Constants

  • Basic Syntax of PHP
  • Variables assigning and declaring
  • Operators (Logical, Arithmetic)
  • Constants

Lesson #4 : Protocols of PHP and their understanding

  • How PHP program run?
  • How PHP and client and server communicate with each other?
  • HTTP Protocols / HTTP Requests / Response

Lesson #5 : Super Global Arrays, Conditional Statements and Switch Statement

  • POST
  • GET
  • REQUEST
  • FILES
  • COOKIE
  • SESSIONS
  • Their switching flow
  • If else with examples, Switch statements with examples

Lesson #6 : Loops and String Functions

  • What are loops?
  • Type of loops (for, while, do-while, for-each)
  • breaking loops
  • String function in PHP and their use
  • Time and date functions and their use in web development apps

Lesson #7 : Functions and Arrays in PHP

  • What are functions?
  • How to create function in PHP ?
  • Scope of variable in function.
  • Arguments passing
  • Arrays introduction
  • Details and types of arrays in PHP and their construction explain with the help of programming examples
  • Functions of arrays and use of loops in arrays

Lesson #8 : Working with HTML forms in PHP (Form Validations and Sessions)

  • Creating ¬† forms
  • Elements of forms (Text area, radio buttons, check boxes etc)
  • Creating Registration Form
  • Regular Expressions (Form Validations using PHP)
  • Creating sessions and used in forms

Lesson #9 : Create a Complete Dynamic Website Layout using Include & Require Functions of PHP

  • Conversion of HTML website to dynamic PHP website
  • Use and difference of PHP include and require function

Lesson #10 : Creating Files and Upload Files using PHP

  • What are files?
  • Creating files
  • working with files
  • Read/Write files
  • Upload Files on server using HTML forms

Lesson #11 : MySQL Database and PHP

  • Intro to database
  • creating database in MySQL
  • CRUD operations (Create,Read,Update and Delete)
  • Sorting and searching in database MySQL in PHP interface
  • Intro to PHPmyAdmin

Lesson #12 : Pagination of MySQL records in PHP (Urdu)

  • Learn Pagination in Urdu
  • Setting pages limit
  • Show records of database on web pages with pagination
  • Searching records

Lesson #12 : Sending Emails using PHP

  • Setting email server (SMTP)
  • Use of mail function

Lesson #12 : Ajax and PHP

  • Relation of PHP and Ajax and their working
  • Examples and concepts of JavaScript

Lesson #13 : Graphics and PHP

  • Introduction of graphics
  • Colors
  • Coordinate System
  • Generate Images
  • Create new images
  • Color selections
  • Basic functions of drawing
  • Draw a pixel over image
  • Creating thumbnails
  • Creating Photo Gallery
  • Write text over image

These are all course out lines of PHP Urdu tutorial which start from very basic level and ends with advance PHP and MySQL project. Now You download this tutorial from below link in PDF.

Click here to Download Complete PHP Tutorial in Urdu

 

Need My Help to learn PHP ?

Dear readers, As you know I am also a web developer from last two years, I love to write PHP programs. Actually its my hobby. So If you need any type of help or want to solve any query. Please do not hesitate to ask here. I will answer your comments and try to solve them. Also I am recording a complete PHP tutorial in Urdu from basic to advance level including Object oriented programming. MVC frameworks will also included in that series of videos. I have not enough time to record these videos, but I try my best to release them very soon. Every time when I get free time I record a new tutorial so keep in touch because soon I will release complete video tutorial.

Read above e-book completely and do practice regularly. After reading Urdu e-book also read this english tutorial of PHP and MySQL Web development which is also available for free download below :

Download PHP 6 Tutorial  (Dynamic Web site Development)

  • Farhan

    Dear I want to design Admin Panel and I want to learn Admin Panel Script on PHP. Can you teach me ADMIN PANEL and EMAIL script PHP Language. My contact 0333-2748996 if you have CD / DVD or video file can you send me on my Email address.

    Regards,
    Muhammad Farhan Khan, Rajput
    f_exceltech@yahoo.com
    muhammadfarhan.rajput@gmail.com
    0333-2748996
    0345-3157481

    • Yes, Why not, Its very easy to create admin panel in PHP, I have dvd too, but soon I will upload video tutorial for free.

      • Dear mr Haris contact me as soon as possible
        Malik imran 0315-2881837

      • dear sir,, im loser in programing but i want to lern php soonr would you help me weither by sugasions or if you have a vidio lacturs then plz send me some info and sugation on my email address..
        zakir_khan83@yahoo.com
        03054377166
        ;;
        if you can help me im worrid about my future,,,
        bundul of thank…

        • Fashion Trends

          Don’t worry about programming and PHP. It looks difficult is start but when you understand the basics and real stretegu that how PHP works. You will feel confident to develop any website.
          Open YouTube and watch these Urdu Tutorials : https://www.youtube.com/playlist?list=PLYcfXSLWiiPBmN2RlJHORFvvOH0BE8RtA
          I will soon upload some more tutorials on YouTube.
          You can also watch Wali Khan Video Tutorials.
          Also I can teach physically or on Skype to students who are willing to learn web development and SEO.

  • dear sir i want to make a website on mvc patteren i want to make ecommerce website plz give me advice i am waitng for u good response.

  • Dear Bro, We are Waiting for Video Tutorial of Admin Panel, How to make Admin Panel of Website, Kindly Urgent…
    Thank you.

  • M.Hassan

    books download nai ho rahai , kia ap na remove kr di ha ?

    • No, It is working fine. Please click on the download link and then click on the download button which appear in next page. I tested, It is fine in my side.

  • link not found “Click here to Download Complete PHP Tutorial in Urdu” plz email me
    mustafahanif007@gmail.com

  • Asslam O Alikum Sir I Want To Learn All Tutorials.(http://superwebportal.com/php-mysql-web-development-tutorial-urdu/)…Sir Give Me Link Where I learn Complete website

  • faizan

    hi dear friends i am Faizan Ansari from Nepal , i have final year project of E-Learning but comes some problem in it i need your help dear i know urdu language properly, you can describe in urdu language and i need Mr . Haris Mughal urdu tutorials of php so please tell me to link of download,
    thanks
    skype : faizan9041
    email: faizanahmad364@gmail.com

    problem like this :

    Warning: session_start() [function.session-start]: Cannot send session cache limiter – headers already sent (output started at C:\AppServ\www\Original_lms\header_dashboard.php:11) in C:\AppServ\www\Original_lms\session.php on line 3

  • very good work

  • MashaAllah Haris bro

  • nice work keep it up Sir Haris Mughal

  • abdullah irfan

    ASSALAM O ALEKUM
    Sir haris i am the student of MCS . i want some help in study . like image mapping in html. please guide me if you can .

  • asim

    Aoa…… Can you send me software of dreamweaver 8 with html5 and css3 at email fasim527@yahoo.com. Can you provide me tutorials in Urdu of objects and classes in php.

  • Nabi Bux Bhatti

    Good work Bro

  • $value) {
    $value = cleanStr($value);
    if(empty($value)) {
    print “” .ucwords($key).” must not be empty please click the browswer back button and correct it.”;
    return false;
    }
    }
    return true;
    // }
    // calling function to check empty value
    if (!emptyFields($_POST)) {
    exit();
    }
    // check require skills and age
    function isEligible($skills, $age) {
    $age = intval ($age);
    if (count($skills) == 0) {
    print (“you dont have any skills”);
    return false;
    }
    if ($age 35) {
    print (” your age must be 23 and 35″);
    return false;
    }
    return true;
    }

    // assigning fields values to veriables
    $name = cleanStr($_POST[‘name’]);
    $phone = cleanStr($_POST[‘phone’]);
    $email = cleanStr($_POST[’email’]);
    $address = cleanStr($_POST[‘address’]);
    $gender = $_POST[‘gender’];
    $city = $_POST[‘city’];
    $age = (int) cleanStr($_POST[‘age’]);
    $skills = $_POST[‘skills’];
    // calling function to check
    // that the condidate is eligibla for the job

    if (!isEligible($skills, $age)) {
    exit();
    }
    // if eveery thing is ok
    print “thnku “.$name.”for your intrest in this job. we will contact you as soon as possible.”;
    print “we nreceive the follwing information about you”;
    // printing user submitted information
    print “your name”.$name.””;
    print “Phone”.$phone. “”;
    print “Email”.$email.””;
    print “Address”.$address.””;
    print “Gender”.$gender.””;
    print “City”.$city.””;
    print “Age”.$age.””;
    print “Your skills”.$skills.””;
    foreach($skills as $value) {
    print $value .”,”;
    }

    ?>
    it gives error like this
    ( ! ) Notice: Undefined variable: ar in C:\wamp\www\application.php on line 25
    and
    ( ! ) Warning: Invalid argument supplied for foreach() in C:\wamp\www\application.php on line 25
    please help me