doukui4786 2015-11-13 18:53
浏览 23

MYSQLI没有选择数据库

I am having an issue where my page throws a "No database selected" error when I am logged on but it works fine when I am NOT logged on. Here is my code:

$cat = $_GET['cat'];

// IF NOT LOGGED ON -- ONLY ALLOW PUBLIC CATS TO BE SELECTED!!
if ($_SESSION['logged'] != 'on') {

    $sql = sprintf("SELECT * FROM diningcategories WHERE publish='1' AND catName='%s'",
            mysqli_real_escape_string($spositas, $cat));

}
// IF LOGGED ON ALLOW UNPUBLISHED CATEGORIES TO BE SELECTED
else {

    $sql = sprintf("SELECT * FROM diningcategories WHERE catName='%s'",
            mysqli_real_escape_string($spositas, $cat));

}
mysqli_select_db($spositas, 'spositas_db');
$selectCat = mysqli_query($spositas, $sql) or die(mysqli_error($spositas));
$selectedCat = mysqli_fetch_assoc($selectCat);

// IF NOT LOGGED ON SELECT PUBLIC MENU ITEMS BASED ON CATEGORY
if ($_SESSION['logged'] != 'on') {
    $sql = sprintf("SELECT * FROM diningmenu WHERE displayOnMenu='1' AND Category='%s'",
            mysqli_real_escape_string($spositas, $cat));
}
// IF LOGGED ON ALLOW ALL MENU ITMES TO BE DISPLAYED
else {
    $sql = sprintf("SELECT * FROM diningmenu WHERE Category='%s'",
            mysqli_real_escape_string($spositas, $cat));
}
mysqli_select_db($spositas, 'spositas_db');
$selectMenuItems = mysqli_query($spositas, $sql) or die(mysqli_error($spositas));
$menuItems = mysqli_fetch_assoc($selectMenuItems);

I have searched and browsed many questions that are similar to mine but I'm having a hard time solving my issue.

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥100 为什么这个恒流源电路不能恒流?
    • ¥15 有偿求跨组件数据流路径图
    • ¥15 写一个方法checkPerson,入参实体类Person,出参布尔值
    • ¥15 我想咨询一下路面纹理三维点云数据处理的一些问题,上传的坐标文件里是怎么对无序点进行编号的,以及xy坐标在处理的时候是进行整体模型分片处理的吗
    • ¥15 CSAPPattacklab
    • ¥15 一直显示正在等待HID—ISP
    • ¥15 Python turtle 画图
    • ¥15 关于大棚监测的pcb板设计
    • ¥15 stm32开发clion时遇到的编译问题
    • ¥15 lna设计 源简并电感型共源放大器