Software Engineering - Third Module

Software Engineering - Third Module

Here is Software Engineering - Third Module (SQL) lecture . Below Attachement contain

- Slides for Software Engineering

Click Here to Download

Software Engineering - Second Module

Software Engineering - Second Module

Here is Software Engineering - Second Module (SVVT) lecture . Below Attachement contain

- Slides for Software Engineering

Click Here to Download

Software Engineering - First Module Slides

Software Engineering - First Module

Here is Software Engineering - First Moule lecture . Below Attachement contain

- Slides for Software Engineering

Click Here to Download

Linux All Presentation

Linux All Presentation

Here is Linux lecture by sir noman qadir. Below Attachement contain

- Slides for Linux and
- Different Detail of Linux

Click Here to Download

PHP Class Lectures

PHP Class Lectures

Here is PHP lecture by sir noman qadir. Below Attachement contain

- Sign and Login in PHP with MySQL Connection,

- Image Upload,

- Session

- and Image Comment like Fb.

Click Here to Download

PHP MYSQL Connection

PHP MYSQL Connection

Before you can get content out of your MySQL database, you must know how to establish a connection to MySQL from inside a PHP script. To perform basic queries from within MySQL is very easy. This article will show you how to get up and running.

Let's get started. The first thing to do is connect to the database.The function to connect to MySQL is called mysql_connect. This function returns a resource which is a pointer to the database connection. It's also called a database handle, and we'll use it in later functions. Don't forget to replace your connection details.

<?php $username = "your_name"; $password = "your_password"; $hostname = "localhost"; //connection to the database $dbhandle = mysql_connect($hostname, $username, $password)   or die("Unable to connect to MySQL"); echo "Connected to MySQL<br>"; ?>

All going well, you should see "Connected to MySQL" when you run this script. If you can't connect to the server, make sure your password, username and hostname are correct.

Once you've connected, you're going to want to select a database to work with. Let's assume the database is called 'examples'. To start working in this database, you'll need the mysql_select_db() function:

<?php //select a database to work with $selected = mysql_select_db("examples",$dbhandle)   or die("Could not select examples"); ?>

Now that you're connected, let's try and run some queries. The function used to perform queries is named - mysql_query(). The function returns a resource that contains the results of the query, called the result set. To examine the result we're going to use the mysql_fetch_array function, which returns the results row by row. In the case of a query that doesn't return results, the resource that the function returns is simply a value true or false.

CREATE DATABASE `examples`;
USE `examples`;
CREATE TABLE `cars` (
   `id` int UNIQUE NOT NULL,
   `name` varchar(40),
   `year` varchar(50),
   PRIMARY KEY(id)
);
INSERT INTO cars VALUES(1,'Mercedes','2000');
INSERT INTO cars VALUES(2,'BMW','2004');
INSERT INTO cars VALUES(3,'Audi','2001');

Installation of PHP

Installation of PHP

PHP is a programming language that can do all sorts of things: evaluate form data sent from a browser, build custom web content to serve the browser, talk to a database, and even send and receive cookies..

For Install PHP, You should have 4 softwares: Windows, Apache, MySQL, PHP or 1 software combination of this name WAMP.. 

So wamp link for download is HERE

If you have also VS installed in your PC then you have to change port for WAMP server to run for this follow this LINK

At first run PHP myadmin panel password is blank and username is 'root'

Introduction to PHP

Introduction to PHP

PHP is a programming language that can do all sorts of things: evaluate form data sent from a browser, build custom web content to serve the browser, talk to a database, and even send and receive cookies..

Why Learn PHP?

"So what?" You might say. "I can do that with JavaScript." And that's true! But JavaScript's knowledge can be limited.

JavaScript generally runs in the browser, orclient. This means it only really knows what's going on in your browser, plus whatever information it gets from the website(s) you're connecting to.

PHP, on the other hand, runs on the same computer as the website you're visiting, which is known as the server. This means that it has access to all the information and files on that machine, which allows it to construct custom HTML pages to send to your browser, handle cookies, and run tasks or perform calculations with data from that website.

PHP and HTML

PHP code can be written right into your HTML, like this:

<body>
  <p>

    <?php
      echo "I'm learning PHP!";
    ?>

  </p>
</body>

Your PHP code goes inside the <?php and ?> delimiters. Here we use the function echoto output I'm learning PHP!. We also end the line with a semicolon.

PHP Files

You might have noticed that our main file is now index.php instead of index.html. This is important! It tells the PHP interpreter that there's PHP code in the file to evaluate.

Echo

The echo function outputs strings. If you type

<?php
  echo "Hello!";
?>

PHP will output Hello!.

Make sure to end your line of PHP code with a semicolon.

Strings

A string is a word or phrase between quotes, like so: "Hello, world!"

You can type a string all at once, like this:

<?php
  echo "Hello, world!";
?>

Or use the concatenation operator, which glues several strings together:

<?php
   echo "Hello," . " " . "world" . "!";
?>

The concatenation operator is just a dot (.). (If you're coming to PHP from JavaScript, the dot does the same thing for strings that +does in JavaScript.)

Variables

So far we've been outputting strings and doing math.

To do more complex coding, we need a way to "save" these values. We can do this usingvariables. A variable can store a string or a number, and gives it a specific case-senstive name.

Examples:

• $myName = "Beyonce";
• $myAge = 32;

All variable names in PHP start with a dollar sign ( $ ).

Semicolons

You've probably noticed that our lines of PHP code end in semicolons (;). PHP requires semicolons at the end of eachstatement, which is the shortest unit of standalone code. (For example, echo"Hello!"; or 2 + 2;)

You can think of a statement is a complete PHP thought. 19 + or echo aren't complete thoughts, so you wouldn't put semicolons at the end of them!

<?php echo "Use your semicolons!"; ?>

Comments

Just like we sometimes put comments in our CSS (using /* this syntax */) or in our HTML (using <!-- this syntax -->), we can also put comments in our PHP code! We do that using two forward slashes (//), like so:

<?php
    echo "I get printed!";
    // I don't! I'm a comment.
?>

Reference : Click Here