我想檢查數據庫是否存在或僅使用 PDO（如果可用）。另外，如果不可能，請為我提供有關如何使用 if else 語句檢查數據庫是否存在的快速解決方案。任何幫助表示贊賞。謝謝你！這是我到目前為止所做的：try { $conn = new PDO("mysql:host=localhost", "root", ""); $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); //Now since I have been connected, I want to check DB existence. if(DB exists) { //check table existence } else { //Create DB }}catch(PDOException $e){ echo "Connection failed: " . $e->getMessage();}
1 回答
慕的地10843
TA貢獻1785條經驗 獲得超8個贊
try {
$conn = new PDO("mysql:host=localhost", "root", "");
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
//Now since I have been connected, I want to check DB existence.
$databases = $conn->query('show databases')->fetchAll(PDO::FETCH_COLUMN);
if(in_array(YOUR_DATABASE_NAME,$databases))
{
//check table existence
}
else {
//Create DB
}
}
catch(PDOException $e)
{
echo "Connection failed: " . $e->getMessage();
}
- 1 回答
- 0 關注
- 160 瀏覽
添加回答
舉報
0/150
提交
取消