使用PHP和MySQL创建数据库 [英] Database creation using PHP and MySQL

问题描述

好的，所以我有这个代码：

Ok, so I have this code:

    <?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpwd = 'ALLO';
$dbname = 'test';
$conn = mysqli_connect($dbhost, $dbuser, $dbpwd, $dbname);


if(! $conn )
{
  die("\nconn: $conn \nCould not connect: " . mysqli_error($conn));
}
echo "\n";







$createtab="CREATE TABLE People(FirstName CHAR(30),LastName CHAR(30),Age INT)";

// Execute query
if (mysqli_query($conn,$createtab))
  {
  echo "Table created successfully";
  }
else
  {
  echo "Error creating table: " . mysqli_error($conn);
  }

echo "\n";




mysqli_query($conn,"INSERT INTO People (FirstName, LastName, Age)
VALUES ('Peter', 'Griffin',35)");

mysqli_query($conn,"INSERT INTO People (FirstName, LastName, Age)
VALUES ('Glenn', 'Quagmire',33)");






mysqli_close($conn)
?>

当我运行php脚本时，运行正常。

When I run the php script, it runs fine.

但是，我在mysql workbench中找不到该表。

However, I can't find the table in mysql workbench.

我刷新了很多次。

http://i.stack.imgur.com/uX1sQ.png
http://i.stack.imgur.com/iEXqT.png

推荐答案

查看是否有任何结果：

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='People'

$createdb="USE test";

// Execute query
if (mysqli_query($conn,$createdb))
 {
  echo "Db selected";
 }
else
 {
  echo "Error selecting db: " . mysqli_error($conn);
 }

这篇关于使用PHP和MySQL创建数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！