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');
?>