Tekil Mesaj gösterimi - Php Veritabanına Veri Ekleme Acil Yardım

Konu Php Veritabanına Veri Ekleme Acil Yardım

06-05-2015, 13:07:32

Üyeliği durduruldu

Arkadaşlar her zaman yaptığım gibi veritabanına kayıt eklemek istiyorum ama bir türlü ekleyemıyorum. Resmen beni deli etti.

Sizden ricam kodları incelemeniz varsa hatam söylemenizdir.

HTML KODLAR

<form action="arac-kaydet.php" method="post" >



<div class="alert" style="width:520px;margin-top:10px;">İLAN BAŞLIĞI</div>
<input type="text" class="span6" name="baslik">

<div class="alert" style="width:520px;margin-top:10px;">ARAÇ FİYATI</div>
<input type="text" class="span6" name="fiyat">



<div class="alert" style="width:520px;margin-top:10px;">ARAÇ MODELİ</div>
<input type="text" class="span6" name="model">

<div class="alert" style="width:520px;margin-top:10px;">ARAÇ RENGİ</div>
<input type="text" class="span6" name="renk">

<div class="alert" style="width:520px;margin-top:10px;">VİTES TİPİ</div>
<label class="radio inline">
 <input type="radio" name="vitestipi"> Otomatik
</label>
<label class="radio inline">
 <input type="radio" name="vitestipi"> Triptonik
</label>
<label class="radio inline">
 <input type="radio" name="vitestipi"> Manuel
</label>

<div class="alert" style="width:520px;margin-top:10px;">KM</div>
<input type="text" class="span6" name="km">

<div class="alert" style="width:520px;margin-top:10px;">HP</div>
<input type="text" class="span6" name="hp">

<div class="alert" style="width:520px;margin-top:10px;">YAKIT</div>
<label class="radio inline">
 <input type="radio" name="yakit"> Benzin
</label>
<label class="radio inline">
 <input type="radio" name="yakit"> Dizel
</label>
<label class="radio inline">
 <input type="radio" name="yakit"> Benzin & Lpg
</label>

<div class="alert" style="width:520px;margin-top:10px;">MARKA</div>
<select class="span6" name="marka">
	<option>Fiat</option>
    <option>Volvo</option>
    <option>Hyundai</option>
    <option>Honda</option>
    <option>Kia</option>
    <option>Renault</option>
    <option>Peugeot</option>
    <option>Bmw</option>
    <option>Mercedes</option>
    <option>Land Rover</option>
    <option>Opel</option>
    <option>Nissan</option>
    <option>Ford</option>
    <option>Citroen</option>
    <option>Mitsubishi</option>
    <option>Porshce</option>
    <option>Wolksvagen</option>
    <option>Alfa Romeo</option>
    <option>Mazda</option>
    <option>Bugatti</option>
    <option>Cadillac</option>
    <option>Audi</option>
    <option>Dacia</option>
    <option>Geely</option>
    <option>Ferrari</option>
    <option>Infiniti</option>
    <option>Jaguar</option>
    <option>Maserati</option>
    <option>Mini</option>
    <option>Rover</option>
    <option>Skoda</option>
    <option>Seat</option>
    <option>Tata</option>
    <option>Subaru</option>
    <option>SsangYong</option>
    <option>Suzuki</option>
    <option>Toyota</option>
</select>

<div class="alert" style="width:520px;margin-top:10px;">KASA TİPİ</div>
<select class="span6" name="kasatipi">
	<option>Sedan</option>
    <option>Hatchback</option>
    <option>Station Wagon</option>
</select>

<div class="alert" style="width:520px;margin-top:10px;">DÖŞEMESİ</div>
<input type="text" class="span6" name="dosemesi">

<div class="alert" style="width:520px;margin-top:10px;">YILLIK MTV</div>
<input type="text" class="span6" name="mtv">

<div class="alert" style="width:520px;margin-top:10px;">KASKO DEĞERİ</div>
<input type="text" class="span6" name="kaskodegeri">

<div class="alert" style="width:520px;margin-top:10px;">DONANIM</div>
<textarea class="span6" name="donanim" rows="10"></textarea>

<div class="alert" style="width:520px;margin-top:10px;">İTHALAT DURUMU</div>
<input type="text" class="span6" name="ithalatdurumu">

<div class="alert" style="width:520px;margin-top:10px;">GARANTİ</div>
<input type="text" class="span6" name="garanti">

<div class="alert" style="width:520px;margin-top:10px;">YEDEK ANAHTARLAR</div>
<label class="radio inline">
 <input type="radio" name="yedekanahtar"> Var
</label>
<label class="radio inline">
 <input type="radio" name="yedekanahtar"> Yok
</label>

