dsgs8208 2015-07-21 04:51
浏览 38

从mysql数据库prestashop填充多个select

I want to create a multiple select with add/remove button and the values in that multiple select i want to fetch from mysql query. my question is how will i populate the result of query in to select lists value? my code is as follows: Product.tpl

         <form>
         <fieldset>
         <form name="formName1">
         <select name="selectfrom" id="select-from" multiple size="5" >
         <option value="1?>">Item1</option>
         <option value="2">Item 2</option>
         <option value="3">Item 3</option>
         <option value="4">Item 4</option>
         </select>

         <a href="JavaScript:void(0);" id="btn-add">Add &raquo;</a>
         <a href="JavaScript:void(0);" id="btn-remove">&laquo; Remove</a>

         <select name="selectto" id="select-to" multiple size="5">
         <option value="5">Item 5</option>
         <option value="6">Item 6</option>
         <option value="7">Item 7</option>
         </select>
         <input type="button" onClick="myFunction()" value="Submit form">
         </fieldset>
         </form>

and my php file code is :

       public function products_configure($url){
       $productsel = "Select id_product,name from ". _DB_PREFIX_ ."product_lang";
          $products = Db::getInstance()->executeS($productsel);
              foreach($products as $product){
                $productintid = $product['id_product'];
                $productintname = $product['name'];
                   }
                  $this->context->smarty->assign(array(
                  'url' => $url
                   ));
              return $this->fetchTemplate('/views/templates/back/products.tpl');
               } 

can anyone pls tell how will i use $productintname to option value in tpl file.

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥100 set_link_state
    • ¥15 虚幻5 UE美术毛发渲染
    • ¥15 CVRP 图论 物流运输优化
    • ¥15 Tableau online 嵌入ppt失败
    • ¥100 支付宝网页转账系统不识别账号
    • ¥15 基于单片机的靶位控制系统
    • ¥15 真我手机蓝牙传输进度消息被关闭了,怎么打开?(关键词-消息通知)
    • ¥15 装 pytorch 的时候出了好多问题,遇到这种情况怎么处理?
    • ¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本
    • ¥15 手机接入宽带网线,如何释放宽带全部速度