<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                <ruby id="bdb3f"></ruby>

                合規國際互聯網加速 OSASE為企業客戶提供高速穩定SD-WAN國際加速解決方案。 廣告
                ## html ``` <form enctype="multipart/form-data" action="/web/merchant.php?c=site&a=entry&m=ewei_shopv2&do=web&r=goods.daoru" method="post"> <div style="display: flex;"> <input type="file" name="myfile" /> <input type="submit" class='btn btn-sm btn-primary' value="導入商品" /> </div> </form> ``` ## php ``` public function daoru() { global $_W; global $_GPC; require_once IA_ROOT . '/framework/library/phpexcel/PHPExcel.php'; require_once IA_ROOT . '/framework/library/phpexcel/PHPExcel/IOFactory.php'; require_once IA_ROOT . '/framework/library/phpexcel/PHPExcel/Reader/Excel5.php'; $objReader = PHPExcel_IOFactory::createReader('Excel5'); //接收存在緩存中的excel表格 $filename = $_FILES['myfile']['tmp_name']; $objPHPExcel = $objReader->load($filename); //$filename可以是上傳的表格,或者是指定的表格 $sheet = $objPHPExcel->getSheet(0); $highestRow = $sheet->getHighestRow(); // 取得總行數 $highestColumn = $sheet->getHighestColumn(); // 取得總列數 //循環讀取excel表格,讀取一條,插入一條 //j表示從哪一行開始讀取 從第二行開始讀取,因為第一行是標題不保存 //$a表示列號 for($j=2;$j<=$highestRow;$j++) { $h1 = $objPHPExcel->getActiveSheet()->getCell("B".$j)->getValue();//獲取B(密碼)列的值 $h2 = $objPHPExcel->getActiveSheet()->getCell("C".$j)->getValue();//獲取B(密碼)列的值 $h3 = $objPHPExcel->getActiveSheet()->getCell("D".$j)->getValue();//獲取B(密碼)列的值 $h4 = $objPHPExcel->getActiveSheet()->getCell("E".$j)->getValue();//獲取B(密碼)列的值 $h5 = $objPHPExcel->getActiveSheet()->getCell("F".$j)->getValue();//獲取B(密碼)列的值 $h6 = $objPHPExcel->getActiveSheet()->getCell("G".$j)->getValue();//獲取B(密碼)列的值 $h7 = $objPHPExcel->getActiveSheet()->getCell("H".$j)->getValue();//獲取B(密碼)列的值 $h8 = $objPHPExcel->getActiveSheet()->getCell("I".$j)->getValue();//獲取B(密碼)列的值 $h9 = $objPHPExcel->getActiveSheet()->getCell("J".$j)->getValue();//獲取B(密碼)列的值 $h10 = $objPHPExcel->getActiveSheet()->getCell("K".$j)->getValue();//獲取B(密碼)列的值 $h11 = $objPHPExcel->getActiveSheet()->getCell("L".$j)->getValue();//獲取B(密碼)列的值 $h12 = $objPHPExcel->getActiveSheet()->getCell("M".$j)->getValue();//獲取B(密碼)列的值 $h13 = $objPHPExcel->getActiveSheet()->getCell("N".$j)->getValue();//獲取B(密碼)列的值 $h14 = $objPHPExcel->getActiveSheet()->getCell("O".$j)->getValue();//獲取B(密碼)列的值 $h15 = $objPHPExcel->getActiveSheet()->getCell("P".$j)->getValue();//獲取B(密碼)列的值 $h16 = $objPHPExcel->getActiveSheet()->getCell("Q".$j)->getValue();//獲取B(密碼)列的值 $h17 = $objPHPExcel->getActiveSheet()->getCell("R".$j)->getValue();//獲取B(密碼)列的值 $h18 = $objPHPExcel->getActiveSheet()->getCell("S".$j)->getValue();//獲取B(密碼)列的值 $h19 = $objPHPExcel->getActiveSheet()->getCell("T".$j)->getValue();//獲取B(密碼)列的值 $h20 = $objPHPExcel->getActiveSheet()->getCell("U".$j)->getValue();//獲取B(密碼)列的值 $h21 = $objPHPExcel->getActiveSheet()->getCell("V".$j)->getValue();//獲取B(密碼)列的值 $h22 = $objPHPExcel->getActiveSheet()->getCell("W".$j)->getValue();//獲取B(密碼)列的值 $h23 = $objPHPExcel->getActiveSheet()->getCell("X".$j)->getValue();//獲取B(密碼)列的值 $h24 = $objPHPExcel->getActiveSheet()->getCell("Y".$j)->getValue();//獲取B(密碼)列的值 $h25 = $objPHPExcel->getActiveSheet()->getCell("Z".$j)->getValue();//獲取B(密碼)列的值 $user_data = array( 'uniacid' => $h1, 'pcate' => $h2, 'ccate' => $h3, 'type' => $h4, 'status' => $h5, 'title' => $h6, 'thumb' => $h7, 'content' => $h8, 'productprice' => $h9, 'marketprice' => $h10, 'costprice' => $h11, 'originalprice' => $h12, 'total' => $h13, 'createtime' => $h14, 'weight' => $h15, 'maxprice' => $h16, 'minprice' => $h17, 'cates' => $h18, 'hasoption' => $h19, 'thumb_url' => $h20, 'isverify' => $h21, 'tcate' => $h22, 'discounts' => $h23, 'tcates' => $h24, 'keywords' => $h25, 'merchid'=> $_W['merchid'] ); $result = pdo_insert('ewei_shop_goods', $user_data); } echo "<script>alert('導入完成!!!');</script>"; header('Location: /web/merchant.php?c=site&a=entry&m=ewei_shopv2&do=web&r=goods'); } ```
                  <ruby id="bdb3f"></ruby>

                  <p id="bdb3f"><cite id="bdb3f"></cite></p>

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                              <ruby id="bdb3f"></ruby>

                              哎呀哎呀视频在线观看