示例#1
0
         return $result;
     }
     function get_collection()
     {
         $sql = "SELECT * FROM `tbl_gender` ORDER BY `gender_order` DESC";
         $query = $this->conn->query($sql);
         $row = array();
         while ($result = $query->fetch_object()) {
             array_push($row, $result);
         }
         return $row;
     }
 }
 $_ajax = new AJAX_CLASS();
 $count = $_ajax->count_collection();
 $data = $_ajax->get_collection();
 $product_id = filter_var($_POST['product_id'], FILTER_SANITIZE_NUMBER_INT);
 $_data = $_ajax->data_collection($product_id);
 echo '<li class="form-group row" id="id-row-collection">';
 echo '<label class="col-xs-3 control-label" for="sizegroup">Gender</label>';
 echo '<div class="col-xs-9">';
 echo '<select class="form-control" id="id-collection" name="gender">';
 echo '<option value="">-- Select Gender --</option>';
 foreach ($data as $data) {
     echo '<option value="' . $data->gender_id . '" ';
     if ($_data->product_gender == $data->gender_id) {
         echo 'selected="selected"';
     }
     echo '>' . $data->gender_name . '</option>';
 }
 echo '</select>';