Veritabanına kayıt yaptırmam gerekiyor. fakat nerede hata yapıyorum bilemedim.
form:
<form action="aracdetayekle.php" method="POST">
<div align="center">
<table border="0" width="821" height="132" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF">
<tr>
<td height="18" width="230" align="right" bgcolor="#00FFFF"><b>
<font size="2" face="Tahoma">Alış Bilgileri</font></b></td>
<td height="18" width="225" align="right" bgcolor="#00FFFF"><b>
<font size="2" face="Tahoma">Dönüş Bilgileri</font></b></td>
<td height="18" width="366" align="right" bgcolor="#00FFFF" colspan="2"><b>
<font size="2" face="Tahoma">Kişisel Bilgiler </font></b></td>
</tr>
<tr>
<td height="22" width="230" align="right" bgcolor="#00FFFF"><select name="alisyeri" style="height: 21; width: 205" size="1"><option value="0">- Seçiniz -</option>
<?php
include ("db.php");
$kat_sorgu = mysql_query("SELECT * FROM alis");
while($dongu = mysql_fetch_array($kat_sorgu))
{
echo "<option value='".$dongu["id"]."'>".$dongu["alis"]."</option>";
}
?>
</select>
</td>
<td height="22" width="225" align="right" bgcolor="#00FFFF"><select name="donusyeri" style="height: 21; width: 205" size="1"><option value="0">- Seçiniz -</option>
<?php
include ("db.php");
$kat_sorgu = mysql_query("SELECT * FROM donus");
while($dongu = mysql_fetch_array($kat_sorgu))
{
echo "<option value='".$dongu["id"]."'>".$dongu["donus"]."</option>";
}
?>
</select>
</td>
<td height="22" width="129" bgcolor="#00FFFF">
<p align="right"><font size="2" face="Tahoma">Ad-Soyad</font></td>
<td height="22" width="237" bgcolor="#00FFFF"> <input type="text" name="adsoyad" size="31"></td>
</tr>
<tr>
<td height="22" width="230" align="right" bgcolor="#00FFFF"><input type="text" name="alistarihi" id="popupDatepicker" size="20"></td>
<td height="22" width="225" align="right" bgcolor="#00FFFF">
<input type="text" name="donustarihi" id="popupDatepicker2" size="20"></td>
<td height="22" width="129" bgcolor="#00FFFF">
<p align="right"><font size="2" face="Tahoma">Cep Numaranız</font></td>
<td height="22" width="237" bgcolor="#00FFFF"> <input type="text" name="cep" size="31"></td>
</tr>
<tr>
<td height="22" width="230" align="right" bgcolor="#00FFFF">
<select name="saat1" style="height: 22; width: 55" size="1">
<option>06</option>
<option>07</option>
<option>08</option>
<option>09</option>
<option>10</option>
<option>11</option>
<option>12</option>
<option>13</option>
<option>14</option>
<option>15</option>
<option>16</option>
<option>17</option>
<option>18</option>
<option>19</option>
<option>20</option>
<option>21</option>
<option>22</option>
<option>23</option>
</select><select name="dakika1" style="height: 22; width: 55" size="1">
<option>00</option>
<option>15</option>
<option>30</option>
<option>45</option>
</select>
</td>
<td height="22" width="225" align="right" bgcolor="#00FFFF">
<select name="saat2" style="height: 22; width: 55" size="1">
<option>06</option>
<option>07</option>
<option>08</option>
<option>09</option>
<option>10</option>
<option>11</option>
<option>12</option>
<option>13</option>
<option>14</option>
<option>15</option>
<option>16</option>
<option>17</option>
<option>18</option>
<option>19</option>
<option>20</option>
<option>21</option>
<option>22</option>
<option>23</option>
</select><select name="dakika2" style="height: 22; width: 55" size="1">
<option>00</option>
<option>15</option>
<option>30</option>
<option>45</option>
</select></td>
<td height="22" width="129" bgcolor="#00FFFF">
<p align="right"><font size="2" face="Tahoma">İş Yeri Numaranız</font></td>
<td height="22" width="237" bgcolor="#00FFFF"> <input type="text" name="is" size="31"></td>
</tr>
<tr>
<td height="22" width="230" bgcolor="#00FFFF"> </td>
<td height="22" width="225" bgcolor="#00FFFF"> </td>
<td height="22" width="129" bgcolor="#00FFFF">
<p align="right"><font size="2" face="Tahoma">Adres:</font></td>
<td height="22" width="237" bgcolor="#00FFFF"> <input type="text" name="adres" size="31"></td>
</tr>
<tr>
<td height="26" width="455" bgcolor="#00FFFF" colspan="2">
<p align="center"><font face="Tahoma" size="2" color="#FF0000">*
Lütfen Bilgileri Eksiksiz Giriniz.</font></td>
<td height="26" width="366" bgcolor="#00FFFF" colspan="2">
<p align="center">
<input type="submit" value="Gönder" name="B2">
</td>
</tr>
</table>
</div>
</form>Postla kayıt:
<?php
include("db.php");
$alisyeri = $_POST ['alisyeri'];
$donusyeri = $_POST ['donusyeri'];
$alistarihi = $_POST ['alistarihi'];
$donustarihi = $_POST ['donustarihi'];
$adsoyad = $_POST ['adsoyad'];
$cep = $_POST ['cep'];
$is = $_POST ['is'];
$adres = $_POST ['adres'];
$kayit=mysql_query("insert into arackira (alisyeri, donusyeri, alistarihi, donustarihi, adsoyad, cep, is, adres) values ('$alisyeri', '$donusyeri', '$alistarihi', '$donustarihi', '$adsoyad', '$cep', '$is', '$adres')");
if ( $kayit ) {
header("Location: aracdetay.php");
}else{
echo "Kayıt Edilmedi..";
}
?>kayıt ettirmek yerine ekrana yazdırdım direk ekrana cıktıyı veriyor fakat veritabanından çektiğim açılır kutudaki veriler çıkmıyor bu seferde. veritabanına eklerken nerede hata yapıyorum :S