Viewing file:  student_details_view.php (6.37 KB) -rw-rw-r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
require("connection.php");
$post['status']="error";
$stud_id=$_REQUEST['stud_id'];
$package_id=$_REQUEST['package_id'];
$result=$con->query("SELECT *
FROM `user_details`
LEFT JOIN enrolldetails ON user_details.user_id=enrolldetails.user_id where enrolldetails.user_id='$stud_id' and enrolldetails.admin_status=1 and enrolldetails.course_id=$package_id");
$count=$result->num_rows;
if($count>0)
{
$r=$con->query("select count(*) from `submit_assignment` where stud_id='$stud_id'");
$ro=$r->fetch_assoc();
while($row=$result->fetch_assoc())
{
$sem= $row['course'];
$course="select * from `course_details` where name='$sem' ";
$courseresult=$con->query($course);
$coursecount=$courseresult->num_rows;
if($coursecount>0)
{
$courserow=$courseresult->fetch_assoc();
$tech=$courserow['technology'];
$se=$courserow['id'];
$techno="select * from `technologies` where id='$tech' ";
$technoresult=$con->query($techno);
$techcount=$technoresult->num_rows;
if($techcount>0)
{
$techrow=$technoresult->fetch_assoc();
$technology=$techrow['name'];
}
}
$re=$con->query("select count(*) from `assign_sub` where semester='$se'");
$row1=$re->fetch_assoc();
$re1=$con->query("select count(*) from `exam` where semester='$se' and type='1'");
$row2=$re1->fetch_assoc();
$re2=$con->query("select * from `exam` where semester='$sem'");
$row4=$re2->fetch_assoc();
$subj=$row4['subject'];
$re1=$con->query("select count(*) from `exam_result` where stud_id='$stud_id'");
$row3=$re1->fetch_assoc();
$data[] =array(
"stud_id"=>(int)$row['user_id'],
"name" => $row['name'],
"email" => $row['email'],
"batch" => $technology,
"semester" => $row['course'],
"password" => "",
"batch_id"=>(int)$tech,
"reg_no"=>"",
"submitted_assignment"=>(int)$ro['count(*)'],
"total_assignment"=>(int)$row1['count(*)'],
"pending_assignment"=>$row1['count(*)']-$ro['count(*)'],
"total_exam"=>(int)$row2['count(*)'],
"submitted_exam"=>(int)$row3['count(*)'],
"pending_exam"=>$row2['count(*)']-$row3['count(*)']
);
//echo $ass;
$sql=$con->query("select * from `assign_sub` where semester='$se'");
$co=$sql->num_rows;
if($co>0){
while($ro=$sql->fetch_assoc())
{
$ass_id=$ro['assign_id'];
$st=$con->query("select * from `submit_assignment` where stud_id='$stud_id' and assign_id='$ass_id'");
$ro4=$st->fetch_assoc();
$flag=$ro4['submit_flag'];
$ass=$ro4['assign_id'];
if($ass_id!=$ass){
// $s= $ro['subject'];
// $a=$con->query("select * from semester_subject where semester='$sem' and subject='$s'");
// $b=$a->fetch_assoc();
// $im=$b['file'];
$data1[] =array(
"assign_id"=>(int)$ro['assign_id'],
"batch_id" => (int)$ro['batch_id'],
"semester" => $row['course'],
"subject" => $ro['subject'],
"topic" => $ro['topic'] ,
"submittion_date" => $ro['submittion_date'],
"faculty_id"=>(int)$ro['faculty_id'],
"assignment_image"=>$ro['file']
);
}
}
}
else{
$data1=array();
}
$sql1=$con->query("select * from `exam` where semester='$se' and type='1' ");
$co1=$sql1->num_rows;
if($co1>0)
{
while($ro1=$sql1->fetch_assoc())
{$sub= $ro1['subject'];
$e=(int)$ro1['exam_id'];
$d="select * from exam_result where exam_id='$e' and stud_id='$stud_id'";
$res=$con->query($d);
$f=$res->fetch_assoc();
$e1=$f['exam_id'];
$o="select * from semester_subject where subject='$sub'";
$p=$con->query($o);
$x=$p->fetch_assoc();
$im1=$x['file'];
if($e!=$e1){
$data2[] =array(
"exam_id"=>(int)$ro1['exam_id'],
"batch_id" => (int)$ro1['batch_id'],
"semester" => $row['course'],
"subject" => $ro1['subject'],
"title" => $ro1['exam_title'],
"date" => $ro1['exam_date'],
"examtime"=>$ro1['examtime'],
"faculty_id"=>(int)$ro1['faculty_id'],
"exam_image"=>$im1
);
}
}
}
else{
$data2=array();
}
$sql2=$con->query("select * from `study_material` where semester='$se' ");
$co2=$sql2->num_rows;
if($co2>0){
while($ro2=$sql2->fetch_assoc())
{
$s2= $ro2['subject'];
$a2=$con->query("select * from semester_subject where semester='$sem' and subject='$s2'");
$b2=$a2->fetch_assoc();
$im2=$b2['file'];
$data3[] =array("material_id"=>(int)$ro2['material_id'],
"batch_id" => (int)$ro2['batch_id'],
"semester" => $row['course'],
"subject" => $ro2['subject'],
"title" => $ro2['title'],
"note" => $ro2['file'],
"faculty_id"=>(int)$ro2['faculty_id'],
"material_image"=>$im2
);
}
}
else{
$data3=array();
}
$sql5=$con->query("select * from `vedioup` where semester='$se' ");
$co5=$sql5->num_rows;
if($co5>0){
while($ro5=$sql5->fetch_assoc())
{
$data5[] =array("vedioid"=>$ro5['id'],
"Package"=>$ro5['semester'],
"subject"=>$ro5['subject'],
"file"=>$ro5['file'],
"faculty_id"=>$ro5['faculty_id'],
"batch_id"=>$ro5['batch_id']
);
}
}
else{
$data5=array();
}
$post = array("status"=>"success","Student_details"=>$data,"Assignment"=>$data1,"Exam"=>$data2,"Note"=>$data3,"vedio"=>$data5);
}
}
else {
$post['status']="fail";
}
header('Content-Type: application/json');
echo(json_encode($post));
?>
|