Wednesday, October 17, 2012

magento language switch code

<?php if(count($this->getStores())>1): ?>
<div class="form-language">
    <label><?php echo $this->__('Language:') ?></label>
    <ul>
    <?php foreach ($this->getStores() as $_lang): ?>
        <?php
            $tam    =    $this->htmlEscape($_lang->getName());
            $ten    =    substr($tam,0,2);
        ?>
        <?php $_selected = ($_lang->getId() == $this->getCurrentStoreId()) ? 'selected    ' : '' ?>
        <li class="<?php echo  $_selected ?>"><a href="<?php echo $_lang->getCurrentUrl() ?>"><?php echo $ten ?></a></li>
    <?php endforeach; ?>
    </ul>
    <script type="text/javascript">decorateGeneric($$('.form-language ul li'), ['first','last'])</script>
</div>
<?php endif; ?>


Magento language switcher

Magento language switcher

this is below phtml code for magento

<?php if(count($this->getGroups())>1): ?>
<div class="language-switcher" style="margin-left:15px">
<label for="select-store"><?php echo $this->__('Select Store') ?>: </label>
<select id="select-store" onchange="location.href=this.value">
<?php /*foreach ($this->getStores() as $_store): ?>
<option value="<?php echo $_store->getUrl('') ?>"<?php if($_store->getId()==$this->getCurrentStoreId()): ?> selected="selected"<?php endif; ?>><?php echo $_store->getName() ?></option>
<?php endforeach;*/ ?>
<?php foreach ($this->getGroups() as $_group): ?>
<?php $_selected = ($_group->getId()==$this->getCurrentGroupId()) ? 'selected="selected"' : '' ?>
<option value="<?php echo $_group->getHomeUrl() ?>" <?php echo $_selected ?>><?php echo $this->htmlEscape($_group->getName()) ?></option>
<?php endforeach; ?>
</select>
</div>
<?php endif; ?>



this below code for xml page for create block

<block type="page/html_header" name="header" as="header">
<block type="page/template_links" name="top.links" as="topLinks"/>
<block type="page/switch" name="store_language" as="store_language" template="page/switch/languages.phtml"/>
<block type="page/switch" name="store_switcher_top" as="store_switcher_top" template="page/switch/stores-top.phtml"/>
<block type="core/text_list" name="top.menu" as="topMenu"/>
</block>

Saturday, October 13, 2012

inserting data into database based by checkbox if checkbox selected.

<input type="button" name="Un_CheckAll" value="Uncheck All "
140onclick="UnCheckAll(document.myform.status)" />
141         
142        <th width="84" scope="row"><label>
143          <label>
144            <input type="submit" name="Simpan" id="Simpan" value="Simpan" />
145          </label>
146      </table>
147    <p>&nbsp;</p>
148    <p>&nbsp;</p>
149  </form>
150  <p>&nbsp;</p>
151  <p>&nbsp;</p>
152</blockquote>
153</body>
154 
155</html><?php
156if(isset($_POST['Simpan']))
157          {
158              
159               $status_id = $_POST['form1.status_id'];
160               $no_pend = $totalRows_kelas['no_pend'];
161               $nama_pelajar = $totalRows_kelas['nama_pelajar'];
162               $kelas = $totalRows_kelas['kelas'];
163               $kod_pensyarah = $totalRows_pensyarah['kod_pensyarah'];
164            if($status_id=1)
165              {
166             $sql="INSERT INTO pend_kursus( kod_pensyarah,kod_kursus, no_pend, kelas  )
167                        VALUES
168                        ('$kod_pensyarah','$kod_kursus','$no_pend' ,'$kelas' )";
169              }
170                 
171            echo "<script language='Javascript'>alert('Maklumat Telah Berjaya Disimpan');</script>";
172          }
173$result = mysql_query($sql);?>
174<?php
175mysql_free_result($pensyarah);
176?>
   <script LANGUAGE="Javascript">
