Inserting data Issue with mysql and php -
this code has work not. when use echo $sql query on mysql workbench adds data database. think there mysql_query method. has been 2 days struggling thing little bit of awesome.
here code
<?php if ($_server["request_method"]=="post") { include('mysqli_connect.php'); $aracmarkasi = mysqli_real_escape_string($conn, $_post['aracmarkasi']); $aracplakasi = mysqli_real_escape_string($conn, $_post['aracplakasi']); $aracrengi = mysqli_real_escape_string($conn, $_post['aracrengi']); $aracmodeli = mysqli_real_escape_string($conn, $_post['aracmodeli']); $aracsahibiadi = mysqli_real_escape_string($conn, $_post['aracsahibiadi']); $aracsahibisoyadi = mysqli_real_escape_string($conn, $_post['aracsahibisoyadi']); $aracsahibiadresi = mysqli_real_escape_string($conn, $_post['aracsahibiadresi']); $aracsahibitc = mysqli_real_escape_string($conn, $_post['aracsahibitc']); $dosyano = mysqli_real_escape_string($conn, $_post['dosyano']); $icradairesino = mysqli_real_escape_string($conn, $_post['icradairesino']); $durum = mysqli_real_escape_string($conn, $_post['durum']); $sql = "insert deptcar.arac_tablosu (aracplakası,aracmarkasi,aracmodeli,aracrengi,aracsahibiadi,aracsahibisoyadi,aracsahibitckimlik,aracsahibiadresi,aracdurum,dosyano,icradairesino) values('$aracplakasi','$aracmarkasi','$aracmodeli','$aracrengi','$aracsahibiadi','$aracsahibisoyadi','$aracsahibitc','$aracsahibiadresi','$durum','$dosyano','$icradairesino')"; echo "$sql"; $result = mysqli_query($conn,$sql); echo "$result"; if(!$result) { die('could not enter data: ' . mysql_error());} else{echo "entered data successfully\n";} mysql_close($conn); } ?> and part output
connected
insert deptcar.arac_tablosu (aracplakası,aracmarkasi,aracmodeli,aracrengi,aracsahibiadi,aracsahibisoyadi,aracsahibitckimlik,aracsahibiadresi,aracdurum,dosyano,icradairesino) values('ads','ads','yt','','rhrg','hg','dhg','ggd','sahapersoneli','gfh','hdg')
could not enter data:
Comments
Post a Comment