<input type="hidden" name="img_url" id="image_url"> <span id="upd_pics" name=""></span> <input type="file" name="file" id="file_image"/> <span id="loading_image" style="display:none;"> <img src="../images/loading.gif" alt="loading..."> </span> <span id="logo_image"></span> <input type="button" value="上传" onclick="return ajaxFileUpload('image');" class="btn btn-large btn-primary" />(*海报尺寸:500*500以内) </p> <br> 商场地址: <select name="province" id="province" onchange="obtain_city(this.value)"> <?php $sql = "select province_name from county group by province_name"; $provinces = $sqlhelper->execute_more($sql); for ($i = 0; $i < count($provinces); $i++) { ?> <option value="<?php echo $provinces[$i]['province_name']; ?> "><?php echo $provinces[$i]['province_name']; ?> </option> <?php } ?> </select> 市:
<?php include_once '../../conn/sqlHelper.php'; $sqlhelper = new sqlHelper(); $province_name = $_POST['province_name']; $city_name = $_POST['city_name']; $sql = "select county_name,county_code from county where province_name='" . $province_name . "' and city_name='" . $city_name . "'"; $arr = $sqlhelper->execute_more($sql); $data = json_encode($arr); echo $data;
<input type="hidden" name="img_url" id="image_url"> <span id="upd_pics" name=""></span> <input type="file" name="file" id="file_image"/> <span id="loading_image" style="display:none;"> <img src="../images/loading.gif" alt="loading..."> </span> <span id="logo_image"></span> <input type="button" value="上传" onclick="return ajaxFileUpload('image');" class="btn btn-large btn-primary" />(*LOGO尺寸:289*110以内) </p> <br> 商场地址: <select name="province" id="province" onchange="obtain_city(this.value)"> <?php $sql = "select province_name from county group by province_name"; $provinces = $sqlhelper->execute_more($sql); for ($i = 0; $i < count($provinces); $i++) { ?> <option value="<?php echo $provinces[$i]['province_name']; ?> " <?php echo $province == $provinces[$i]['province_name'] ? "selected" : ""; ?> ><?php echo $provinces[$i]['province_name']; ?> </option> <?php } ?>