baran.f.a
پنج شنبه 25 دی 1393, 20:47 عصر
سلام من یک فرم جستجوی پیشرفته طراحی کردم که کاربر هم می تونه تمام فیلد های این فرم را پر کند و یا فقط قسمت های خاصی را تکمیل کند . اما دچار یه مشکل شدم خطایی میده که من چیزی ازش سر در نمیارم لطفا کمک کنید . آیا کد من اشتباهه ؟
if($_SERVER["REQUEST_METHOD"] == "POST"){
$psp = $_POST['psp_project'];
$project = $_POST['project'];
$branch = $_POST['branch'];
$city = $_POST['city'];
$technician = $_POST['technician'];
$from_date = $_POST['from_date'];
$until_date = $_POST['until_date'];
$from_amount = $_POST['from_amount'];
$until_amount = $_POST['until_amount'];
$from_number = $_POST['from_number'];
$until_number = $_POST['until_number'];
$arr = array();
if (!empty($psp))
{
$sql=mysql_query("select *
from psp
where psp_name
LIKE '%$psp%'") or die(mysql_error());
$count=mysql_num_rows($sql);
while($rows=mysql_fetch_array($sql)){
$psp_project=$rows['psp_project'];
$search=mysql_query("select *
from psp
where psp_project='$psp_project'") or die(mysql_error());
$count=mysql_num_rows($search);
while($rows=mysql_fetch_array($search)){
$arr['psp'] =$rows['id'];
}
}
}
if (!empty($project))
{
$sql=mysql_query("select psp.psp_name
from (select *
from psp
where psp_project
LIKE '%$psp%') t3 , psp
where t3.psp_project=psp.id
") or die(mysql_error());
$count=mysql_num_rows($search);
while($rows=mysql_fetch_array($search)){
$arr['project'] = $rows['psp_name'];
}
}
if (!empty($city))
{
$arr['city'] = " merchant.branch_name LIKE '%$city%' ";
}
if (!empty($technician))
{
$arr['tech'] = " pos.technician_id = '$technician' ";
}
if (!empty($from_date))
{
$miladi=date("Y/m/d ", strtotime($from_date));
$arr['fd'] = " transaction.update_date > '$miladi' ";
}
if (!empty($until_date))
{
$miladi=date("Y/m/d ", strtotime($until_date));
$arr['ud'] = " transaction.update_date < '$miladi' ";
}
if (!empty($from_amount))
{
$arr['fa'] = " transaction.amount_trans > '$from_amount' ";
}
if (!empty($until_amount))
{
$arr['ua'] = " transaction.amount_trans < '$until_amount' ";
}
if (!empty($until_number))
{
$arr['un'] = " transaction.total_trans = '$until_number' ";
}
if (!empty($from_number))
{
$arr['fn'] = " transaction.total_trans = '$from_number' ";
}
$where = 'WHERE' . implode('AND', $arr);
$query = 'SELECT pos.* , sum(transaction.amount_trans) as `amount_trans` , sum(transaction.total_trans) as `total_trans`,sum(transaction.buy_amount) as `buy_amount` ,sum(transaction.buy_trans) AS `buy_trans`
FROM pos
INNER JOIN merchant
on merchant.m_id=pos.merchant_id
INNER JOIN transaction
on transaction.serial_code=pos.serial_code
INNER JOIN psp
on psp.id=pos.psp_id
' . $where ;
$result = mysql_query($query) or die (mysql_error());
$anymatches=mysql_num_rows($query);
if ($anymatches == 0)
{
echo "Sorry, but we can not find an entry to match your query<br><br>";
}
}
خطایی که دارنو در تصویر می بینید . لطفا هر کس می تونه راهنمایی کنه . ممنون
127581
if($_SERVER["REQUEST_METHOD"] == "POST"){
$psp = $_POST['psp_project'];
$project = $_POST['project'];
$branch = $_POST['branch'];
$city = $_POST['city'];
$technician = $_POST['technician'];
$from_date = $_POST['from_date'];
$until_date = $_POST['until_date'];
$from_amount = $_POST['from_amount'];
$until_amount = $_POST['until_amount'];
$from_number = $_POST['from_number'];
$until_number = $_POST['until_number'];
$arr = array();
if (!empty($psp))
{
$sql=mysql_query("select *
from psp
where psp_name
LIKE '%$psp%'") or die(mysql_error());
$count=mysql_num_rows($sql);
while($rows=mysql_fetch_array($sql)){
$psp_project=$rows['psp_project'];
$search=mysql_query("select *
from psp
where psp_project='$psp_project'") or die(mysql_error());
$count=mysql_num_rows($search);
while($rows=mysql_fetch_array($search)){
$arr['psp'] =$rows['id'];
}
}
}
if (!empty($project))
{
$sql=mysql_query("select psp.psp_name
from (select *
from psp
where psp_project
LIKE '%$psp%') t3 , psp
where t3.psp_project=psp.id
") or die(mysql_error());
$count=mysql_num_rows($search);
while($rows=mysql_fetch_array($search)){
$arr['project'] = $rows['psp_name'];
}
}
if (!empty($city))
{
$arr['city'] = " merchant.branch_name LIKE '%$city%' ";
}
if (!empty($technician))
{
$arr['tech'] = " pos.technician_id = '$technician' ";
}
if (!empty($from_date))
{
$miladi=date("Y/m/d ", strtotime($from_date));
$arr['fd'] = " transaction.update_date > '$miladi' ";
}
if (!empty($until_date))
{
$miladi=date("Y/m/d ", strtotime($until_date));
$arr['ud'] = " transaction.update_date < '$miladi' ";
}
if (!empty($from_amount))
{
$arr['fa'] = " transaction.amount_trans > '$from_amount' ";
}
if (!empty($until_amount))
{
$arr['ua'] = " transaction.amount_trans < '$until_amount' ";
}
if (!empty($until_number))
{
$arr['un'] = " transaction.total_trans = '$until_number' ";
}
if (!empty($from_number))
{
$arr['fn'] = " transaction.total_trans = '$from_number' ";
}
$where = 'WHERE' . implode('AND', $arr);
$query = 'SELECT pos.* , sum(transaction.amount_trans) as `amount_trans` , sum(transaction.total_trans) as `total_trans`,sum(transaction.buy_amount) as `buy_amount` ,sum(transaction.buy_trans) AS `buy_trans`
FROM pos
INNER JOIN merchant
on merchant.m_id=pos.merchant_id
INNER JOIN transaction
on transaction.serial_code=pos.serial_code
INNER JOIN psp
on psp.id=pos.psp_id
' . $where ;
$result = mysql_query($query) or die (mysql_error());
$anymatches=mysql_num_rows($query);
if ($anymatches == 0)
{
echo "Sorry, but we can not find an entry to match your query<br><br>";
}
}
خطایی که دارنو در تصویر می بینید . لطفا هر کس می تونه راهنمایی کنه . ممنون
127581