Viewing file:  view_batch.php (1.7 KB) -rw-rw-r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
require("connection.php");
$userid=$_REQUEST['user_id'];
$data=array();
$sqldata="select * from tb_user where user_id='$userid' and delete_status=0";
$resultdata=$con_it->query($sqldata);
$countdata=$resultdata->num_rows;
if($countdata>0){
$row=$resultdata->fetch_assoc();
$phone=$row['phone'];
$query="SELECT *
FROM `user_details`
INNER JOIN enrolldetails ON user_details.user_id=enrolldetails.user_id where user_details.phone='$phone'";
$queryResult=$con->query($query);
$queryCount=$queryResult->num_rows;
if($queryCount>0){
while($queryRow=$queryResult->fetch_assoc()){
$course_id=$queryRow['course_id'];
$coursequery="SELECT * FROM `course_details` where id=$course_id";
$courseResult=$con->query($coursequery);
$courseRow=$courseResult->fetch_assoc();
$technology=$courseRow['technology'];
$result=$con->query("select * from `technologies` where id=$technology");
$count=$result->num_rows;
if($count>0)
{while($row=$result->fetch_assoc())
{
$data[] =array(
"batch_id" => $row['id'],
"batch_name" => $row['name'] );
$post = array("status"=>true,"batch_details"=>$data);
}
}
}
}
else{
$result=$con->query("select * from `technologies`");
$count=$result->num_rows;
if($count>0)
{while($row=$result->fetch_assoc())
{
$data[] =array(
"batch_id" => $row['id'],
"batch_name" => $row['name'] );
$post = array("status"=>true,"batch_details"=>$data);
}
}
}
}
else {
$post=array("status"=>false,"batch_details"=>$data);
}
echo(json_encode($post));
?>
|