lundi 16 février 2015

Store input checkbox values into MySQL database

Even after some extensive research on stackOverflow, I currently haven't found the solution of my problem.


Basically, I have multiple input checkbox and when the user clicks "OK", the values are stored in a specific MYSQL database. I managed to store everything, text input, tel, date etc but not the checkboxes values! In MYSQL, "jeux" is set as a varchar(256). My error:


Error: INSERT INTO donnees (nom, prenom, adresse, tel, email, adresse2, date, nb_invite, evenement, jeux) VALUES ('hergiuyer', 'rsthrsr', 'tnrhdsh', 'rsthnrs', 'rtsnhtdyhjr', 'ntherjhtyg', 'hzrh'edr', 'hre(rsjher', 'rjhedtjher', 'Chuck-à-Luck, Roulette, Stud Poker') You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'edr', 'hre(rsjher', 'rjhedtjher', 'Chuck-à-Luck, Roulette, Stud Poker')' at line 2


How can I store them?


vos_jeux.php



<form method="post" action="end.php">
<p>
Cochez les jeux désirés pour votre soirée:<br>

<label for="blackjack"><img src="img/blackjack.jpg" alt=""></label>
<INPUT id="blackjack" type="checkbox" name="game[]" value="Blackjack">

<label for="chuckaluck"><img src="img/chuckaluck.jpg" alt=""></label>
<INPUT id="chuckaluck" type="checkbox" name="game[]" value="Chuck-à-Luck">

<label for="roulette"><img src="img/roulette.jpg" alt=""></label>
<INPUT id="roulette" type="checkbox" name="game[]" value="Roulette">

<label for="stud"><img src="img/stud.jpg" alt=""></label>
<INPUT id="stud" type="checkbox" name="game[]" value="Stud Poker">

<label for="holdem"><img src="img/holdem.jpg" alt=""></label>
<INPUT id="holdem" type="checkbox" name="game[]" value="Holdem Poker">

<label for="boule"><img src="img/boule.jpg" alt=""></label>
<INPUT id="boule" type="checkbox" name="game[]" value="La Boule">

<input type="button" value="Retour en arrière" onClick="self.history.back();">
<input type="submit" name="submit" value="Poursuivre">
</p>


end.php



<?php

include "connect.php";

$nom = $_POST['nom'];
$prenom = $_POST['prenom'];
$adresse = $_POST['adresse'];
$tel = $_POST['tel'];
$mail = $_POST['mail'];
$adresse2 = $_POST['adresse2'];
$date = $_POST['date'];
$nb_invite = $_POST['nb_invite'];
$evenement = $_POST['evenement'];
$game = implode(', ', $_POST['game']);

mysql_query("SET NAMES UTF8");

$sql = "INSERT INTO donnees (nom, prenom, adresse, tel, email, adresse2, date, nb_invite, evenement, jeux)
VALUES ('$nom', '$prenom', '$adresse', '$tel', '$mail', '$adresse2', '$date', '$nb_invite', '$evenement', '$game')";

if (mysqli_query($conn, $sql)) {
echo "";
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}

mysqli_close($conn);
?>




Aucun commentaire:

Enregistrer un commentaire