note 122726 deleted from class.pdostatement by cmb
| From: | cmb@php.net | Date: | Wed, 15 Dec 2021 18:31:56 +0000 |
| Subject: | note 122726 deleted from class.pdostatement by cmb | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-217371@lists.php.net to get a copy of this message | ||
Note Submitter: code4fun at gmail dot com
----
Example of persist in bd
public function persist($dbh) {
if ($this->id) {//Update
$modificar = 'UPDATE usuarios set nombre = :nombre ,pass = :pass'
. ' WHERE id = :id';
$persistir = $dbh->prepare($modificar);
$persistido = $persistir->execute(array(':nombre' =>
$this->getNombre(), ':pass' => $this->getPass(), ':id' =>
$this->getId()));
} else {
$insert = 'INSERT INTO usuarios (nombre,pass) VALUES (:nombre,:pass)';
$persistir = $dbh->prepare($insert);
$persistido = $persistir->execute(array('nombre' =>
$this->getNombre(), 'pass' => $this->getPass()));
if ($persistido) {
$this->setId($dbh->lastInsertId());
} else {
throw new Exception;
}
}
return $persistido;
}
//Example of select
public function getCredencial($dbh) {
$select = "SELECT * FROM usuarios WHERE nombre= :user AND pass= :pass";
$consulta = $dbh->prepare($select);
$consulta->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, "Usuario");
$consulta->execute(array(":user" => $this->nombre, ":pass"
=> $this->pass));
$logueado = $consulta->fetch();
return $logueado;
}
//Example of select all
public static function getAll($bd, $id) {
$query = 'SELECT * FROM
cuentas WHERE idUsuario = :idUsuario';
$prepare = $bd->prepare($query);
$prepare->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'Movimiento');
$prepare->execute(array(':idUsuario' => $id));
$movimientos = $prepare->fetchAll();
return $movimientos;
}
//Example of delete
public function eliminar($dbh,$id) {
$sql = 'DELETE FROM alumnos '
. 'WHERE id = :id';
$stmt = $dbh->prepare($sql);
$stmt->bindValue(':id', $id);
$stmt->execute();
return $stmt->rowCount();
}