Listing images stored in Mysql with PHP

[jchapa]

Hello to all,

Well I have my images stored in a MySQL database. I want to list all images stored in the database. I know how to display one, however, I cannot find anything on displaying a list of all my images also ability to display in different sizes.

Any feedback is appreciated.

jchapa

[jchapa]

Originally posted by jchapa
Hello to all,

Well I have my images stored in a MySQL database. I want to list all images stored in the database. I know how to display one, however, I cannot find anything on displaying a list of all my images also ability to display in different sizes.

Any feedback is appreciated.

jchapa

Well I figured it out. To display an image stored in MySQL as a BLOB along with other fields insert text in blue :

// begin to show results set

echo "<table>\n";
echo " <tr>\n";
echo " <td>Pid</td>\n";
echo " <td>Name</td>\n";
echo " <td>DOB</td>\n";
echo " <td>Race</td>\n";
echo " <td> </td>\n";
echo " </tr>\n";

for ($i = 0; $i < $rows; $i++) {
$data = mysql_fetch_object($results);
// since our script is very small, i'm not going to escape out to html mode here
echo " <tr>\n";

echo "  <td>$data->PID</td>\n";
echo "  <td>$data->name</td>\n";
echo "  <td>$data->dob</td>\n";
echo "  <td>$data->race</td>\n";

// echo " <td>" . stripslashes($data->description) . "</td>\n";
echo " <td><img src='getdata.php?userid=$data->PID'></td>\n";
echo " <td>( <a href='upoff.php?userid=$data->PID'>Criminal History</a> )</td>\n";
echo " </tr>\n";
}