Warning: mysql_query() expects parameter 2 to be resource
Résolu
timri
Messages postés
5
Statut
Membre
-
timri Messages postés 5 Statut Membre -
timri Messages postés 5 Statut Membre -
Bonjour
Besoin d'aide
J'ai cette erreur lorsque je clique sur le button submit de mon formulaire
Warning: mysql_query() expects parameter 2 to be resource, boolean given in C:\wamp\ on line 30
voilà le code
<?php
$link = mysqli_connect('localhost', 'root', '');
if (!$link) {
die('Impossible de se connecter : ' . mysql_error());
}
// Rendre la base de données foo, la base courante
$db_selected = mysqli_select_db($link, 'akwi_form');
if (!$db_selected) {
die ('Impossible de sélectionner la base de données : ' . mysql_error());
}
if ( isset($_POST['submit'])){
$fatherNat=$_POST['country'];
$fatherReg=$_POST['region'];
$fatherDiv=$_POST['division'];
$fatherDia=$_POST['dialect'];
$motherNat=$_POST['country1'];
$motherReg=$_POST['region1'];
$motherDiv=$_POST['division1'];
$motherDia=$_POST['dialect1'];
$childDia=$_POST['dialect2'];
$childDia2=$_POST['dialect3'];
$childTribe=$_POST['tribe'];
$childFoot=$_POST['foot'];
$childFits=$_POST['fits'];
$sql="INSERT INTO parents VALUES('', $fatherNat, $fatherReg, $fatherDiv, $fatherDia, $motherNat,
$motherReg,$motherDiv ,$motherDia ,$childDia ,$childDia2 ,$childTribe ,$childFoot, $childFits)";
$requete = mysql_query($sql, $db_selected) or die( mysql_error() ) ;
if($requete)
{
echo("L'insertion a été correctement effectuée") ;
}
else
{
echo("L'insertion à échouée") ;
}
}
?>
<!DOCTYPE html>
<html>
<head>
<title>Demo Beautiful Registration Form with HTML5 and CSS3</title>
<meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7; IE=EmulateIE9">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1.0, user-scalable=no"/>
<link rel="stylesheet" type="text/css" href="style.css" media="all" />
<link rel="stylesheet" type="text/css" href="demo.css" media="all" />
</head>
<body>
<div class="container">
<!-- freshdesignweb top bar -->
<header>
<h1>CULTURE DATA BASE - PLEASE COMPLETE ONE PER FAMILY</h1>
<p>Culture is an integral part of our lives and comes from our heritage. Each child needs to have basic information about his/her origin, the dialects spoken by parents, special/traditional out fits and some common foods/dishes of that locality. In order to assist the school to work with each child we need information about your origin.</p>
</header>
<div class="form">
<form id="contactform" method="POST">
<h2>About father</h2><hr/>
<p class="contact"><label for="country">Country or Nationality</label></p>
<input id="name" name="country" required="" tabindex="1" type="text">
<p class="contact"><label for="region">Region of origin</label></p>
<input id="name" name="region" required="" tabindex="1" type="text">
<p class="contact"><label for="division">Division and Subdivision</label></p>
<input id="name" name="division" required="" tabindex="1" type="text">
<p class="contact"><label for="dialect">Dialect spoken</label></p>
<input id="name" name="dialect" required="" tabindex="1" type="text">
<h2>About mother</h2><hr/>
<p class="contact"><label for="country1">Country or Nationality</label></p>
<input id="name" name="country1" required="" tabindex="1" type="text">
<p class="contact"><label for="region1">Region of origin</label></p>
<input id="name" name="region1" required="" tabindex="1" type="text">
<p class="contact"><label for="division1">Division and Subdivision</label></p>
<input id="name" name="division1" required="" tabindex="1" type="text">
<p class="contact"><label for="dialect1">Dialect spoken</label></p>
<input id="name" name="dialect1" required="" tabindex="1" type="text">
<h2>About child</h2><hr/>
<p class="contact"><label for="dialect2">What dialect does the child speak?</label></p>
<input id="name" name="dialect2" required="" tabindex="1" type="text">
<p class="contact"><label for="dialect3">What dialect would you like the child to learn?</label></p>
<input id="name" name="dialect3" required="" tabindex="1" type="text">
<p class="contact"><label for="tribe">Any special remarks about your tribe?</label></p>
<input id="name" name="tribe" required="" tabindex="1" type="text">
<p class="contact"><label for="foot">Special foods/dishes of that tribe?</label></p>
<input id="name" name="foot" required="" tabindex="1" type="text">
<p class="contact"><label for="fits">Traditional out fits (name or description)</label></p>
<input id="name" name="fits" required="" tabindex="1" type="text">
<input class="buttom" name="submit" id="submit" tabindex="5" value="submit" type="submit">
</form>
</div>
</div>
</body>
</html>
Besoin d'aide
J'ai cette erreur lorsque je clique sur le button submit de mon formulaire
Warning: mysql_query() expects parameter 2 to be resource, boolean given in C:\wamp\ on line 30
voilà le code
<?php
$link = mysqli_connect('localhost', 'root', '');
if (!$link) {
die('Impossible de se connecter : ' . mysql_error());
}
// Rendre la base de données foo, la base courante
$db_selected = mysqli_select_db($link, 'akwi_form');
if (!$db_selected) {
die ('Impossible de sélectionner la base de données : ' . mysql_error());
}
if ( isset($_POST['submit'])){
$fatherNat=$_POST['country'];
$fatherReg=$_POST['region'];
$fatherDiv=$_POST['division'];
$fatherDia=$_POST['dialect'];
$motherNat=$_POST['country1'];
$motherReg=$_POST['region1'];
$motherDiv=$_POST['division1'];
$motherDia=$_POST['dialect1'];
$childDia=$_POST['dialect2'];
$childDia2=$_POST['dialect3'];
$childTribe=$_POST['tribe'];
$childFoot=$_POST['foot'];
$childFits=$_POST['fits'];
$sql="INSERT INTO parents VALUES('', $fatherNat, $fatherReg, $fatherDiv, $fatherDia, $motherNat,
$motherReg,$motherDiv ,$motherDia ,$childDia ,$childDia2 ,$childTribe ,$childFoot, $childFits)";
$requete = mysql_query($sql, $db_selected) or die( mysql_error() ) ;
if($requete)
{
echo("L'insertion a été correctement effectuée") ;
}
else
{
echo("L'insertion à échouée") ;
}
}
?>
<!DOCTYPE html>
<html>
<head>
<title>Demo Beautiful Registration Form with HTML5 and CSS3</title>
<meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7; IE=EmulateIE9">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1.0, user-scalable=no"/>
<link rel="stylesheet" type="text/css" href="style.css" media="all" />
<link rel="stylesheet" type="text/css" href="demo.css" media="all" />
</head>
<body>
<div class="container">
<!-- freshdesignweb top bar -->
<header>
<h1>CULTURE DATA BASE - PLEASE COMPLETE ONE PER FAMILY</h1>
<p>Culture is an integral part of our lives and comes from our heritage. Each child needs to have basic information about his/her origin, the dialects spoken by parents, special/traditional out fits and some common foods/dishes of that locality. In order to assist the school to work with each child we need information about your origin.</p>
</header>
<div class="form">
<form id="contactform" method="POST">
<h2>About father</h2><hr/>
<p class="contact"><label for="country">Country or Nationality</label></p>
<input id="name" name="country" required="" tabindex="1" type="text">
<p class="contact"><label for="region">Region of origin</label></p>
<input id="name" name="region" required="" tabindex="1" type="text">
<p class="contact"><label for="division">Division and Subdivision</label></p>
<input id="name" name="division" required="" tabindex="1" type="text">
<p class="contact"><label for="dialect">Dialect spoken</label></p>
<input id="name" name="dialect" required="" tabindex="1" type="text">
<h2>About mother</h2><hr/>
<p class="contact"><label for="country1">Country or Nationality</label></p>
<input id="name" name="country1" required="" tabindex="1" type="text">
<p class="contact"><label for="region1">Region of origin</label></p>
<input id="name" name="region1" required="" tabindex="1" type="text">
<p class="contact"><label for="division1">Division and Subdivision</label></p>
<input id="name" name="division1" required="" tabindex="1" type="text">
<p class="contact"><label for="dialect1">Dialect spoken</label></p>
<input id="name" name="dialect1" required="" tabindex="1" type="text">
<h2>About child</h2><hr/>
<p class="contact"><label for="dialect2">What dialect does the child speak?</label></p>
<input id="name" name="dialect2" required="" tabindex="1" type="text">
<p class="contact"><label for="dialect3">What dialect would you like the child to learn?</label></p>
<input id="name" name="dialect3" required="" tabindex="1" type="text">
<p class="contact"><label for="tribe">Any special remarks about your tribe?</label></p>
<input id="name" name="tribe" required="" tabindex="1" type="text">
<p class="contact"><label for="foot">Special foods/dishes of that tribe?</label></p>
<input id="name" name="foot" required="" tabindex="1" type="text">
<p class="contact"><label for="fits">Traditional out fits (name or description)</label></p>
<input id="name" name="fits" required="" tabindex="1" type="text">
<input class="buttom" name="submit" id="submit" tabindex="5" value="submit" type="submit">
</form>
</div>
</div>
</body>
</html>
4 réponses
-
Bonjour,
1 - Merci de bien vouloir utiliser la coloration syntaxique (les balises de code) lorsque tu postes du code sur le forum.
Explications disponibles ici :
https://codes-sources.commentcamarche.net/faq/10686-le-nouveau-codes-sources-comment-ca-marche#balises-code
2 - .. tu as un message d'erreur qui parle de mysql_query() ... alors que pour la connexion à ta BDD tu utilises : mysqli_
$link = mysqli_connect('localhost', 'root', ''); if (!$link) { die('Impossible de se connecter : ' . mysql_error()); } -
Merci Jordan pour tes précisions. j'ai changé le message d'erreur en mysqli_error, mais l'erreur persiste
<?php $link = mysqli_connect('localhost', 'root', ''); if (!$link) { die('Impossible de se connecter : ' . mysqli_error()); } $db_selected = mysqli_select_db($link, 'akwi_form'); if (!$db_selected) { die ('Impossible de sélectionner la base de données : ' . mysqli_error()); } if ( isset($_POST['submit'])){ $fatherNat=$_POST['country']; $fatherReg=$_POST['region']; $fatherDiv=$_POST['division']; $fatherDia=$_POST['dialect']; $motherNat=$_POST['country1']; $motherReg=$_POST['region1']; $motherDiv=$_POST['division1']; $motherDia=$_POST['dialect1']; $childDia=$_POST['dialect2']; $childDia2=$_POST['dialect3']; $childTribe=$_POST['tribe']; $childFoot=$_POST['foot']; $childFits=$_POST['fits']; $sql="INSERT INTO parents VALUES('', $fatherNat, $fatherReg, $fatherDiv, $fatherDia, $motherNat, $motherReg,$motherDiv ,$motherDia ,$childDia ,$childDia2 ,$childTribe ,$childFoot, $childFits)"; $requete = mysqli_query($sql, $db_selected) or die( mysqli_error() ) ; if($requete) { echo("L'insertion a été correctement effectuée") ; } else { echo("L'insertion à échouée") ; } } ?> -
Mets des QUOTES autour de tes valeurs dans ta requête sql
$sql="INSERT INTO parents VALUES('' , '$fatherNat' , '$fatherReg' , '$fatherDiv' , '$fatherDia' , '$motherNat' , '$motherReg' , '$motherDiv' , '$motherDia' , '$childDia' , '$childDia2' , '$childTribe' , '$childFoot' , '$childFits')";
Cordialement,
Jordane -
Bonjour
Jordan t'a signalé une erreur qu'il faut effectivement corriger, mais ce n'est pas celle de ton message d'erreur.
Tu ne passes pas les bons paramètres à mysqli_query.
Le premier devrait être la connexion ($link) et le second ta requête ($sql). Et $db_selected n'a rien à faire ici.