002<!--
003 
004<!-- Begin
005function CheckAll(chk)
006{
007for (i = 0; i < chk.length; i++)
008chk[i].checked = true ;
009}
010 
011function UnCheckAll(chk)
012{
013for (i = 0; i < chk.length; i++)
014chk[i].checked = false ;
015}
016// End -->
017</script>
018 
019 
020<?php require_once('../Connections/connection.php'); ?>
021<?php
022 
023$kod_kursus=$_POST["kod_kursus"];  
024mysql_select_db($database_connection, $connection);
025$query_kursus = "SELECT * FROM m_kursus WHERE kod_kursus='$kod_kursus'";
026$kursus = mysql_query($query_kursus, $connection) or die(mysql_error());
027$row_kursus = mysql_fetch_assoc($kursus);
028$totalRows_kursus = mysql_num_rows($kursus);
029 
030$kelas=$_POST["kelas"];
031mysql_select_db($database_connection, $connection);
032$query_kelas = "SELECT * FROM m_pelajar WHERE kelas='$kelas'";
033$kelas = mysql_query($query_kelas, $connection) or die(mysql_error());
034$row_kelas = mysql_fetch_assoc($kelas);
035$totalRows_kelas = mysql_num_rows($kelas);
036 
037$kod_pensyarah=$_POST["kod_pensyarah"];
038mysql_select_db($database_connection, $connection);
039$query_pensyarah = "SELECT * FROM plogin WHERE kod_pensyarah = '$kod_pensyarah'";
040$pensyarah = mysql_query($query_pensyarah, $connection) or die(mysql_error());
041$row_pensyarah = mysql_fetch_assoc($pensyarah);
042$totalRows_pensyarah = mysql_num_rows($pensyarah);
043$result = mysql_query($query_kelas);
044 
045?>
046 
047<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
048<html xmlns="http://www.w3.org/1999/xhtml">
049<head>
050<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
051<title>Untitled Document</title>
052<style type="text/css">
053<!--
054body,td,th {
055    font-family: Verdana, Geneva, sans-serif;
056    font-weight: bold;
057    color: #FFF;
058    font-size: 14;
059}
060.tulisan {
061    font-family: "Arial Black", Gadget, sans-serif;
062}
063.tulisan {
064    font-family: "A Charming Font", "Felix Titling", "Floral Dawn", "Lucida Sans Unicode";
065}
066.tulisan {
067    font-family: Verdana, Geneva, sans-serif;
068}
069.tulisan {
070    font-size: 14px;
071}
072.tulisan {
073    font-family: "Kozuka Mincho Pro B", Utsaah, "Segoe UI";
074}
075.tulisan {
076    font-family: Verdana, Geneva, sans-serif;
077}
078.tulisan {
079    font-size: 16px;
080}
081#form table {
082    font-family: Verdana, Geneva, sans-serif;
083}
084-->
085</style></head>
086 
087<body background="image_e-kehadiran/Bs_Black_Floor_1440x900.jpg">
088<blockquote>
089  <table width="494" border="0" align="center">
090    <tr>
091      <th width="204" align="center" valign="middle" class="tulisan" scope="row"><blockquote>
092        <p class="tulisan"><span class="tulisan"> Kod Kursus :</span></p>
093      </blockquote></th>
094      <td width="232"><span class="tulisan"><?php echo $row_kursus['kod_kursus']; ?>&nbsp;</span></td>
095    </tr>
096    <tr>
097      <th align="center" class="tulisan" scope="row"><blockquote>
098        <p><span class="tulisan">Nama Kursus :</span></p>
099      </blockquote></th>
100      <td><span class="tulisan"><?php echo $row_kursus['nama_kursus']; ?>&nbsp;</span></td>
101    </tr>
102  </table>
103  <form id="form" name="myform" method="post" action="">
104    <p>&nbsp;</p>
105    <table width="733" height="63" border="1" align="center">
106      <tr>
107        <td width="220" height="29" align="center"><strong>No. Pendaftaran </strong></td>
108        <td width="231" align="center"><strong>Nama </strong></td>
109        <td width="174" align="center"><strong>Kelas </strong></td>
110        <td width="80" align="center"><strong>Daftar </strong></td>
111      </tr>
112      <?php
113      while($rows = mysql_fetch_array($result))
114{
115 
116 
117?>
118<?php
119     
120    ?>
121      <tr>
122        <td height="26" align="center" valign="middle"><label>
123          <?php  echo $no_pend ?>
124        </label>
125          &nbsp;</td>
126        <td align="center" valign="middle"><?php  echo $nama_pelajar ?>
127          &nbsp;</td>
128        <td align="center" valign="middle"><?php  echo $kelas ?>
129          &nbsp;</td>
130        <td align="center" valign="middle"><input name="status_id" type="checkbox" id="status" value="1" /></td>
131      </tr>
132      <?
133         
134}?>
135    </table>
136    <p>&nbsp;</p>
137    <table width="332" border="0" align="center">
138      <tr>
139        <th width="193" align="right" scope="row"><input type="button" name="Check_All" value="Check All"
140onclick="CheckAll(document.myform.status)" />
141          <input type="button" name="Un_CheckAll" value="Uncheck All "
142onclick="UnCheckAll(document.myform.status)" />
143         
144        <th width="84" scope="row"><label>
145          <label>
146            <input type="submit" name="Simpan" id="Simpan" value="Simpan" />
147          </label>
148      </table>
149    <p>&nbsp;</p>
150    <p>&nbsp;</p>
151  </form>
152  <p>&nbsp;</p>
153  <p>&nbsp;</p>
154</blockquote>
155</body>
156 
157</html><?php
158if(isset($_POST['Simpan']))
159          {
160              
161               $status_id = $_POST['form1.status_id'];
162               $no_pend = $totalRows_kelas['no_pend'];
163               $nama_pelajar = $totalRows_kelas['nama_pelajar'];
164               $kelas = $totalRows_kelas['kelas'];
165               $kod_pensyarah = $totalRows_pensyarah['kod_pensyarah'];
166            if($status_id=1)
167              {
168             $sql="INSERT INTO pend_kursus( kod_pensyarah,kod_kursus, no_pend, kelas  )
169                        VALUES
170                        ('$kod_pensyarah','$kod_kursus','$no_pend' ,'$kelas' )";
171              }
172                 
173            echo "<script language='Javascript'>alert('Maklumat Telah Berjaya Disimpan');</script>";
174          }
175$result = mysql_query($sql);?>
176<?php
177mysql_free_result($pensyarah);
178?>
179[attachment=22599:pend_kursus.php]
 

