使用PDO从MySQL获得结果

问题描述：

I'm trying to retrieve data from my table using PDO, only I can't seem to output anything to my browser, I just get a plain white page.

try {
  // Connect and create the PDO object
  $conn = new PDO("mysql:host=$hostdb; dbname=$namedb", $userdb, $passdb);
  $conn->exec("SET CHARACTER SET utf8");      // Sets encoding UTF-8

        $lastIndex = 2;

        $sql = "SELECT * FROM directory WHERE id > :lastIndex AND user_active != '' LIMIT 20"
        $sth = $conn->prepare($sql);
        $sth->execute(array(':lastIndex' => $lastIndex));

        $c = 1;
        while ($row = $sth->fetch(PDO::FETCH_ASSOC)) {
            echo 'ALL STYLING ETC RESULTS HERE';
        $c++;
        }

  $conn = null;        // Disconnect
}

我正在尝试使用PDO从我的表中检索数据，只是我似乎无法向我输出任何内容浏览器，我只是得到一个纯白页。 p>

 尝试{
 //连接并创建PDO对象
 $ conn = new PDO（“mysql：host = $  hostdb; dbname = $ namedb“，$ userdb，$ passdb）; 
 $ conn-＆gt; exec（”SET CHARACTER SET utf8“）;  //设置编码UTF-8 
 
 $ lastIndex = 2; 
 
 $ sql =“SELECT * FROM目录WHERE id＆gt;：lastIndex AND user_active！=''LIMIT 20”
 $ sth = $ conn  - ＆gt; prepare（$ sql）; 
 $ sth-＆gt; execute（array（'：lastIndex'=＆gt; $ lastIndex））; 
 
 $ c = 1; 
 while（$ row = $ sth  - ＆gt; fetch（PDO :: FETCH_ASSOC））{
 echo'ALL STYLING ETC RESULTS HERE'; 
 $ c ++; 
} 
 
 $ conn = null;  //断开
} 
  code>  pre> 
  div>

答

EXAMPLE. This is your dbc class

<?php

class dbc {

    public $dbserver = 'server';
    public $dbusername = 'user';
    public $dbpassword = 'pass';
    public $dbname = 'db';

    function openDb() {    
        try {
            $db = new PDO('mysql:host=' . $this->dbserver . ';dbname=' . $this->dbname . ';charset=utf8', '' . $this->dbusername . '', '' . $this->dbpassword . '');
        } catch (PDOException $e) {
            die("error, please try again");
        }        
        return $db;
    }

    function getAllData($qty) {
        //prepared query to prevent SQL injections
        $query = "select * from TABLE where qty = ?";
        $stmt = $this->openDb()->prepare($query);
        $stmt->bindValue(1, $qty, PDO::PARAM_INT);
        $stmt->execute();
        $rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
        return $rows;
    }    
?>

your PHP page:

<?php 
require "dbc.php";

$getList = $db->getAllData(25);

foreach ($getList as $key=> $row) {
         echo $row['columnName'] .' key: '. $key;
    }

使用PDO从MySQL获得结果

相关推荐