B910
V2EX  ›  PHP

PHP 在线操作 Sqlite 报错

  •  
  •   B910 · Jul 4, 2020 · 2065 views
    This topic created in 2174 days ago, the information mentioned may be changed or developed.
    <?php
    class MyDB extends SQLite3
    {
    function __construct()
    {
    $this->open('test.db3');
    }
    }
    $qb=$_POST["bank"];
    if not(is_null($qb)){
    $db = new MyDB();
    if(!$db){
    echo $db->lastErrorMsg();
    }
    $sql = "SELECT * FROM aps WHERE bank LIKE". $qb;

    $ret = $db->query($sql);
    while($row = $ret->fetchArray(SQLITE3_ASSOC) ){
    echo "<p>";
    echo "ID = ". $row['bank'] . "\n";
    echo "NAME = ". $row['aps'] ."\n";
    echo "</P>";
    }
    echo "查询结束。";
    $db->close();
    }
    ?>
    <form action=aps.php method=post><p>银行名称模糊查询<input type=text name=bank /></p><input type=submit value=查询 /></form>


    ==========================================================================

    单页面查询,一个单数据库,十五万银行数据,2 个表。
    3 replies    2020-07-06 09:28:12 +08:00
    herbertzz
        1
    herbertzz  
       Jul 4, 2020
    目测 拼接 sql 字符串有问题, 话说使用 pdo 不香吗

    ```
    $sql = "SELECT * FROM aps WHERE bank LIKE ". $qb;
    ```
    ben1024
        2
    ben1024  
       Jul 6, 2020
    echo sql
    打印报错
    B910
        3
    B910  
    OP
       Jul 6, 2020 via iPhone
    @ben1024
    @henyi2211

    sql 和 if 都有错,已经好了,谢谢你们。
    你们看看需不需要这份数据可以分享给你们。
    全国网点联行号查询
    b910.cn/B/cnaps.php
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Solana   ·   1055 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 35ms · UTC 23:02 · PVG 07:02 · LAX 16:02 · JFK 19:02
    ♥ Do have faith in what you're doing.