php - 为什么 mysqli 和 PDO 给出不同的结果

Question

这是我正在使用的代码片段 -

    //mysqli
    $db_conn = mysqli_connect('localhost', 'root', 'XXXX', 'core');        
    $db = mysqli_select_db($db_conn, 'core');
    $result = mysqli_query($db_conn, 'SELECT * FROM customers WHERE email = "juz_acool1@gmail.com"');
    $result_rows= mysqli_fetch_assoc($result);
    var_dump($result_rows);

    //pdo
    $dsn = "mysql:host=localhost;dbname=core;";
    $u = 'root';
    $p = 'XXXX';
    $pdo = new PDO($dsn, $u, $p);
    var_dump($pdo);
    $test = $pdo->exec('show databases;');
    var_dump($test);
    var_dump($pdo);

    $query = $pdo->prepare("SELECT * FROM customers WHERE email = 'juz_acool1@gmail.com'");
    var_dump($query);        
    $r = $query->execute();
    var_dump($r);

这是我得到的结果 -

  //mysqli 
  array (size=10)
  'id' => string '1' (length=1)
  'fullname' => string 'Shalom Sam' (length=10)
  'username' => string 'shalom.sam' (length=10)
  'email' => string 'juz_acool1@gmail.com' (length=19)
  'birthdate' => string '05/25/1986' (length=10)
  'gender' => string 'm' (length=1)
  'location' => string 'Mumbai, Maharashtra, India' (length=26)
  'verified' => string '1' (length=1)
  'timezone' => string '5.5' (length=3)
  'lastupdatetime' => string '2014-05-02 15:42:35' (length=19)

//pdo
int 0

object(PDO)[4]

object(PDOStatement)[5]

  public 'queryString' => string 'SELECT * FROM customers WHERE email = 'juz.cool1@gmail.com'' (length=59)

boolean false

我知道这一切需要读很多东西。但我真的很想找出我可能出错的地方。希望有人可以帮助我。

Answer 1

对 PDO 结果使用 fetch

$r = $query->execute();
$res = $r->fetch(PDO::FECTH_ASSOC);
var_dump($res);

在这里，阅读该内容，它应该回答所有这些类型的问题

http://wiki.hashphp.org/PDO_Tutorial_for_MySQL_Developers