PHP DataBase::close方法代码示例

 public function get($id)
 {
     require_once 'DataBase.php';
     $data = new DataBase();
     $data->open();
     $sql = "BEGIN GETRUTACONDUCTOR(:p_id, :rc); END;";
     $sent = oci_parse($data->getConn(), $sql);
     $refcur = oci_new_cursor($data->getConn());
     $this->id = $id;
     oci_bind_by_name($sent, ':p_id', $this->id);
     oci_bind_by_name($sent, ':rc', $refcur, -1, OCI_B_CURSOR);
     if (!oci_execute($sent)) {
         return false;
     }
     if (!oci_execute($refcur)) {
         return false;
     }
     while (($row = oci_fetch_array($refcur, OCI_ASSOC + OCI_RETURN_NULLS)) != false) {
         $this->ruta = $row['ID_RUTA'];
         $this->conductor = $row['ID_CONDUCTOR'];
         $this->kilometraje = $row['KILOMETRAJE'];
         $this->descripcion = $row['DESCRIPCION'];
     }
     oci_free_statement($refcur);
     $data->free($sent);
     $data->close();
     return true;
 }

 public function saveToDB($poiId, $componentId, $stageRating)
 {
     global $secKeys;
     $now = date("Y-m-d H:i:s");
     try {
         DataBase::connect('localhost', $secKeys->cakeVars->{'dbUsr'}, $secKeys->cakeVars->{'dbPw'}, $secKeys->cakeVars->{'dbCake'});
         $sql = "INSERT INTO stages (component_id, poi_id, created, modified, rating) VALUES (:component_id, :poi_id, :tstamp, :tstamp, :rating)";
         $para = array('component_id' => $componentId, 'poi_id' => $poiId, 'tstamp' => $now, 'rating' => $stageRating);
         DataBase::fire($sql, $para);
         $this->savedStagesCount = DataBase::lastInsertId();
         DataBase::close();
     } catch (Exception $e) {
         die('Fehler bei .... Fehler: ' . $e->getMessage());
     }
 }

 public function get($id)
 {
     require_once 'DataBase.php';
     $data = new DataBase();
     $data->open();
     $sql = "BEGIN GETPLANIFICACION(:id, :nombre, :distancia, :ruta); END;";
     $sent = oci_parse($data->getConn(), $sql);
     $this->id = $id;
     oci_bind_by_name($sent, ':id', $this->id);
     oci_bind_by_name($sent, ':nombre', $this->nombre);
     oci_bind_by_name($sent, ':distancia', $this->distancia);
     oci_bind_by_name($sent, ':ruta', $this->ruta);
     oci_execute($sent);
     $data->free($sent);
     $data->close();
 }

 public function getBook($id)
 {
     require_once 'dbm.php';
     $data = new DataBase();
     $data->open();
     $query = "SELECT * FROM `archivo` WHERE `id_archivo` = {$id}";
     $result = mysqli_query($data->get_connect(), $query);
     $row = mysqli_fetch_array($result);
     $this->id = $row[0];
     $this->user = $row[1];
     $this->title = $row[2];
     $this->path = $row[5];
     $this->description = $row[3];
     $this->punteo = $row[6];
     $data->close();
 }

 static function handle()
 {
     $bd = new DataBase();
     $gestor = new ManageRelations($bd);
     $action = Request::req("action");
     $do = Request::req("do");
     $metodo = $action . ucfirst($do);
     if (method_exists(get_class(), $metodo)) {
         //ucfirst pone la primera en mayuscula
         echo 'El método existe';
         self::$metodo($gestor);
     } else {
         echo 'la función no existe';
         self::readView($gestor);
     }
     $bd->close();
 }

 public function get($courriel)
 {
     $cnx = DataBase::getInstance();
     $pstmt = $cnx->prepare("SELECT * FROM user WHERE courriel = :c");
     $pstmt->execute(array('c' => $courriel));
     $result = $pstmt->fetch(PDO::FETCH_OBJ);
     if ($result) {
         $u = new User();
         $u->loadFromObject($result);
         $pstmt->closeCursor();
         DataBase::close();
         return $u;
     }
     $pstmt->closeCursor();
     DataBase::close();
     return NULL;
 }

 function getComentarios($id_archivo)
 {
     require_once 'dbm.php';
     require_once 'user.php';
     $data = new DataBase();
     $data->open();
     $comentarios = array();
     $query = "SELECT comentario.id_usuario, comentario.texto FROM comentario WHERE comentario.id_archivo = {$id_archivo} ORDER BY comentario.id_comentario DESC";
     $result = mysqli_query($data->get_connect(), $query);
     while ($row = mysqli_fetch_array($result)) {
         $elemento = new Comment();
         $usuario = new User();
         $usuario->getUser($row[0]);
         $elemento->setComentario($usuario->getNombre(), $row[1]);
         $comentarios[] = $elemento;
     }
     $data->close();
     return $comentarios;
 }

 public function findAll()
 {
     $liste = array();
     $cnx = DataBase::getInstance();
     $pstmt = $cnx->prepare("SELECT * FROM alerts ORDER BY active=1 DESC");
     $pstmt->execute();
     while ($result = $pstmt->fetch(PDO::FETCH_OBJ)) {
         $p = new Alert();
         $p->setId($result->id);
         $p->setTitle($result->title);
         $p->setText($result->text);
         $p->setDate($result->date);
         $p->setActive($result->active);
         array_push($liste, $p);
     }
     $pstmt->closeCursor();
     DataBase::close();
     return $liste;
 }

?>
> Admin<br>
						<br/><br/>
						<input type="submit" value="Save" id="guardarperfil"/>
					</fieldset>
				</form>
				<form action="php/phpdeleteuser.php" method="post">
					<br/><br/><br/>
					<fieldset>
						<legend>Delete user</legend><br/>
						<input type="hidden" name="email" value="<?php 
echo $usuario->getEmail();
?>
"/>
						<input type="checkbox" name="confirm" value="yes"> Confirm delete user<br>
						<input type="submit" value="Delete" id="eliminarmensaje"/>
					</fieldset>
				</form>
			</div>
   		</div>
   		
   		<footer>
   			<h class="left">Copyright by Socializate</h>
   			<h class="right">Designed by David Gamarra</h>
   		</footer>
    </body>
</html>

<?php 
$db->close();

<?php

$username = $_POST['user'];
$password = $_POST['pass'];
$rol = 0;
require_once 'DataBase.php';
$data = new DataBase();
$data->open();
$id = 0;
$sql = "BEGIN LOGIN(:user, :pass, :rol, :id); END;";
$sent = oci_parse($data->getConn(), $sql);
oci_bind_by_name($sent, ':user', $username);
oci_bind_by_name($sent, ':pass', $password);
oci_bind_by_name($sent, ':rol', $rol);
oci_bind_by_name($sent, ':id', $id);
oci_execute($sent);
$data->free($sent);
$data->close();
if ($rol > 0 && $id > 0) {
    session_start();
    $_SESSION['id'] = $id;
    $_SESSION['user'] = $username;
    $_SESSION['rol'] = $rol;
    header('Location: index.php');
} else {
    header('Location: loginform.php?error=1');
}

 public function delete($id)
 {
     require_once 'DataBase.php';
     $data = new DataBase();
     $data->open();
     $sql = "BEGIN DELUSUARIO(:id); END;";
     $sent = oci_parse($data->getConn(), $sql);
     oci_bind_by_name($sent, ':id', $id);
     if (!oci_execute($sent)) {
         return false;
     }
     $data->free($sent);
     $data->close();
     return true;
 }

 public function findBySeasonAndCategory($categ, $season, $page = 0, $taille = 0, $visibleOnly = 1)
 {
     $liste = array();
     $where = "";
     if ($visibleOnly) {
         $where = " AND hidden=0";
     }
     $cnx = DataBase::getInstance();
     if ($page == 0) {
         $pstmt = $cnx->prepare("SELECT * FROM photo WHERE season=:s AND category=:c" . $where);
     } else {
         $debut = $taille * ($page - 1);
         $pstmt = $cnx->prepare("SELECT * FROM photo WHERE season=:s AND category=:c" . $where . " LIMIT " . $debut . "," . $taille);
     }
     $pstmt->execute(array('s' => $season, 'c' => $categ));
     while ($result = $pstmt->fetch(PDO::FETCH_OBJ)) {
         $p = new Photo();
         $p->loadFromObject($result);
         array_push($liste, $p);
     }
     $pstmt->closeCursor();
     DataBase::close();
     return $liste;
 }

<?php

require '../clases/AutoCarga.php';
$bd = new DataBase();
$gestorUsuario = new ManageUser($bd);
?>
<!DOCTYPE html>
<html>
    <head>
        <meta charset="UTF-8">
        <title></title>
        <link href="../css/estilos.css" rel="stylesheet">
    </head>
    <body>
        <form action="phpregister.php" method="POST" >
            <div class="logo"></div>
            <div class="login-block">
            <label for="email">Email: </label><input type="email" name="email" value="" /><br/>
            <label for="password">Password: </label><input type="password" name="clave" value="" /><br/>           
            <input type="submit" value="Registrar"/>
            </div>
        </form>
    </body>
</html>
<?php 
$bd->close();

 public function Delete()
 {
     require_once 'dbm.php';
     $data = new DataBase();
     $data->open();
     $query = "DELETE FROM categoria WHERE id_categoria = {$this->id}";
     $result = mysqli_query($data->get_connect(), $query);
     $data->close();
     if ($result) {
         $this->id = null;
         $this->nombre = null;
         $this->descripcion = null;
         return true;
     } else {
         return false;
     }
 }

 function getForceBalance($account = "", $from = "", $to = "")
 {
     //Connect
     $sql = new DataBase();
     $sql->connect();
     //Objects
     $json = array();
     $accounts = $this->get(50, $account);
     //Data
     foreach ($accounts as $acc) {
         //Query
         $balance = 0;
         $query = "SELECT transaction.amount, transaction.account_to_id FROM transactions transaction";
         $query .= " WHERE (transaction.account_from_id = '" . $acc['id'] . "' OR transaction.account_to_id = '" . $acc['id'] . "')";
         if (!empty($from)) {
             $query .= " AND transaction.date >= '" . $from . "' ";
         }
         if (!empty($to)) {
             $query .= " AND transaction.date <= '" . $to . "' ";
         }
         //execute
         $sql->query($query);
         //Data
         while ($data = mysql_fetch_array($sql->result)) {
             if ($data["account_to_id"] == $acc["id"]) {
                 $balance -= $data["amount"];
             } else {
                 $balance += $data["amount"];
             }
         }
         $balance += $acc["initial_balance"];
         //Array
         $acc['balance'] = round($balance, 2);
         $array = $acc;
         array_push($json, $array);
     }
     return $json;
     $sql->close();
 }