PHP DataBase::open方法代码示例

 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 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();
 }

 function getUserId($usuario, $contrasena)
 {
     if ($usuario == "" or $contrasena == "") {
         return -1;
     }
     $datab = new DataBase();
     $datab->open();
     $connect = $datab->get_connect();
     echo $query = "SELECT id_usuario, nombre, contrasena FROM usuario WHERE nombre = '" . $usuario . "' AND contrasena = '" . $contrasena . "';";
     $result = mysqli_query($connect, $query);
     while ($row = mysqli_fetch_array($result)) {
         mysqli_close($connect);
         return $row[0];
     }
     mysqli_close($connect);
     return -1;
 }

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

 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 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;
     }
 }

 public function getAll()
 {
     $respuesta = array();
     require_once 'DataBase.php';
     $data = new DataBase();
     $data->open();
     $sql = "BEGIN GETALLRUTAS(:rc); END;";
     $sent = oci_parse($data->getConn(), $sql);
     $refcur = oci_new_cursor($data->getConn());
     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) {
         $elemento = new Ruta();
         $elemento->id = $row['ID_RUTA'];
         $elemento->nombre = $row['NOMBRE'];
         $respuesta[] = $elemento;
     }
     oci_free_statement($refcur);
     $data->free($sent);
     $data->close();
     return $respuesta;
 }

<?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 update()
 {
     if ($this->factura != "" && $this->proveedor != "" && $this->id != 0) {
         require_once 'DataBase.php';
         $data = new DataBase();
         $data->open();
         $sql = "BEGIN UPDMANTENIMIENTO(:id, :factura, :proveedor, :fecha, :monto, :descripcion, :vehiculo, :tipo); END;";
         $sent = oci_parse($data->getConn(), $sql);
         oci_bind_by_name($sent, ':id', $this->id);
         oci_bind_by_name($sent, ':factura', $this->factura);
         oci_bind_by_name($sent, ':proveedor', $this->proveedor);
         oci_bind_by_name($sent, ':fecha', $this->fecha);
         oci_bind_by_name($sent, ':monto', $this->monto);
         oci_bind_by_name($sent, ':descripcion', $this->descripcion);
         oci_bind_by_name($sent, ':vehiculo', $this->vehiculo);
         oci_bind_by_name($sent, ':tipo', $this->tipoMantenimiento);
         if (!oci_execute($sent)) {
             return false;
         }
         $data->free($sent);
         $data->close();
         return true;
     } else {
         return false;
     }
 }

 function get($id)
 {
     require_once 'DataBase.php';
     $data = new DataBase();
     $data->open();
     $sql = "BEGIN GETVEHICULO(:id, :rc); END;";
     $sent = oci_parse($data->getConn(), $sql);
     $refcur = oci_new_cursor($data->getConn());
     $this->id = $id;
     oci_bind_by_name($sent, ':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->id = $row['ID_VEHICULO'];
         $this->placa = $row['PLACA'];
         $this->kilometraje = $row['KILOMETRAJE'];
         $this->serie = $row['SERIE'];
         $this->motor = $row['MOTOR'];
         $this->anio = $row['ANIO'];
         $this->color = $row['COLOR'];
         $this->marca = $row['MARCA'];
     }
     oci_free_statement($refcur);
     $data->free($sent);
     $data->close();
     return true;
 }

 function list_of_files()
 {
     // Esta funcion devolvera un arreglo de objetos para los archivos
     require_once 'dbm.php';
     $data = new DataBase();
     $userid = $this->userid;
     $query = "SELECT * FROM archivo WHERE id_usuario = {$userid}";
     $data->open();
     $result = mysqli_query($data->get_connect(), $query);
     $list_of_files = array();
     while ($row = mysqli_fetch_array($result)) {
         $elemento = new element_book($row[1], $row[2], $row[3], $row[4]);
         $elemento->setId($row[0]);
         $list_of_files[] = $elemento;
     }
     $data->close();
     return $list_of_files;
 }