i tried to run these codes manually at url but it returns null values
1.when admin accept the request status will be updated as in first query
2.second query will fetched remain_leave
3.third query will update the found difference from remain_leave and
ldays
<?php
$con=mysql_connect("","","");
$db=mysql_select_db('',$con);
$status=$_REQUEST['status'];
$eid=$_REQUEST['eid'];
$ldays=$_REQUEST['ldays'];
$leave=0;
$result=mysql_query("update user_request set status='$status' where eid
='$eid'") or die("error");
$result1=mysql_query("select remain_leave from user where id='$id'");
while($row= mysql_fetch_assoc($result1))
{
$leave=$row['remain_leave'];
}
$diff=$leave-$ldays;
$result=mysql_query("update user set remain_leave=$diff where id
='$eid'") or die("error");
echo json_encode($respon);
?>