Advertisement
joeaffos

Region, Province, City Dropdown

Jul 12th, 2015
263
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.47 KB | None | 0 0
  1. <div id="col_region" class="col_loc_selected form-group" data-location="region" >
  2.     <label class="col-sm-2 control-label">Region</label>
  3.     <div class="col-sm-10 input-group" style="padding-left: 15px;">
  4.         <select name="region" class="form-control chosen-select" id="region" onchange="" multiple style="width:850px;" tabindex="4" data-placeholder="Select Regions">
  5.                 <?php
  6.                 $sql_region=query("SELECT * FROM tbl_region ORDER BY name ASC");
  7.                 $num=NumRows($sql_region);
  8.                 while($row=fetchAssoc($sql_region)){
  9.                 ?>
  10.                     <option value="<?php echo $row['r_id'];?>">
  11.                     <?php echo utf8_encode($row['name']); ?></option>
  12.                 <?php
  13.                  }
  14.                 ?>
  15.         </select>
  16.     </div>
  17. </div>
  18. <div id="col_province" class="col_loc_selected form-group" data-location="province" >
  19.     <label class="col-sm-2 control-label">Province</label>
  20.     <div class="col-sm-10 input-group" style="padding-left: 15px;">
  21.         <select name="province" class="form-control chosen-select" id="province" onchange="" multiple style="width:850px;" tabindex="4" data-placeholder="Select Provinces">
  22.                 <?php
  23.                 $sql_province=query("SELECT * FROM tbl_province ORDER BY name ASC");
  24.                 $num=NumRows($sql_province);
  25.                 while($row=fetchAssoc($sql_province)){
  26.                 ?>
  27.                     <option value="<?php echo $row['pt_id'];?>">
  28.                     <?php echo utf8_encode($row['name']); ?></option>
  29.                 <?php
  30.                  }
  31.                 ?>
  32.         </select>
  33.     </div>
  34. </div>
  35. <div id="col_city" class="col_loc_selected form-group" data-location="city" >
  36.     <label class="col-sm-2 control-label">City/Town</label>
  37.     <div class="col-sm-10 input-group" style="padding-left: 15px;">
  38.         <select name="city" class="form-control chosen-select" id="city" onchange="" multiple style="width:850px;" tabindex="4" data-placeholder="Select Cities / Towns">
  39.                 <?php
  40.                 $sql_city=query("SELECT * FROM tbl_city ORDER BY name ASC");
  41.                 $num=NumRows($sql_city);
  42.                 while($row=fetchAssoc($sql_city)){
  43.                 ?>
  44.                     <option value="<?php echo $row['ct_id'];?>">
  45.                     <?php echo utf8_encode($row['name']); ?></option>
  46.                 <?php
  47.                  }
  48.                 ?>
  49.         </select>
  50.     </div>
  51. </div>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement