I trying to work on a project that need to pull some data from multiple table from mysql and display it into php. Here is the code:
<?php $db = new PDO('mysql:host='. DB_HOST .';dbname='. DB_NAME . ';charset=utf8', DB_USER, DB_PASS);
if(!$db) echo "fail";
// else
// echo "success";
$sth = $db->prepare("SELECT e.COURSE_NAME 'CourseCatalog', e.COURSE_CATEGORY 'CourseCatalog', d.OFFERING_START_DATE 'CourseOffered', d.OFFERING_END_DATE 'CourseOffered', d.OFFERING_CLASS_DAY 'CourseOffered' FROM PortalAccount a, Student_has_PortalAccount b, StudentEnrollment c, CourseOffered d, CourseCatalog e WHERE d.COURSE_ID = e.COURSE_ID and c.OFFERING_ID = d.OFFERING_ID and b.Student_Student_ID = c.STUDENT_ID and a.user_id = b.PortalAccount_PORTAL_ACCOUNT_ID and a.user_id = :user_id");
$sth->bindValue(':user_id', $_SESSION['user_id'], PDO::PARAM_STR);
$sth->execute();
$row = $sth->fetchAll();
var_dump($row);
?>
and the result is like this:
array (size=2)
0 =>
array (size=7)
'CourseCatalog' => string 'Video Game Design' (length=17)
0 => string 'Video Game Design Minecraft Modding' (length=35)
1 => string 'Video Game Design' (length=17)
'CourseOffered' => string 'SATURDAY' (length=8)
2 => string '2015-09-12' (length=10)
3 => string '2015-11-14' (length=10)
4 => string 'SATURDAY' (length=8)
1 =>
array (size=7)
'CourseCatalog' => string 'Video Game Design' (length=17)
0 => string 'Programming is Fun Using MIT Scratch' (length=36)
1 => string 'Video Game Design' (length=17)
'CourseOffered' => string 'SATURDAY' (length=8)
2 => string '2015-09-12' (length=10)
3 => string '2015-10-14' (length=10)
4 => string 'SATURDAY' (length=8)
The problem is how can I make it displayed like this table in php:
Course Name Type Detail
Video Game Design Minecraft Modding Video Game Design 09/12 - 11/14 SATURDAY
Programming is Fun Using MIT Scratch Video Game Design09/12 - 11/14 SATURDAY
Thank you!