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