本文整理汇总了PHP中DataBase::free方法的典型用法代码示例。如果您正苦于以下问题:PHP DataBase::free方法的具体用法?PHP DataBase::free怎么用?PHP DataBase::free使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DataBase
的用法示例。
在下文中一共展示了DataBase::free方法的8个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: get
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;
}
示例2: get
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();
}
示例3: getAll
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;
}
示例4: DataBase
<?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');
}
示例5: delete
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;
}
示例6: update
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;
}
}
示例7: get
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;
}
示例8: get
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();
}