How to delete database in php

How to delete a database in php

1. First check which databases there are

2. Use php to delete test2

<?php
$dbhost = &#39;localhost&#39;;  // mysql服务器主机地址
$dbuser = &#39;root&#39;;            // mysql用户名
$dbpass = &#39;root&#39;;          // mysql用户名密码
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
    die(&#39;连接失败: &#39; . mysqli_error($conn));
}
$sql = &#39;DROP DATABASE test2&#39;;
$retval = mysqli_query( $conn, $sql );
if(! $retval )
{
    die(&#39;删除数据库失败: &#39; . mysqli_error($conn));
}
echo "数据库 test2 删除成功\n";
mysqli_close($conn);
?>

3. Run the php program

3. Check the database again

test2 is gone and deleted successfully!

For more PHP related knowledge, please visit PHP Chinese website!

The above is the detailed content of How to delete database in php. For more information, please follow other related articles on the PHP Chinese website!