Insertion de ligne en PHP

Question

ily29

23 Jul 2020 à 22:15

Bonjour j'essaye d'insérer une ligne en php dans une base de données mysql voici mon code :

<?php 
session_start();

	$bdd = new PDO('mysql:host=localhost;dbname=espace_membre;charset=utf8', 'root', '');

	if(isset($_POST['formco'])) {
		$pseudo = htmlspecialchars($_POST['pseudo']);
		$mdp = $_POST['mdp'];

		if (!empty($pseudo) AND !empty($mdp)) {
			$reqpseudo = $bdd->prepare('SELECT * FROM membre WHERE pseudo = ?');
			$reqpseudo->execute(array($pseudo));
			$respseudo = $reqpseudo->rowCount();

			if ($respseudo == 1) {
				$reqmdp = $bdd->prepare('SELECT * FROM membre WHERE mdp = ?');
				$reqmdp->execute(array($mdp));
				$resmdp = $reqmdp->rowCount();

				if ($resmdp == 1) {
					$_SESSION['pseudo'] = $pseudo;
					$_SESSION['mdp'] = $mdp;
					header('Location: ../../connecter/Marlin.com.connect.php');
				}
				else { ?>
				<script>alert('Idantifiant ou mot de passe incorect !');</script>
				<?php }
			}
			else { ?>
				<script>alert('Idantifiant ou mot de passe incorect !');</script>
			<?php }
		}
		else {
			$message = "Veuillez remplir toute les cases !";
		}
	}
?>
<html>
	<head>
		<meta charset="utf-8">
		<title>Connexion</title>
		<link rel="stylesheet" type="text/css" href="../../Style/style.css">
		<style type="text/css">
.form_co_style {
	background-color: #d4d2d1;
	width: 500px;
	height: 200px;
	border-radius: 15px;
	box-shadow: 8px 11px 20px 0px rgba(0,0,0,0.2);
}
.form_co_entre {
	margin-left: 20px;
	width: 400px;
	height: 40px;
	border-radius: 10px;
	outline: none;
}
.button_valide {
	margin-left: 10px;
	width: 100px;
	height: 40px;
	background-color: #448aff;
	border-color: #448aff;
	border-radius: 10px;
	outline: none;
}
footer {
	border-top: 2px solid black;
	background-color: white;
	position: absolute;
	bottom: 0;
	width: 100%;
	height: 60px;
}
#main{
	max-width:2000px;
	min-height:100%;
	margin:0 auto;
	position:relative;
}
		</style>
	</head>
	<body>
		<div id="main">
		<nav>
			<ul>
				<li class="accueil"><a href="../../Marlin.com.php">Accueil</a></li>
				<li class="favoris"><a href="../Favoris.php">Favoris</a></li>
				<li class="connexion"><a href="Connexion.php">Connexion</a></li>
				<li class="inscription"><a href="Inscription.php">Inscription</a></li>
			</ul>
		</nav>
		<br/>
		<h1 align="center"><b>Connectez-vous !</b></h1>
		<br/>
		<div align="center">
		<article class="form_co_style" align="center">
			<br/>
		<form method="POST">
			<input type="text" class="form_co_entre" name="pseudo" placeholder="Pseudo" value="<?php if(isset($pseudo)){echo $pseudo;}?>"/><br/>
			<br/>
			<input type="password" class="form_co_entre" name="mdp" placeholder="Mot de passe" /><br/>
			<br/>
			<input type="submit" name="formco" class="button_valide" value="Connexions"/>
 		</form>
 		<?php if(isset($message)){echo "<font color='red'>".$message."</font>";}?>
 		</article>
 		</div>
 		<br/>
 		<footer><h3 align="center">&#169;2020 ## ###### ######</h3></footer>
		</div>
	</body>
</html>

ily29

24 Jul 2020 à 09:31

je me suis tromper de code:


