html 可编辑表格插件,jquery可编辑表格插件

function runSQL($rsql) {

$connect = mysql_connect($hostname,$username,$password) or die ("Error: could not connect to database");

$db = mysql_select_db($dbname);

$result = mysql_query($rsql) or die ('test');

return $result;

mysql_close($connect);

}

function countRec($fname,$tname) {

$sql = "SELECT count($fname) FROM $tname ";

$result = runSQL($sql);

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

return $row[0];

}

}

$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";

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

$result = runSQL($sql);

$total = countRec('iso','country');

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/xml");

$xml = "<?xml version=\"1.0\" encoding=\"utf-8\"?>\n";

$xml .= "";

$xml .= "$page";

$xml .= "$total";

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

$xml .= "";

$xml .= "";

$xml .= "";

$xml .= "";

$xml .= "";

$xml .= "";

$xml .= "";

}

$xml .= "";

echo $xml;