[php]
//echo (‘‘);
echo (‘‘);
echo (‘ ‘);
$itemID=$_GET[‘id’];
/* connect to the db */
$link =mysql_connect(“localhost”,”thomsons_wrdp1″,”FKX7e0wzs9qS”) or die(‘Cannot connect to the db’);
mysql_select_db(“thomsons_wrdp1”,$link) or die(“Cannot select the db “);
$result = mysql_query(“select * from ProductItem where itemID=$itemID”);
$productName =””;
$productType=1;
$itemPrice=0;
while($row = mysql_fetch_array($result)){
$productName=$row[‘ItemName’];
$itemPrice=$row[‘Price’];
$productType=$row[‘ProductTypeID’];
echo ‘[div class=”one_third”]’;
echo ‘[div class=””]’;
echo ‘[div class=”modern_preload_portrait_thumb”]’;
echo ‘[div class=””]’;//LTAS 07.11.2014 Change/Update
if($row[‘ProductTypeID’]==1){
echo ‘<img src=”https://thomsons.wpengine.com/Perennials/’;
echo ‘Perennials_’.$row[‘PictureID’];
echo ‘.bmp” alt=”” width=”274px” />’;
echo ‘[/a]’;
}
if($row[‘ProductTypeID’]==2){
echo ‘<img src=”https://thomsons.wpengine.com/Shrubs/’;
echo ‘Shrubs_’.$row[‘PictureID’];
echo ‘.bmp” alt=”” width=”274px” />’;
echo ‘[/a]’;
}
if($row[‘ProductTypeID’]==3){
echo ‘<img src=”https://thomsons.wpengine.com/Trees/’;
echo ‘Trees_’.$row[‘PictureID’];
echo ‘.bmp” alt=”” width=”274px” />’;
echo ‘[/a]’;
}
if($row[‘ProductTypeID’]==4){
echo ‘<img src=”https://thomsons.wpengine.com/Hardgoods/’;
echo ‘Hardgoods_’.$row[‘PictureID’];
echo ‘.bmp” alt=”” width=”274px” />’;
echo ‘[/a]’;
}
if($row[‘ProductTypeID’]==5){
echo ‘<img src=”https://thomsons.wpengine.com/Annuals/’;
echo ‘Annuals_’.$row[‘PictureID’];
echo ‘.bmp” alt=”” width=”274px” />’;
echo ‘[/a]’;
}
//if (file_exists(‘/home/thomsons/public_html/wp-content/uploads/picture/’.$row[‘InventoryID’].’.jpg’)) {
// echo ‘<img src=”https://thomsons.wpengine.com/wp-content/uploads/picture/’;
// echo $row[‘InventoryID’];
// echo ‘.jpg” alt=”” width=”274px” />’;
// echo ‘[/a]’;
//} else {
// echo ‘<img src=”https://thomsons.wpengine.com/wp-content/uploads/inventory/’;
// echo $row[‘InventoryID’];
// echo ‘.bmp” alt=”” width=”274px” />’;
// echo ‘[/a]’;
//}
echo ‘</div>’;
echo ‘</div>’;
echo ‘</div>’;
echo ‘</div>’;
echo ‘[div class=”two_thirds_last”]’;
echo ‘<p>’;
echo ‘[strong]’;
echo ‘Item Name:’;
echo ‘</strong> ‘;
echo htmlentities($row[‘ItemName’]);
echo ‘[br /]’;
echo ‘[strong]’;
echo ‘Code:’;
echo ‘</strong> ‘;
echo $row[‘Code’];
echo ‘</p>’;
echo ‘<p>’;
echo ‘[strong]’;
echo ‘Item Description:’;
echo ‘</strong> ‘;
echo ‘[br /]’;
echo $row[‘ItemDescription’];
echo ‘</p>’;
echo ‘<p>’;
echo ‘[strong]’;
echo ‘Price:’;
echo ‘</strong> ‘;
echo ‘ $’;
echo $row[‘Price’];
echo ‘</p>’;
echo ‘<p>’;
echo ‘ [br /] ‘;
echo ‘<p>’;
echo ‘[strong]’;
echo ‘Size:’;
echo ‘</strong> ‘;
echo ‘ ‘;
echo $row[‘size’];
echo ‘</p>’;
echo ‘<p>’;
echo ‘To make your shopping experience easier at Thomsons Landscaping add this item to a wishlist and show it to the retail staff and they can take you right to the plant.’;
echo ‘</p>’;
echo ‘<p>’;
echo ‘<a href=”#” class=”ka_button small_button small_forestgreen” onclick=”addCar()”>’;
echo ‘[span]’;
echo ‘ADD To Wishlist’;
echo ‘</span>’;
echo ‘</a>’;
echo ‘<a href=”https://thomsons.wpengine.com/wishlist’;
echo ‘” class=”ka_button small_button small_forestgreen” target=”_self”>’;
echo ‘[span]’;
echo ‘View Wishlist’;
echo ‘</span>’;
echo ‘</a>’;
echo ‘</p>’;
echo ‘</div>’;
}
$productTypeRow= mysql_fetch_array(mysql_query(“select * from ProductType where ProductTypeID=$productType”));
$productTypeName= $productTypeRow[‘ProductType’];/* disconnect from the db */
@mysql_close($link);echo ‘<script type=”text/javascript”>’;
echo ‘$(function(){$(“.frame h1:first-child”).text(“Item-‘;
echo $productName;
echo ‘”);’;
echo ‘$(“.current_crumb”).html(“<a href=\”https://thomsons.wpengine.com/products\”>Products</a><a href=\”https://thomsons.wpengine.com/product?id=’;
echo $productType;
echo ‘\”>’;
echo $productTypeName;
echo ‘</a> <span class=\”current_crumb\”>Item </span>”);});’;
echo ‘function addCar() { jQuery.ajax({type: “post”, url: “https://thomsons.wpengine.com/addwish.php”, cache: false, async: false,dataType:”json”, data: {id:’;
echo $itemID;
echo ‘,n:”‘;
echo $productName;
echo ‘”,p:’;
echo $itemPrice;
echo ‘},success: function(data) {location.href = “https://thomsons.wpengine.com/wishlist”;} });}’;
echo ‘</script>’;
[/php]
Contact Us
Phone: 740-374-9353
Toll Free: 800-367-4572
Fax: 740-374-3863
Store Hours:
Monday – Saturday: 8:00am – 7:00pm
Sunday – 11:00am – 5:00pm
Located At
26130 State Route 7
Marietta, Ohio
thomsonsgardencenter45750@gmail.com