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 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93
| ------
Ajouter.php
------
<code type="php">
<html >
<head>
<title>Ajouter des personnes</title>
</head>
<body bgcolor=pink>
<form name="ajout" method="post" action="Ajouter.php" onSubmit="return verif()" >
<table width="440" align="center" >
<caption align="center" >
<strong> <h2>Ajouter des personnes : </h2></strong><strong></strong>
</caption>
<?
if (isset($_POST['Ajout']))
{
$n1 = $_POST['Nom'];
$p1 = $_POST['Prenom'];
$e1 = $_POST['Email'];
$t1 = $_POST['tel'];
$d1 = date('Y-m-d');
$pos2 = strpos($e1, '@');
$pos3 = strpos($e1, '.');
if($n1=="")
echo'<tr><b><td align="left"><script language="javascript"> document.write("tapez votre nom"); </script></td> </b></tr>';
elseif($p1=="")
echo'<tr><b><td align="left"><script language="javascript"> document.write("tapez votre penom"); </script></td> </b></tr>';
elseif(empty($t1) || (strlen($t)<8))
echo'<tr ><b><td align="left"><script language="javascript"> document.write("tapez votre tel"); </script></td> </b></tr>';
elseif (strpos($e1, '@') <> false || strpos($e1, '.') <> false )
echo'<tr ><b><td align="left"><script language="javascript"> document.write("adresse email nom valide:Votre email doit comporter un "@" et un ".""); </script></td> </b></tr>';
$pos = strpos($e1, '@');
$pos1 = strpos($e1, '.');
if(!empty($n1) && !empty($p1) && !empty($t1) && $t1>=8 && !empty($e1) && $pos <> false && $pos1 <> false)
{
// Connexion au serveur
mysql_connect('localhost','root','') or die("erreur de connexion au serveur");
// Connexion à la base
mysql_select_db('formation') or die("erreur de connexion a la base de données");
// Creation et envoi de la requete
$requet_sql='INSERT INTO user (nom,prenom,tel,email,date_ajout) VALUES ("'.$n1.'","'.$p1.'","'.$t1.'","'.$e1.'","'.$d1.'")';
$res=mysql_query($requet_sql) or die ('Erreur SQL ! '.mysql_error());
echo'<tr align=center "><b><td align="left"><script language="javascript"> document.write("Insertion accepter"); </script></td> </b></tr>';
// Deconnexion de la base de donnees
mysql_close();
}
}
?>
<tr width="84" align="left">
<td height="43" align="left"><strong><em> Nom :</em></strong></td>
<td><em>
<input type="text" name="Nom" size=30 />
</em></td></tr>
<tr> <td width="126" height="39" align="left"><strong><em> Prenom :</em></strong></td>
<td width="302" align="left"><input type="text" name="Prenom" size=30 /></td></tr>
<tr> <td width="126" height="39" align="left"><strong><em> Telephone :</em></strong></td>
<td width="302" align="left"><input type="text" name="tel" size=30 /></td></tr>
<tr width="76" align="left">
<td width="126" height="39" align="left"><strong><em> Email :</em></strong></td>
<td><input type="text" name="Email" size=30 />
</td></tr>
</table>
<br/>
<table width="195" align="center" >
<tr >
<td width="98" height="36" align="center"><input type="submit" name="Ajout" value="Ajouter" /></td>
<td width="97" height="36" align="center"><input type="reset" name="annuler" value="annuler"></td>
</tr>
</table>
</form>
<FORM action="liste.php" >
<table width="498" align="center" >
<tr><td width="512" align="center">
<INPUT type="submit" value="Liste des personnes" align="absmiddle">
</td></tr></table>
</FORM>
</body>
</html>
</code>
------------------ |
Partager