Getting Data from MYSQL DB displayed on my page in PHP

The first small project I created to start my site was to be successful in connecting to the database and then displaying the information in php

Step 1- Create a variable the will hold the $_GET variable that will come in from the url.

$pdisplayed = $_GET[‘pid’];

Step 2 - Connect to your database:

$db_connection = mysql_connect('localhost', 'root', '');
if (!$db_connection) {
die('Opps Problem ' . mysql_error());
}

Step 3 – Create the query – you can create the query and store them in variables.

$sqlquery = ‘SELECT id, name, description FROM mysite.product where id = $pdisplayed';

Step 4 - Run the query through the mysql_query() function.

$result = mysql_query($sqlquery);

Step 5 – Now choose with fetch function you will use.

while ($row = mysql_fetch_assoc($result)) {
printf("ID: %s Name: %s", $row[id], $row[name]);
}

or

while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
printf("ID: %s Name: %s", $row[0], $row[1]);
}

or

$row = mysql_fetch_row($result);





The best one to use is the mysql_fetch_assoc

And that should now show you data from the database from the url of the page.

EXAMPLE: www.mysite.com/index.php?pid=2

That 2 would be element two in the databalse.