public function find_category() { $db = new data_base(tpl_category::category(), array(tpl_category::id(), tpl_category::active(), tpl_category::name()), array(tpl_category::active() => 1)); $data = $db->get_where(); $w = ''; foreach ($data as $row) { $w = $w . '<option value="' . $row[tpl_category::id()] . '">' . $row[tpl_category::name()] . '</option>'; } return $w; }
public function update() { $id = $_POST[tpl_category::category() . '_' . tpl_category::id() . '_update']; $name = $_POST[tpl_category::category() . '_' . tpl_category::name() . '_update']; $db = new data_base(tpl_category::category(), array(tpl_category::name() => $name, tpl_category::date() => date_time::Date_time_24()), array(tpl_category::id() => $id)); $results = $db->change(); if ($results) { echo json_encode(array('valid' => 1, 'title' => 'Successfully !!', 'massage' => 'I\'ve been Update ' . $name)); } else { echo json_encode(array('valid' => 0, 'title' => 'Oops !!', 'massage' => 'Was not Update ' . $name . ', please try again')); } }
public function ajax_companies() { $db = new data_base(tpl_companies::companies(), array(tpl_companies::id(), data_base::select_multiple_table(tpl_category::category(), tpl_category::category() . '.' . tpl_category::id(), tpl_companies::companies() . '.' . tpl_companies::id_category(), tpl_category::name(), tpl_category::category() . '_' . tpl_category::name()), tpl_companies::name()), array(tpl_companies::active() => 1)); echo json_encode($db->get_where()); }
echo tpl_category::category() . '_' . tpl_category::id() . '_update'; ?> "/> </div> <div class="form-group"> <label for=""><?php echo tpl_category::name() . ' ' . tpl_category::category(); ?> : </label> <input type="text" class="form-control" id="<?php echo tpl_category::category() . '_' . tpl_category::name() . '_update'; ?> " name="<?php echo tpl_category::category() . '_' . tpl_category::name() . '_update'; ?> "/> </div> <button type="submit" class="btn btn-success" id="update" name="update">Save</button> </form> </br> </br> <div class="" id="result_massages_update"></div> </div> </div> </div> </div>
<table id="tpl_category" data-toggle="table" data-url="<?php echo site_url('admin/home/ajax_category'); ?> " data-cache="false" data-height="400" data-show-refresh="true" data-show-toggle="true" data-show-columns="true" data-pagination="true" data-page-list="[5, 10, 20, 50, 100, 200]" data-search="true" data-flat="true"> <thead> <tr> <th data-field="<?php echo tpl_category::id(); ?> " data-halign="center" data-sortable="true"> ID</th> <th data-field="<?php echo tpl_category::name(); ?> " data-halign="center" data-sortable="true"> Name </th> </tr> </thead> </table> </div> </div> <div class="col-sm-4"> <h3 class="page-header">college</h3> <div class="table-responsive"> <table id="tpl_college" data-toggle="table" data-url="<?php echo site_url('admin/home/ajax_college'); ?>