September 22,2016

Php Script:

<?php
$stream = $_POST[‘stream’];
$year=$_POST[‘year’];
//$stream=’CSE’;
//$year=’1′;
$sub=array();
$desc=array();
$url=array();
$con=new mysqli(“localhost”,”root”,””,”login”);
if($con->connect_errno){
echo “connection error”;
}
$query1=”select Subject,Description,URL from upload_asgnmt where Stream=’$stream’ and Year=’$year'”;
$result =$con->query($query1);
if($result->num_rows>0){
while($sql_arr=mysqli_fetch_array($result)){
array_push($sub,$sql_arr[‘Subject’]);
array_push($desc,$sql_arr[‘Description’]);
array_push($url,$sql_arr[‘URL’]);
}
$response=’ok’;
}
else
{
$response=’error’;
}
echo json_encode(array(‘result’=>$response,’Subject’=>$sub,’desc’=>$desc,’url’=>$url));
?>