oGrid/getJSON_DB2.php at master · babydragoner/oGrid · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
<?php
header('Access-Control-Allow-Origin: *');
header('Access-Control-Allow-Methods: POST, GET');


class Item
{
	public $Id;
	public $WebSite;
	public $Description;
	public $CreUser;
	public $CreDate;
}
require_once("./util/Common.php");
require_once("./db/DB_config.php");
require_once("./db/DB_Class.php");

$type = $_GET["type"];;
$page = isset($_POST['page']) ? intval($_POST['page']) : 0;
$rows = isset($_POST['rows']) ? intval($_POST['rows']) : 10;
$sort = isset($_POST['sort']) ? strval($_POST['sort']) : "";
$offset = ($page)*$rows;
if($sort != "")
{
	$sort = "Order By $sort";
}
$sql = "SELECT * FROM TestItem";
$sql = $sql." $sort limit $offset,$rows";

$db = new DB();
$db->connect_db($_DB['host'], $_DB['username'], $_DB['password'], $_DB['dbname']);
$res = $db->query($sql);
if($res == "true"){
	$items = array();
	while($row = $db->fetch_assoc()){
		array_push($items, $row);
	}
}else{
	echo get_class($this)."->".__FUNCTION__." at ".__LINE__." => $res";
}

//$result["total"] = 30;
$result["rows"] = $items;
$result["msg"] = '';

if($type == "init")
{
	$columns = array();
	$col = new column("Id", "No");
	$col->editor = "text";
	$col->width = "60px";
	array_push($columns, $col);
	$col = new column("WebSite", "Your WebSite");
	$col->editor = "text";
	$col->sortable = true;
	array_push($columns, $col);
	$col = new column("Description", "Description");
	$col->editor = "text";
	$col->sortable = true;
	$col->width = "200px";
	array_push($columns, $col);
	$col = new column("CreUser", "Your Name");
	$col->editor = "text";
	$col->sortable = true;
	array_push($columns, $col);
	$col = new column("CreDate", "The Date");
	$col->editor = "date";
	$col->sortable = true;
	array_push($columns, $col);
	$result["columns"] = $columns;
}

echo json_encode($result);

?>