Formdan gelen verilerin tümü dolu ise sıkıntı yok ancak doldurulmayan boş veri geldiğinde veritabanına hiç kayıt yapmıyor. Phpmyadmin üzerinden tabloda boş değer olabilir kutucuklarınıda işaretledim. Nerede hata var bulamıyorum. Yardımcı olur musunuz.





Form.php


<form action="kaydet.php" method="POST">
<table class="table table-sm table-bordered">

<tr>
<th>İp No</th>
<td>
<select class="form-control form-control-sm" name="ipno" id="ipno">
<option value="6/1">6/1</option>
<option value="8/1">8/1</option>
</select>
</td>
</tr>
<tr>
<th>İp Tipi</th>
<td>
<select class="form-control form-control-sm" name="iptipi" id="iptipi">
<option value="PENYE">PENYE</option>
<option value="OPEN-END">OPEN-END</option>
<option value="KARDE">KARDE</option>
<option value="POLYESTER">POLYESTER</option>
<option value="NAY GİPE">NAY GİPE</option>
</select>
</td>
</tr>
<tr>
<th>İp Oranı</th>
<td>
<select class="form-control form-control-sm" name="iporani" id="iporani">
<option value="100/">100/</option>
<option value="90/10">90/10</option>
<option value="85/15">85/15</option>

</select>
</td>
</tr>
<tr>
<th>Açıklama</th>
<td>
<input class="form-control form-control-sm" value="" type="text" name="aciklama" id="aciklama">
</td>
</tr>
<tr>
<th>Firma</th>
<td>
<input class="form-control form-control-sm" value="" type="text" name="firma" id="firma">
</td>
</tr>
<tr>
<th>Tarih</th>
<td>
<input class="form-control form-control-sm" value="" type="date" name="tarih" id="tarih">
</td>
</tr>
<tr>
<th>Vade</th>
<td>
<input class="form-control form-control-sm" value="" type="text" name="vade" id="vade">
</td>
</tr>
<tr>
<th>Kur</th>
<td>
<input class="form-control form-control-sm" value="" type="text" name="kur" id="kur">
</td>
</tr>
<tr>
<th>USD</th>
<td>
<input class="form-control form-control-sm" value="" type="text" name="usd" id="usd">
</td>
</tr>
<tr>
<th>TL</th>
<td>
<input class="form-control form-control-sm" value="" type="text" name="tl" id="tl">
</td>
</tr>
</table>


<button name="submit" type="submit" class="btn btn-primary">Kaydet</button>
</form>

Kaydet.php

<?php
include("include/baglan.php");


	$ipno = $_POST['ipno'];
	$iptipi = $_POST['iptipi'];
	$iporani= $_POST['iporani'];
	$aciklama= $_POST['aciklama'];
	$firma = $_POST['firma'];
	$tarih = $_POST['tarih'];
	$vade = $_POST['vade'];
	$kur = $_POST['kur'];
	$usd = $_POST['usd'];
	$tl = $_POST['tl'];


	$baglanti->query("insert into iplikler (ipno, iptip, iporan, aciklama, firma, tarih, vade, kur, usd, tl) values ('$ipno', '$iptipi', '$iporani', '$aciklama', '$firma', '$tarih', '$vade', '$kur', '$usd', '$tl')");


?>