lundi 29 juillet 2019

Display data as cross tab in laravel

I have this join

$degreesPdfs = DB::select("SELECT student_tbs.student_id,student_tbs.regno,student_tbs.stdName,student_tbs.stdfName,student_tbs.department_id,student_tbs.degree_id,roll_no_tbs.rollno,roll_no_com_dets.subcode,subject_tbs.Na,subject_tbs.semester_id,college_tbs.name FROM student_tbs INNER JOIN roll_no_tbs ON roll_no_tbs.regno = student_tbs.regno INNER JOIN roll_no_com_dets ON roll_no_com_dets.rollno = roll_no_tbs.rollno INNER JOIN college_tbs ON college_tbs.college_id = student_tbs.department_id LEFT JOIN subject_tbs ON subject_tbs.code =roll_no_com_dets.subcode WHERE student_tbs.department_id = $degAdmin_department AND student_tbs.degree_id = $degree");

I want to display data like this Please click on the in order to view the image.I have search alot but could not find any proper solution

https://drive.google.com/open?id=1dSOCRd8TLOdx-E8z3qNpaTNBuEvciOH5

I will be very thankful to you



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire