PHP myAdmin中未选择数据库错误 - No Database Selected Error in PHP myAdmin

No Database Selected Error in PHP myAdmin

本文关键字：数据库错误选择 myAdmin PHP | 更新日期: 2024-06-05

我有以下SQL语句：

DELETE FROM Menu WHERE restaurantID = '2' AND foodID = '12';

每当我试图运行它时，我总是会收到错误"#1046-未选择数据库"。我在W3 Schools上查找了示例SQL语句，似乎我的语句包含了所有必要的部分。

DELETE FROM your_database_name.Menu WHERE restaurantID = '2' AND foodID = '12';

此代码可以帮助您与mysql和php交互

$link = mysqli_connect("localhost", "UserName","password", "databaseName");
$sql="delete from Table_name where restaurantID = '2' AND foodID = '12' ";
$del = mysqli_query($link, $sql);
    mysqli_close($link);
    if ($del) {
        echo "deleted ";
    } else {
        echo "did not delete ";
    }

注意：您运行服务器
对于您的问题，我认为您没有选择数据库
忘记使用上面的代码，它非常简单
我希望我能帮助你
祝好运