I really can't get the idea posted by mitok.. i need to retrieve and post the a picture on my website from my database... I save the path to the database
Heres how i save the path to the database
CODE
<?php
include("includes\connect.php");
require_once('includes\connect.php');
if(isset($_POST['add'])){
$sName=$_POST['sName'];
$category=$_POST['category'];
$description=$_POST['description'];
$price=$_POST['price'];
$quantity=$_POST['quantity'];
$picture=$_POST['picture'];
$status=$_POST['status'];
if(empty($sName)||empty($category)||empty($description)||empty($price)||empty($quantity)||empty($picture)){
$problem=true;
$errors="<li>empty field(s)</li><li>fill up!</li>";
}
if(!$problem){
//add comment sucessfully added
$errors="<li>software has been successfully added!</li><li>ready to add another one!</li>";
$query="Insert into products(sName,category,description,price,quantity,picture,status) values('$sName','$category','$description','$price','$quantity','$picture','$status')";
mysql_query($query);
}
ob_end_flush();
}
?>
and here's how i retrieve it
CODE
<td width="48%" valign="top"> <div align="justify">
<?php
ob_start();
include 'includes/connect.php';
require_once('includes/connect.php');
$query="Select * from products where status<>0";
$result=mysql_query($query);
$row1=mysql_num_rows($result);
echo "<table align=\"center\" border=\"2\" cellspacing=\"1\">";
echo "$br";
echo "<tr>";
echo "<td align=\"center\"><strong>Picture</strong></td>";
echo "<td align=\"center\"><strong>Software Name</strong></td>";
echo "<td align=\"center\"><strong>Category</strong></td>";
echo "<td align=\"center\"><strong>Description</strong></td>";
echo "<td align=\"center\"><strong>Price</strong></td>";
echo "<td align=\"center\"><strong>Quantity</strong></td>";
echo "</tr>";
while($array=mysql_fetch_array($result))
{
extract($array);
echo "<tr>";
echo "<td align=\"center\"><img src=".$picture."></td>";
echo "<td align=\"center\"><font color=\"red\">".$sName."</font></td>";
echo "<td align=\"center\">".$category."</td>";
echo "<td align=\"center\">".$description."</td>";
echo "<td align=\"center\">".$price."</td>";
echo "<td align=\"center\">".$quantity."</td>";
echo "</tr>";
}
echo "</table>";
?>
</div></td>
11 Aug, 2007 - 12:44 PM
| 