Kod bu envarter sistemine kayıt eklenilmek isteniyor 2 tane envarteri(demirbaş) kodla derlediğim zaman hata almıyorum ama envarter sayısı 3 veya 4 olduğu zaman hata alıyorum anlamadım neden böyle bir hata alıyorum hatanın tamamı bu şekilde ve kodlar
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 'demirbas_ismi3,demirbas_sayisi3,demirbas_ismi4,demirbas_sayisi4) values (''' at line 2
<?php
$baglan=mysql_connect("localhost","root","");
$sec=mysql_select_db("proje3",$baglan);
?>
<html>
<body>
<?php
if($_POST)
{
$d_zimbetlisi=$_POST["demirbas_zimbetlisi"];
$d_konum=$_POST["demirbas_konum"];
$d_adi1=$_POST["demirbas_ismi1"];
$d_adedi1=$_POST["demirbas_sayisi1"];
$d_adi2=$_POST["demirbas_ismi2"];
$d_adedi2=$_POST["demirbas_sayisi2"];
$d_adi3=$_POST["demirbas_ismi3"];
$d_adedi3=$_POST["demirbas_sayisi3"];
$d_adi4=$_POST["demirbas_ismi4"];
$d_adedi4=$_POST["demirbas_sayisi4"];
/* if(!empty($d_zimbetlisi)&&!empty($d_konum)&&!empty($d_adi)&&!empty($d_adedi))
{ */
$ekle=mysql_query("insert into demirbas3 (demirbas_zimbetlisi,zimbetli_sinifi,demirbas_ismi1,demirbas_sayisi1,demirbas_ismi2,demirbas_sayisi2
demirbas_ismi3,demirbas_sayisi3,demirbas_ismi4,demirbas_sayisi4)
values ('$d_zimbetlisi','$d_konum','$d_adi1','$d_adedi1','$d_adi2','$d_adedi2','$d_adi3','$d_adedi3','$d_adi4','$d_adedi4')");
if($ekle){
echo "Basariyla eklendi ";
header("Refresh:2;url=proje.php");
}
else{
echo "Basarisiz oldu ".mysql_error();
}
}
else
{
?>
<form action="" method="post">
<h1> Ekle </h1>
<table cellpadding='2' cellspacing='2'>
<tr>
<td>Demirbas Zimbetlisi</td>
<td><input type="text" name="demirbas_zimbetlisi"> </td>
</tr>
<tr>
<td>Demirbasin Bulundugu Konum</td>
<td><input type="text" name="demirbas_konum"> </td>
</tr>
<tr>
<td>Demirbasin Adi </td>
<td><input type="text" name="demirbas_ismi1"> </td>
<td>Adet</td>
<td><input type="text" name="demirbas_sayisi1"> </td>
</tr>
<tr>
<td>Demirbasin Adi </td>
<td><input type="text" name="demirbas_ismi2"> </td>
<td>Adet</td>
<td><input type="text" name="demirbas_sayisi2"> </td>
</tr>
<tr>
<td>Demirbasin Adi </td>
<td><input type="text" name="demirbas_ismi3"> </td>
<td>Adet</td>
<td><input type="text" name="demirbas_sayisi3"> </td>
</tr>
<tr>
<td>Demirbasin Adi </td>
<td><input type="text" name="demirbas_ismi4"> </td>
<td>Adet</td>
<td><input type="text" name="demirbas_sayisi4"> </td>
</tr>
<tr>
<td><input type="submit" value="Gonder"> </td>
</tr>
</table>
</form>
<?php } ?>
</body>
</html>
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 'demirbas_ismi3,demirbas_sayisi3,demirbas_ismi4,demirbas_sayisi4) values (''' at line 2
<?php
$baglan=mysql_connect("localhost","root","");
$sec=mysql_select_db("proje3",$baglan);
?>
<html>
<body>
<?php
if($_POST)
{
$d_zimbetlisi=$_POST["demirbas_zimbetlisi"];
$d_konum=$_POST["demirbas_konum"];
$d_adi1=$_POST["demirbas_ismi1"];
$d_adedi1=$_POST["demirbas_sayisi1"];
$d_adi2=$_POST["demirbas_ismi2"];
$d_adedi2=$_POST["demirbas_sayisi2"];
$d_adi3=$_POST["demirbas_ismi3"];
$d_adedi3=$_POST["demirbas_sayisi3"];
$d_adi4=$_POST["demirbas_ismi4"];
$d_adedi4=$_POST["demirbas_sayisi4"];
/* if(!empty($d_zimbetlisi)&&!empty($d_konum)&&!empty($d_adi)&&!empty($d_adedi))
{ */
$ekle=mysql_query("insert into demirbas3 (demirbas_zimbetlisi,zimbetli_sinifi,demirbas_ismi1,demirbas_sayisi1,demirbas_ismi2,demirbas_sayisi2
demirbas_ismi3,demirbas_sayisi3,demirbas_ismi4,demirbas_sayisi4)
values ('$d_zimbetlisi','$d_konum','$d_adi1','$d_adedi1','$d_adi2','$d_adedi2','$d_adi3','$d_adedi3','$d_adi4','$d_adedi4')");
if($ekle){
echo "Basariyla eklendi ";
header("Refresh:2;url=proje.php");
}
else{
echo "Basarisiz oldu ".mysql_error();
}
}
else
{
?>
<form action="" method="post">
<h1> Ekle </h1>
<table cellpadding='2' cellspacing='2'>
<tr>
<td>Demirbas Zimbetlisi</td>
<td><input type="text" name="demirbas_zimbetlisi"> </td>
</tr>
<tr>
<td>Demirbasin Bulundugu Konum</td>
<td><input type="text" name="demirbas_konum"> </td>
</tr>
<tr>
<td>Demirbasin Adi </td>
<td><input type="text" name="demirbas_ismi1"> </td>
<td>Adet</td>
<td><input type="text" name="demirbas_sayisi1"> </td>
</tr>
<tr>
<td>Demirbasin Adi </td>
<td><input type="text" name="demirbas_ismi2"> </td>
<td>Adet</td>
<td><input type="text" name="demirbas_sayisi2"> </td>
</tr>
<tr>
<td>Demirbasin Adi </td>
<td><input type="text" name="demirbas_ismi3"> </td>
<td>Adet</td>
<td><input type="text" name="demirbas_sayisi3"> </td>
</tr>
<tr>
<td>Demirbasin Adi </td>
<td><input type="text" name="demirbas_ismi4"> </td>
<td>Adet</td>
<td><input type="text" name="demirbas_sayisi4"> </td>
</tr>
<tr>
<td><input type="submit" value="Gonder"> </td>
</tr>
</table>
</form>
<?php } ?>
</body>
</html>