Usamos cookies para medir audiência e melhorar sua experiência. Você pode aceitar ou recusar a qualquer momento. Veja sobre o iMasters.
<?php
require_once("conn.php");
require_once("header.php");
//get 3 random products
$q1 = "select devbg_products.*, devbg_categories.*, devbg_subcategories.* from devbg_products
left join devbg_categories on devbg_products.ItemCategory = devbg_categories.CategoryID
left join devbg_subcategories on devbg_products.ItemSubcategory = devbg_subcategories.SubcategoryID
order by rand() limit 0,6 ";
$r1 = mysql_query($q1) or die(mysql_error());
if(mysql_num_rows($r1) == '0')
{
$NoItems = "<center>Sem Itens Ainda</center>";
} $MyPrice = number_format($a1[itemPrice], 2, ".", "");
if(!empty($a1[itemImage]))
{
$xy = @getimagesize("items_images/$a1[itemImage]");
$x = $xy[0];
$y = $xy[1];
$NewItemName = str_replace("'", "", $a1[itemName]);
$DisplayImage = "<a href=\"javascript:ShowPic('items_images/$a1[itemImage]', '$NewItemName', '$x', '$y');\"><img src=\"items_images/$a1[itemImage]\" width=100 alt=\"$a1[itemName]\" border=0 style=\"border-color:black\"></a>";
}
else
{
$DisplayImage = " ";
}
$DisplayIndex .= "
<table align=center width=300 border=0 rules=rows cellspacing=0 bordercolor=black>
<tr>
<td valign=top width=140>$DisplayImage</td>
<td width=160 valign=top>
<a class=\"ItemTitle\" href=\"ViewItem.php?ItemID=$a1[itemID]\">$a1[itemName]</a>
<br><BR>
<font color=black face=verdana size=1><b>Categoria: </b></font><a class=\"CategoryClass\" href=\"ShowCategory.php?CategoryID=$a1[itemCategory]\">$a1[CategoryName]</a>";
if(!empty($a1[subcategoryID]))
{
$DisplayIndex .= ", <a class=\"SubcategoryClass\" href=\"ShowCategory.php?CategoryID=$a1[itemCategory]&SubcategoryID=$a1[itemSubcategory]\">$a1[subcategoryName]</a>";
}
$DisplayIndex .= " <br>
<font color=red face=verdana size=2><b>preço: R$ $MyPrice</b></font>
<br><br>
<form method=post action=add.php style=\"margin:0\">
<input type=hidden name=ItemID value=\"$a1[itemID]\">
<input type=hidden name=ItemName value=\"$a1[itemName]\">
<input type=hidden name=ItemShipping value=\"$a1[itemShipping]\">
<input type=hidden name=ItemPrice value=\"$MyPrice\">
<input type=submit name=s1 value=\"Comprar\" class=sub>
</form>
</td>
</tr>
</table><br><hr size=1 color=E3E3E3>";
}
}
if(isset($NoItems))
{
echo $NoItems;
}require_once("templates/IndexTemplate.php");
}
require_once("footer.php");
?>Carregando comentários...