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