Use dbhost, dbuser, dbpassword and dbdefault
public connect ( $choice = NULL ) : nothing | ||
$choice | integer, host number (default NULL) | |
return | nothing |
public function saveAction() { $db = new DBmysql(); $conn = $db->connect(); $last_id = $conn->query("SELECT MAX(ide) as dato from encuestas"); $last_id = mysqli_fetch_array($last_id); $last_id = $last_id['dato'] + 1; $val1 = 1; $query = "INSERT INTO encuestas (" . "ide," . "idForm," . "idMuestra," . "cod_municipio," . "idEstablecimiento," . "idAreaSupervision," . "fechaencuesta," . "resultados," . "cod_usuario," . "phone" . ") VALUES (" . $last_id . "," . $this->idForm . "," . $this->idMuestra . "," . $this->idMunicipio . "," . $this->idEstablecimiento . "," . $this->idAreaSupervision . ",'" . $this->fechaEncuesta . "','" . $this->resultados . "\t'," . $this->idUsuario . "," . $val1 . ");"; echo $query; $conn->query($query); return 0; }
public function getMunicipios() { $db = new DBmysql(); $conn = $db->connect(); $query = "SELECT cod_municipio as id, municipio as name FROM municipios"; $result = $conn->query($query); $municipios = array(); // $query_est = "SELECT * FROM establecimientos"; $ind = 0; while ($row = mysqli_fetch_assoc($result)) { $query_est = "SELECT idEstablecimiento as id, establecimiento as name FROM establecimientos WHERE cod_municipio = " . $row['id']; $result2 = $conn->query($query_est); $establecimientos = array(); while ($row2 = mysqli_fetch_assoc($result2)) { array_push($establecimientos, $row2); } $municipios[$ind]['id'] = $row['id']; $municipios[$ind]['name'] = $row['name']; $municipios[$ind]['establecimientos'] = $establecimientos; //array_push($municipios, $row); $ind++; } return json_encode($this->utf8ize($municipios)); }
private function getRestricciones($idsend) { $db = new DBmysql(); $conn = $db->connect(); $query = "SELECT idRestriccion as id, idPreguntaDestino as destino, idListaValor as valor FROM restricciones WHERE idpregunta =" . $idsend; $result = $conn->query($query); $restricciones = array(); $ind = 0; while ($row = mysqli_fetch_assoc($result)) { $restricciones[$ind]['id'] = $row['id']; $restricciones[$ind]['destino'] = $row['destino']; $restricciones[$ind]['valor'] = $row['valor']; $ind++; } return $restricciones; }
<?php // Database initialization $oDB = new DBmysql($fusebox['dbLogin'], $fusebox['dbPassword'], $fusebox['dbName'], $fusebox['dbHost'], $fusebox['dbPort']); if (!$oDB) { _throw("FCannotInstantiateDB", "Cannot instantiate DB class"); } if (!$oDB->connect()) { _throw("FCannotConnectToDB", "Cannot connect to database server you specified (" . $oDB->getError() . ")"); } // making fake fuseaction for global things $ogFuseaction = new Fuseaction(0, $fusebox['globalFuseaction'], "Entire site", "", $fusebox['globalStickyAttributes']); // FuseManager initialization $oFuseManager = new FuseManager($oDB, $fusebox['tableFuseactions'], false); if (!$oFuseManager->initialize()) { _throw("FNoFuseactionsTable", "There is no fuseactions table called \"{$fusebox['tableFuseactions']}\" present in DB"); } // sync'ing fuseactions if ($fusebox['mode'] == "development") { if (!$oFuseManager->synchronizeFuseactions($fusebox)) { _throw("FCannotSynchronizeFuseactions", "Error occured while synchronizing fuseactions, check your database"); } } // getting current fuseaction $oFuseaction = $oFuseManager->getFuseaction($attributes['fuseaction']); if (!$oFuseaction) { _throw("FNoSuchFuseaction", "There is no fuseaction called \"{$attributes['fuseaction']}\" found"); } // loading 'sticky' attributes values from session for entire site getStickyAttributes($ogFuseaction->getName(), $ogFuseaction->getStickyAttributes()); // loading 'sticky' attributes values from session for this fuseaction
<?php include_once 'FormularioEntity.php'; $user = isset($_GET['user']) ? $_GET['user'] : ''; $pass = isset($_GET['password']) ? $_GET['password'] : ''; $db = new DBmysql(); $conn = $db->connect(); $query = "SELECT * FROM usuarios"; $result = $conn->query($query); $valid = false; while ($row = mysqli_fetch_assoc($result)) { if ($row['usuario'] == $user && $row['password_android'] == $pass) { $valid = true; } //print_r($row);echo "<br>"; } if (!$valid) { $enviar['respuesta'] = 0; $enviar['mensaje'] = "Credenciales incorrectas"; $enviar['muestras'] = array(); print_r($enviar); } else { $formulario = new Formularios(); $formularios = $formulario->getMuestras(); $enviar = array(); $enviar['respuesta'] = 1; $enviar['mensaje'] = "validado exitosamente"; $enviar['muestras'] = $formularios; print_r($enviar); return json_encode($formulario->utf8ize($enviar)); print_r($formularios);
public function saveAction() { $db = new DBmysql(); $conn = $db->connect(); $last_id = $conn->query("SELECT MAX(idModulo) as dato from modulos"); $last_id = mysqli_fetch_array($last_id); $last_id = $last_id['dato'] + 1; $query = "INSERT INTO modulos (idModulo,codModulo,nomModulo) VALUES (" . $last_id . ",'" . $this->codModulo . "','" . $this->nomModulo . "');"; $conn->query($query); return 0; }