function query($query)
{
if ($this->debug) {
logger("DB:" . $this->name, "Query: " . substr($query, 0, $this->traceLength));
}
return parent::query($query);
}
public static function getInstance()
{
if (is_null(self::$_instance) || isset(self::$_instance)) {
self::$_instance = new self();
}
return self::$_instance;
}
/**
* Overwritten method from parent class to allow logging facility
*
* @param the SQL query
*
* @access public
*
* @return mixed returns a valid MySQL result for successful SELECT
* queries, DB_OK for other successful queries. A DB error is
* returned on failure.
*/
function simpleQuery($query)
{
if ($this->debug) {
// to mysql server are sent not only queries passed as a parameters
// also the simpleQuery function when special condition occurs send
// some commands by itself, so we have to log it as well - that is
// why this condition.
if (!$this->autocommit && DB::isManip($query) && $this->transaction_opcount == 0) {
echo "SET AUTOCOMMIT=0<br>";
echo "START TRANSACTION<br>";
}
//echo "<pre>$query</pre>";
}
return parent::simpleQuery($query);
}
<?php
include "coneccion/config.php";
include "coneccion/clases_mysql.php";
extract($_POST);
$miconexion = new DB_mysql();
$miconexion->conectar($dbname, $dbhost, $dbuser, $dbpass);
$b = $_POST['cedula'];
$c = $_POST['nombres'];
$d = $_POST['apellidos'];
$e = $_POST['telefono'];
$f = $_POST['email'];
$G = $_POST['NumMesaR'];
$sql = "INSERT INTO clientes (CEDULA, NOMBRES, APELLIDOS, TELEFONO, EMAIL) VALUES ('{$b}','{$c}','{$d}','{$e}','{$f}')";
$miconexion->consulta($sql);
$sql = "INSERT INTO realizan (CEDULA, ID_MESA) VALUES ('{$b}','{$g}')";
$miconexion->consulta($sql);
echo '<script>alert("Se registro satisfactoriamente la informacion...")</script>';
echo "<script>location.href='gestionMesas.php'</script>";
<!DOCTYPE>
<?php
include "coneccion/config.php";
include "coneccion/clases_mysql.php";
$miconexion = new DB_mysql();
$miconexion->conectar($dbname, $dbhost, $dbuser, $dbpass);
error_reporting(0);
?>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<meta name="author" content="">
<title>CarFood </title>
<!-- Custom CSS -->
<link href="css/estiloGM.css" rel="stylesheet">
<!-- Custom Fonts -->
<link href='http://fonts.googleapis.com/css?family=Lobster' rel='stylesheet' type='text/css'>
<script language="JavaScript" type="text/javascript" src="ajax.js"></script>
<script src="bootstrap/js/bootstrap.min.js"></script>
<script src="js/contact_me.js"></script>
<script src="js/jqBootstrapValidation.js"></script>
<script src="js/modernizr.custom.js"></script>
/**
* 直前のクエリが影響を与えた行数を取得
*
* @return int
*/
function affectedRows()
{
return $this->db->affectedRows();
}
<?php
include "../dll/config.php";
include "../dll/clase1.php";
extract($_POST);
$miconexion = new DB_mysql();
$miconexion->conectar($dbname, $dbhost, $dbuname, $dbpass);
$miconexion->consulta("insert into inscritos values('','{$nombres}','{$apellidos}','{$ceduladni}','{$email}','{$tandem}','{$presicion}','{$distancia}','{$pais}','{$ciudad}','{$club}','{$direccion}','{$seguro}','{$alergia}','{$celular}','{$sangre}','{$parapente}','{$homologacion}','{$colores}','{$telef1}','{$telef2}','{$telef3}',NOW())");
echo '<script>alert("Datos guardados correctamente..")</script>';
echo "<script>location.href='../inscritos.php'</script>";
<!DOCTYPE>
<?php
include "coneccion/config.php";
include "coneccion/clases_mysql.php";
$miconexion = new DB_mysql();
$miconexion->conectar($dbname, $dbhost, $dbuser, $dbpass);
session_start();
if ($_SESSION["miSession"]['TIPO_USUARIO'] == 1) {
?>
<div>
<p><font color="#FFFFFF">Bienvenido: <?php
echo $_SESSION["miSession"]['USUARIO'];
?>
</font>
<font color="#FFFFFF"> <?php
echo " <a href='cerrarsesion.php'>cerrar session</a>";
?>
</font></p>
</div>
<?php
} else {
header('Location: logeo.php?error=1');
}
?>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<link rel="stylesheet" type="text/css" href="css/bootstrap.min.css">
<link rel="stylesheet" type="text/css" href="css/estilos.css">
</head>
<body>
<header>
<h1><?php
echo $site_name;
?>
</h1>
</header>
<nav>
<a href="../" title="">Home</a>
<a href="/" title="">Formulario</a>
<a href="inscritos.php" title="">Inscritos</a>
</nav>
<section id="contenedor">
<h2>Inscritos del evento</h2>
<?php
$miconexion = new DB_mysql();
$miconexion->conectar($dbname, $dbhost, $dbuname, $dbpass);
//$miconexion->consulta("select * from inscritos");
$miconexion->consulta("select id '#', nombres 'NOMBRES', apellidos 'APELLIDOS', pais 'PAIS', club 'CLUB PERTENECIENTE', parapente 'PARAPENTE', homologacion 'HOLOGOCACION' from inscritos");
$miconexion->verconsulta();
?>
</section>
<hr>
<footer id="pie">
Desarrollado por: <a href="http://www.loxatec.com">Loxatec</a>
</footer>
</body>
</html>
