douli8040 2014-04-16 02:33
浏览 26
已采纳

如何使用MYSQLi和PHP显示信息?

I am using MYSQLi (from this website: http://codular.com/php-mysqli) and getting a blank page.

<html>
<body>  
    <h1>TEST21</h1>

    <?php

    error_reporting(E_ALL);  ini_set('display_errors', 1);

    $db = new mysqli('localhost', 'Brendan', 'password', 'Library');

    if($db->connect_errno > 0){
        die('Unable to connect to database [' . $db->connect_error . ']');
    }

    echo "STEP1";

    //STEP 2

    $sql = <<<SQL
        SELECT *
        FROM 'BOOK'
        WHERE 'ISBN10' > 0
    SQL;

    if(!$result = $db->query($sql)){
        die('There was an error running the query [' . $db->error . ']');
    }

    echo "STEP2";

    ?>

</body>

  • 写回答

1条回答 默认 最新

  • douzangdang2225 2014-04-16 03:07
    关注

    The whacky thing with HEREDOC is that the closing identifier must not have any leading spaces (must not be indented). See the big warning here - http://php.net/manual/language.types.string.php#language.types.string.syntax.heredoc

    You're also using the wrong quote characters in your query. I'd simplify it all down to this...

    $sql = 'SELECT * FROM `BOOK` WHERE `ISBN10` > 0';
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥100 set_link_state
  • ¥15 虚幻5 UE美术毛发渲染
  • ¥15 CVRP 图论 物流运输优化
  • ¥15 Tableau online 嵌入ppt失败
  • ¥100 支付宝网页转账系统不识别账号
  • ¥15 基于单片机的靶位控制系统
  • ¥15 真我手机蓝牙传输进度消息被关闭了,怎么打开?(关键词-消息通知)
  • ¥15 装 pytorch 的时候出了好多问题,遇到这种情况怎么处理?
  • ¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本
  • ¥15 手机接入宽带网线,如何释放宽带全部速度