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 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62
|
<?php
if(isset($_POST['nom'])) $nom=$_POST['nom'];
else $nom="";
if(isset($_POST['Prenom'])) $prenom=$_POST['Prenom'];
else $prenom="";
if(isset($_POST['club'])) $club=$_POST['club'];
else $club="";
if(isset($_POST['submit2'])) $path_photo=$_POST['submit2'];
else $path_poto="";
if(isset($_POST['jour'])) $jour=$_POST['jour'];
else $jour="";
if(isset($_POST['mois'])) $mois=$_POST['mois'];
else $mois="";
if(isset($_POST['annee'])) $annee=$_POST['annee'];
else $annee="";
if(isset($_POST['login'])) $login=$_POST['login'];
else $login="";
if(isset($_POST['mdp'])) $mdp=$_POST['mdp'];
else $mdp="";
if(isset($_POST['annee'].'-'.$_POST['mois'].'-'.$_POST['jour'])) $date_naiss=$_POST['annee'].'-'.$_POST['mois'].'-'.$_POST['jour'];
else $date_naiss="";
if(empty($nom) OR empty($login) OR empty($mdp))
{
echo '<font color="red">Attention, seul le champs <b>Date de naissance</b> peut rester vide !</font>';
}
else
{
$db = mysql_connect('localhost', 'root', '') or die('Erreur de connexion '.mysql_error());
mysql_select_db('connexion',$db) or die('Erreur de selection '.mysql_error());
$sql = "INSERT INTO licencies(Nom_licencies, Num_licencies, Prenom_licencies,club, path_photo, date_naissance) VALUES('$nom','','$prenom','$club','$path_photo','$date_naiss')";
$sql2 = "INSERT INTO auth(login, motdepasse, ip) VALUES ('$login','$mdp','')";
mysql_query($sql) or die('Erreur SQL !'.$sql.'<br>'.mysql_error());
mysql_query($sql2) or die('Erreur SQL !'.$sql.'<br>'.mysql_error());
echo 'Vos infos on été ajoutées.';
mysql_close(); // on ferme la connexion
}
?> |
Partager