PHP MYSQL images

harkly

I have a DB working where imgs are stored in the DB and I do not want that but can't get it to work with the filename. The code is in 2 different files..

My first one - -

<?php
header("Content-type: image/jpeg");
$prodid = $_GET['id'];
$con = mysql_connect("localhost", "test", "test") or die('');
mysql_select_db("store", $con);
$query = "SELECT image from products WHERE prodid = $prodid";
$result = mysql_query($query);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$picture = $row['prodid'];
echo $picture;
?>

2nd one - -

while($row=mysql_fetch_array($result, MYSQL_ASSOC))
{
$prodid = $row['prodid'];
$description = $row['description'];
$image = $row['pic'];
echo "<tr><td>$prodid</td><td>$description</t...
echo "<td><img src=\"showimage.php?id=$prodid\" width=\"80\" height=\"60\"></td></tr>\n";
echo "<td><img src=\"images/'$pic'\" width=\"80\" height=\"60\"></td></tr>\n";
}

The 1st img src worked fine and I modified the file for the 2nd one but it will not display.

I also tried these 2 -

echo "<img src=\"images/" . $pic . "\">" ;

printf ("<img src=\"images/%s\">", $pic );

I am just starting coding and am at a loss.

HalfaBee

Your problem is here

$picture = $row['prodid'];
echo $picture;

You will also have to use stripslashes() to remove escaped characters.

harkly

Didn't work. Here's the full code of my second file, could it be something in there?

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<title>Image Test</title>

<?php
include("mylibrary/login.php");
login();$query = "SELECT prodid, description, image FROM products";
$result = mysql_query($query) or die(mysql_error());echo "<table width=\"50%\" cellpadding=\"1\" border=\"1\">\n";
echo "<tr><td>Product ID</td><td>Description</td><td>Image</td><td>Image 2</td></tr>\n";
while($row=mysql_fetch_array($result, MYSQL_ASSOC))
{
$prodid = $row['prodid'];
$description = $row['description'];
$picture = $row['prodid'];
echo "<tr><td>$prodid</td><td>$description</td>\n";

echo "<td><img src=\"$picture\" width=\"80\" height=\"60\"></td></tr>\n";

}
echo "</table>\n";
?>

bradgrafelman

For the first file, the one that retrieves the image data from MySQL and outputs it, you're trying to echo $row['prodid'], which doesn't exist - you don't SELECT the 'prodid' column, nor should you; the column you want to print is the one containing the image data (presumably image, the one you already SELECT'ed in that query).

HalfaBee

Geeze, teach him to fish, don't spoon feed him. 😉

bradgrafelman

Eh? Who's been spoonfeeding? 😕