It’s also possible to use JSON string as a data source with one extra step: use json_decode and set the second parameter to true to return the decoded JSON string to an associative array.
Once you have the array, it can be passed to the phpGrid constructor as if it’s a local array data source. This is useful when your data is real-time or loaded from a remote source such as stock quote and RSS etc.
1 2 3 4 5 6 | $url = "http://myurl.com/json_string"; $json = file_get_contents($url); $json_output = json_decode($json, true); $dg = new C_DataGrid($json_output['items'], "id", "items"); $dg -> display(); |
Load Stored Procedure with OUT parameter
Tip: sp() function is your friend
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 | use phpCtrl\C_DataGrid; use phpCtrl\C_DataBase; require_once("/file/path/to/conf.php"); $db = new C_DataBase(PHPGRID_DB_HOSTNAME, PHPGRID_DB_USERNAME, PHPGRID_DB_PASSWORD, PHPGRID_DB_NAME, PHPGRID_DB_TYPE,PHPGRID_DB_CHARSET); $results = $db->sp('CALL GetOrderCountByStatus(?, @total)', 'Shipped'); $data = $db->db_query("SELECT @total"); // create PHP array from results returned by stored proc $data1 = []; $count = 0; while($row = $db->fetch_array_assoc($data)) { $data_row = array(); for($i = 0; $i < $db->num_fields($data); $i++) { $col_name = $db->field_name($data, $i); $data1[$count][$col_name] = $row[$col_name]; } $count++; } $dg = new C_DataGrid($data1, "id", "data1"); $dg -> display(); |
Create Array from Database Table
Learn how to create array from database from Complex Query tutorial.
Save local array back to database
It’s possible to save local array data back into a relational DB. The technique uses a local array as indirect mean to edit complex database query with JOINS, UNION etc. See KB: Save local array back to database via Ajax