Friday, October 12, 2012

Remove shipping address and method from onepage checkout in magento

Go to:
app\code\core\Mage\Checkout\Block \Onepage.php
Change the code :

public function getSteps()
 {
 $steps = array();
 if (!$this->isCustomerLoggedIn()) {
 $steps['login'] = $this->getCheckout()->getStepData('login');
 }
 //$stepCodes = array('billing', 'shipping', 'shipping_method', 'payment', 'review');
 $stepCodes = array('billing', 'payment', 'review');
 foreach ($stepCodes as $step) {
 $steps[$step] = $this->getCheckout()->getStepData($step);
 }
 return $steps;
 }


Go to:
app\code\core\Mage\Checkout\controllers\ OnepageController.php

Edit:
protected $_sectionUpdateFunctions = array(
 'payment-method' => '_getPaymentMethodsHtml',
 // 'shipping-method' => '_getShippingMethodsHtml',
 'review' => '_getReviewHtml',
 );
 
 Also edit  saveBillingAction() function

public function saveBillingAction()
 {
 if ($this->_expireAjax()) {
 return;
 }
 if ($this->getRequest()->isPost()) {
 //$postData = $this->getRequest()->getPost('billing', array());
 //$data = $this->_filterPostData($postData);
 $data = $this->getRequest()->getPost('billing', array());
 $customerAddressId = $this->getRequest()->getPost('billing_address_id', false);
 if (isset($data['email'])) {
 $data['email'] = trim($data['email']);
 }
 $result = $this->getOnepage()->saveBilling($data, $customerAddressId);
 if (!isset($result['error'])) {
 /* check quote for virtual */
 if ($this->getOnepage()->getQuote()->isVirtual()) {
 $result['goto_section'] = 'payment';
 $result['update_section'] = array(
 'name' => 'payment-method',
 'html' => $this->_getPaymentMethodsHtml()
 );
 }
 /*elseif (isset($data['use_for_shipping']) && $data['use_for_shipping'] == 1) {
 $result['goto_section'] = 'shipping_method';
 $result['update_section'] = array(
 'name' => 'shipping-method',
 'html' => $this->_getShippingMethodsHtml()
 );
 $result['allow_sections'] = array('shipping');
 $result['duplicateBillingInfo'] = 'true';
 }*/
 //End of Comment by Amit Bera
 else {
 //$result['goto_section'] = 'shipping';
 $result['goto_section'] = 'payment';
 }
 }
 $this->getResponse()->setBody(Mage::helper('core')->jsonEncode($result));
 }
 }

 Go to:
\app\code\core\Mage\Sales\Model\Service\ Quote.php

Edit:
 

