splitting an array with single key and string value into an array with multiple keys and values

Question

I have a table which stores the courses registered by students during a semester and session. I populated it with course-codes for a particular student. Here is the function that fetches the course-code below:

function get_course_code(){
    global $connection;

    $query = "SELECT DISTINCT course_code ";
    $query .= "FROM tbl_registered_courses_400 ";
    $query .= "WHERE matric_no = '03/55ec101' LIMIT 10";

    $course_code_set = mysql_query($query, $connection);
    confirm_query($course_code_set);
    return $course_code_set;
}

When I called the function in my main page. It returned the following result

$courseCode = get_course_code();
$courseFilter = '';
while ($courseList = mysql_fetch_array($courseCode)){
    $courseList['course_code']; 
    $courseFilter .= "\""."{$courseList['course_code']}"."\",";
    $courseFilter;
}

$course = array($courseFilter);

print_r($course);

Array ( [0] => "PHY 432","CSC 491","CHM 401","CHM 402","MAT 451","MAT 452","CSC 423","BLY 401", )

I want to split the $course array into an array that will have the values of the string in the above to read

array(
    [0] => PHY 432
    [1] => CSC 491
    [2] => CHM 401
    [3] => CHM 402
    .
    .
    .
    e.t.c
)

The string data in the $course array is from the course_code column in the database. My intention is to use the results of the new array to form a row in the database that will hold the results of each matric_no for different courses done for the semester/session. I would appreciate any help I can get to get this done.

as a side note, you should switch from mysql to mysqli or PDO as it is becoming depreciated! — mlishn
– mlishn, Commented Aug 7, 2012 at 12:19

Mihai Iorga · Accepted Answer · 2012-08-07 12:14:53Z

5

create the array and then assign the values to that array.

$courseCode = get_course_code();
$course = array();
while ($courseList = mysql_fetch_array($courseCode)){
    $course[] = $courseList['course_code'];
}

print_r($course);

answered Aug 7, 2012 at 12:14

Mihai Iorga

39.8k17 gold badges109 silver badges109 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Olotu Ayodeji Olajuwon Over a year ago

Whao...Thanks a million. I would want you to be my mentor. Wouldn't know if I can use this medium to communicate you personally?

Mihai Iorga Over a year ago

I answer here on my small spare time and, believe me, you will find very good and helping people here :). Glad I helped.

Olotu Ayodeji Olajuwon Over a year ago

Then I would be a regular visitor to StackOverFlow. Once again...Thanks a bunch!

Collectives™ on Stack Overflow

splitting an array with single key and string value into an array with multiple keys and values

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related