function getArraySQL($sql)
{
//Creamos la conexión con la función anterior
$conexion = connectDB();
//generamos la consulta
mysqli_set_charset($conexion, "utf8");
//formato de datos utf8
$result = mysqli_query($conexion, $sql);
if (!$sql) {
echo "La consulta no se logró: " . mysql_error();
die;
//si la conexión cancelar programa
}
//creamos un array
$rawdata = array();
//guardamos en un array multidimensional todos los datos de la consulta
$i = 0;
while ($row = mysqli_fetch_array($result)) {
$rawdata[$i] = $row;
$i++;
}
header("Content-type: application/json");
header("Access-Control-Allow-Origin: *");
disconnectDB($conexion);
//desconectamos la base de datos
return $rawdata;
//devolvemos el array
}
function getArraySQL($sql, $DB)
{
//Creamos la conexión con la función anterior
$conexion = connectDB();
mysqli_select_db($conexion, $DB);
//selecciono la base de datos
//generamos la consulta
mysqli_set_charset($conexion, "utf8");
//formato de datos utf8
if (!($result = mysqli_query($conexion, $sql))) {
die;
}
//si la conexión cancelar programa
$rawdata = array();
//creamos un array
//guardamos en un array multidimensional todos los datos de la consulta
$i = 0;
while ($row = mysqli_fetch_array($result)) {
$rawdata[$i] = $row;
$i++;
}
disconnectDB($conexion);
//desconectamos la base de datos
return $rawdata;
//devolvemos el array
}
function exeSQL($sql)
{
//Creamos la conexión con la función anterior
$conexion = connectDB();
//generamos la consulta
mysqli_set_charset($conexion, "utf8");
//formato de datos utf8
if (!($result = mysqli_query($conexion, $sql))) {
die;
}
//si la conexión cancelar programa
disconnectDB($conexion);
//desconectamos la base de datos
}
function getArraySQL($query)
{
//Creamos la conexion a la DB
$conexion = connectDB();
//Hacemos la consulta
$result = mysqli_query($conexion, $query);
if (!$result) {
die;
//Si la conexion NO fue exitosa, cancela el programa
}
//Creamos un array de datos
$rawdata = array();
//Guardamos un array multidimensional todos los datos de la consulta
$i = 0;
while ($row = mysqli_fetch_array($result)) {
$rawdata[$i] = $row;
$i++;
}
//Desconectamos la DB
disconnectDB($conexion);
//Retornamos el array
return $rawdata;
}
echo "If you press button \"Delete TMP Files\" all tmp files will be lost";
echo "<INPUT type=\"hidden\" name=\"delete_registry\" value=\"tmp\"";
echo "<br>";
echo "<br>";
echo "<INPUT type=\"Submit\" value=\"Delete TMP Files\"><br></br>";
echo "</FORM>";
echo "<FORM name=\"svuota_registry\" action=\"./DB_SERVICES/SVUOTA_REGISTRY_DB.php\" method=\"POST\"onSubmit=\"return conferma()\">";
echo "If you press button \"Delete Database\" all references of documents in the Registry Database will be lost";
echo "<INPUT type=\"hidden\" name=\"delete_registry\" value=\"database\"";
echo "<br>";
echo "<br>";
echo "<INPUT type=\"Submit\" value=\"Delete Registry\"><br></br>";
echo "</FORM>";
}
#################### PASSWORD ####################
$get_USER = "******";
$res_USER = query_select2($get_USER, $connessione);
$USER_login = $res_USER[0][0];
echo "<h3>Setup User and password</h3>";
echo "If you change login or password <br>you must fill the new login e the new password <br>immediately after you press update<br><br>";
echo "<FORM name=\"myForm\" action=\"updateuser.php\" method=\"POST\"onSubmit=\"return validatePwd()\">";
echo "Login: <INPUT type=\"text\" name=\"login\" value=\"{$USER_login}\" size=\"20\" maxlength=\"30\"><br></br>";
echo "Password: <INPUT type=\"password\" name=\"password\" value=\"\" size=\"10\" maxlength=\"20\"><br></br>";
echo "Verify Password: <INPUT type=\"password\" name=\"password2\" value=\"\" size=\"10\" maxlength=\"20\"><br></br>";
echo "<INPUT type=\"Submit\" value=\"Update User\"><br></br>";
echo "</FORM>";
echo "</td></tr>";
echo '<tr bgcolor="black"><td colspan="2"><br><br></td></tr></table>';
}
disconnectDB($connessione);
<?php
#include utility.php
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$fname = cleanInput($_POST["fname"]);
$lname = cleanInput($_POST["lname"]);
$dobM = cleanInput($_POST["dobM"]);
$dobD = cleanInput($_POST["dobD"]);
$dobY = cleanInput($_POST["dobY"]);
$email = cleanInput($_POST["email"]);
$pass = cleanInput($_POST["pass"]);
error_log("Processing: {$fname} {$lname}");
logMsg('Storing Data:' . $fname);
$dbconn = connectToDB();
$query = "insert into logIn_PingIt (first, last, dobM, dobD, dobY, email, pass) values ('\${$fname}', '{$lname}', '{$dobM}', '{$dobD}', '{$dobY}', '{$email}', '{$pass}');";
logMsg($query);
$result = $dbconn->query($query);
if (!$result) {
logMsgAndDie('Error loading data!!!!');
} else {
logMsg('Good data load!');
}
disconnectDB($dbconn);
}
$stmt->bindValue(3, htmlspecialchars($end), SQLITE3_TEXT);
$stmt->bindValue(4, htmlspecialchars($where), SQLITE3_TEXT);
$result = $stmt->execute();
return $result;
}
if (isset($_POST) && isset($_POST['action'])) {
$dbConnection = connectDB();
$action = $_POST['action'];
if ($dbConnection) {
switch ($action) {
case 'getParties':
$retarr = getParties($dbConnection);
break;
case 'deleteParty':
$retarr = deleteParty($dbConnection, $_POST['party']);
break;
case 'addParty':
$retarr = addParty($dbConnection, $_POST['partyname'], $_POST['partystart'], $_POST['partyend'], $_POST['partyplace']);
break;
default:
$retarr['error'] = 'Unknown action';
break;
}
disconnectDB($dbConnection);
} else {
$retarr = getErrorArray("Couldn't connect database");
}
} else {
$retarr['error'] = 'Unknown method';
}
echo json_encode($retarr);
<?php
include 'includes/fonctions.php';
$id_visiteur = htmlspecialchars($_POST['id']);
$prenom = htmlspecialchars($_POST['prenom']);
$nom = htmlspecialchars($_POST['nom']);
$email = htmlspecialchars($_POST['email']);
$site_web = htmlspecialchars($_POST['site_web']);
$ville = htmlspecialchars($_POST['ville']);
$etudes = htmlspecialchars($_POST['etudes']);
$photo = htmlspecialchars($_POST['photo']);
if (isset($_POST['autorisation'])) {
$autorisation = "1";
} else {
$autorisation = "0";
}
$ateliersVisites = $_POST['ateliersVisites'];
$myDB = connectDB();
$sql = 'UPDATE visiteurs SET prenom="' . $prenom . '", nom="' . $nom . '", email="' . $email . '", etudes="' . $etudes . '", photo="' . $photo . '", site_web="' . $site_web . '", ville="' . $ville . '", autorisation=' . $autorisation . ' WHERE id_visiteur = ' . $id_visiteur;
$insert = $myDB->query($sql);
$sql = 'DELETE FROM ateliers_visites WHERE id_visiteur LIKE ' . $id_visiteur;
$clear = $myDB->query($sql);
$i = 1;
foreach ($ateliersVisites as $id_atelier) {
$sql = 'INSERT INTO ateliers_visites(id_visiteur, id_atelier) VALUES (' . $id_visiteur . ', ' . htmlspecialchars($id_atelier) . ')';
$myDB->query($sql);
}
disconnectDB($myDB);
header('Location: visiteur.php?id=' . $id_visiteur);
function infosVisiteursAtelier($atelier)
{
$myDB = connectDB();
$sql = 'SELECT visiteurs.id_visiteur, visiteurs.nom, visiteurs.prenom FROM visiteurs, ateliers_visites WHERE visiteurs.id_visiteur=ateliers_visites.id_visiteur AND ateliers_visites.id_atelier LIKE ' . $atelier;
$infosVisiteurs = $myDB->query($sql);
$i = 1;
while ($myData = $infosVisiteurs->fetch()) {
$myVisiteurs[$i]['id_visiteur'] = $myData['id_visiteur'];
$myVisiteurs[$i]['prenom'] = $myData['prenom'];
$myVisiteurs[$i]['nom'] = $myData['nom'];
$i++;
}
disconnectDB($myDB);
return $myVisiteurs;
}
// Append Row Data to Result Set
$resultSet[] = array('index'=>$rowIndex++, 'cells'=>$cells);
}
// Make sure we don't have an extra row; we use that to determine if we're at end of record set
if (count($resultSet) > $request['rows']) {
array_pop($resultSet);
} else {
$resultSetInfo['end'] = true;
}
}
// Add Result Set to Response Data
$responseData['resultSet'] = $resultSet;
// Add Result Set Info to Response Data
$responseData['resultSetInfo'] = $resultSetInfo;
// Add Column Model to Response Data
if ($request['columnModel']) {
$responseData['columnModel'] = getColumnModel();
}
// Disconnect from DB
disconnectDB();
// Output Response Data in JSON format
echo json_encode($responseData);
?>
function getUserArticles($idUser)
{
$myDB = connectDB();
$sql = 'SELECT * FROM articles WHERE id_utilisateur = ' . $idUser;
$articleReq = $myDB->query($sql);
$verif = getUserArticles($idUser);
disconnectDB($myDB);
if ($verif != 0) {
$i = 1;
while ($myData = $articleReq->fetch()) {
$userArticle[$i]['id'] = $myData['id_article'];
$userArticle[$i]['date'] = $myData['date'];
$userArticle[$i]['titre'] = $myData['Titre'];
$userArticle[$i]['text'] = $myData['text'];
$i++;
}
return $userArticle;
} else {
return null;
}
}
