flexgrid (sql자동 생성툴 화면 아이디어)

http://www.flexigrid.info/

$page = $_POST['page'];

$rp = $_POST['rp'];

$sortname = $_POST['sortname'];

$sortorder = $_POST['sortorder'];

if (!$sortname) $sortname = 'name';

if (!$sortorder) $sortorder = 'desc';

$sort = "ORDER BY $sortname $sortorder";

if (!$page) $page = 1;

if (!$rp) $rp = 10;

$start = (($page-1) * $rp);

$limit = "LIMIT $start, $rp";

$query = $_POST['query'];

$qtype = $_POST['qtype'];

$where = "";

if ($query) $where = " WHERE $qtype LIKE '%$query%' ";

$sql = "SELECT iso,name,printable_name,iso3,numcode FROM country $where $sort $limit";

$result = runSQL($sql);

$total = countRec("iso","country $where");

header("Expires: Mon, 26 Jul 1997 05:00:00 GMT" );

header("Last-Modified: " . gmdate( "D, d M Y H:i:s" ) . "GMT" );

header("Cache-Control: no-cache, must-revalidate" );

header("Pragma: no-cache" );

header("Content-type: text/x-json");

$json = "";

$json .= "{\n";

$json .= "page: $page,\n";

$json .= "total: $total,\n";

$json .= "rows: [";

$rc = false;

while ($row = mysql_fetch_array($result)) {

if ($rc) $json .= ",";

$json .= "\n{";

$json .= "id:'".$row['iso']."',";

$json .= "cell:['".$row['iso']."'";

$json .= ",'".addslashes($row['name'])."'";

$json .= ",'".addslashes($row['printable_name'])."'";

$json .= ",'".addslashes($row['iso3'])."'";

$json .= ",'".$row['numcode']."']";

$json .= "}";

$rc = true;

}

$json .= "]\n";

$json .= "}";

echo $json;

?>