<div class="alert" style="width:520px;margin-top:10px;">SERVİS KİTAPLARI</div>
<label class="radio inline">
 <input type="radio" name="serviskitaplari"> Var
</label>
<label class="radio inline">
 <input type="radio" name="serviskitaplari"> Yok
</label>

<div class="alert" style="width:520px;margin-top:10px;">ARAÇ DOSYASI</div>
<label class="radio inline">
 <input type="radio" name="aracdosyasi"> Var
</label>
<label class="radio inline">
 <input type="radio" name="aracdosyasi"> Yok
</label>

<div class="alert" style="width:520px;margin-top:10px;">FATURA</div>
<label class="radio inline">
 <input type="radio" name="fatura"> Var
</label>
<label class="radio inline">
 <input type="radio" name="fatura"> Yok
</label>

<div class="alert" style="width:520px;margin-top:10px;">KULLANILABİLİR KREDİ</div>
<label class="radio inline">
 <input type="radio" name="kredi"> Var
</label>
<label class="radio inline">
 <input type="radio" name="kredi"> Yok
</label>

<div class="alert" style="width:520px;margin-top:10px;">PLAKA</div>
<input type="text" class="span6" name="plaka">

<div class="alert" style="width:520px;margin-top:10px;">ŞASİ NO</div>
<input type="text" class="span6" name="sasino">

<div class="alert" style="width:520px;margin-top:10px;">EXPERTİZ</div>
<label class="radio inline">
 <input type="radio" name="expertiz"> Var
</label>
<label class="radio inline">
 <input type="radio" name="expertiz"> Yok
</label>

<div class="alert" style="width:520px;margin-top:10px;">KONDİSYON</div>
<input type="text" class="span6" name="kondisyon">

<div class="alert" style="width:520px;margin-top:10px;">TRAMER</div>
<input type="text" class="span6" name="tramer">

<input type="submit" name="gonder" value="KAYDET" class="span7" style="margin-top:20px;margin-bottom:75px;">

</form>

PHP KODLARI

<?php

require_once("baglan.php");


$vitrin = $_POST ['vitrin'];
$baslik = $_POST ['baslik'];
$fiyat = $_POST ['fiyat'];
$model = $_POST ['model'];
$renk = $_POST ['renk'];
$vitestipi = $_POST ['vitestipi'];
$km = $_POST ['km'];
$hp = $_POST ['hp'];
$yakit = $_POST ['yakit'];
$marka = $_POST ['marka'];
$kasatipi = $_POST ['kasatipi'];
$dosemesi = $_POST ['dosemesi'];
$mtv = $_POST ['mtv'];
$kaskodegeri = $_POST ['kaskodegeri'];
$donanim = $_POST ['donanim'];
$ithalatdurumu = $_POST ['ithalatdurumu'];
$garanti = $_POST ['garanti'];
$serviskitaplari = $_POST ['serviskitaplari'];
$aracdosyasi = $_POST ['aracdosyasi'];
$fatura = $_POST ['fatura'];
$kredi = $_POST ['kredi'];
$plaka = $_POST ['plaka'];
$sasino = $_POST ['sasino'];
$expertiz = $_POST ['expertiz'];
$kondisyon = $_POST ['kondisyon'];
$tramer = $_POST ['tramer'];
$yedekanahtar = $_POST ['yedekanahtar'];



$sql = "insert into arac(baslik, vitrin, fiyat, model, renk, vites, km, hp, yakit, marka, kasatipi, doseme, mtv, kaskodegeri, donanim, ithalatdurumu, garanti, yedekanahtar, serviskitaplari, aracdosyasi, fatura, kredi, plaka, sasino, ekspertiz, kondisyon, tramer) values ('".$baslik."','".$vitrin."','".$fiyat."','".$model."','".$renk."','".$vitestipi."','".$km."','".$hp."','".$yakit."','".$marka."','".$kasatipi."','".$dosemesi."','".$mtv."','".$kaskodegeri."','".$donanim."','".$ithalatdurumu."','".$garanti."','".$yedekanahtar."','".$serviskitaplari."','".$aracdosyasi."','".$fatura."','".$kredi."','".$plaka."','".$plaka."','".$sasino."','".$expertiz."','".$kondisyon."','".$tramer."')";

if (mysql_query($sql))
    echo "veriler eklendi";



?>

BAGLAN.PHP DOSYASI

<?php

$kullaniciadi="root";
$sifre= "";
$host="localhost";
$veritabani="2elim";

$baglan=mysql_connect($host,$kullaniciadi,$sifre);
mysql_select_db($veritabani,$baglan);
 
mysql_query("SET NAMES 'latin5'");
mysql_query("SET CHARACTER SET 'latin5'");
mysql_query("SET COLLATION_CONNECTION = 'latin5_turkish_ci'");
 
mysql_close($baglan);


?>