soroush.r70
جمعه 30 آبان 1393, 21:48 عصر
در کد زیر خطای مربوطه رخ میده هرکاری هم می کنم رفع نمیشه ممنون میشم کمک کنید تا خطا رو رفع کنم
خطا :
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 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 ') VALUES (NULL,'زمین','رهن','5645641','1','2','3','4 ','5','6','7','' at line 1' in /home4/amlakete/public_html/inc/class.php:67 Stack trace: #0 /home4/amlakete/public_html/inc/class.php(67): PDOStatement->execute() #1 /home4/amlakete/public_html/orders.php(122): content->execute() #2
کد در فایل order.php :
///////////////////////////////////////////////////////////////////////if(isset($_POST['group']) && !empty($_POST['group'])){ $group=$_POST['group']; $melktype=$_POST['melktype']; $codemelk=$_POST['codemelk']; $fullname=$_POST['fullname']; $phone=$_POST['phone']; $mobile=$_POST['mobile']; $province=$_POST['province']; $city=$_POST['city']; $onvan=$_POST['onvan']; $title=$_POST['title']; $vaziat=$_POST['vaziat']; $zamin=$_POST['zamin']; $bana=$_POST['bana']; $jahat=$_POST['jahat']; $salesakht=$_POST['salesakht']; $eskelet=$_POST['eskelet']; $tabaghe=$_POST['tabaghe']; $room=$_POST['room']; $nama=$_POST['nama']; $condition=$_POST['condition']; $foroshmoney=$_POST['foroshmoney']; $mablaghvam=$_POST['mablaghvam']; $ghmt=$_POST['ghmt']; $address=$_POST['address']; $tolzamin=$_POST['tolzamin']; $arz=$_POST['arz']; $ertefa=$_POST['ertefa']; $parking=$_POST['parking']; $barghmoshtarak=$_POST['barghmoshtarak']; $gazmoshtarak=$_POST['gazmoshtarak']; $watermoshtarak=$_POST['watermoshtarak']; $waterwarm=$_POST['waterwarm']; $shofazh=$_POST['shofazh']; $pakage=$_POST['pakage']; $cabinet=$_POST['cabinet']; $roomdoor=$_POST['roomdoor']; $voroddoor=$_POST['voroddoor']; $telephon=$_POST['telephon']; $kaf=$_POST['kaf']; $saghf=$_POST['saghf']; $mdf=$_POST['mdf']; $koche=$_POST['koche']; $sona=$_POST['sona']; $jakozi=$_POST['jakozi']; $vaan=$_POST['vaan']; $estakhr=$_POST['estakhr']; $balkon=$_POST['balkon']; $negahbani=$_POST['negahbani']; $suit=$_POST['suit']; $chah=$_POST['chah']; $text=$_POST['text'];
if(!empty($group)) { $class=new content; $send=$class->query('insert into `tbl_melk` (`id`,`group`,`melktype`,`codemelk`,`fullname`,`ph one`,`mobile`,`province`,`city`,`onvan`,`title`,`v aziat`,`zamin`,`bana`,`jahat`,`salesakht`,`eskelet `,`tabaghe`,`room`,`nama`,`condition`,`foroshmoney `,`mablaghvam`,`ghmt`,`address`,`tolzamin`,`arz`,` ertefa`,`parking`,`barghmoshtarak`,`gazmoshtarak`, `watermoshtarak`,`waterwarm`,`shofazh`,`pakage`,`c abinet`,`roomdoor`,`voroddoor`,`telephon`,`kaf`,`s aghf`,`mdf`,`koche`,`sona`,`jakozi`,`vaan`,`estakh r`,`balkon`,`negahbani`,`suit`,`chah`,`text` ) VALUES (NULL,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, ?,?,?,?)');
$class->bind(1,!is_null($group) ? $group : ''); $class->bind(2,!is_null($melktype) ? $melktype : ''); $class->bind(3,!is_null($codemelk) ? $codemelk : ''); $class->bind(4,!is_null($fullname) ? $fullname : ''); $class->bind(5,!is_null($phone) ? $phone : ''); $class->bind(6,!is_null($mobile) ? $mobile : ''); $class->bind(7,!is_null($province) ? $province : ''); $class->bind(8,!is_null($city) ? $city : ''); $class->bind(9,!is_null($onvan) ? $onvan : ''); $class->bind(10,!is_null($title) ? $title : ''); $class->bind(11,!is_null($vaziat) ? $vaziat : ''); $class->bind(12,!is_null($zamin) ? $zamin : ''); $class->bind(13,!is_null($bana) ? $bana : ''); $class->bind(14,!is_null($jahat) ? $jahat : ''); $class->bind(15,!is_null($salesakht) ? $salesakht : ''); $class->bind(16,!is_null($eskelet) ? $eskelet : ''); $class->bind(17,!is_null($tabaghe) ? $tabaghe : ''); $class->bind(18,!is_null($room) ? $room : ''); $class->bind(19,!is_null($nama) ? $nama : ''); $class->bind(20,!is_null($condition) ? $condition : ''); $class->bind(21,!is_null($foroshmoney) ? $foroshmoney : ''); $class->bind(22,!is_null($mablaghvam) ? $mablaghvam : ''); $class->bind(23,!is_null($ghmt) ? $ghmt : ''); $class->bind(24,!is_null($address) ? $address : ''); $class->bind(25,!is_null($tolzamin) ? $tolzamin : ''); $class->bind(26,!is_null($arz) ? $arz : ''); $class->bind(27,!is_null($ertefa) ? $ertefa : ''); $class->bind(28,!is_null($parking) ? $parking : ''); $class->bind(29,!is_null($barghmoshtarak) ? $barghmoshtarak : ''); $class->bind(30,!is_null($gazmoshtarak) ? $gazmoshtarak : ''); $class->bind(31,!is_null($watermoshtarak) ? $watermoshtarak : ''); $class->bind(32,!is_null($waterwarm) ? $waterwarm : ''); $class->bind(33,!is_null($shofazh) ? $shofazh : ''); $class->bind(34,!is_null($pakage) ? $pakage : ''); $class->bind(35,!is_null($cabinet) ? $cabinet : ''); $class->bind(36,!is_null($roomdoor) ? $roomdoor : ''); $class->bind(37,!is_null($voroddoor) ? $voroddoor : ''); $class->bind(38,!is_null($telephon) ? $telephon : ''); $class->bind(39,!is_null($kaf) ? $kaf : ''); $class->bind(40,!is_null($saghf) ? $saghf : ''); $class->bind(41,!is_null($mdf) ? $mdf : ''); $class->bind(42,!is_null($koche) ? $koche : ''); $class->bind(43,!is_null($sona) ? $sona : ''); $class->bind(44,!is_null($jakozi) ? $jakozi : ''); $class->bind(45,!is_null($vaan) ? $vaan : ''); $class->bind(46,!is_null($estakhr) ? $estakhr : ''); $class->bind(47,!is_null($balkon) ? $balkon : ''); $class->bind(48,!is_null($negahbani) ? $negahbani : ''); $class->bind(49,!is_null($suit) ? $suit : ''); $class->bind(50,!is_null($chah) ? $chah : ''); $class->bind(51,!is_null($text) ? $text : ''); $class->execute(); $mes='<div class="mesn">پیغام شما با موفقیت ارسال شد</div>'; }}
خطا :
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 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 ') VALUES (NULL,'زمین','رهن','5645641','1','2','3','4 ','5','6','7','' at line 1' in /home4/amlakete/public_html/inc/class.php:67 Stack trace: #0 /home4/amlakete/public_html/inc/class.php(67): PDOStatement->execute() #1 /home4/amlakete/public_html/orders.php(122): content->execute() #2
کد در فایل order.php :
///////////////////////////////////////////////////////////////////////if(isset($_POST['group']) && !empty($_POST['group'])){ $group=$_POST['group']; $melktype=$_POST['melktype']; $codemelk=$_POST['codemelk']; $fullname=$_POST['fullname']; $phone=$_POST['phone']; $mobile=$_POST['mobile']; $province=$_POST['province']; $city=$_POST['city']; $onvan=$_POST['onvan']; $title=$_POST['title']; $vaziat=$_POST['vaziat']; $zamin=$_POST['zamin']; $bana=$_POST['bana']; $jahat=$_POST['jahat']; $salesakht=$_POST['salesakht']; $eskelet=$_POST['eskelet']; $tabaghe=$_POST['tabaghe']; $room=$_POST['room']; $nama=$_POST['nama']; $condition=$_POST['condition']; $foroshmoney=$_POST['foroshmoney']; $mablaghvam=$_POST['mablaghvam']; $ghmt=$_POST['ghmt']; $address=$_POST['address']; $tolzamin=$_POST['tolzamin']; $arz=$_POST['arz']; $ertefa=$_POST['ertefa']; $parking=$_POST['parking']; $barghmoshtarak=$_POST['barghmoshtarak']; $gazmoshtarak=$_POST['gazmoshtarak']; $watermoshtarak=$_POST['watermoshtarak']; $waterwarm=$_POST['waterwarm']; $shofazh=$_POST['shofazh']; $pakage=$_POST['pakage']; $cabinet=$_POST['cabinet']; $roomdoor=$_POST['roomdoor']; $voroddoor=$_POST['voroddoor']; $telephon=$_POST['telephon']; $kaf=$_POST['kaf']; $saghf=$_POST['saghf']; $mdf=$_POST['mdf']; $koche=$_POST['koche']; $sona=$_POST['sona']; $jakozi=$_POST['jakozi']; $vaan=$_POST['vaan']; $estakhr=$_POST['estakhr']; $balkon=$_POST['balkon']; $negahbani=$_POST['negahbani']; $suit=$_POST['suit']; $chah=$_POST['chah']; $text=$_POST['text'];
if(!empty($group)) { $class=new content; $send=$class->query('insert into `tbl_melk` (`id`,`group`,`melktype`,`codemelk`,`fullname`,`ph one`,`mobile`,`province`,`city`,`onvan`,`title`,`v aziat`,`zamin`,`bana`,`jahat`,`salesakht`,`eskelet `,`tabaghe`,`room`,`nama`,`condition`,`foroshmoney `,`mablaghvam`,`ghmt`,`address`,`tolzamin`,`arz`,` ertefa`,`parking`,`barghmoshtarak`,`gazmoshtarak`, `watermoshtarak`,`waterwarm`,`shofazh`,`pakage`,`c abinet`,`roomdoor`,`voroddoor`,`telephon`,`kaf`,`s aghf`,`mdf`,`koche`,`sona`,`jakozi`,`vaan`,`estakh r`,`balkon`,`negahbani`,`suit`,`chah`,`text` ) VALUES (NULL,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, ?,?,?,?)');
$class->bind(1,!is_null($group) ? $group : ''); $class->bind(2,!is_null($melktype) ? $melktype : ''); $class->bind(3,!is_null($codemelk) ? $codemelk : ''); $class->bind(4,!is_null($fullname) ? $fullname : ''); $class->bind(5,!is_null($phone) ? $phone : ''); $class->bind(6,!is_null($mobile) ? $mobile : ''); $class->bind(7,!is_null($province) ? $province : ''); $class->bind(8,!is_null($city) ? $city : ''); $class->bind(9,!is_null($onvan) ? $onvan : ''); $class->bind(10,!is_null($title) ? $title : ''); $class->bind(11,!is_null($vaziat) ? $vaziat : ''); $class->bind(12,!is_null($zamin) ? $zamin : ''); $class->bind(13,!is_null($bana) ? $bana : ''); $class->bind(14,!is_null($jahat) ? $jahat : ''); $class->bind(15,!is_null($salesakht) ? $salesakht : ''); $class->bind(16,!is_null($eskelet) ? $eskelet : ''); $class->bind(17,!is_null($tabaghe) ? $tabaghe : ''); $class->bind(18,!is_null($room) ? $room : ''); $class->bind(19,!is_null($nama) ? $nama : ''); $class->bind(20,!is_null($condition) ? $condition : ''); $class->bind(21,!is_null($foroshmoney) ? $foroshmoney : ''); $class->bind(22,!is_null($mablaghvam) ? $mablaghvam : ''); $class->bind(23,!is_null($ghmt) ? $ghmt : ''); $class->bind(24,!is_null($address) ? $address : ''); $class->bind(25,!is_null($tolzamin) ? $tolzamin : ''); $class->bind(26,!is_null($arz) ? $arz : ''); $class->bind(27,!is_null($ertefa) ? $ertefa : ''); $class->bind(28,!is_null($parking) ? $parking : ''); $class->bind(29,!is_null($barghmoshtarak) ? $barghmoshtarak : ''); $class->bind(30,!is_null($gazmoshtarak) ? $gazmoshtarak : ''); $class->bind(31,!is_null($watermoshtarak) ? $watermoshtarak : ''); $class->bind(32,!is_null($waterwarm) ? $waterwarm : ''); $class->bind(33,!is_null($shofazh) ? $shofazh : ''); $class->bind(34,!is_null($pakage) ? $pakage : ''); $class->bind(35,!is_null($cabinet) ? $cabinet : ''); $class->bind(36,!is_null($roomdoor) ? $roomdoor : ''); $class->bind(37,!is_null($voroddoor) ? $voroddoor : ''); $class->bind(38,!is_null($telephon) ? $telephon : ''); $class->bind(39,!is_null($kaf) ? $kaf : ''); $class->bind(40,!is_null($saghf) ? $saghf : ''); $class->bind(41,!is_null($mdf) ? $mdf : ''); $class->bind(42,!is_null($koche) ? $koche : ''); $class->bind(43,!is_null($sona) ? $sona : ''); $class->bind(44,!is_null($jakozi) ? $jakozi : ''); $class->bind(45,!is_null($vaan) ? $vaan : ''); $class->bind(46,!is_null($estakhr) ? $estakhr : ''); $class->bind(47,!is_null($balkon) ? $balkon : ''); $class->bind(48,!is_null($negahbani) ? $negahbani : ''); $class->bind(49,!is_null($suit) ? $suit : ''); $class->bind(50,!is_null($chah) ? $chah : ''); $class->bind(51,!is_null($text) ? $text : ''); $class->execute(); $mes='<div class="mesn">پیغام شما با موفقیت ارسال شد</div>'; }}