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;