PHP-數據庫的創(chuàng)建
$servername = "127.0.0.1:3306";
$username = "root";
$password = "root";
//創(chuàng)建連接
$conn = mysqli_connect($servername, $username, $password);
//監(jiān)測連接
if (!$conn) {
die("connection faild: ".mysqli_connect_error());
} else {
echo "成功";
}
//創(chuàng)建數據庫
$sql = "CREATE DATABASE myDB2";
if (mysqli_query($conn, $sql)) {
echo "成功";
} else {
echo "錯誤".mysqli_error($conn);
}
mysqli_close($conn);
注: die函數是PHP里終止腳本運行的函數,到這就不往下運行了, 之前else里也寫了die函數,還納悶為什么一直創(chuàng)建不成功,原來都沒往下運行, 改成echo好了.
