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