PHP 创建 MySQL 表

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

<?php $servername = "localhost"; $username = "username"; $password = "password"; $dbname = "myDB";    // 创建连接 $conn = mysqli_connect($servername, $username, $password, $dbname); // 检测连接 if (!$conn) {     die("连接失败: " . mysqli_connect_error()); }    // 使用 sql 创建数据表 $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 (mysqli_query($conn, $sql)) {     echo "数据表 MyGuests 创建成功"; } else {     echo "创建数据表错误: " . mysqli_error($conn); }    mysqli_close($conn); ?>