要将数据插入MySQLi表,您需要使用SQL INSERT INTO 命令.您可以使用mysql将数据插入MySQLi表.提示或使用PHP之类的任何脚本.
以下是INSERT INTO命令的通用SQL语法,用于将数据插入MySQLi表:
INSERT INTO table_name ( field1, field2,...fieldN ) VALUES ( value1, value2,...valueN );
要插入字符串数据类型,需要将所有值保持为双引号或单引号,例如: - "value".
这将使用SQL INSERT INTO命令将数据插入MySQLi表tutorials_inf.
以下示例将在 tutorials_tbl 表中创建3条记录 :
root@host# mysql -u root -p password; Enter password:******* mysql> use TUTORIALS; Database changed mysql> INSERT INTO tutorials_inf ->(id, name) ->VALUES ->(10, "John Poul"); Query OK, 1 row affected (0.01 sec)
注意 : 请注意,所有箭头符号( - >)都不是SQL命令的一部分;它们表示一个新行,它们是由MySQL提示符自动创建的,同时按下回车键而不在命令的每一行末尾给出分号.
您可以在PHP函数 mysqli_query()中使用相同的SQL INSERT INTO命令将数据插入MySQLi表.
此示例将从用户获取三个参数,并将它们插入MySQLi表 :
<html> <head> <title>Add New Record in MySQLi Database</title> <link rel = "stylesheet" type = "text/css" href = "style.css"> </head> <body> <div id = "main"> <form action = "" method = "post"> <label>Name :</label> <input type = "text" name = "name" id = "name" /> <br /> <br /> <input type = "submit" value ="Submit" name = "submit"/> <br /> </form> </div> <?php if(isset($_POST["submit"])){ $servername = "localhost:3306"; $username = "root"; $password = "<Password here>"; $dbname = "TUTORIALS"; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "INSERT INTO tutorials_inf(name)VALUES ('".$_POST["name"]."')"; if (mysqli_query($conn, $sql)) { echo "New record created successfully"; } else { echo "Error: " . $sql . "" . mysqli_error($conn); } $conn->close(); } ?> </body> </html>
示例输出应该是这样的 :
New record created successfully