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");
}
?>
Afficher la suite