douping5015 2017-01-10 12:34
浏览 34

用php变量查询多个mysql表

I have a list of table names in my $_POST variable and I am trying to feed them into a MySQL query. My ultimate goal is to be able to select what tables I want to pull data from one page and then be able to use that data. Everything is accurate and working in my $_POST variable, I just don't know how to pass that onto the query string.

Using the code below, I'm not getting any results back at all. I'm fairly new and completely pulling my hair out. Any help would be greatly appreciated, even if it is just a point in the right direction.

foreach ($_POST as $item) {
    if ($item != 'Submit') {
        $query = "SELECT * FROM " . $item;
        $result = $database->query($query);
        $$item = mysqli_fetch_array($result);
    }
}
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 神经网络预测均方误差很小 但是图像上看着差别太大
    • ¥15 Oracle中如何从clob类型截取特定字符串后面的字符
    • ¥15 想通过pywinauto自动电机应用程序按钮,但是找不到应用程序按钮信息
    • ¥15 如何在炒股软件中,爬到我想看的日k线
    • ¥15 seatunnel 怎么配置Elasticsearch
    • ¥15 PSCAD安装问题 ERROR: Visual Studio 2013, 2015, 2017 or 2019 is not found in the system.
    • ¥15 (标签-MATLAB|关键词-多址)
    • ¥15 关于#MATLAB#的问题,如何解决?(相关搜索:信噪比,系统容量)
    • ¥500 52810做蓝牙接受端
    • ¥15 基于PLC的三轴机械手程序