PHP MySQL 插入数据

 

 1 <?php
 2 $servername = "localhost";
 3 $username = "username";
 4 $password = "password";
 5 $dbname = "myDB";
 6  
 7 // 创建连接
 8 $conn = mysqli_connect($servername, $username, $password, $dbname);
 9 // 检测连接
10 if (!$conn) {
11     die("Connection failed: " . mysqli_connect_error());
12 }
13  
14 $sql = "INSERT INTO MyGuests (firstname, lastname, email)
15 VALUES ('John', 'Doe', 'john@example.com')";
16  
17 if (mysqli_query($conn, $sql)) {
18     echo "新记录插入成功";
19 } else {
20     echo "Error: " . $sql . "<br>" . mysqli_error($conn);
21 }
22  
23 mysqli_close($conn);
24 ?>

 

posted @ 2022-03-10 20:58  保罗php  阅读(99)  评论(0)    收藏  举报