douwen5951 2017-02-28 15:32
浏览 49

PDO显示多个表列

I'm trying to execute two almost identical queries. But for some reason it keeps loading if I execute them both.

Here is my code:

$query = "show columns from auto_new";
$stmtColumns = $db->prepare($query);
$stmtColumns->execute();
$result = $stmtColumns->fetchAll(PDO::FETCH_BOTH);

foreach($result as $r) {
    $velden .= $r["0"]. "| ";
}

$query = "show columns from auto_coc";
$stmtColumnsCoc = $db->prepare($query);
$stmtColumnsCoc->execute();
$resultCoc = $stmtColumnsCoc->fetchAll(PDO::FETCH_BOTH);

foreach($resultCoc as $r) {
    $velden .= $r["0"]. "| ";
}

If I only execute one of two queries it works just fine, but both doesn't work at all.

Also tried the following with no luck: $auto_new = 'auto_new'; $auto_coc = 'auto_coc';

$query = "SELECT * FROM information_schema.columns
          WHERE TABLE_NAME =:auto_new OR TABLE_NAME = :auto_coc";
$stmt = $db->prepare($query);
$stmt->bindParam(':auto_new', $auto_new, PDO::PARAM_STR);
$stmt->bindParam(':auto_coc', $auto_coc, PDO::PARAM_STR);
$stmt->execute();
$result = $stmt->fetchAll(PDO::FETCH_BOTH);

In both ways it keeps loading forever. What am I doing wrong?

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 全部备份安卓app数据包括密码,可以复制到另一手机上运行
    • ¥15 Python3.5 相关代码写作
    • ¥20 测距传感器数据手册i2c
    • ¥15 RPA正常跑,cmd输入cookies跑不出来
    • ¥15 求帮我调试一下freefem代码
    • ¥15 matlab代码解决,怎么运行
    • ¥15 R语言Rstudio突然无法启动
    • ¥15 关于#matlab#的问题:提取2个图像的变量作为另外一个图像像元的移动量,计算新的位置创建新的图像并提取第二个图像的变量到新的图像
    • ¥15 改算法,照着压缩包里边,参考其他代码封装的格式 写到main函数里
    • ¥15 用windows做服务的同志有吗