part of my script:
.........................
.........................
data = $(this).serialize() + "&" + $.param(data);
$.ajax({
type: "POST",
dataType: "json",
url: "fetch_tutor.php", //Relative or absolute path to response.php file
data: data,
success: function(data) {
}
});
......................
.........................
I spotted a weird thing. In the php script that I'm fetching the data from (fetch_tutor.php)
, I have a query that goes like this:
WHERE posts.subname LIKE '%tamil%'
AND posts.pricing <= '161'
AND posts.morning IN ('sun')
OR posts.afternoon IN ('sun') OR posts.evening IN ('sun','mon')
WHen I had this query I've no issue in fetching data from the php script but obviously '()'
is missed arounf the IN
.
So I replaced the above query with this (just added '()'
brackets):
WHERE posts.subname LIKE '%tamil%'
AND posts.pricing <= '161'
AND (posts.morning IN ('sun')
OR posts.afternoon IN ('sun')
OR posts.evening IN ('sun','mon'))
But now ajax request not fetching any data, in fact it shows status 500 (internal server error) in the console tab. Why is it so?
FULL PHP SCRIPT
<?php
session_start();
include('config.php');
$return = $_POST;
//sample data
//$return = '{"subject":"tamil","try":"","location":"kajang","lat":"","lon":"","rate":"100","distance":"40","avail":["Sun-1","Sun-2","Sun-3"],"action":"test"}';
$return["json"] = json_encode($return);
$data = json_decode($return["json"], true);
$personal = $data['pers'];
$tuition = $data['tuit'];
$avail = $data['avail'];
$days = array();
$cols = array();
$array = array();
if (strpos($data['subject'], '>') != FALSE)
{
$array = explode(' > ', $data['subject']);
$array[0]; // Languages
$array[1]; // English
$subject = $array[1];
$catname = $array[0];
}
else
{
$subject = $data['subject'];
}
//after the symbol
$catid = $data['try'];
$location = $data['location'];
//$lat = $data['lat'];
//$lon = $data['lon'];
$o_rate=$data['rate'];
$rate = $data['rate']* 1.15;
$distance =$data['distance'];
//$address = '43000 kajang';
$coordinates = file_get_contents('http://maps.googleapis.com/maps/api/geocode/json?address=' . urlencode($location) . '&sensor=true');
$coordinates = json_decode($coordinates);
$coordinates->results[0]->geometry->location->lat;
$coordinates->results[0]->geometry->location->lng;
$lat = $coordinates->results[0]->geometry->location->lat;
$lng = $coordinates->results[0]->geometry->location->lng;
$lat = $lat;
$lon = $lng;
/*insert starts*/
$insert="INSERT INTO search_history(place,budget,subject,level,datetime)VALUES('$location','$o_rate','$subject','$catname', now())";
$stmt_insert =connection::$pdo->prepare($insert);
$stmt_insert->execute();
/*insert ends*/
if($personal != "")
{
$add_here = " AND centre =0";
}
if($tuition != "")
{
$add_here .= " || centre =1";
}
$size = sizeof($avail);
if(($avail != "")&&($size > 1)){
$periods = array();
foreach($avail as $v){
list($day, $column) = explode("-", $v); // make sure you validated the data to avoid errors
$periods[$column][] = "'" . mysql_escape_string(strtolower($day)) . "'"; // PHP would automatically create an empty array if $periods[$column] was not defined
}
$intToCol = array(1 => "morning", 2 => "afternoon", 3 => "evening");
// $periods should now be identical to ["2" => ["'sun'", "'mon'"], "3" => ["'sun'"]]
$conditions = array();
foreach($periods as $int => $days){
$dayString = implode(",", $days);
$conditions[] = "posts." . $intToCol[$int] . " IN ($dayString)";
}
$add_here = implode(" OR ", $conditions) . "";
}else if(($avail != "")&&($size == 1))
{
foreach($avail as $k=>$v)
{
$v;
$array = explode('-', $v);
$day =$array[0]; // Wed
$column = $array[1]; // 2
if($column == 1)
{
$col = "morning";
}
if($column == 2)
{
$col = "afternoon";
}
if($column == 3)
{
$col = "evening";
}
}
$add_here = "AND posts.".$col." = '".$day."' ";
}
if (strpos($data['subject'], '>') != FALSE)
{
$sql=" SELECT * , (3956 * 2 * ASIN(SQRT( POWER(SIN(('$lat' - lat) * pi()/180 / 2), 2) +COS('$lat' * pi()/180) * COS(lat * pi()/180) * POWER(SIN(('$lon' - lon) * pi()/180 / 2), 2) ))) as distance
from posts,subjects WHERE posts.catID = '$catid' AND posts.subname LIKE '%$subject%' AND posts.subid = subjects.subid AND posts.catID = subjects.catid AND posts.pricing <= '$rate' AND (".$add_here.") GROUP BY posts.UUID having distance <= '$distance' order by distance";
}else
{
$sql = "SELECT * , (3956 * 2 * ASIN(SQRT( POWER(SIN(('$lat' - lat) * pi()/180 / 2), 2) +COS('$lat' * pi()/180) * COS(lat * pi()/180) * POWER(SIN(('$lon' - lon) * pi()/180 / 2), 2) ))) as distance from posts WHERE posts.subname LIKE '%$subject%' AND posts.pricing <= '$rate' AND (".$add_here.") GROUP BY posts.UUID having distance <= '$distance' order by distance";
}
$stmt =connection::$pdo->prepare($sql);
$stmt->execute();
$place=array();
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
$place[] = $row;
}
$_SESSION['subject'] = $place;
echo json_encode($place);
?>