function ajax_add_table()
{
$table_name = $_POST['table_name'];
$column_info = $_POST['column_info'];
$unique_key = $_POST['unique_key'];
return_and_finish(add_table($table_name, $column_info, $unique_key));
}
</head>
<body>
<?php
header('Content-type: text/html; charset=utf-8');
include "config.inc.php";
include "dbconnect.php";
include "function.inc.php";
error_reporting(0);
$add_table = $_POST["addtname"];
$table_field = $_POST["addtfield"];
$dele_table = $_POST["deletname"];
if ($dele_table != '') {
dele_table($dele_table);
}
if ($add_table != '' && $table_field != '') {
add_table($add_table, $table_field);
}
$device_data = get_allDevice_data();
//echo "<pre>";
//print_r($device_data);
//echo "<br>";
function add_table($add_table, $table_field)
{
$sql = "insert into device (表名,字段名) values('{$add_table}','{$table_field}')";
if (!mysql_query($sql)) {
die("添加表失败" . mysql_error());
}
}
function dele_table($dele_table)
{
$sql = "delete from device where 表名=" . $dele_table;
<div class="result collection">
<?php
$dbname = $_GET["db-name"];
if ($tablename = $_POST["table"]) {
if ($result = add_table($connection, $tablename, $dbname)) {
echo "<h5>La table " . $tablename . " a bien été créée</h5>";
echo "<p> Redirection ... </p>";
?>
<meta http-equiv="refresh" content="2; url=index.php?action=tablecontents&db-name=<?php
echo $dbname;
?>
&table-name=<?php
echo $tablename;
?>
"/>
<div class="preloader-wrapper active">
<div class="spinner-layer spinner-red-only">
<div class="circle-clipper left">
<div class="circle"></div>
</div><div class="gap-patch">
<div class="circle"></div>
</div><div class="circle-clipper right">
<div class="circle"></div>
</div>
</div>
</div>
<?php
} else {
echo "<h5>La table n'a pas pu être créée</h5>";
echo "<p> Redirection ... </p>";
?>
if (!$dbc) {
die('NOT CONNECTED:' . mysql_error());
}
$db_selected = mysql_select_db("restaurant", $dbc);
if (!$db_selected) {
die('NOT CONNECTED TO DATABASE:' . mysql_error());
}
$check = "SELECT * from `TABLES` WHERE Table_Number={$table_num}";
$result = mysql_query($check);
$num_items = mysql_num_rows($result);
if ($num_items) {
echo "<script type=\"text/javascript\">" . "\n";
echo "alert(\"Table Number Already Exists!!!\");" . "\n";
echo "</script>" . "\n";
return;
}
$items = "\"" . $table_num . "\",\"" . $details . "\"";
$query = "insert into `TABLES`(`Table_Number`,`Details`)values (" . $items . ");";
$result = mysql_query($query);
echo "<script type=\"text/javascript\">" . "\n";
echo "alert(\"New Table Added!!!\");" . "\n";
echo "</script>" . "\n";
}
add_table($_POST["Table_Number"], $_POST["Details"]);
?>
</script>
<body background = "1.png">
<meta HTTP-EQUIV="REFRESH" content="0; url=admin.html">
</body>
</html>
if ($addcol_datatype == 'table') {
$jsfiles[] = './includes/js/tablemanage.js';
}
// Except for ajax requests, we'll send the general headers now
if (!isset($_POST['jsrequest'])) {
printheader($httptitle, false, $jsfiles);
}
if (!($permissions & $SUPER || $permissions & $TABLECREATOR)) {
navbar($USER['permissions']);
echo "<h3 align='center'><b>Sorry, this page is not for you</B></h3>";
printfooter($db, $USER);
exit;
}
while (list($key, $val) = each($_POST)) {
if ($key == "addtable") {
add_table($db, $newtable_name, $newtable_label, $newtable_sortkey, $newtable_plugincode);
break;
} elseif (substr($key, 0, 8) == 'modtable') {
$modarray = explode("_", $key);
$id = $_POST['table_id'][$modarray[1]];
mod_table($db, $id, $modarray[1]);
break;
} elseif (substr($key, 0, 8) == 'deltable') {
$modarray = explode("_", $key);
$id = $_POST['table_id'][$modarray[1]];
$tablename = $_POST['table_name'][$modarray[1]];
del_table($db, $tablename, $id, $USER);
break;
} elseif ($key == 'table_column_select') {
add_associated_table($db, $table_name, $addcol_name, $_POST['table_select'], $_POST['table_column_select']);
break;
