public function data() { //data feed $this->load->database(); $connector = new GridConnector($this->db, "phpCI"); $connector->configure("events", "event_id", "start_date, end_date, event_name"); $connector->event->attach($this); $connector->render(); }
public function data() { //data feed $this->load->database(); $this->load->model("event_model"); $connector = new GridConnector($this->db, "PHPCI"); $connector->configure("events", "event_id", "start_date, end_date, event_name"); $connector->useModel($this->event_model); $connector->render(); }
<?php require_once '../../../codebase/grid_connector.php'; require_once '../../config.php'; $res = mysql_connect($mysql_server, $mysql_user, $mysql_pass); mysql_select_db($mysql_db); $grid = new GridConnector($res); $grid->enable_log("sql.log"); $grid->configure("grid50000", "item_id", "item_nm,item_cd"); $sql = $grid->sql; echo $id = $grid->insert(array("item_nm" => "1", "item_cd" => Null)); echo "<hr>"; $sql->query("SELECT * FROM grid50000 WHERE item_id=" . $id); print_r($sql->get_next()); echo "<hr>"; echo $grid->update(array("item_id" => $id, "item_nm" => "2")); echo "<hr>"; $sql->query("SELECT * FROM grid50000 WHERE item_id=" . $id); print_r($sql->get_next()); echo "<hr>"; echo $grid->delete($id); echo "<hr>"; $sql->query("SELECT * FROM grid50000 WHERE item_id=" . $id); print_r($sql->get_next() == Null);