php实现mysql表添加数据库

CREATE TABLE users (
  id INT(11) AUTO_INCREMENT PRIMARY KEY,
  username VARCHAR(255) NOT NULL,
  password VARCHAR(255) NOT NULL,
  email VARCHAR(255) NOT NULL
);

<?php
// 连接到MySQL服务器
$conn = mysqli_connect("localhost", "username", "password");

// 选择数据库
mysqli_select_db($conn, "database_name");

// 创建表
$sql = "CREATE TABLE users (
  id INT(11) AUTO_INCREMENT PRIMARY KEY,
  username VARCHAR(255) NOT NULL,
  password VARCHAR(255) NOT NULL,
  email VARCHAR(255) NOT NULL
)";

mysqli_query($conn, $sql);

// 检查执行结果
if (mysqli_affected_rows($conn) > 0) {
  echo "表创建成功！";
} else {
  echo "表创建失败！";
}

// 关闭数据库连接
mysqli_close($conn);
?>