function __construct()
{
require_once "../coreapp/Conection.php";
$conection = new Conection();
$this->conn = $conection->Conectar();
return $this->conn;
}
function verificar($usuario, $clave)
{
require '../coreapp/Conection.php';
$conection = new Conection();
$con = $conection->Conectar();
$rpta;
$sql = "SELECT cod_usu FROM usuarios WHERE log_usu='{$usuario}' AND psw_usu ='{$clave}' LIMIT 0,1;";
$result = $con->query($sql);
$numero = $result->num_rows;
if ($numero > 0) {
$rpta = TRUE;
} else {
$rpta = FALSE;
}
return $rpta;
}
<?php
require_once 'header.php';
require_once '../coreapp/Conection.php';
$conection = new Conection();
$mysqli = $conection->Conectar();
if (isset($_REQUEST['btnbuscar'])) {
$nexo = "%";
$nombre_bien = trim($_REQUEST['nombre_bien']);
$separar = explode(" ", $nombre_bien);
$union = implode($nexo, $separar);
$sql = "SELECT cod_sct, cod_sub, fec_doc, nom_bie, proy_id FROM escrituras1 WHERE nom_bie Like '%{$union}%'";
$res = $mysqli->query($sql);
$data = $res->fetch_assoc();
$numeroRegistros = $res->num_rows;
echo "Numero de Registros: " . $numeroRegistros;
}
?>
<form id="busqueda" name="busqueda" method="post">
<table>
<thead>
<tr>
<td>BUSCAR POR BIEN</td>
<td><input name="nombre_bien" type="text" size="80" value="<?php
echo @$nombre_bien;
?>
" required placeholder="Nombre del bien"/></td>
<td><input name="btnbuscar" type="submit" value="Buscar" class="btn btn-info"/></td>
<td></td>
</tr>
<?php
require_once "../coreapp/Conection.php";
$conn = new Conection();
$mysqli = $conn->Conectar();
$activo = 0;
$id = 1;
$sql = "UPDATE campos SET activo = '{$activo}' WHERE campos.id = {$id} LIMIT 1;";
$mysqli->query($sql) or die($mysqli->error());
<?php
class Conection
{
public function Conectar()
{
require_once "config.php";
$mysqli = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
$mysqli->set_charset("utf8");
if ($mysqli->connect_errno) {
echo "Error al contenctar a MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
exit;
}
echo $mysqli->host_info . " Test eb Conection.php";
return $mysqli;
}
}
$conn = new Conection();
$conn->Conectar();