<?php 
	
	$bdd = new PDO('mysql:host=localhost;dbname=espace_membre;charset=utf8', 'root', '');

	if (isset($_POST['formins'])) {

		if (!empty($_POST['pseudo']) AND !empty($_POST['mdp1']) AND !empty($_POST['mdp2']) AND !empty($_POST['email1']) AND !empty($_POST['email2'])) {
		$pseudo = htmlspecialchars($_POST['pseudo']);
		$mdp1 = sha1($_POST['mdp1']);
		$mdp2 = sha1($_POST['mdp2']);
		$email1 = htmlspecialchars($_POST['email1']);
		$email2 = htmlspecialchars($_POST['email2']);
		$reqpseudo = $bdd->prepare('SELECT * FROM membre WHERE pseudo = ?');
		$reqpseudo->execute(array($pseudo));
		$respseudo = $reqpseudo->rowCount();
			if($respseudo == 0) {
				if ($mdp1 == $mdp2) {
					if ($email1 == $email2) {
						$reqmail = $bdd->prepare('SELECT * FROM membre WHERE email = ?');
						$reqmail->execute(array($email1));
						$resmail = $reqmail->rowCount();
						if ($resmail == 0) {
							if (filter_var($email1, FILTER_VALIDATE_EMAIL)) {
								$increm = $bdd->prepare('INSERT INTO membre(pseudo, mdp, email) VALUES( ?, ?, ?)');
								$increm->execute(array($pseudo, $mdp1, $email1));

								$message = "Votre compte à été créer !<a href='Connexion.php'>Me connecter</a>";
							}
							else {
								$message_email_valide = "Votre email n'ai pas valide.";
							}
						}
						else {
							$message_email_valide = "L'email existe déjà.";
						}
					}
					else {
						$message_email = "Vos email de correspondent pas.";
					}
				}
				else {
					$message_mdp = "Les mots de passe ne correspondent pas.";
				}
			}
			else {
				$message_pseudo = "Ce pseudo existe déjà.";
			}
		}
		else {
			$message = "Veuillez remplir toutes les cases.";
		}
	}

?>
<html>
	<head>
		<meta charset="utf-8">
		<title>Inscription</title>
		<link rel="stylesheet" type="text/css" href="../../Style/style.css">
		<style type="text/css">
.form_ins_style {
	background-color: #d4d2d1;
	width: 500px;
	height: 370px;
	border-radius: 15px;
	box-shadow: 8px 11px 20px 0px rgba(0,0,0,0.2);
}
.form_ins_entre {
	margin-left: 20px;
	width: 400px;
	height: 40px;
	border-radius: 10px;
	outline: none;
}
.button_valide {
	margin-left: 10px;
	width: 100px;
	height: 40px;
	background-color: #448aff;
	border-color: #448aff;
	border-radius: 10px;
	outline: none;
}
footer {
	border-top: 2px solid black;
	background-color: white;
	position: absolute;
	bottom: 0;
	width: 100%;
	height: 60px;
}
#main{
	max-width:2000px;
	min-height:100%;
	margin:0 auto;
	position:relative;
}
		</style>
	</head>
	<body>
		<div id="main">
		<nav>
			<ul>
				<li class="accueil"><a href="../../Marlin.com.php">Accueil</a></li>
				<li class="favoris"><a href="../Favoris.php">Favoris</a></li>
				<li class="connexion"><a href="Connexion.php">Connexion</a></li>
				<li class="inscription"><a href="Inscription.php">Inscription</a></li>
			</ul>
		</nav>
		<br/>
		<h1 align="center"><b>Inscrivez-vous!</b></h1>
		<br/>
		<div align="center">
		<article class="form_ins_style">
			<br/>
			<form method="POST">
				<input type="text" name="pseudo" class="form_ins_entre" class="enter_pseudo" value="<?php if(isset($pseudo)){ echo $pseudo; } ?>" placeholder="Votre pseudo"/><br/><?php if(isset($message_pseudo)){echo "<font color='red'>".$message_pseudo."</font>";} ?>
				<br/>
				<input type="password" name="mdp1" class="form_ins_entre" class="enter_mdp" placeholder="Votre mot de passe"/><br/><?php if(isset($message_mdp)){echo "<font color='red'>".$message_mdp."</font>";} ?>
				<br/>
				<input type="password" name="mdp2" class="form_ins_entre" class="enter_mdp" placeholder="Confirmez votre mot de passe"/><br/>
				<br/>
				<input type="email" name="email1" class="form_ins_entre" class="enter_email" value="<?php if(isset($email1)){ echo $email1; } ?>" placeholder="Votre email"/><br/><?php if(isset($message_email)){echo "<font color='red'>".$message_email."</font>";} ?>
				<br/>
				<input type="email" name="email2" class="form_ins_entre" class="enter_email"value="<?php if(isset($email2)){ echo $email2; } ?>" placeholder="Comfirmez votre email"/><br/><?php if(isset($message_email_valide)){echo "<font color='red'>".$message_email_valide."</font>";} ?>
				<br/>
				<input type="submit" value="S'inscrire" class="button_valide" name="formins"/>
			</form>
			<?php
				if (isset($message)) {
					echo "<font color='red'>".$message."</font>";
				}
		    ?>
		</article>
		<br/>
		<br/>
		<br/>
		<br/>
		<br/>
		<footer><h3 align="center"><b>&#169;2020 EL YAOUTI Ilyass</b></h3></footer>
		</div>
	</body>
</html>

parsimonhi

Modérateur

25 Jul 2020 à 09:27

Bonjour,

Et c'était quoi, la question ?

Amicalement,

JENCAL

31 Jul 2020 à 14:29

Salut

Tu as essayé avec bindParam ?

Sujet clos

Questions générales et questions de débutants

Insertion de ligne en PHP