Testing - PHP
fetch(PDO::FETCH_ASSOC)
TEST: fetch(PDO::FETCH_ASSOC) YU course codes
Array
(
[0] => Array
(
[course_code] => PSYC6104
)
[1] => Array
(
[course_code] => PSYC6213
)
[2] => Array
(
[course_code] => PSYC6203
)
[3] => Array
(
[course_code] => PSYC6153
)
[4] => Array
(
[course_code] => PSYC6163
)
[5] => Array
(
[course_code] => PSYC6246
)
[6] => Array
(
[course_code] => PSYC6233
)
[7] => Array
(
[course_code] => PSYC6273
)
[8] => Array
(
[course_code] => PSYC6256
)
[9] => Array
(
[course_code] => PSYC6223
)
[10] => Array
(
[course_code] => PSYC6263
)
[11] => Array
(
[course_code] => PSYC6383
)
[12] => Array
(
[course_code] => PSYC7113
)
[13] => Array
(
[course_code] => PSYC7203
)
[14] => Array
(
[course_code] => DONE0000
)
[15] => Array
(
[course_code] => PERS0000
)
[16] => Array
(
[course_code] => DONE0000
)
)
TEST: fetch(PDO::FETCH_ASSOC) YU all course info
Array
(
[0] => Array
(
[id] => 1
[trimester] => 1
[term_code] => 23F
[course_code] => PSYC6104
[course_name] => A Biopsychosocial Approach to Counselling
[credits] => 4
[current] => n
[completed] => y
[start_date] => 2023-09-04
[end_date] => 2023-11-12
[recordDateTime] => 2024-12-09 10:31:33
)
[1] => Array
(
[id] => 2
[trimester] => 1
[term_code] => 23F
[course_code] => PSYC6213
[course_name] => Research Methodology
[credits] => 3
[current] => n
[completed] => y
[start_date] => 2023-11-13
[end_date] => 2023-12-17
[recordDateTime] => 2024-12-09 10:34:56
)
[2] => Array
(
[id] => 3
[trimester] => 2
[term_code] => 24W
[course_code] => PSYC6203
[course_name] => Ethical Standards for Mental Health Service Providers
[credits] => 3
[current] => n
[completed] => y
[start_date] => 2024-01-08
[end_date] => 2024-02-11
[recordDateTime] => 2024-12-09 10:36:09
)
[3] => Array
(
[id] => 4
[trimester] => 2
[term_code] => 24W
[course_code] => PSYC6153
[course_name] => Counselling Methodologies: Humanistic and Psychodynamic Modalities
[credits] => 3
[current] => n
[completed] => y
[start_date] => 2024-02-12
[end_date] => 2024-03-17
[recordDateTime] => 2024-12-09 10:40:38
)
[4] => Array
(
[id] => 5
[trimester] => 2
[term_code] => 24W
[course_code] => PSYC6163
[course_name] => Counselling Methodologies: Behavioral and Cognitive Modalities
[credits] => 3
[current] => n
[completed] => y
[start_date] => 2024-03-18
[end_date] => 2024-04-21
[recordDateTime] => 2024-12-09 10:41:17
)
[5] => Array
(
[id] => 6
[trimester] => 3
[term_code] => 25W
[course_code] => PSYC6246
[course_name] => Counselling Skills and Competencies
[credits] => 6
[current] => n
[completed] => y
[start_date] => 2025-01-06
[end_date] => 2025-03-16
[recordDateTime] => 2025-03-17 10:42:18
)
[6] => Array
(
[id] => 7
[trimester] => 3
[term_code] => 25W
[course_code] => PSYC6233
[course_name] => Assessment in Counselling
[credits] => 3
[current] => n
[completed] => y
[start_date] => 2025-03-17
[end_date] => 2025-04-20
[recordDateTime] => 2025-04-29 09:13:16
)
[7] => Array
(
[id] => 8
[trimester] => 4
[term_code] => 25SS
[course_code] => PSYC6273
[course_name] => Cultural Diversity in Counselling
[credits] => 3
[current] => n
[completed] => y
[start_date] => 2025-05-05
[end_date] => 2025-06-08
[recordDateTime] => 2025-06-10 14:14:39
)
[8] => Array
(
[id] => 9
[trimester] => 4
[term_code] => 25SS
[course_code] => PSYC6256
[course_name] => Applying Interventions
[credits] => 6
[current] => n
[completed] => y
[start_date] => 2025-06-09
[end_date] => 2025-08-17
[recordDateTime] => 2025-08-20 07:05:56
)
[9] => Array
(
[id] => 10
[trimester] => 5
[term_code] => 25F
[course_code] => PSYC6223
[course_name] => Group Counselling
[credits] => 3
[current] => n
[completed] => y
[start_date] => 2025-09-01
[end_date] => 2025-10-05
[recordDateTime] => 2025-10-08 11:37:13
)
[10] => Array
(
[id] => 11
[trimester] => 5
[term_code] => 25F
[course_code] => PSYC6263
[course_name] => Couples and Family Systems
[credits] => 3
[current] => n
[completed] => y
[start_date] => 2025-10-06
[end_date] => 2025-11-09
[recordDateTime] => 2025-11-17 10:35:15
)
[11] => Array
(
[id] => 12
[trimester] => 5
[term_code] => 25F
[course_code] => PSYC6383
[course_name] => Crisis and Trauma in Counselling
[credits] => 3
[current] => n
[completed] => y
[start_date] => 2025-11-10
[end_date] => 2025-12-14
[recordDateTime] => 2026-01-03 15:06:40
)
[12] => Array
(
[id] => 13
[trimester] => 6
[term_code] => 26W
[course_code] => PSYC7113
[course_name] => Practicum I
[credits] => 3
[current] => n
[completed] => y
[start_date] => 2026-01-05
[end_date] => 2026-04-19
[recordDateTime] => 2026-05-06 07:55:22
)
[13] => Array
(
[id] => 14
[trimester] => 7
[term_code] => 26S
[course_code] => PSYC7203
[course_name] => Practicum II
[credits] => 3
[current] => n
[completed] => n
[start_date] => 2026-05-04
[end_date] => 2026-08-16
[recordDateTime] => 2026-09-09 17:00:50
)
[14] => Array
(
[id] => 15
[trimester] =>
[term_code] => 00A
[course_code] => DONE0000
[course_name] => Answer to the Ultimate Question of Life, the Universe, and Everything
[credits] =>
[current] => n
[completed] =>
[start_date] => 2025-09-01
[end_date] => 2025-10-05
[recordDateTime] => 2025-08-25 08:18:14
)
[15] => Array
(
[id] => 16
[trimester] =>
[term_code] => 00A
[course_code] => PERS0000
[course_name] => No course: Personal
[credits] =>
[current] => y
[completed] => n
[start_date] =>
[end_date] =>
[recordDateTime] => 2026-09-09 17:00:50
)
[16] => Array
(
[id] => 17
[trimester] =>
[term_code] => 00A
[course_code] => DONE0000
[course_name] => Hypnotism 101
[credits] =>
[current] => n
[completed] =>
[start_date] =>
[end_date] =>
[recordDateTime] => 2026-09-09 17:00:50
)
)
TEST: fetch(PDO::FETCH_ASSOC) YU MACP program order id test
Array
(
[1] => Array
(
[id] => 1
[trimester] => 1
[term_code] => 23F
[course_code] => PSYC6104
[course_name] => A Biopsychosocial Approach to Counselling
[credits] => 4
[current] => n
[completed] => y
[start_date] => 2023-09-04
[end_date] => 2023-11-12
[recordDateTime] => 2024-12-09 10:31:33
)
[2] => Array
(
[id] => 2
[trimester] => 1
[term_code] => 23F
[course_code] => PSYC6213
[course_name] => Research Methodology
[credits] => 3
[current] => n
[completed] => y
[start_date] => 2023-11-13
[end_date] => 2023-12-17
[recordDateTime] => 2024-12-09 10:34:56
)
[3] => Array
(
[id] => 3
[trimester] => 2
[term_code] => 24W
[course_code] => PSYC6203
[course_name] => Ethical Standards for Mental Health Service Providers
[credits] => 3
[current] => n
[completed] => y
[start_date] => 2024-01-08
[end_date] => 2024-02-11
[recordDateTime] => 2024-12-09 10:36:09
)
[4] => Array
(
[id] => 4
[trimester] => 2
[term_code] => 24W
[course_code] => PSYC6153
[course_name] => Counselling Methodologies: Humanistic and Psychodynamic Modalities
[credits] => 3
[current] => n
[completed] => y
[start_date] => 2024-02-12
[end_date] => 2024-03-17
[recordDateTime] => 2024-12-09 10:40:38
)
[5] => Array
(
[id] => 5
[trimester] => 2
[term_code] => 24W
[course_code] => PSYC6163
[course_name] => Counselling Methodologies: Behavioral and Cognitive Modalities
[credits] => 3
[current] => n
[completed] => y
[start_date] => 2024-03-18
[end_date] => 2024-04-21
[recordDateTime] => 2024-12-09 10:41:17
)
[6] => Array
(
[id] => 6
[trimester] => 3
[term_code] => 25W
[course_code] => PSYC6246
[course_name] => Counselling Skills and Competencies
[credits] => 6
[current] => n
[completed] => y
[start_date] => 2025-01-06
[end_date] => 2025-03-16
[recordDateTime] => 2025-03-17 10:42:18
)
[7] => Array
(
[id] => 7
[trimester] => 3
[term_code] => 25W
[course_code] => PSYC6233
[course_name] => Assessment in Counselling
[credits] => 3
[current] => n
[completed] => y
[start_date] => 2025-03-17
[end_date] => 2025-04-20
[recordDateTime] => 2025-04-29 09:13:16
)
[8] => Array
(
[id] => 8
[trimester] => 4
[term_code] => 25SS
[course_code] => PSYC6273
[course_name] => Cultural Diversity in Counselling
[credits] => 3
[current] => n
[completed] => y
[start_date] => 2025-05-05
[end_date] => 2025-06-08
[recordDateTime] => 2025-06-10 14:14:39
)
[9] => Array
(
[id] => 9
[trimester] => 4
[term_code] => 25SS
[course_code] => PSYC6256
[course_name] => Applying Interventions
[credits] => 6
[current] => n
[completed] => y
[start_date] => 2025-06-09
[end_date] => 2025-08-17
[recordDateTime] => 2025-08-20 07:05:56
)
[10] => Array
(
[id] => 10
[trimester] => 5
[term_code] => 25F
[course_code] => PSYC6223
[course_name] => Group Counselling
[credits] => 3
[current] => n
[completed] => y
[start_date] => 2025-09-01
[end_date] => 2025-10-05
[recordDateTime] => 2025-10-08 11:37:13
)
[11] => Array
(
[id] => 11
[trimester] => 5
[term_code] => 25F
[course_code] => PSYC6263
[course_name] => Couples and Family Systems
[credits] => 3
[current] => n
[completed] => y
[start_date] => 2025-10-06
[end_date] => 2025-11-09
[recordDateTime] => 2025-11-17 10:35:15
)
[12] => Array
(
[id] => 12
[trimester] => 5
[term_code] => 25F
[course_code] => PSYC6383
[course_name] => Crisis and Trauma in Counselling
[credits] => 3
[current] => n
[completed] => y
[start_date] => 2025-11-10
[end_date] => 2025-12-14
[recordDateTime] => 2026-01-03 15:06:40
)
[13] => Array
(
[id] => 13
[trimester] => 6
[term_code] => 26W
[course_code] => PSYC7113
[course_name] => Practicum I
[credits] => 3
[current] => n
[completed] => y
[start_date] => 2026-01-05
[end_date] => 2026-04-19
[recordDateTime] => 2026-05-06 07:55:22
)
[14] => Array
(
[id] => 14
[trimester] => 7
[term_code] => 26S
[course_code] => PSYC7203
[course_name] => Practicum II
[credits] => 3
[current] => n
[completed] => n
[start_date] => 2026-05-04
[end_date] => 2026-08-16
[recordDateTime] => 2026-09-09 17:00:50
)
[15] => Array
(
[id] => 15
[trimester] =>
[term_code] => 00A
[course_code] => DONE0000
[course_name] => Answer to the Ultimate Question of Life, the Universe, and Everything
[credits] =>
[current] => n
[completed] =>
[start_date] => 2025-09-01
[end_date] => 2025-10-05
[recordDateTime] => 2025-08-25 08:18:14
)
[16] => Array
(
[id] => 16
[trimester] =>
[term_code] => 00A
[course_code] => PERS0000
[course_name] => No course: Personal
[credits] =>
[current] => y
[completed] => n
[start_date] =>
[end_date] =>
[recordDateTime] => 2026-09-09 17:00:50
)
[17] => Array
(
[id] => 17
[trimester] =>
[term_code] => 00A
[course_code] => DONE0000
[course_name] => Hypnotism 101
[credits] =>
[current] => n
[completed] =>
[start_date] =>
[end_date] =>
[recordDateTime] => 2026-09-09 17:00:50
)
)