protected function _validate()
 {
 $helper = Mage::helper('sales');
 if (!$this->getQuote()->isVirtual()) {
 $address = $this->getQuote()->getShippingAddress();
 $addressValidation = $address->validate();
 // if ($addressValidation !== true) {
 // Mage::throwException(
 //$helper->__('Please check shipping address information. %s', implode(' ', $addressValidation))
 //);
 //}
 // $method= $address->getShippingMethod();
 //$rate = $address->getShippingRateByCode($method);
 //if (!$this->getQuote()->isVirtual() && (!$method || !$rate)) {
 //Mage::throwException($helper->__('Please specify a shipping method.'));
 //}
 }


In billing information tab  you see radio button for  shipping address as billing address ,just hidden it or remove it .the file located at – app\design\frontend\default\your template\yourtemplate\persistent\checkout\onepage\billing,phtml
Or
app\design\frontend\default\your template\template \checkout\onepage\billing,phtml

In  app\locale\en_US\template\email\sales\ order_new.html
From
{{var order.getShippingAddress().format('html')}}
To
{{var order.getBillingAddress().format('html')}}
And
{{var order.getShippingDescription()}}
Remove it. 

Thursday, October 11, 2012

Tuesday, October 9, 2012

Magento EM product label

<?php
class EM_Productlabels_Helper_Data extends Mage_Core_Helper_Abstract
{
    protected $labels;
    public function resizeImage($imageName, $width=NULL, $height=NULL, $imagePath=NULL,$type)
   {
       $imagePath = str_replace("/", DS, $imagePath);
       $imagePathFull = Mage::getBaseDir('media') . DS . $imagePath . DS . $imageName;

       if($width == NULL && $height == NULL) {
          $width = 100;
          $height = 100;
       }
       $resizePath = $width . 'x' . $height;
       $resizePathFull = Mage::getBaseDir('media') . DS . $imagePath . DS . $type. DS . $resizePath . DS . $imageName;

       if (file_exists($imagePathFull) && !file_exists($resizePathFull)) {
          $imageObj = new Varien_Image($imagePathFull);
          $imageObj->keepTransparency(true);
          //$imageObj->constrainOnly(TRUE);
          $imageObj->keepAspectRatio(TRUE);
          $imageObj->resize($width,$height);
          $imageObj->save($resizePathFull);
       }

       $imagePath=str_replace(DS, "/", $imagePath);
       return Mage::getBaseUrl("media") . $imagePath . "/" . $type . "/" . $resizePath . "/"  . $imageName;
    }

    function initLabels()
    {
        if($this->labels)
            return $this->labels;
      
        $label = Mage::getModel('productlabels/productlabels');
        $attributes = $label->getAttributes();
        $collection = $label->getCollection();
        foreach($attributes as $a)
        {
            $atrNameTbl = $a->getNameAttribute().'tbl';
            $atrNameTblDefault = $a->getNameAttribute().'tbl_default';
            $collection->getSelect()->joinLeft(array($atrNameTbl => $collection->getTable('productlabels/type_'.$a->getType())),
                                    "$atrNameTbl.label_id = main_table.id
                                    AND $atrNameTbl.attribute_id = ".$a->getId()."
                                    AND $atrNameTbl.store_id = ".Mage::app()->getStore()->getId(), array(
                            ))->joinLeft(array($atrNameTblDefault => $collection->getTable('productlabels/type_'.$a->getType())),
                                    "$atrNameTblDefault.label_id = main_table.id
                                    AND $atrNameTblDefault.attribute_id = ".$a->getId()."
                                    AND $atrNameTblDefault.store_id = ".$this->_getDefaultStoreId(), array(
                                    $a->getNameAttribute() => "if($atrNameTbl.value <> 'NULL',$atrNameTbl.value,$atrNameTblDefault.value)"
                            ));
        }
        $this->labels = $collection;
        return $this->labels;
    }

    function display($_product)
    {
        $labels = $this->initLabels();
        $block = new EM_Productlabels_Block_Productlabels();
        $labelShows = array();
        foreach ($labels as $label)
        {
            $catalogRule = Mage::getModel('productlabels/rule');
            $actionsArr = unserialize($label->getActions());
            if (!empty($actionsArr) && is_array($actionsArr)) {
                $catalogRule->getConditions()->loadArray($actionsArr);
            }
            $object = new Varien_Object();
            $object->setData('product', $_product);
            $object->setData('label', $label);
           
            if($validate = (bool)$catalogRule->validate($object) && $label->getEnable() == 1)
            {
                $labelShows[] = $label;
               
            }

        }
        if(!empty ($labelShows))
        {
            echo $block->addObject(array('labels'=>$labelShows,'product'=>$_product))->setTemplate('em_productlabels/productlabels.phtml')->toHtml();
        }


       
    }

    /**
     * Default sore ID getter
     *
     * @return integer
     */
    protected function _getDefaultStoreId()
    {
        return Mage_Catalog_Model_Abstract::DEFAULT_STORE_ID;
    }
}

Magenot Cloudzoom view page code

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&amp;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>