dtnat80842 2014-08-29 00:19
浏览 357
已采纳

我无法使用'fetch(PDO :: FETCH_ASSOC)'从表中获取数据

Why does fetch (PDO::FETCH_ASSOC) not work properly? How can I get the data I want from the table without a foreach loop? I have used the $statement variable before to prepare/execute another query. Could this be the problem?

try
{
    $database = new PDO ('mysql:host=localhost;dbname=youdonotneedtoknow;charset=utf8', 'youdonotneedtoknow', 'youdonotneedtoknow');
    $database -> setAttribute (PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $database -> setAttribute (PDO::ATTR_EMULATE_PREPARES, true);

    //Read
    $statement = $database -> prepare ('SELECT * FROM edit');
    $statement -> execute ();
    while ($row = $statement -> fetch (PDO::FETCH_ASSOC))
    {
        $windowTitle = $row ['windowTitle'];
        $bodyBackgroundColour = $row ['bodyBackgroundColour'];
        $divisionBackgroundColour = $row ['divisionBackgroundColour'];
    }
}
catch (PDOException $exception)
{
    die ('Error: ' . $exception -> getMessage () . '<br><br>' . 'Por favor diríjase a "index.php" en este mismo directorio y contacte a su administrador.');
}
  • 写回答

1条回答 默认 最新

  • douyu4535 2014-08-29 00:37
    关注

    Do this:

    while ($row = $statement -> fetch (PDO::FETCH_ASSOC))
    {
        switch ($row['id']) {
            case 'windowTitle':
                $windowTitle = $row ['value'];
                break;
            case 'bodyBackgroundColour':
                $bodyBackgroundColour = $row['value'];
                break;
            case 'divisionBackgroundColour':
                $divisionBackgroundColour = $row['value'];
                break;
        }
    }
    

    You could also use variable variables:

    while ($row = $statement -> fetch (PDO::FETCH_ASSOC))
    {
        ${$row['id']} = $row['value'];
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 MddBootstrapInitialize2失败
  • ¥15 LCD Flicker
  • ¥15 Spring MVC项目,访问不到相应的控制器方法
  • ¥15 esp32在micropython环境下使用ssl/tls连接mqtt服务器出现以下报错Connected on 192.168.154.223发生意外错误: 5无法连接到 MQTT 代理,如何解决?
  • ¥15 关于#genesiscsheel#的问题,如何解决?
  • ¥15 Android aidl for hal
  • ¥15 STM32CubeIDE下载程序报错
  • ¥15 微信好友如何转变为会员系统?(相关搜索:小程序)
  • ¥15 c# 直接使用c++ 类库文件
  • ¥15 一个主机电脑有两个显示器,当前有两个软件主体是网页html打包的exe程序,如何通过cmd命令bat同时打开软件一个在主屏幕显示,另外一个软件在2副屏幕上显示