dongxiane0395 2015-09-30 23:55
浏览 38

如何在PHP中将多维数组显示到表中?

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!

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥20 求个正点原子stm32f407开发版的贪吃蛇游戏
    • ¥15 正弦信号发生器串并联电路电阻无法保持同步怎么办
    • ¥15 划分vlan后,链路不通了?
    • ¥20 求各位懂行的人,注册表能不能看到usb使用得具体信息,干了什么,传输了什么数据
    • ¥15 个人网站被恶意大量访问,怎么办
    • ¥15 Vue3 大型图片数据拖动排序
    • ¥15 Centos / PETGEM
    • ¥15 划分vlan后不通了
    • ¥20 用雷电模拟器安装百达屋apk一直闪退
    • ¥15 算能科技20240506咨询(拒绝大模型回答)