查看文件: add_streetshop.php
大小: 11.13 KB
类型: application/octet-stream
<?php require('system/login.php'); ?> <?php require_once('../Connections/BE2.php'); ?> <?php if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) { $wwwpath='/www2/skybni'; $picpath= "/number_jpg/c_".$_POST['si10b']; $spicpath= "/number_jpgs/c_".$_POST['si10b']; $tfile="fileToUpload1"; $wimgext=''; $img_ext_array=array("jpg","jpeg","png","gif"); if($_FILES[$tfile]["name"]<>''){ $ext= explode('.',$_FILES[$tfile]['name']) ; $imgext=strtolower($ext[count($ext)-1]); //取最後一筆 if(in_array($imgext,$img_ext_array)){ $spic=$wwwpath.$spicpath.".".$imgext; move_uploaded_file($_FILES[$tfile]["tmp_name"],$spic); $chk_file=true; while($chk_file) { if (file_exists($spic)){ $chk_file=false; } } //$pic=$wwwpath.$picpath.".".$imgext; $picn=$wwwpath.$spicpath.".png"; //$extension = strtolower(pathinfo($filename, PATHINFO_EXTENSION)); switch ($imgext) { case 'jpg': case 'jpeg': $image = imagecreatefromjpeg($spic); break; case 'gif': $image = imagecreatefromgif($spic); break; case 'png': $image = imagecreatefrompng($spic); break; } imagepng($image, $picn); $chk_file=true; $c=time()+10; $ff=0; while($chk_file) { if (file_exists($picn)){ $ff=1; $chk_file=false; } $c1=time(); if($c1>$c){ $chk_file=false; } } if($ff>0){ $repic ='/www2/skybni/number_jpg/c_'.$_POST['si10b'].".png"; $syscall_3b="/usr/local/bin/convert $picn -resize 100x100 -size 100x100 xc:white +swap -gravity center -composite $repic"; $output2=`$syscall_3b`; } } } $updateSQL = sprintf("INSERT INTO shop5 (si5,si6,si11,si12,si13,si14,address_id)VALUES(%s,%s,%s,%s,%s,%s,%s)", GetSQLValueString($_POST['si5'], "text"), GetSQLValueString($_POST['si6'], "text"), GetSQLValueString($_POST['si11'], "text"), GetSQLValueString($_POST['si12'], "text"), GetSQLValueString($_POST['si13'], "text"), GetSQLValueString($_POST['si14'], "text"), GetSQLValueString($_POST['address_id'], "int") ); mysql_select_db($database_BE2, $BE2); $Result1 = mysql_query($updateSQL, $BE2) or die(mysql_error()); $write='資料已更新...'; $updateGoTo = $_POST["url"]; // echo $upSQL; // header(sprintf("Location: %s", $updateGoTo)); echo "<script>alert('".$write."');location.href='".$updateGoTo."';</script>"; } mysql_select_db($database_BE2, $BE2); // address_id county district street $query_Rot2 = "SELECT distinct(county) FROM address where 1 order by county"; $Rot2 = mysql_query($query_Rot2, $BE2) or die(mysql_error()); $row_Rot2 = mysql_fetch_assoc($Rot2); $totalRows_Rot2 = mysql_num_rows($Rot2); $county=$row_Rot2['county']; mysql_select_db($database_BE2, $BE2); // address_id county district street $query_Rat2 = sprintf("SELECT distinct(district) FROM address where county='%s' order by district",$county); $Rat2 = mysql_query($query_Rat2, $BE2) or die(mysql_error()); $row_Rat2 = mysql_fetch_assoc($Rat2); $totalRows_Rat2 = mysql_num_rows($Rat2); $district=$row_Rat2['district']; mysql_select_db($database_BE2, $BE2); // address_id county district street $query_Rbt2 = sprintf("SELECT address_id,street FROM address where county='%s' AND district='%s' order by street",$county, $district); $Rbt2 = mysql_query($query_Rbt2, $BE2) or die(mysql_error()); $row_Rbt2 = mysql_fetch_assoc($Rbt2); $totalRows_Rbt2 = mysql_num_rows($Rbt2); $street=$row_Rbt2['street']; ?> <form action="" method="post" name="form1" id="form1" enctype="multipart/form-data"> <table width="802" align="center"> <tr valign="baseline"> <td height="22" align="right" nowrap> </td> <td> </td> <td> </td> </tr> <tr valign="baseline"> <td width="98" align="right" nowrap><span class="font2">商店名稱：</span></td> <td width="517"><input name="si5" type="text" class="form-control g-color-black g-bg-white g-bg-white--focus g-brd-gray-light-v4 g-brd-primary--hover rounded g-py-10 g-px-15" id="si5" placeholder="商店名稱" value="" maxlength="4" /> <input type="button" value="尋找商店 ID" onclick="showshop()" /></td> <td width="11"> </td> </tr> <tr valign="baseline"> <td nowrap align="right"><span class="font2">商店ID：</span></td> <td><input id="si10b" name="si10b" type="text" required="required" class="form-control g-color-black g-bg-white g-bg-white--focus g-brd-gray-light-v4 g-brd-primary--hover rounded g-py-10 g-px-15" placeholder="必須有ID" readonly="readonly"/></td> <td> </td> </tr> <tr valign="baseline"> <td nowrap align="right"><span class="font2">公司地址：</span></td> <td><select name="city" id="city" class="form-control placeholder col-xs-12 col-sm-4 mb-4" onchange="Selectcity()"> <? do { ?> <option value="<?= $row_Rot2['county']; ?>" <?= ($row_Rot2['county']==$county)?'selected="selected"':""; ?>> <?= $row_Rot2['county']; ?> </option> <?php } while ($row_Rot2 = mysql_fetch_assoc($Rot2)); ?> </select> </td> <td> </td> </tr> <tr valign="baseline"> <td nowrap align="right"> </td> <td><select name="district" id="district" class="form-control placeholder col-xs-12 col-sm-4 mb-4" onchange="Selectstreet();"> <? do { ?> <option value="<?= $row_Rat2['district']; ?>" <?= ($row_Rat2['district']==$district)?'selected="selected"':""; ?>> <?= $row_Rat2['district']; ?> </option> <?php } while ($row_Rat2 = mysql_fetch_assoc($Rat2)); ?> </select></td> <td> </td> </tr> <tr valign="baseline"> <td nowrap align="right"> </td> <td><select name="street" id="street" class="form-control placeholder col-xs-12 col-sm-4 mb-4" onchange="show_id()"> <? do { ?> <option value="<?= $row_Rbt2['address_id']; ?>" <?= ($row_Rbt2['street']==$street)?'selected="selected"':""; ?>> <?= $row_Rbt2['street']; ?> </option> <?php } while ($row_Rbt2 = mysql_fetch_assoc($Rbt2)); ?> </select></td> <td> </td> </tr> <tr valign="baseline"> <td nowrap align="right"><span class="font2">巷：</span></td> <td><input id="si11" name="si11" type="text" class="form-control g-color-black g-bg-white g-bg-white--focus g-brd-gray-light-v4 g-brd-primary--hover rounded g-py-10 g-px-15" placeholder="請輸入巷" value="" /></td> <td> </td> </tr> <tr valign="baseline"> <td nowrap align="right"><span class="font2">弄：</span></td> <td><input id="si2" name="si2" type="text" class="form-control g-color-black g-bg-white g-bg-white--focus g-brd-gray-light-v4 g-brd-primary--hover rounded g-py-10 g-px-15" placeholder="請輸入弄" value="" /></td> <td> </td> </tr> <tr valign="baseline"> <td nowrap align="right"><span class="font2">號：</span></td> <td><input id="si13" name="si13" type="text" required="required" class="form-control g-color-black g-bg-white g-bg-white--focus g-brd-gray-light-v4 g-brd-primary--hover rounded g-py-10 g-px-15" placeholder="請輸入路號" value="" onchange="show_id()"/> 號</td> <td> </td> </tr> <tr valign="baseline"> <td nowrap align="right"><span class="font2">樓：</span></td> <td><input id="si14" name="si14" type="text" class="form-control g-color-black g-bg-white g-bg-white--focus g-brd-gray-light-v4 g-brd-primary--hover rounded g-py-10 g-px-15" placeholder="請輸入之樓號" value="" onchange="show_id()"/> 樓 </td> <td> </td> </tr> <tr valign="baseline"> <td height="36" align="right" nowrap> </td> <td><input name="si6" type="text" id="si6" value="" size="60" readonly="readonly" /></td> <td> </td> </tr> <tr valign="baseline"> <td nowrap align="right"><span class="font2"><img src="/number_jpg/c_6.png" width="100" height="100" /> </span></td> <td><input name="fileToUpload1" type="file" id="fileToUpload1" /> PS 圖: 100px X 100px PNG,JPG</td> <td> </td> </tr> <tr valign="baseline"> <td nowrap align="right"> </td> <td><input type="hidden" name="MM_update" value="form1" /> <input name="url" type="hidden" id="url" value="<?php echo $_SERVER['HTTP_REFERER']; ?>" /> <input id="address_id" name="address_id" type="hidden" value="" readonly="readonly" /></td> <td> </td> </tr> <tr valign="baseline"> <td nowrap align="right"> </td> <td><input type="submit" value="更新記錄" /></td> <td> </td> </tr> </table> </form> <script> function Selectstreet() { var county= $("#city").val(); // $(city).find(':selected')[0].id; var district = $("#district").val(); //.find(':selected')[0].id; $.ajax({ type: 'POST', url: 'SelectstreetApi.php', data: { 'county': county,'district':district }, success: function (data) { // the next thing you want to do var $street = $('#street'); $street.empty(); $("select#street").html(data); } }); } function Selectcity() { var county= $("#city").val(); // $(city).find(':selected')[0].id; $.ajax({ type: 'POST', url: 'SelectcityApi.php', data: {'county': county}, success: function (data) { // the next thing you want to do var $street = $('#street'); $street.empty(); var $district = $('#district'); $district.empty(); $("select#district").html(data); Selectstreet(); } }); } function show_id(){ //var s=$('#city').find(":selected").text(); var s=$('#city').val() +$('#district').val()+$.trim($('#street').find(":selected").text()); //$('#aioConceptName :selected').text(); // var county= $("#city").val(); s=s+$('#si13').val()+'號'; if($('#si14').val()!=''){ s=s+$('#si14').val()+'樓'; } $('#si6').val(s); $('#address_id').val($('#street').val()); // alert(1); } function showshop(){ // alert(1); var s=$('#si5').val(); $.ajax({ type: 'POST', url: 'SelectcompanyId.php', data: { 'company_title': s }, success: function (data) { // the next thing you want to do if(data>0){ $("#si10b").val(data); alert('找到 ID ..') } else { alert('找不到 ID :'+s); }; } }); } </script> <?php mysql_free_result($Rot2); mysql_free_result($Rat2); mysql_free_result($Rbt2); ?>
保存
取消
返回文件列表