CodeThatGrid - Data saving at the database
<php
function my_split($buffer)
{
$length = strlen($buffer);
$i = 0;
while ($length > = 1)
{
$pos2 = strpos($buffer, ';');
if (!$pos2)
{
$fields[$i] = $buffer;
$length = - 1;
}
else
{
$fields[$i] = substr($buffer, 0, $pos2);
$buffer = substr($buffer, ($pos2 + 1));
$length = strlen($buffer);
}
$i++;
}
return $fields;
}
if ($dbsave)
{
if (!$csv)
{
print_error("You should click 'Export Data'
button before save data on server.");
}
else
{
$pos1 = 0;
$pos2 = 1;
while ($pos2)
{
$pos2 = strpos($csv, "\r\n");
$buffer = substr($csv, $pos1, $pos2);
$csv = substr($csv, ($pos2 + 1));
if (!$buffer) $buffer = $csv;
$fields = my_split($buffer);
$name = $fields[1];
$dt = $fields[2];
$kind = $fields[3];
$sql = "insert into test_data2 (username, regdate, kind) " .
"values('$name', '$dt', $kind)";
$result = db_query($sql);
$Error = mysql_error($db);
if ($Error != "")
{
print_error($Error);
}
}
echo"<p>All CodeThatGrid data have been successfully " .
"stored at the server database!";
}
}
?>
<HEAD>
<link href="/common_codethat.css" rel="stylesheet" type="text/css">
<link rel="stylesheet" href="style.css">
<script language="javascript1.2" src="codethatsdk.js"></script>
<script language="javascript" src="codethattype.js"></script>
<script language="javascript" src="codethatgridpro.js"></script>
<script language="javascript" src="content.js"></script>
<link rel="stylesheet" href="style.css">
</head>
<body>
<script language="javascript1.2">
<!--
var g = new CCodeThatGrid("g", 5, 6);
g.init(gridDef);
g.doAction();
//-->
</script>
<DIV id=ebg style="TOP: 548px">
<FORM name=exportForm method=post>
<BR>
<TEXTAREA style="OVERFLOW: auto; WIDTH: 660px" name=csv
rows=15 cols=90 onselect="g.clip = this.value;">
</TEXTAREA>
<BR><BR><INPUT onclick="exportForm.csv.value = g.toCSV()"
type=button value="Export Data">
| <INPUT name=dbsave type=submit value="Save on server DB">
</FORM>
</DIV>
</BODY>
</HTML>
|