function updateAdherent($id, $conn)
{
// Récuperation des anciennes datas de l'adherent avec son $id
$query = "SELECT * FROM adherents where id_adherent={$id}";
$statement = $conn->query($query);
while ($obj = $statement->fetch(PDO::FETCH_OBJ)) {
// boucle sur le resultat du fetch de l'objet statement
$datas["id"] = $obj->id_adherent;
$datas["nom"] = $obj->nom;
$datas["prenom"] = $obj->prenom;
$civilite = $obj->civilite;
$datas["date_naissance"] = $obj->date_naissance;
$datas["adresse"] = $obj->adresse;
$datas["email"] = $obj->email;
$datas["codepostal"] = $obj->codepostal;
$datas["etat"] = $obj->etat;
$datas["civilite"] = $civilite == "mr" ? "1" : ($civilite == "mme" ? "2" : "3");
}
$form = formAdherent("", "modifier", $datas);
// Traitement du submit du formulaire de modification
if (isset($_POST["submit"])) {
if ($_POST["civilite"] != "0" and !empty($_POST["nom"]) and !empty($_POST["prenom"]) and validMail($_POST["email"])) {
// premiere validation
$date = $_POST["annee"] . "-" . $_POST["mois"] . "-" . $_POST["jour"];
if (checkdate($_POST["mois"], $_POST["jour"], $_POST["annee"])) {
// deuxième validation
$civilite = $_POST["civilite"] == "1" ? "mr" : ($_POST["civilite"] == "2" ? "mme" : "mlle");
$nom = utf8_decode($_POST["nom"]);
// decode les jeux de cractères utf8 en un code lisible pour mysql
$prenom = utf8_decode($_POST["prenom"]);
$email = $_POST["email"];
$adresse = utf8_decode($_POST["adresse"]);
$codepostal = $_POST["codepostal"];
$etat = $_POST["etat"];
// Création d'une requete update pour mise à jour del'adherent id
$query = "UPDATE `association`.`adherents` SET `civilite` = '" . $civilite . "' , `nom` = '" . $nom . "', `prenom` = '" . $prenom . "', `date_naissance` = '" . $date . "', `email` = '" . $email . "', `adresse` = '" . $adresse . "', `etat` = '" . $etat . "', `codepostal` = '" . $codepostal . "' WHERE `adherents`.`id_adherent` = " . $id . ";";
// requête update sur la table adherents à partir de la connexion $conn
if ($conn->exec($query)) {
header("Location:adherents.php");
}
}
} else {
// donnée prenom non valide
$errors .= "<span class='alert alert-danger'>Vos données ne sont pas renseignées</span>";
// messages d'erreurs
}
if (!empty($errors)) {
echo $errors;
}
// affichage d'erreurs
}
echo $form;
}
function sendMail($mailTo, $text = '', $subject = '', $mailFrom = '', $nameTo = '', $nameFrom = '')
{
$mailTo = (string) $mailTo;
$mailFrom = (string) $mailFrom;
$text = (string) $text;
$subject = (string) $subject;
$nameTo = (string) $nameTo;
$nameFrom = (string) $nameFrom;
// if $mailTo is not valid or $mailFrom is not empty and not valid
if (!validMail($mailTo) || !empty($mailFrom) && !validMail($mailFrom)) {
return 0;
}
$to = $nameTo . ' <' . $mailTo . '>';
$from = $nameFrom . ' <' . $mailFrom . '>';
$headers = 'MIME-Version: 1.0' . '\\r\\n';
$headers .= 'From: ' . $from . '\\r\\n';
return mail($to, $subject, $text, $headers);
}
CEP = [0-9]{2}\.[0-9]{3}\-[0-9]{3} 00.000-000
CPF = [0-9]{3}\.[0-9]{3}\.[0-9]{3}\-[0-9]{2}
URL = http(s)?:\/\/(www\.)?[a-z0-9_\.\-]*[a-z0-9_\.\-]+\.[a-z]{2,4}
$string = 'https://www.upinside.com.br';
if(preg_match('/^$/',$string)){
echo 'Accept';
}else{
echo 'Erro';
}
*/
// /^(http|https):\/\/[a-z0-9]+([\-\.]{1}[a-z0-9]+)*\.[a-z]{2,5}'.'((:[0-9]{1,5})?\/.*)?$/i
$string = 'http://www.as.com.br';
if (preg_match('/^(http|https):\\/\\/[a-z0-9]+([\\-\\.]{1}[a-z0-9]+)*\\.[a-z]{2,5}' . '((:[0-9]{1,5})?\\/.*)?$/i', $string)) {
echo 'Accept<br /><br />';
} else {
echo 'Erro<br /><br />';
}
function validMail($email)
{
if (preg_match('/[a-z0-9_\\.\\-]+@[a-z0-9_\\.\\-]*[a-z0-9_\\.\\-]+\\.[a-z]{2,4}$/', $email)) {
return true;
} else {
return false;
}
}
if (!validMail('*****@*****.**')) {
echo 'Informe um e-mail válido!';
} else {
echo 'E-mail válido!';
}
<?php
require "includes/config.inc.php";
include "includes/fonction.inc.php";
include "includes/header.inc.php";
$errors = "";
$succes = "";
if (isset($_POST["submit"])) {
if ($_POST["civilite"] != "0" and !empty($_POST["nom"]) and !empty($_POST["prenom"]) and validMail($_POST["email"])) {
// premiere validation
$date = $_POST["annee"] . "-" . $_POST["mois"] . "-" . $_POST["jour"];
if (checkdate($_POST["mois"], $_POST["jour"], $_POST["annee"])) {
// Validation de la date de naissance
$civilite = $_POST["civilite"] == "1" ? "mr" : ($_POST["civilite"] == "2" ? "mme" : "mlle");
// decode les jeux de cractères utf8 en un code lisible pour mysql
$nom = utf8_decode($_POST["nom"]);
$prenom = utf8_decode($_POST["prenom"]);
$email = $_POST["email"];
$adresse = utf8_decode($_POST["adresse"]);
$codepostal = $_POST["codepostal"];
$etat = $_POST["etat"];
$nbr_enfants = $_POST["nbr_enfants"];
// nbr d'enfants renseigné par l'utilisateur lors de la première étape d'inscription
// Inertion d'un nouveau adherent dans la table adherent
$query = "INSERT INTO `adherents`(`id_adherent`, `civilite`, `nom`, `prenom` , `date_naissance`, `email` , `adresse` , `codepostal` , `etat` )\n VALUES (NULL,'{$civilite}' , '{$nom}' ,'{$prenom}', '{$date}', '{$email}' , '{$adresse}' , '{$codepostal}' , '{$etat}');";
// requête insert sur la table employes à partir de la connexion $conn
$count = $conn->exec($query);
// nombre d'enregistrement ajouté avec l'insert
if ($count) {
$last = $conn->lastInsertId();
if ($_POST["nbr_enfants"] > 1) {
$the_type = $v;
$has_type = true;
}
} elseif (filter_var($variable, FILTER_SANITIZE_STRING) == 'g-recaptcha-response') {
if ($use_reCaptcha) {
$response = $reCaptcha->verifyResponse($_SERVER["REMOTE_ADDR"], $v);
if ($response == null || !$response->success) {
$output = json_encode(array('type' => 'error', 'text' => 'Please check the Captcha!'));
die($output);
}
}
} else {
$o_string .= filter_var($variable, FILTER_SANITIZE_STRING) . ': ' . filter_var($v, FILTER_SANITIZE_STRING) . " - \n";
if (filter_var($variable, FILTER_SANITIZE_STRING) == 'email') {
$user_Email = $v;
if (!validMail($user_Email)) {
$output = json_encode(array('type' => 'error', 'text' => 'Please enter a valid email!'));
die($output);
}
} else {
$pix_extra[filter_var($variable, FILTER_SANITIZE_STRING)] = filter_var($v, FILTER_SANITIZE_STRING);
}
// if($use_reCaptcha){
// if(filter_var($variable, FILTER_SANITIZE_STRING) == 'g-recaptcha-response'){
// $response = $reCaptcha->verifyResponse(
// $_SERVER["REMOTE_ADDR"],
// $v
// );
// if ($response == null || (!$response->success)) {
// $output = json_encode(array('type'=>'error', 'text' => 'Please check the Captcha!'));
// die($output);
