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;
}
