<?php //begin ?>
<?php
$_producty = $this->getProduct();
$productid = $_producty['entity_id'];
$resource = Mage::getSingleton('core/resource');
$read = $resource->getConnection('catalog_read');
$productEntityTable = (string)Mage::getConfig()->getTablePrefix().'catalog_product_entity';
$productoptionTable = (string)Mage::getConfig()->getTablePrefix().'catalog_product_option';
$productOptionTypeTable = (string)Mage::getConfig()->getTablePrefix().'catalog_product_option_type_value';
$productOptionTypeTitleTable = (string)Mage::getConfig()->getTablePrefix().'catalog_product_option_type_title';
$select = $read->select()
->from(array('cp'=>$productEntityTable))
->join(array('po'=>$productoptionTable),'cp.entity_id=po.product_id')
->join(array('pot'=>$productOptionTypeTable),'pot.option_id=po.option_id')
->join(array('pott'=>$productOptionTypeTitleTable),'pott.option_type_id=pot.option_type_id')
->where('cp.entity_id=?',$productid) ;
$rows = $read->fetchAll($select);
// $rows = array_unique($rows);
$items = $rows;
$optionid = array();
$ik = 1;
foreach ($items as $item)
{
$optionid[] = $item['option_id'];
}
$optionid = array_unique($optionid);
foreach($optionid as $oid){
$name = "options[".$oid."]";
$id = "select_".$oid;
foreach ($items as $item){
if($item['option_id']==$oid){
echo "<input name='".$name."' id='".$id."' type='text' value='".$item['option_type_id']."' />";
break;
}
}
echo "<ul class='".$id."' id='inpur_select".$ik."' >";
$ij =1;
foreach ($items as $item){
if($item['option_id']==$oid){
if($ij==1){
echo "<li class='selected' alt='".$item['option_type_id']."'>".$item['title']."</li>";
}else{
echo "<li alt='".$item['option_type_id']."'>".$item['title']."</li>";
}
$ij++;
}
}
echo "</ul><div class='clearer'></div>";
$ik++;
}
?>
<?php //end ?>
magento 产品详细页面的下拉框,下拉条,改成点击方式,从数据库中提取下拉框中的信息...
最新推荐文章于 2024-07-16 10:28:31 发布