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'