salut les amis je suis en train de concevoir un site web dynamique mais après la conception de mes formulaires ,je n'arrive pas à insérer les informations de mes formulaires dans ma base de données donc je vais vous donner le nom de ma base de données , une table, un formulaire et les scripts php/mysql
nom de la base de données: synafepci
nom de la table: membre
Structure de la table `membre`
--
CREATE TABLE `membre` (
`id_membre` int(11) NOT NULL auto_increment,
`nom` varchar(10) NOT NULL,
`prenom` varchar(20) NOT NULL,
`sexe` varchar(10) NOT NULL,
`emploi_actuel` varchar(30) NOT NULL,
`adresse` varchar(20) NOT NULL,
`telephone` varchar(20) NOT NULL,
`ville` varchar(30) NOT NULL,
`ecole` varchar(50) NOT NULL,
`email` varchar(25) NOT NULL,
`login` varchar(15) NOT NULL,
`passe` varchar(50) NOT NULL,
PRIMARY KEY (`id_membre`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
formulaire et script php/mysql<body>
<form method="post" action="">
<table width="539" border="0" cellspacing="0" cellpadding="5" bgcolor="#c3cacc">
<tr height="45">
<td colspan="2" width="529" height="45">
<div align="center"><font size="3" face="Helvetica, Geneva, Arial, SunSans-Regular, sans-serif"><strong>FORMULAIRE MEMBRE <br />
<br />
</strong></font></div>
</td>
</tr>
<tr height="32">
<td width="127" height="32">
<div align="left"><strong>Nom</strong></div>
</td>
<td width="392" height="32">
<div align="left">
<font size="2" face="Helvetica, Geneva, Arial, SunSans-Regular, sans-serif"><input type="text" name="motcle" size="45" /></font></div>
</td>
</tr>
<tr height="30">
<td width="127" height="30">
<div align="left"><font size="2" face="Helvetica, Geneva, Arial, SunSans-Regular, sans-serif"><strong>Prénom</strong></font></div>
</td>
<td width="392" height="30">
<div align="left">
<font size="2" face="Helvetica, Geneva, Arial, SunSans-Regular, sans-serif"><input type="text" name="motcle" size="45" /></font></div>
</td>
</tr>
<tr height="30">
<td width="127" height="30">
<div align="left"><font size="2" face="Helvetica, Geneva, Arial, SunSans-Regular, sans-serif"><strong>Sexe</strong></font></div>
</td>
<td width="392" height="30">
<div align="left">
<font size="2" face="Helvetica, Geneva, Arial, SunSans-Regular, sans-serif"><select name="sexe" size="1">
<option value="" selected="selected"></option>
<option value="Masculin">Masculin</option>
<option value="Feminnin">Feminin</option>
</select></font></div>
</td>
</tr>
<tr height="30">
<td width="127" height="30">
<div align="left">
<font size="2" face="Helvetica, Geneva, Arial, SunSans-Regular, sans-serif"><strong>Emploi actuel</strong> </font></div>
</td>
<td width="392" height="30">
<div align="left"><input type="text" name="motcle" size="45" /></div>
</td>
</tr>
<tr height="80">
<td width="127" height="80">
<div align="left"><font size="2" face="Helvetica, Geneva, Arial, SunSans-Regular, sans-serif"><strong>Adresse</strong></font></div>
</td>
<td width="392" height="80">
<div align="left">
<textarea name="parties" rows="3" cols="45"></textarea></div>
</td>
</tr>
<tr height="30">
<td width="127" height="30">
<div align="left"><font size="2" face="Helvetica, Geneva, Arial, SunSans-Regular, sans-serif"><strong>Téléphone</strong></font></div>
</td>
<td width="392" height="30">
<div align="left"><input type="text" name="motcle" size="45" /></div>
</td>
</tr>
<tr height="30">
<td width="127" height="30">
<div align="left"><font size="2" face="Helvetica, Geneva, Arial, SunSans-Regular, sans-serif"><strong>Ville</strong></font></div>
</td>
<td width="392" height="30">
<div align="left"><input type="text" name="motcle" size="45" /></div>
</td>
</tr>
<tr height="80">
<td width="127" height="80">
<div align="left"><font size="2" face="Helvetica, Geneva, Arial, SunSans-Regular, sans-serif"><strong>Ecole</strong></font></div>
</td>
<td width="392" height="80">
<div align="left">
<textarea name="parties" rows="3" cols="45"></textarea></div>
</td>
</tr>
<tr height="30">
<td width="127" height="30">
<div align="left"><strong><font size="2" face="Helvetica, Geneva, Arial, SunSans-Regular, sans-serif">Email</font></strong></div>
</td>
<td width="392" height="30">
<div align="left"><input type="text" name="motcle" size="45" /></div>
</td>
</tr>
<tr height="30">
<td width="127" height="30">
<div align="left"><font size="2" face="Helvetica, Geneva, Arial, SunSans-Regular, sans-serif"><strong>Login</strong> </font></div>
</td>
<td width="392" height="30">
<div align="left"><input type="text" name="motcle" size="45" /></div>
</td>
</tr>
<tr height="30">
<td width="127" height="30">
<div align="left"><font size="2" face="Helvetica, Geneva, Arial, SunSans-Regular, sans-serif"><strong>Mot de passe</strong> </font></div>
</td>
<td width="392" height="30">
<div align="left"><input type="text" name="motcle" size="45" /></div>
</td>
</tr>
<tr height="80">
<td colspan="2" width="529" height="80">
<div align="center">
<input type="reset" value="Valider" /></div>
</td>
</tr>
</table>
<font face="Verdana, Arial, Helvetica, sans-serif"><strong><font size="3"><br />
<br />
</font></strong></font>
</form>
<?php
$hte = "localhost";
$usa = "root";
$pwor = "";
$bod = "synafepci";
$can = mysql_connect($hte, $usa, $pwor);
mysql_select_db($bd) or die("Impossible de se connecter a la base de donnees $bod");
$requet = "SELECT * FROM action"; //requete SQL
mysql_query($requet); //Execute la requete SQL sur la connection actuel et la base de donnee semectionne par mysql_select_db
$nom=isset($_POST['Nom'])? $_POST['Nom']):'';
$prenom=isset($_POST['Prénom'])? $_POST['Prénom']:'';
$sexe=isset($_POST['Sexe'])? $_POST['Sexe']:'';
$emploi=isset($_POST['Emploi actuel'])? $_POST['Emploi actuel']:'';
$adresse=isset($_POST['Adresse'])? $_POST['Adresse']):'';
$tel=isset($_POST['Téléphone'])? $_POST['Téléphone']:'';
$vil=isset($_POST['Ville'])? $_POST['Ville']:'';
$ecole=isset($_POST['Ecole'])? $_POST['Ecole']:'';
$mail=isset($_POST['Email'])? $_POST['Email']:'';
$log=isset($_POST['Login'])? $_POST['Login']:'';
$mot=isset($_POST['Mot de passe'])? $_POST['Mot de passe']:'';
//echo "Nom: $nom, Prénom: $prenom,Sexe: $sexe,Emploi actuel: $emploi,Adresse: $adresse,Téléphone: $tel,Ville: $vil,Ecole: $ecole,Email: $mail,Login: $log,Mot de passe: $mot";
if (!empty($nom) AND !empty($prenom) AND !empty($sexe) AND !empty($emploi) AND !empty($adresse)AND !empty($tel) AND !empty($vil) AND !empty($ecole) AND !empty($mail) AND !empty($log) AND !empty($mot)
)
{
// echo "essai";
// exit;
mysql_connect ('localhost','root','');
mysql_select_db ("synafepci");
mysql_query ("INSERT INTO membre (id_membre, nom, prenom, sexe, emploi_actuel, adresse, telephone, ville, ecole, email, login, passe) VALUES ('','Nom','Prénom','Sexe','Emploi actuel','Adresse','Téléphone','Ville','Ecole','Email','Login','Mot de passe')");
mysql_close ();
?>
</body>
</html>
merci et s'il vous c'est mon theme de stage