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>