function gereConnexion($bdd)
{
/* On récupère la date courante */
list($a, $mo, $j, $h, $m, $s) = dateAuj($bdd);
/* On récupère toutes les connexions */
$sql = 'SELECT Connexion_ID, Last_Connexion, HOUR(Last_Connexion), MINUTE(Last_Connexion), SECOND(Last_Connexion) FROM Connexion ';
$stmt = $bdd->prepare($sql, array(PDO::ATTR_CURSOR, PDO::CURSOR_SCROLL));
$stmt->execute(array());
while ($row = $stmt->fetch(PDO::FETCH_ASSOC, PDO::FETCH_ORI_NEXT)) {
$idco = $row['Connexion_ID'];
$h2 = $row['HOUR(Last_Connexion)'];
$m2 = $row['MINUTE(Last_Connexion)'];
$s2 = $row['SECOND(Last_Connexion)'];
$diff = $h - $h2 + ($m - $m2) / 60 + ($s - $s2) / 3600;
if ($diff > 0.5) {
//On supprime la connexion
/* Récupération du membre id */
$memberID = getMemberID($bdd, $idco);
/* Récupération du basket id */
$basketID = getBasketID($bdd, $memberID);
/* Incrémentation des capacités de toutes les activités supprimées */
setCapacity($bdd, $memberID, $basketID);
/* Suppression des activités non payées */
videBasket($bdd, $basketID);
/* Suppression de la connexion */
suppConnexion($bdd, $idco);
}
}
}
<?php getMemberID(); ?> <header> <div id="pageTitle"> </div> <nav> <ul> <a href="profile.php?id=<?php echo $yourId; ?> "> <li> Profile </li> </a> <a href="edit-list.php?id=<?php echo $_COOKIE['online']; ?> "> <li> Your List </li> </a> <a href="settings.php?id=<?php echo $_COOKIE['online']; ?> "> <li> Settings
function miseajourinfos($bdd, $idco, $email, $nom, $prenom, $rue, $num, $cadr, $cp, $ville, $tel, $portable)
{
$memberid = getMemberID($bdd, $idco);
$sql = 'SELECT Person_ID FROM Member WHERE (Member_ID = :id)';
$stmt = $bdd->prepare($sql, array(PDO::ATTR_CURSOR, PDO::CURSOR_SCROLL));
$stmt->execute(array(':id' => "{$memberid}"));
$row = $stmt->fetch(PDO::FETCH_ASSOC, PDO::FETCH_ORI_NEXT);
$personid = $row["Person_ID"];
$sql2 = 'UPDATE Member SET Member_Email= :email ,Member_Street = :street,Member_Postal_Code = :cp,Member_Additional_Adress = :cadr,Member_City = :city,Member_Phone = :phone,Member_Mobile = :mobile,Member_Num = :num WHERE (Member_ID = :id)';
$stmt = $bdd->prepare($sql2);
$stmt->execute(array('email' => "{$email}", 'street' => "{$rue}", 'cp' => "{$cp}", 'cadr' => "{$cadr}", 'city' => "{$ville}", 'phone' => "{$tel}", 'mobile' => "{$portable}", 'num' => "{$num}", 'id' => "{$memberid}"));
$sql2 = 'UPDATE Person SET Person_Lastname= :nom ,Person_Firstname= :prenom WHERE (Person_ID = :id)';
$stmt = $bdd->prepare($sql2);
$stmt->execute(array('nom' => "{$nom}", 'prenom' => "{$prenom}", 'id' => "{$personid}"));
}
function submitEmergencyContactInformation($submittedFirstName, $submittedLastName, $submittedPhone, $submittedRelationship, $submittedEmail)
{
try {
$connection = new PDO("mysql:host=" . DB_HOST_NAME . ";dbname=" . DB_NAME . ";charset=utf8", DB_USER_NAME, DB_PASSWORD);
// Exceptions fire when occur
$connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$accountInformationUpdate = $connection->prepare("\n INSERT INTO " . EMERGENCY_CONTACTS_TABLE . "(FIRSTNAME, LASTNAME, PHONE, RELATIONSHIP, MEMBER_ID)\n VALUES (:submittedFirstName, :submittedLastName, :submittedPhone, :submittedRelationship, '" . getMemberID($submittedEmail) . "')");
$accountInformationUpdate->execute(array(':submittedFirstName' => $submittedFirstName, ':submittedLastName' => $submittedLastName, ':submittedPhone' => $submittedPhone, ':submittedRelationship' => $submittedRelationship));
} catch (PDOException $e) {
echo "\n <div>\n Error2: " . $e->getMessage() . "</div>";
return FALSE;
}
return TRUE;
}
