为什么你应该考虑用PHP开发多用户商城系统？

// 创建数据库连接
$conn = new mysqli("localhost", "username", "password", "database");

// 检查连接状态
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 创建一个表来存储用户信息
$sql = "CREATE TABLE users (
    id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(30) NOT NULL,
    email VARCHAR(50) NOT NULL
)";

if ($conn->query($sql) === TRUE) {
    echo "用户表创建成功";
} else {
    echo "表创建失败: " . $conn->error;
}

// 插入用户信息
$sql = "INSERT INTO users (username, email)
VALUES ('John Doe', 'johndoe@example.com')";

if ($conn->query($sql) === TRUE) {
    echo "用户信息插入成功";
} else {
    echo "插入失败: " . $conn->error;
}

// 查询用户信息
$sql = "SELECT * FROM users";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        echo "id: " . $row["id"]. " - 用户名: " . $row["username"]. " - 邮箱: " . $row["email"]. "<br>";
    }
} else {
    echo "没有用户信息";
}

// 关闭数据库连接
$conn->close();