try this code in view product page code
<?php
/**
* Magento
*
* NOTICE OF LICENSE
*
* This source file is subject to the Academic Free License (AFL 3.0)
* that is bundled with this package in the file LICENSE_AFL.txt.
* It is also available through the world-wide-web at this URL:
* http://opensource.org/licenses/afl-3.0.php
* If you did not receive a copy of the license and are unable to
* obtain it through the world-wide-web, please send an email
* to license@magentocommerce.com so we can send you a copy immediately.
*
* DISCLAIMER
*
* Do not edit or add to this file if you wish to upgrade Magento to newer
* versions in the future. If you wish to customize Magento for your
* needs please refer to http://www.magentocommerce.com for more information.
*
* @category design
* @package base_default
* @copyright Copyright (c) 2011 Magento Inc. (http://www.magentocommerce.com)
* @license http://opensource.org/licenses/afl-3.0.php Academic Free License (AFL 3.0)
*/
/**
* Product view template
*
* @see Mage_Catalog_Block_Product_View
* @see Mage_Review_Block_Product_View
*/
?>
<?php $_helper = $this->helper('catalog/output'); ?>
<?php $_product = $this->getProduct(); ?>
<script type="text/javascript">
var optionsPrice = new Product.OptionsPrice(<?php echo $this->getJsonConfig() ?>);
</script>
<?php echo $this->getLayout()->getBlock('breadcrumbs')->toHTML()?>
<div id="messages_product_view"><?php echo $this->getMessagesBlock()->getGroupedHtml() ?></div>
<div class="product-view">
<div class="product-essential">
<form action="<?php echo $this->getSubmitUrl($_product) ?>" method="post" id="product_addtocart_form"<?php if($_product->getOptions()): ?> enctype="multipart/form-data"<?php endif; ?>>
<div class="no-display">
<input type="hidden" name="product" value="<?php echo $_product->getId() ?>" />
<input type="hidden" name="related_product" id="related-products-field" value="" />
</div>
<div class="product-shop">
<div class="product-name">
<h1><?php echo $_helper->productAttribute($_product, $_product->getName(), 'name') ?></h1>
</div>
<div class="addthis-review">
<?php echo $this->getReviewsSummaryHtml($_product, false, true)?>
<!-- AddThis Button BEGIN -->
<a class="addthis_button" href="http://www.addthis.com/bookmark.php?v=300&pubid=xa-4ef995db1847b418"><img src="http://s7.addthis.com/static/btn/v2/lg-share-en.gif" width="125" height="16" alt="Bookmark and Share" style="border:0"/></a>
<script type="text/javascript" src="http://s7.addthis.com/js/300/addthis_widget.js#pubid=xa-4ef995db1847b418"></script>
<!-- AddThis Button END -->
</div>
<?php echo $this->getChildHtml('alert_urls') ?>
<?php echo $this->getChildHtml('product_type_data') ?>
<?php echo $this->getChildHtml('extrahint') ?>
<?php echo $this->getTierPriceHtml() ?>
<div class="sku"><?php echo $this->__('<span>SKU : </span>').$this->stripTags($_product->getSku()); ?></div>
<?php echo $this->getPriceHtml($_product) ?>
<?php if (!$this->hasOptions()):?>
<div class="add-to-box">
<?php if($_product->isSaleable()): ?>
<?php echo $this->getChildHtml('addtocart') ?>
<?php if( $this->helper('wishlist')->isAllow() || $_compareUrl=$this->helper('catalog/product_compare')->getAddUrl($_product)): ?>
<span class="or"><?php echo $this->__('OR') ?></span>
<?php endif; ?>
<?php endif; ?>
<?php echo $this->getChildHtml('addto') ?>
</div>
<?php echo $this->getChildHtml('extra_buttons') ?>
<?php elseif (!$_product->isSaleable()): ?>
<div class="add-to-box">
<?php echo $this->getChildHtml('addto') ?>
</div>
<?php endif; ?>
<?php echo $this->getChildHtml('other');?>
<?php if ($_product->isSaleable() && $this->hasOptions()):?>
<?php echo $this->getChildChildHtml('container1', '', true, true) ?>
<?php endif;?>
<?php if ($_product->getShortDescription()):?>
<div class="short-description">
<h2><?php echo $this->__('Quick Overview') ?></h2>
<div class="std"><?php echo $_helper->productAttribute($_product, nl2br($_product->getShortDescription()), 'short_description') ?></div>
</div>
<?php endif;?>
<!-- AddThis Button BEGIN -->
<div class="addthis_toolbox addthis_default_style ">
<a class="addthis_button_facebook_like" fb:like:layout="button_count"></a>
<a class="addthis_button_tweet"></a>
<a class="addthis_button_google_plusone" g:plusone:size="medium"></a>
<!--a class="addthis_counter addthis_pill_style"></a-->
</div>
<script type="text/javascript" src="http://s7.addthis.com/js/300/addthis_widget.js#pubid=xa-4ef9939f03d6e628"></script>
<!-- AddThis Button END -->
</div>
<div class="product-img-box">
<?php echo $this->getChildHtml('media') ?>
</div>
<div class="clearer"></div>
<?php if ($_product->isSaleable() && $this->hasOptions()):?>
<?php echo $this->getChildChildHtml('container2', '', true, true) ?>
<?php endif;?>
</form>
<script type="text/javascript">
//<![CDATA[
var productAddToCartForm = new VarienForm('product_addtocart_form');
productAddToCartForm.submit = function(button, url) {
if (this.validator.validate()) {
var form = this.form;
var oldUrl = form.action;
if (url) {
form.action = url;
}
var e = null;
try {
this.form.submit();
} catch (e) {
}
this.form.action = oldUrl;
if (e) {
throw e;
}
if (button && button != 'undefined') {
button.disabled = true;
}
}
}.bind(productAddToCartForm);
productAddToCartForm.submitLight = function(button, url){
if(this.validator) {
var nv = Validation.methods;
delete Validation.methods['required-entry'];
delete Validation.methods['validate-one-required'];
delete Validation.methods['validate-one-required-by-name'];
if (this.validator.validate()) {
if (url) {
this.form.action = url;
}
this.form.submit();
}
Object.extend(Validation.methods, nv);
}
}.bind(productAddToCartForm);
//]]>
</script>
</div>
<div class="product-collateral">
<?php if(count($this->getChildGroup('detailed_info', 'getChildHtml')>0)):?>
<div id="detailtabs">
<ul>
<li><a href="#tabs-1"><?php echo $this->__('Product description') ?></a></li>
<li class="last"><a href="#tabs-2"><?php echo $this->__('Information') ?></a></li>
</ul>
<div id="tabs-1">
<?php $i=1; foreach ($this->getChildGroup('detailed_info', 'getChildHtml') as $alias => $html):?>
<?php echo $html; ?>
<?php $i++ ; endforeach;?>
</div>
<div id="tabs-2">
<?php if(count($this->getChildGroup('detailed_info', 'getChildHtml'))<2):?>
<?php endif;?>
</div>
<script type="text/javascript">
jQuery(function(){
//jQuery('#detailtabs').tabs();
});
</script>
</div>
<?php endif ?>
<?php echo $this->getChildHtml('product_additional_data_review') ?>
<?php echo $this->getChildHtml('product_additional_data') ?>
<div id="tabs_relate_upsell">
<ul>
<li><a href="#tabs-1"><?php echo $this->__('Related Top Seller On Your Website') ?></a></li>
<li class="last"><a href="#tabs-2"><?php echo $this->__('You Might Also Like') ?></a></li>
</ul>
<div id="tabs-1">
<?php echo $this->getChildHtml('catalog_product_related') ?>
</div>
<?php
mysql_connect('localhost','root','admin') or die (mysql_error());
mysql_select_db('mhgreen') or die (mysql_error());
$result = mysql_query('SELECT * FROM label_attribute_value_varchar ');
while ($R = mysql_fetch_array($result))
{
echo "<img src='http://localhost/newgreen/media/em_productlabels/image/admin/50x50/".$R['value']." ' ><br>";
}
?>
<div id="tabs-2">
<?php echo $this->getChildHtml('upsell_products') ?>
</div>
<script type="text/javascript">
jQuery(function(){
//jQuery('#tabs_relate_upsell').tabs();
});
</script>
</div>
</div>
</div>
<?php
/**
* Magento
*
* NOTICE OF LICENSE
*
* This source file is subject to the Academic Free License (AFL 3.0)
* that is bundled with this package in the file LICENSE_AFL.txt.
* It is also available through the world-wide-web at this URL:
* http://opensource.org/licenses/afl-3.0.php
* If you did not receive a copy of the license and are unable to
* obtain it through the world-wide-web, please send an email
* to license@magentocommerce.com so we can send you a copy immediately.
*
* DISCLAIMER
*
* Do not edit or add to this file if you wish to upgrade Magento to newer
* versions in the future. If you wish to customize Magento for your
* needs please refer to http://www.magentocommerce.com for more information.
*
* @category design
* @package base_default
* @copyright Copyright (c) 2011 Magento Inc. (http://www.magentocommerce.com)
* @license http://opensource.org/licenses/afl-3.0.php Academic Free License (AFL 3.0)
*/
/**
* Product view template
*
* @see Mage_Catalog_Block_Product_View
* @see Mage_Review_Block_Product_View
*/
?>
<?php $_helper = $this->helper('catalog/output'); ?>
<?php $_product = $this->getProduct(); ?>
<script type="text/javascript">
var optionsPrice = new Product.OptionsPrice(<?php echo $this->getJsonConfig() ?>);
</script>
<?php echo $this->getLayout()->getBlock('breadcrumbs')->toHTML()?>
<div id="messages_product_view"><?php echo $this->getMessagesBlock()->getGroupedHtml() ?></div>
<div class="product-view">
<div class="product-essential">
<form action="<?php echo $this->getSubmitUrl($_product) ?>" method="post" id="product_addtocart_form"<?php if($_product->getOptions()): ?> enctype="multipart/form-data"<?php endif; ?>>
<div class="no-display">
<input type="hidden" name="product" value="<?php echo $_product->getId() ?>" />
<input type="hidden" name="related_product" id="related-products-field" value="" />
</div>
<div class="product-shop">
<div class="product-name">
<h1><?php echo $_helper->productAttribute($_product, $_product->getName(), 'name') ?></h1>
</div>
<div class="addthis-review">
<?php echo $this->getReviewsSummaryHtml($_product, false, true)?>
<!-- AddThis Button BEGIN -->
<a class="addthis_button" href="http://www.addthis.com/bookmark.php?v=300&pubid=xa-4ef995db1847b418"><img src="http://s7.addthis.com/static/btn/v2/lg-share-en.gif" width="125" height="16" alt="Bookmark and Share" style="border:0"/></a>
<script type="text/javascript" src="http://s7.addthis.com/js/300/addthis_widget.js#pubid=xa-4ef995db1847b418"></script>
<!-- AddThis Button END -->
</div>
<?php echo $this->getChildHtml('alert_urls') ?>
<?php echo $this->getChildHtml('product_type_data') ?>
<?php echo $this->getChildHtml('extrahint') ?>
<?php echo $this->getTierPriceHtml() ?>
<div class="sku"><?php echo $this->__('<span>SKU : </span>').$this->stripTags($_product->getSku()); ?></div>
<?php echo $this->getPriceHtml($_product) ?>
<?php if (!$this->hasOptions()):?>
<div class="add-to-box">
<?php if($_product->isSaleable()): ?>
<?php echo $this->getChildHtml('addtocart') ?>
<?php if( $this->helper('wishlist')->isAllow() || $_compareUrl=$this->helper('catalog/product_compare')->getAddUrl($_product)): ?>
<span class="or"><?php echo $this->__('OR') ?></span>
<?php endif; ?>
<?php endif; ?>
<?php echo $this->getChildHtml('addto') ?>
</div>
<?php echo $this->getChildHtml('extra_buttons') ?>
<?php elseif (!$_product->isSaleable()): ?>
<div class="add-to-box">
<?php echo $this->getChildHtml('addto') ?>
</div>
<?php endif; ?>
<?php echo $this->getChildHtml('other');?>
<?php if ($_product->isSaleable() && $this->hasOptions()):?>
<?php echo $this->getChildChildHtml('container1', '', true, true) ?>
<?php endif;?>
<?php if ($_product->getShortDescription()):?>
<div class="short-description">
<h2><?php echo $this->__('Quick Overview') ?></h2>
<div class="std"><?php echo $_helper->productAttribute($_product, nl2br($_product->getShortDescription()), 'short_description') ?></div>
</div>
<?php endif;?>
<!-- AddThis Button BEGIN -->
<div class="addthis_toolbox addthis_default_style ">
<a class="addthis_button_facebook_like" fb:like:layout="button_count"></a>
<a class="addthis_button_tweet"></a>
<a class="addthis_button_google_plusone" g:plusone:size="medium"></a>
<!--a class="addthis_counter addthis_pill_style"></a-->
</div>
<script type="text/javascript" src="http://s7.addthis.com/js/300/addthis_widget.js#pubid=xa-4ef9939f03d6e628"></script>
<!-- AddThis Button END -->
</div>
<div class="product-img-box">
<?php echo $this->getChildHtml('media') ?>
</div>
<div class="clearer"></div>
<?php if ($_product->isSaleable() && $this->hasOptions()):?>
<?php echo $this->getChildChildHtml('container2', '', true, true) ?>
<?php endif;?>
</form>
<script type="text/javascript">
//<![CDATA[
var productAddToCartForm = new VarienForm('product_addtocart_form');
productAddToCartForm.submit = function(button, url) {
if (this.validator.validate()) {
var form = this.form;
var oldUrl = form.action;
if (url) {
form.action = url;
}
var e = null;
try {
this.form.submit();
} catch (e) {
}
this.form.action = oldUrl;
if (e) {
throw e;
}
if (button && button != 'undefined') {
button.disabled = true;
}
}
}.bind(productAddToCartForm);
productAddToCartForm.submitLight = function(button, url){
if(this.validator) {
var nv = Validation.methods;
delete Validation.methods['required-entry'];
delete Validation.methods['validate-one-required'];
delete Validation.methods['validate-one-required-by-name'];
if (this.validator.validate()) {
if (url) {
this.form.action = url;
}
this.form.submit();
}
Object.extend(Validation.methods, nv);
}
}.bind(productAddToCartForm);
//]]>
</script>
</div>
<div class="product-collateral">
<?php if(count($this->getChildGroup('detailed_info', 'getChildHtml')>0)):?>
<div id="detailtabs">
<ul>
<li><a href="#tabs-1"><?php echo $this->__('Product description') ?></a></li>
<li class="last"><a href="#tabs-2"><?php echo $this->__('Information') ?></a></li>
</ul>
<div id="tabs-1">
<?php $i=1; foreach ($this->getChildGroup('detailed_info', 'getChildHtml') as $alias => $html):?>
<?php echo $html; ?>
<?php $i++ ; endforeach;?>
</div>
<div id="tabs-2">
<?php if(count($this->getChildGroup('detailed_info', 'getChildHtml'))<2):?>
<?php endif;?>
</div>
<script type="text/javascript">
jQuery(function(){
//jQuery('#detailtabs').tabs();
});
</script>
</div>
<?php endif ?>
<?php echo $this->getChildHtml('product_additional_data_review') ?>
<?php echo $this->getChildHtml('product_additional_data') ?>
<div id="tabs_relate_upsell">
<ul>
<li><a href="#tabs-1"><?php echo $this->__('Related Top Seller On Your Website') ?></a></li>
<li class="last"><a href="#tabs-2"><?php echo $this->__('You Might Also Like') ?></a></li>
</ul>
<div id="tabs-1">
<?php echo $this->getChildHtml('catalog_product_related') ?>
</div>
<?php
mysql_connect('localhost','root','admin') or die (mysql_error());
mysql_select_db('mhgreen') or die (mysql_error());
$result = mysql_query('SELECT * FROM label_attribute_value_varchar ');
while ($R = mysql_fetch_array($result))
{
echo "<img src='http://localhost/newgreen/media/em_productlabels/image/admin/50x50/".$R['value']." ' ><br>";
}
?>
<div id="tabs-2">
<?php echo $this->getChildHtml('upsell_products') ?>
</div>
<script type="text/javascript">
jQuery(function(){
//jQuery('#tabs_relate_upsell').tabs();
});
</script>
</div>
</div>
</div>
No comments:
Post a Comment