i've got this code
{ <?php
include 'koneksi.php';
$idAgent = $_GET["rqid"];
$ipAgent = $_SERVER['REMOTE_ADDR'];
$app = $_GET["app"];
$action = $_GET["action"];
$org = $_GET["org"];
$des = $_GET["des"];
$trainNo = $_GET["train_no"];
$depDate = $_GET["dep_date"];
$query = "SELECT cekRQID('$idAgent','$ipAgent') as jml;";
//echo($query);
$hasil = mysql_query($query);
$data = mysql_fetch_array($hasil);
$channelOK = $data['jml'];
if ($channelOK == "1") {
if ($app == "information" && $action == "get_seat_map") {
$query="SELECT 0 as err_code, '$org' as org, '$des' as des, '$trainNo' as train_no, $depDate as dep_date ";
$hasil1 = mysql_query($query);
$rows1 = array();
while ($r1 = mysql_fetch_assoc($hasil1)){
$rows1 = $r1;
}
$tglnya = date('Ymd',$depDate); //STR_TO_DATE('$depDate','%Y%m%d')
$query = mysql_query("CALL GET_SEAT_MAP('$org','$des','$trainNo',STR_TO_DATE('$depDate','%Y%m%d'),@TEST);") or die mysql_error();
$query = mysql_query("SELECT @TEST;") or die mysql_error();
//echo($query);
while($row = mysql_fetch_row($query))
{
$query = $row[0];
}
$hasil = mysql_query($query);
//echo($query);
$rows = array();
$index= 0;
$bufk0 = "";
$body = 0;
while ($r = mysql_fetch_row($hasil)){
$curfk0 = $r[0].$r[1];
if( $bufk0 != $curfk0 ){
$head[$curfk0] = array ( $r[0],$r[1]);
$out2[$curfk0][] = array( $r[2],$r[3],$r[4],$r[5],$r[6],$r[7] );
} else {
$out2[$curfk0][] = array( $r[2],$r[3],$r[4],$r[5],$r[6],$r[7] );
}
$bufk0 = $r[0].$r[1];
$bufindex = $index;
$headindex = $head ;
$index++;
}
}
if (is_array($values)){
foreach ($head as $key => $val ){
$final['seat_map'][] = array( $val[0],$val[1], $out2[$key] );
}
}
header('Content-type: application/json');
echo json_encode($rows1+$final);
}
?>
}
when i'm run this code, i've got some error message : Parse error: syntax error, unexpected T_STRING in /var/www/html/sgetseatmap.php on line 37
which is in code :
$query = mysql_query("CALL GET_SEAT_MAP('$org','$des','$trainNo',STR_TO_DATE('$depDate','%Y%m%d'),@TEST);") or die mysql_error();
I just can't figure out why its happening here, any help is greatly appreciated.
{ <?php
and?>}
so I'm not sure about your code and where exactly line 37 is. – Fred -ii- Sep 19 '13 at 0:25