Php mysql
bassaa
Messages postés
23
Statut
Membre
-
le père -
le père -
Bonjour,
j'ai un probleme avec langage php mysql tel que j'execute la fonction inserer ,
mais aprés l'execution l'affichage est suivant :
Column count doesn't match value count at row 1
les formulaires sont:
verif_ajout_vol.php:
<?php
session_start();
if(isset($_SESSION['administrateur'])=="administrateur")
{
include ('config.php');
if($_POST['ajout_vol']){
$c_v=$_POST['cod_vol'];$n_v=$_POST['n_vol'];$t_v=$_POST['tarif'];
$d_v=$_POST['annee'].$_POST['mois'].$_POST['jour'];$hd_v=$_POST['heure'].$_POST['minute'].$_POST['seconde'];
$ha_v=$_POST['heure1'].$_POST['minute1'].$_POST['seconde1'];
$vd_v=$_POST['ville_depart'];$va_v=$_POST['ville_arrivee'];$nb_v=$_POST['nbr_place'];
$ss="select 'cod_vol' from vol where 'cod_vol'='$c_v'";
$r= mysql_query($ss,$con);$ll= mysql_fetch_array($r);
if($ll){
header("location: ajout_vol.php?exist") ;
}
else{
$q="INSERT INTO vol values('$c_v','$n_v',
'$t_v''$d_v''$hd_v''$ha_v''$vd_v''$va_v''$nb_v')";
mysql_query($q,$con)or die(mysql_error());
header("location: ajout_vol.php?oui") ;
}
}
if(!empty($_POST['supp_vol'])){
if (isset($_POST['checkbox'])){
$checkbox=$_POST['checkbox'];
foreach ($checkbox as $a){
$s="DELETE FROM 'vol' where 'cod_vol'='$a'";
mysql_query($s,$con)or die(mysql_error());
}
header("location:supprimer.php?oui");
}
else
{
header("location:supprimer.php?cocher");
}
}
mysql_close();
}
?>
et ajout_vol.php:
<?php
session_start();
include ('config.php');
if(isset($_SESSION['administrateur'])=="administrateur")
{
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<!-- DW6 -->
<head>
<!-- Copyright 2005 Macromedia, Inc. All rights reserved. -->
<title>Page d'accueil</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link rel="stylesheet" href="style.css" type="text/css" />
<script language="JavaScript" type="text/javascript">
//--------------- LOCALIZEABLE GLOBALS---------------
var d=new Date();
monthname= new Array("Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre");
//Ensure correct for language. English is "January 1, 2004"
var TODAY = monthname[d.getMonth()] + " " + d.getDate() + ", " + d.getFullYear();
//--------------- END LOCALIZEABLE ---------------
</script>
<script language="javascript">
function checkform() {
if(document.v_vol.cod_vol.value=="") {
alert("Inserer code de vol.");
return false;
}
if(document.v_vol.n_vol.value=="") {
alert("inserer N°de vol.");
return false;
}
if(document.v_vol.tarif.value=="") {
alert("inserer tarif.");
return false;
}
}
</script>
<style type="text/css">
<!--
.Style3 {
color: #66FF00;
font-size: 36px;
}
.Style4 {
font-size: 16px;
color: #FFFF00;
}
.Style5 {color: #FF0000}
.Style7 {
color: #0000FF;
font-weight: bold;
font-size: 22px;
}
.Style8 {color: #000000}
-->
</style>
</head>
<body bgcolor="#F4FFE4">
<table width="100%" height="1138" border="0" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" bgcolor="#FFFFFF">
<tr bgcolor="#3333CC">
<td colspan="3" rowspan="2" bgcolor="#0066CC"><img src="IMAGE/avion.jpg" alt="Header image" width="605" height="157" border="0" /></td>
<td height="87" colspan="3" align="center" valign="bottom" nowrap="nowrap" bgcolor="#0066CC" id="logo"><span class="Style3">AIR ALGERIE</span> </td>
<td width="56" bgcolor="#0066CC"> </td>
</tr>
<tr bgcolor="#3333CC">
<td height="70" colspan="3" align="center" valign="top" bgcolor="#0066CC" id="tagline"><p class="Style4">RESERVATION DES VOLS EN LIGNE </p></td>
<td width="56" bgcolor="#0066CC"> </td>
</tr>
<tr bgcolor="#99CC66">
<td height="26" colspan="7" bgcolor="#FF0000" id="dateformat">
<script language="JavaScript" type="text/javascript">
document.write(TODAY); </script>
<?php for($i=0;$i<205;$i++) echo " ";?>
<a href="verif_pass_admin.php?dec">Déconnecté: </a>
<?php echo $_SESSION["administrateur"];?></td>
</tr>
<tr>
<td width="166" height="910" valign="top" bgcolor="#0066CC"><table border="0" cellspacing="0" cellpadding="0" width="165" id="navigation">
<tr>
<td width="165"><a href=ajout_vol.php class="navText">nouveau vol </a></td>
</tr>
<tr>
<td width="165"><a href=supprimer.php class="navText">supprimer vol </a></td>
</tr>
<tr>
<td width="165"><a href=modifier_date.php class="navText">modifier date de vol </a></td>
</tr>
<tr>
<td width="165"> </td>
</tr>
</table>
<br />
<br />
<br />
<br />
</td>
<td width="178" bgcolor="#FFFFFF"> </td>
<td colspan="2" valign="top" bgcolor="#FFFFFF"><h2 align="left" class="quote"><img src="img/mm_spacer.gif" alt="" width="305" height="1" border="0" /><br /><br />
<?php if (isset($_GET['oui'])){
echo "<h1><font face='Times New Roman' style='color:green'>Le vol a été ajouté</h1></font>";}
if (isset($_GET['exist'])){
echo "<h1><font face='Times New Roman' style='color:red'>Le vol est existe!</h1></font>";}?>
<span class="Style7 Style9">ajouter un nouveau vol : </span></h2>
<form name="V_vol"method="post" action="verif_ajout_vol.php" onsubmit="javascript: return checkform()">
<table width="494" height="295">
<tr>
<td width="227" height="47" class="quote Style8">Code de vol: </td>
<td width="255"><input type="text" name="cod_vol"size="30" /></td>
</tr>
<tr>
<td height="48" class="quote Style8">N° de vol: </td>
<td><input type="text" name="n_vol" size="30" /></td>
</tr>
<tr>
<td height="46" class="quote Style8">Tarif:</td>
<td><input type="text" name="tarif" size="30" /></td>
</tr>
<tr>
<td height="43" class="quote Style8">Date de vol: </td>
<td><select name="annee">
<?php for ($i=2011;$i<2099;$i++){?>
<option value="<?php echo $i;?>"> <?php echo $i;?> </option>
<?php }?>
</select>
<select name="mois">
<option value="01">JAN</option>
<option value="02">FEV</option>
<option value="03">MAR</option>
<option value="04">AVR</option>
<option value="05">MAI</option>
<option value="06">JUIN</option>
<option value="07">JUIL</option>
<option value="08">AOUT</option>
<option value="09">SEP</option>
<option value="10">OCT</option>
<option value="11">NOV</option>
<option value="12">DEC</option>
</select>
<select name="jour">
<?php for ($i=1;$i<10;$i++){?>
<option value="<?php echo "0".$i;?>"> <?php echo "0".$i;?> </option>
<?php }?>
<?php for ($i=10;$i<32;$i++){?>
<option value="<?php echo $i;?>"> <?php echo $i;?> </option>
<?php }?>
</select></td></tr>
<tr>
<td height="46" class="quote Style8">Heure de déppart:</td>
<td><select name="heure">
<?php for ($i=0;$i<10;$i++){?>
<option value="<?php echo "0".$i;?>"> <?php echo "0".$i;?> </option>
<?php }?>
<?php for ($i=10;$i<24;$i++){?>
<option value="<?php echo $i;?>"> <?php echo $i;?> </option>
<?php }?>
</select>
<select name="minute">
<?php for ($i=0;$i<10;$i++){?>
<option value="<?php echo "0".$i;?>"> <?php echo "0".$i;?> </option>
<?php }?>
<?php for ($i=10;$i<60;$i++){?>
<option value="<?php echo $i;?>"> <?php echo $i;?> </option>
<?php }?>
</select>
<select name="seconde">
<?php for ($i=0;$i<10;$i++){?>
<option value="<?php echo "0".$i;?>"> <?php echo "0".$i;?> </option>
<?php }?>
<?php for ($i=10;$i<60;$i++){?>
<option value="<?php echo $i;?>"> <?php echo $i;?> </option>
<?php }?>
</select></td>
</tr>
<tr>
<td height="47" class="quote Style8">Heure d'arrivée:</td>
<td><select name="heure1">
<?php for ($i=0;$i<10;$i++){?>
<option value="<?php echo "0".$i;?>"> <?php echo "0".$i;?> </option>
<?php }?>
<?php for ($i=10;$i<24;$i++){?>
<option value="<?php echo $i;?>"> <?php echo $i;?> </option>
<?php }?>
</select>
<select name="minute1">
<?php for ($i=0;$i<10;$i++){?>
<option value="<?php echo "0".$i;?>"> <?php echo "0".$i;?> </option>
<?php }?>
<?php for ($i=10;$i<60;$i++){?>
<option value="<?php echo $i;?>"> <?php echo $i;?> </option>
<?php }?>
</select>
<select name="seconde1">
<?php for ($i=0;$i<10;$i++){?>
<option value="<?php echo "0".$i;?>"> <?php echo "0".$i;?> </option>
<?php }?>
<?php for ($i=10;$i<60;$i++){?>
<option value="<?php echo $i;?>"> <?php echo $i;?> </option>
<?php }?>
</select></td>
</tr>
<tr>
<td height="46" class="quote Style8">Ville de déppart:</td>
<td><input type="text" name="ville_depart" size="22" /></td>
</tr>
<tr>
<td height="46" class="quote Style8">Ville d'arrivée:</td>
<td><input type="text" name="ville_arrivee" size="22" /></td>
</tr>
<tr>
<td height="46" class="Style8 quote">Nembre des places: </td>
<td><input type="text" name="nbr_place" size="22" /></td>
</tr>
<tr>
<td height="48" align="center"><input name="ajout_vol" type="submit" class="Style8 quote"value="valider" /></td>
<td><input name="reset" type="reset" class="Style8 quote" value="effacer" /></td>
</tr>
</table>
</form></td>
</tr>
<tr>
<td width="166" height="29" bgcolor="#FF0000"><span class="Style5"></span></td>
<td width="178" bgcolor="#FF0000"><span class="Style5"></span></td>
<td width="261" bgcolor="#FF0000"> </td>
<td width="170" bgcolor="#FF0000"><span class="Style5"></span></td>
<td width="51" bgcolor="#FF0000"><span class="Style5"></span></td>
<td width="211" bgcolor="#FF0000"><span class="Style5"></span></td>
<td width="56" bgcolor="#FF0000"><span class="Style5"></span></td>
</tr>
</table>
</body>
</html>
<?php
}else{
header("Location: admin.html");
}
?>
j'ai un probleme avec langage php mysql tel que j'execute la fonction inserer ,
mais aprés l'execution l'affichage est suivant :
Column count doesn't match value count at row 1
les formulaires sont:
verif_ajout_vol.php:
<?php
session_start();
if(isset($_SESSION['administrateur'])=="administrateur")
{
include ('config.php');
if($_POST['ajout_vol']){
$c_v=$_POST['cod_vol'];$n_v=$_POST['n_vol'];$t_v=$_POST['tarif'];
$d_v=$_POST['annee'].$_POST['mois'].$_POST['jour'];$hd_v=$_POST['heure'].$_POST['minute'].$_POST['seconde'];
$ha_v=$_POST['heure1'].$_POST['minute1'].$_POST['seconde1'];
$vd_v=$_POST['ville_depart'];$va_v=$_POST['ville_arrivee'];$nb_v=$_POST['nbr_place'];
$ss="select 'cod_vol' from vol where 'cod_vol'='$c_v'";
$r= mysql_query($ss,$con);$ll= mysql_fetch_array($r);
if($ll){
header("location: ajout_vol.php?exist") ;
}
else{
$q="INSERT INTO vol values('$c_v','$n_v',
'$t_v''$d_v''$hd_v''$ha_v''$vd_v''$va_v''$nb_v')";
mysql_query($q,$con)or die(mysql_error());
header("location: ajout_vol.php?oui") ;
}
}
if(!empty($_POST['supp_vol'])){
if (isset($_POST['checkbox'])){
$checkbox=$_POST['checkbox'];
foreach ($checkbox as $a){
$s="DELETE FROM 'vol' where 'cod_vol'='$a'";
mysql_query($s,$con)or die(mysql_error());
}
header("location:supprimer.php?oui");
}
else
{
header("location:supprimer.php?cocher");
}
}
mysql_close();
}
?>
et ajout_vol.php:
<?php
session_start();
include ('config.php');
if(isset($_SESSION['administrateur'])=="administrateur")
{
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<!-- DW6 -->
<head>
<!-- Copyright 2005 Macromedia, Inc. All rights reserved. -->
<title>Page d'accueil</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link rel="stylesheet" href="style.css" type="text/css" />
<script language="JavaScript" type="text/javascript">
//--------------- LOCALIZEABLE GLOBALS---------------
var d=new Date();
monthname= new Array("Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre");
//Ensure correct for language. English is "January 1, 2004"
var TODAY = monthname[d.getMonth()] + " " + d.getDate() + ", " + d.getFullYear();
//--------------- END LOCALIZEABLE ---------------
</script>
<script language="javascript">
function checkform() {
if(document.v_vol.cod_vol.value=="") {
alert("Inserer code de vol.");
return false;
}
if(document.v_vol.n_vol.value=="") {
alert("inserer N°de vol.");
return false;
}
if(document.v_vol.tarif.value=="") {
alert("inserer tarif.");
return false;
}
}
</script>
<style type="text/css">
<!--
.Style3 {
color: #66FF00;
font-size: 36px;
}
.Style4 {
font-size: 16px;
color: #FFFF00;
}
.Style5 {color: #FF0000}
.Style7 {
color: #0000FF;
font-weight: bold;
font-size: 22px;
}
.Style8 {color: #000000}
-->
</style>
</head>
<body bgcolor="#F4FFE4">
<table width="100%" height="1138" border="0" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" bgcolor="#FFFFFF">
<tr bgcolor="#3333CC">
<td colspan="3" rowspan="2" bgcolor="#0066CC"><img src="IMAGE/avion.jpg" alt="Header image" width="605" height="157" border="0" /></td>
<td height="87" colspan="3" align="center" valign="bottom" nowrap="nowrap" bgcolor="#0066CC" id="logo"><span class="Style3">AIR ALGERIE</span> </td>
<td width="56" bgcolor="#0066CC"> </td>
</tr>
<tr bgcolor="#3333CC">
<td height="70" colspan="3" align="center" valign="top" bgcolor="#0066CC" id="tagline"><p class="Style4">RESERVATION DES VOLS EN LIGNE </p></td>
<td width="56" bgcolor="#0066CC"> </td>
</tr>
<tr bgcolor="#99CC66">
<td height="26" colspan="7" bgcolor="#FF0000" id="dateformat">
<script language="JavaScript" type="text/javascript">
document.write(TODAY); </script>
<?php for($i=0;$i<205;$i++) echo " ";?>
<a href="verif_pass_admin.php?dec">Déconnecté: </a>
<?php echo $_SESSION["administrateur"];?></td>
</tr>
<tr>
<td width="166" height="910" valign="top" bgcolor="#0066CC"><table border="0" cellspacing="0" cellpadding="0" width="165" id="navigation">
<tr>
<td width="165"><a href=ajout_vol.php class="navText">nouveau vol </a></td>
</tr>
<tr>
<td width="165"><a href=supprimer.php class="navText">supprimer vol </a></td>
</tr>
<tr>
<td width="165"><a href=modifier_date.php class="navText">modifier date de vol </a></td>
</tr>
<tr>
<td width="165"> </td>
</tr>
</table>
<br />
<br />
<br />
<br />
</td>
<td width="178" bgcolor="#FFFFFF"> </td>
<td colspan="2" valign="top" bgcolor="#FFFFFF"><h2 align="left" class="quote"><img src="img/mm_spacer.gif" alt="" width="305" height="1" border="0" /><br /><br />
<?php if (isset($_GET['oui'])){
echo "<h1><font face='Times New Roman' style='color:green'>Le vol a été ajouté</h1></font>";}
if (isset($_GET['exist'])){
echo "<h1><font face='Times New Roman' style='color:red'>Le vol est existe!</h1></font>";}?>
<span class="Style7 Style9">ajouter un nouveau vol : </span></h2>
<form name="V_vol"method="post" action="verif_ajout_vol.php" onsubmit="javascript: return checkform()">
<table width="494" height="295">
<tr>
<td width="227" height="47" class="quote Style8">Code de vol: </td>
<td width="255"><input type="text" name="cod_vol"size="30" /></td>
</tr>
<tr>
<td height="48" class="quote Style8">N° de vol: </td>
<td><input type="text" name="n_vol" size="30" /></td>
</tr>
<tr>
<td height="46" class="quote Style8">Tarif:</td>
<td><input type="text" name="tarif" size="30" /></td>
</tr>
<tr>
<td height="43" class="quote Style8">Date de vol: </td>
<td><select name="annee">
<?php for ($i=2011;$i<2099;$i++){?>
<option value="<?php echo $i;?>"> <?php echo $i;?> </option>
<?php }?>
</select>
<select name="mois">
<option value="01">JAN</option>
<option value="02">FEV</option>
<option value="03">MAR</option>
<option value="04">AVR</option>
<option value="05">MAI</option>
<option value="06">JUIN</option>
<option value="07">JUIL</option>
<option value="08">AOUT</option>
<option value="09">SEP</option>
<option value="10">OCT</option>
<option value="11">NOV</option>
<option value="12">DEC</option>
</select>
<select name="jour">
<?php for ($i=1;$i<10;$i++){?>
<option value="<?php echo "0".$i;?>"> <?php echo "0".$i;?> </option>
<?php }?>
<?php for ($i=10;$i<32;$i++){?>
<option value="<?php echo $i;?>"> <?php echo $i;?> </option>
<?php }?>
</select></td></tr>
<tr>
<td height="46" class="quote Style8">Heure de déppart:</td>
<td><select name="heure">
<?php for ($i=0;$i<10;$i++){?>
<option value="<?php echo "0".$i;?>"> <?php echo "0".$i;?> </option>
<?php }?>
<?php for ($i=10;$i<24;$i++){?>
<option value="<?php echo $i;?>"> <?php echo $i;?> </option>
<?php }?>
</select>
<select name="minute">
<?php for ($i=0;$i<10;$i++){?>
<option value="<?php echo "0".$i;?>"> <?php echo "0".$i;?> </option>
<?php }?>
<?php for ($i=10;$i<60;$i++){?>
<option value="<?php echo $i;?>"> <?php echo $i;?> </option>
<?php }?>
</select>
<select name="seconde">
<?php for ($i=0;$i<10;$i++){?>
<option value="<?php echo "0".$i;?>"> <?php echo "0".$i;?> </option>
<?php }?>
<?php for ($i=10;$i<60;$i++){?>
<option value="<?php echo $i;?>"> <?php echo $i;?> </option>
<?php }?>
</select></td>
</tr>
<tr>
<td height="47" class="quote Style8">Heure d'arrivée:</td>
<td><select name="heure1">
<?php for ($i=0;$i<10;$i++){?>
<option value="<?php echo "0".$i;?>"> <?php echo "0".$i;?> </option>
<?php }?>
<?php for ($i=10;$i<24;$i++){?>
<option value="<?php echo $i;?>"> <?php echo $i;?> </option>
<?php }?>
</select>
<select name="minute1">
<?php for ($i=0;$i<10;$i++){?>
<option value="<?php echo "0".$i;?>"> <?php echo "0".$i;?> </option>
<?php }?>
<?php for ($i=10;$i<60;$i++){?>
<option value="<?php echo $i;?>"> <?php echo $i;?> </option>
<?php }?>
</select>
<select name="seconde1">
<?php for ($i=0;$i<10;$i++){?>
<option value="<?php echo "0".$i;?>"> <?php echo "0".$i;?> </option>
<?php }?>
<?php for ($i=10;$i<60;$i++){?>
<option value="<?php echo $i;?>"> <?php echo $i;?> </option>
<?php }?>
</select></td>
</tr>
<tr>
<td height="46" class="quote Style8">Ville de déppart:</td>
<td><input type="text" name="ville_depart" size="22" /></td>
</tr>
<tr>
<td height="46" class="quote Style8">Ville d'arrivée:</td>
<td><input type="text" name="ville_arrivee" size="22" /></td>
</tr>
<tr>
<td height="46" class="Style8 quote">Nembre des places: </td>
<td><input type="text" name="nbr_place" size="22" /></td>
</tr>
<tr>
<td height="48" align="center"><input name="ajout_vol" type="submit" class="Style8 quote"value="valider" /></td>
<td><input name="reset" type="reset" class="Style8 quote" value="effacer" /></td>
</tr>
</table>
</form></td>
</tr>
<tr>
<td width="166" height="29" bgcolor="#FF0000"><span class="Style5"></span></td>
<td width="178" bgcolor="#FF0000"><span class="Style5"></span></td>
<td width="261" bgcolor="#FF0000"> </td>
<td width="170" bgcolor="#FF0000"><span class="Style5"></span></td>
<td width="51" bgcolor="#FF0000"><span class="Style5"></span></td>
<td width="211" bgcolor="#FF0000"><span class="Style5"></span></td>
<td width="56" bgcolor="#FF0000"><span class="Style5"></span></td>
</tr>
</table>
</body>
</html>
<?php
}else{
header("Location: admin.html");
}
?>
A voir également:
- Php mysql
- Easy php - Télécharger - Divers Web & Internet
- Mysql community server - Télécharger - Bases de données
- Expert php pinterest - Télécharger - Langages
- Php alert - Forum PHP
- Retour a la ligne php - Forum Webmastering
1 réponse
Bonjour
Le message signifie que le nombre de valeurs que tu donnes dans ta requête ne correspond pas au nombre de champs de la table. Donc Mysql ne sait pas faire correspondre les valeurs aux champs.
C'est peut-être parce qu'il te manque quelques virgules :
$q="INSERT INTO vol values('$c_v','$n_v',
'$t_v''$d_v''$hd_v''$ha_v''$vd_v''$va_v''$nb_v')";
devrait plutôt être
$q="INSERT INTO vol values('$c_v','$n_v',
'$t_v','$d_v','$hd_v','$ha_v','$vd_v','$va_v','$nb_v')";
Le message signifie que le nombre de valeurs que tu donnes dans ta requête ne correspond pas au nombre de champs de la table. Donc Mysql ne sait pas faire correspondre les valeurs aux champs.
C'est peut-être parce qu'il te manque quelques virgules :
$q="INSERT INTO vol values('$c_v','$n_v',
'$t_v''$d_v''$hd_v''$ha_v''$vd_v''$va_v''$nb_v')";
devrait plutôt être
$q="INSERT INTO vol values('$c_v','$n_v',
'$t_v','$d_v','$hd_v','$ha_v','$vd_v','$va_v','$nb_v')";
