php创建数数据表的简单实现

代码参考自http://www.runoob.com/php/php-mysql-create-table.html

<?php//mysql$servername = "localhost";$username = "root";$password = "****";$dbname = "****";$conn = new mysqli($servername, $username, $password, $dbname);if ($conn->connect_error) {        die("Connect Failed: " . $conn->connect_error);}echo "Connected Success!";// use sql create database table$sql = "create table guests (        id int(6) unsigned auto_increment primary key,        name varchar(30) not null,        email varchar(50),        reg_date timestamp)";if ($conn->query($sql) === true) {        echo "Table guests created Successfully";} else {        echo "Create Error: " . $conn->error;}$conn->close();?>

执行结果如下：