48 lines
1004 B
PHP
48 lines
1004 B
PHP
<?php
|
|
require_once "global.php";
|
|
|
|
$conexion=new mysqli(DB_HOST,DB_USERNAME,DB_PASSWORD,DB_NAME);
|
|
|
|
mysqli_query($conexion, 'SET NAMES "'.DB_ENCODE.'"');
|
|
|
|
//muestra posible error en la conexion
|
|
if (mysqli_connect_errno()) {
|
|
printf("Falló en la conexion con la base de datos: %s\n",mysqli_connect_error());
|
|
exit();
|
|
}
|
|
|
|
if (!function_exists('ejecutarConsulta')) {
|
|
|
|
Function ejecutarConsulta($sql){
|
|
global $conexion;
|
|
$query=$conexion->query($sql);
|
|
return $query;
|
|
}
|
|
|
|
function ejecutarConsultaArray($sql) {
|
|
global $conexion;
|
|
$result = $conexion->query($sql);
|
|
return $result->fetch_all(MYSQLI_ASSOC);
|
|
}
|
|
|
|
function ejecutarConsultaSimpleFila($sql){
|
|
global $conexion;
|
|
$query=$conexion->query($sql);
|
|
$row=$query->fetch_assoc();
|
|
return $row;
|
|
}
|
|
function ejecutarConsulta_retornarID($sql){
|
|
global $conexion;
|
|
$query=$conexion->query($sql);
|
|
return $conexion->insert_id;
|
|
}
|
|
|
|
function limpiarCadena($str){
|
|
global $conexion;
|
|
$str=mysqli_real_escape_string($conexion,trim($str));
|
|
return htmlspecialchars($str);
|
|
}
|
|
|
|
}
|
|
|
|
?>
|