PHP DataBase::prepare示例

 public function search_matrix($idMatrix = FALSE)
 {
     $objData = new DataBase();
     $sth = $objData->prepare('SELECT * FROM matrix M inner join users U ' . 'on M.id_matrix = U.id_matrix WHERE M.id_matrix = :idMatrix');
     $sth->execute(array(':idMatrix' => $idMatrix));
     return $result = $sth->fetchAll();
 }

示例#2

显示文件

文件： login_in.php 项目： dareyesm/login_jquery

<?php

require 'class/database.php';
$objData = new DataBase();
require 'class/sessions.php';
$objSess = new Session();
if (isset($_POST['nuser'])) {
    $usuario = $_POST['nuser'];
    $clave = $_POST['puser'];
}
$sth = $objData->prepare('SELECT idUser, naUser, paUser FROM users ' . 'where naUser = :naUser and paUser = :paUser');
$sth->bindParam(':naUser', $usuario);
$sth->bindParam(':paUser', $clave);
$sth->execute();
$result = $sth->fetchAll();
if ($sth->rowCount() > 0) {
    $objSess->init();
    $objSess->set('idUser', $result[0]['idUser']);
    $objSess->set('naUser', $result[0]['naUser']);
    echo "Usuario encontrado";
    //header('location: otra.php');
} else {
    echo "Usuario No encontrado";
}