โดย tanapong » 27/04/2020 1:36 pm
โค้ด: เลือกทั้งหมด
<?php
$serverName = "localhost";
$userName = "root";
$userPassword = "root1234";
$dbName = "login_db";
$conn = mysqli_connect($serverName,$userName,$userPassword,$dbName);
?>
<style>
body {
background-image: url("paper.gif");
background-color: #cccccc;
}
.center {
margin: auto;
width: 60%;
border: 3px solid #73AD21;
padding: 10px;
}
</style>
<div align="center" style="border ">
<html>
--SECTION NAME--
<body>
<form action="add_section.php" method="post">
<input type="text" name="Work">
<br/>
<br/>
<input type="submit" value="ADD">
</form>
<br/>
อันนี้เป็นฟอร์มรับค่าครับ
โค้ด: เลือกทั้งหมด
<?php
$Work = $_POST['Work'];
$serverName = "localhost";
$userName = "root";
$userPassword = "root1234";
$dbName = "login_db";
$conn = mysqli_connect($serverName,$userName,$userPassword,$dbName);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// sql to create table
$sql = "CREATE TABLE $Work (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
rack VARCHAR(30) NOT NULL,
position VARCHAR(30) NOT NULL,
)";
if ($conn->query($sql) === TRUE) {
echo "Table created successfully";
} else {
echo "Error creating table: " . $conn->error;
}
$conn->close();
?>
Error creating table: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 6
[code]<?php
$serverName = "localhost";
$userName = "root";
$userPassword = "root1234";
$dbName = "login_db";
$conn = mysqli_connect($serverName,$userName,$userPassword,$dbName);
?>
<style>
body {
background-image: url("paper.gif");
background-color: #cccccc;
}
.center {
margin: auto;
width: 60%;
border: 3px solid #73AD21;
padding: 10px;
}
</style>
<div align="center" style="border ">
<html>
--SECTION NAME--
<body>
<form action="add_section.php" method="post">
<input type="text" name="Work">
<br/>
<br/>
<input type="submit" value="ADD">
</form>
<br/>
[/code]
อันนี้เป็นฟอร์มรับค่าครับ
[code]<?php
$Work = $_POST['Work'];
$serverName = "localhost";
$userName = "root";
$userPassword = "root1234";
$dbName = "login_db";
$conn = mysqli_connect($serverName,$userName,$userPassword,$dbName);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// sql to create table
$sql = "CREATE TABLE $Work (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
rack VARCHAR(30) NOT NULL,
position VARCHAR(30) NOT NULL,
)";
if ($conn->query($sql) === TRUE) {
echo "Table created successfully";
} else {
echo "Error creating table: " . $conn->error;
}
$conn->close();
?> [/code]
Error creating table: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 6