CODEWITHSUNDEEP
phpmysql
ElaGorilaki
ElaGorilaki

Reputation: 227

How can I open a link into a div that has data from mysql?

I am building a site that has a page where I display some products that I have on my database. The products are displayed by small divs that are next to each other. I have put inside each div a link that I want to have the information of each product. The information will all have the same structure. I thought about having an

<a href="'.$row[id].".php".'">

and have an id.php file for each of the products. But that doesn t seem to make sense.

Here it is a bit of my code

<?php
mysql_select_db("myshop",$con);
$result = mysql_query('SELECT * FROM products',$con);
while($row = mysql_fetch_array($result))
{
    $myimage = '<img src="'.$row['image'].'" />';

    echo  "<div id='appear'>" . $myimage . '<br />' . $row['title'] . 
"<br  />" . "<p style='color:red;' >" . "value " . $row['price'] . "€" . 
"</p>".  <a   href="'.$row[id].".php".'">. "details" . "<a>". 
</div>";                                       
}
mysql_close($con);
?>

Upvotes: 0

Views: 221

Answers (1)

HappyTimeGopher
HappyTimeGopher

Reputation: 1387

Create an image.php...

<?php

mysql_select_db("myshop",$con);
id = (int)$_GET['id'];

$result = mysql_query("SELECT * FROM products WHERE id=$id",$con);
print_r($result)

?>

And instead of this:

<a href="'.$row[id].".php".'">

Do this:

<a href="image.php?id='.$row[id].'">

Upvotes: 2

Related Questions