php5.6,连接数据库，创建数据库，创建表，插入多条语句。

来源：互联网发布：软件开发进度表模板编辑：程序博客网时间：2024/06/06 20:00

<?php$servername = 'localhost'; //$username = '';   //用户名$password = ''; //密码自己填$database='';  //数据库名称// 创建连接$conn = new mysqli($servername, $username, $password,$database);// 检测连接if ($conn->connect_error) {    die("Connection failed: " . $conn->connect_error);}echo "Connected successfully";//Create database$sql = "CREATE DATABASE myDB";if ($conn->query($sql) === TRUE) {    echo "Database created successfully";} else {    echo "Error creating database: " . $conn->error;}// sql to create table$sql = 'CREATE TABLE MyGuests (id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, firstname VARCHAR(30) NOT NULL,lastname VARCHAR(30) NOT NULL,email VARCHAR(50),reg_date TIMESTAMP)';if ($conn->query($sql) === TRUE) {    echo "Table MyGuests created successfully";} else {    echo "Error creating table: " . $conn->error;}//解释一下为什么第二个sql语句有一个 . 相当于把前一个sql语句和这个语句连接起来。$sql = "INSERT INTO MyGuests (firstname, lastname, email)VALUES ('John', 'Doe', 'john@example.com');";$sql .= "INSERT INTO MyGuests (firstname, lastname, email)VALUES ('Mary', 'Moe', 'mary@example.com');";$sql .= "INSERT INTO MyGuests (firstname, lastname, email)VALUES ('Julie', 'Dooley', 'julie@example.com')";if (mysqli_multi_query($conn, $sql)) {    echo "New records created successfully";} else {    echo "Error: " . $sql . "<br>" . mysqli_error($conn);}$conn->close();?>

0 0