1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
| function saveSignature(){
$nom = mysql_real_escape_string($_POST['nom']);
$prenom = mysql_real_escape_string($_POST['prenom']);
$adresse = mysql_real_escape_string($_POST['adresse']);
$prof = mysql_real_escape_string($_POST['profession']);
if ($this->checkEntry($nom,$prenom)){
$query = sprintf("INSERT INTO signataire (`nom`, `prenom`, `adresse`, `profession`, `date`)
VALUES ('%s', '%s', '%s','%s', NOW())",
$nom, $prenom, $adresse, $prof );
if (mysql_query($query))
return true;
}
else
return false;
}
function checkEntry($nom,$prenom){
$query = sprintf("SELECT COUNT(*) FROM signataire WHERE nom='%s' AND prenom='%s'",$nom ,$prenom);
echo $query;
$check = mysql_query($query);
if (mysql_result($check,0,0) == 0){
return true;
}
else {
return false;
}
} |
Partager