scofield007
دوشنبه 05 اسفند 1392, 11:42 صبح
سلام.خسته نباشید
حین اجرای قطعه کد زیر با خطا مواجه شدم.هر کاری کردم نتونستم خطا رو برطرف کنم.خواستم بپرسم مشکلم از کجاس؟
با تشکر
<?php
session_start();
if (!isset($_SESSION['namdavar']))
{
header("location: login.php");
}
$con = mysqli_connect("localhost","root","","login") or die ("can not connect" . mysqli_error());
$checkbox = $_POST['check'];
if (!isset($checkbox))
{
header("location: page-davar.php");
}
foreach ($checkbox as $key => $value)
{
$members = "SELECT * FROM members WHERE id = '$value' ";
$result = mysqli_query($con , $members);
$row = mysqli_fetch_array($result);
$davaran = "insert INTO maghalat-dav(login , nashrie) VALUES ('$row[login]','$row[nashrie]')";
mysqli_query($con , $davaran);
if (!mysqli_query($con , $davaran))
{
die('Error... ' . mysqli_error($con));
header("location: page-davar.php");
}
$maghalat2 = "DELETE FROM members WHERE id = '$value'";
mysqli_query($con , $maghalat2);
}
echo "<b>maghalat entekhab shodand...</b>";
?>
خطایی که نمایش میده این هست
Error... 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 '-dav (login , nashrie) VALUES ('pedram','Date.pdf')' at line 1
حین اجرای قطعه کد زیر با خطا مواجه شدم.هر کاری کردم نتونستم خطا رو برطرف کنم.خواستم بپرسم مشکلم از کجاس؟
با تشکر
<?php
session_start();
if (!isset($_SESSION['namdavar']))
{
header("location: login.php");
}
$con = mysqli_connect("localhost","root","","login") or die ("can not connect" . mysqli_error());
$checkbox = $_POST['check'];
if (!isset($checkbox))
{
header("location: page-davar.php");
}
foreach ($checkbox as $key => $value)
{
$members = "SELECT * FROM members WHERE id = '$value' ";
$result = mysqli_query($con , $members);
$row = mysqli_fetch_array($result);
$davaran = "insert INTO maghalat-dav(login , nashrie) VALUES ('$row[login]','$row[nashrie]')";
mysqli_query($con , $davaran);
if (!mysqli_query($con , $davaran))
{
die('Error... ' . mysqli_error($con));
header("location: page-davar.php");
}
$maghalat2 = "DELETE FROM members WHERE id = '$value'";
mysqli_query($con , $maghalat2);
}
echo "<b>maghalat entekhab shodand...</b>";
?>
خطایی که نمایش میده این هست
Error... 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 '-dav (login , nashrie) VALUES ('pedram','Date.pdf')' at line 1