Separating two arrays returned from mysqli_fetch_array

Question

I have created this

while ($data = mysqli_fetch_array($course_result, MYSQLI_ASSOC)) {
    print_r($data['course']);   
}

Which prints this:

Array ( 
     [user_id] => 57 
     [course] => 6 
)
Array ( 
     [user_id] => 57 
     [course] => 5 
)

How can I create two variables that are equal to the values of the 'course' fields. So ideally, variable x ends up equalling to 6 and variable y equals 5 (essentially what I'm asking is how to extract the value from the mysql arrays and putting it into a variable)?

Will they always be 6/5, or will it always be 1st result as x and 2nd result as y, and will there always just be 2 rows returned? — Sean
– Sean, Commented Jul 19, 2014 at 15:59
@Sean no, the value of the course field won't always be 6/5. So yes, the 1st result = x, the second equal to y. — user2379090
– user2379090, Commented Jul 19, 2014 at 16:00
So there will never be more than two results from the query? What's the likelihood of needing a 3rd, 4th and so on variable? — David Barker
– David Barker, Commented Jul 19, 2014 at 16:02
while ($data = mysqli_fetch_array($course_result, MYSQLI_ASSOC)) { if(!isset($x)){$x=$data['course']['course'];}else{$y=$data['course']['course'];} }. This assumes only 2 rows returned from your query, and that it is only called once, as once $x is set, it won't be reset, and $y would continue to be reset. — Sean
– Sean, Commented Jul 19, 2014 at 16:07

Marcin Nabiałek · Accepted Answer · 2014-07-19 16:12:03Z

2

There is no something as you called "mysql_arrays". They are normal arrays.

You can do for example:

$array = array();
while ($data = mysqli_fetch_array($course_result, MYSQLI_ASSOC)) {
   $array[] = $data; // probably this way and not $array[] = $data['course'];
}  

$x = $array[0]['course'];
$y = $array[1]['course'];

answered Jul 19, 2014 at 16:12

Marcin Nabiałek

112k43 gold badges271 silver badges299 bronze badges

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

1 Comment

bhushya Over a year ago

also there is array_column function which can help you with the above ans..check the link ..w3schools.com/php/func_array_column.asp

plaky93 · Accepted Answer · 2014-07-19 16:09:29Z

0

I would suggest you using an array instead of a variable to store the values.

$arr= array();
while ($data = mysqli_fetch_array($course_result, MYSQLI_ASSOC)) {
    $arr[] = $data['course'];
}

answered Jul 19, 2014 at 16:09

plaky93

12 bronze badges

1 Comment

Sean Over a year ago

note it should be $arr[] = $data['course']['course'] as according to the OP's code -> print_r($data['course']); returns Array ( [user_id] => 57 [course] => 6 )

David Barker · Accepted Answer · 2014-07-19 16:11:44Z

0

Speculating a bit as don't have the full picture but I guess you're after something like this.

Get an array of the courses from your data

$data = array_map(function($value) {
    return $value['course'];
}, $data);

If there are only ever two results, assign each one to a variable :

list($x, $y) = $data;

If there are more than two results, you have an array of courses in $data from your query results.

answered Jul 19, 2014 at 16:11

David Barker

14.6k3 gold badges51 silver badges77 bronze badges

Collectives™ on Stack Overflow

Separating two arrays returned from mysqli_fetch_array

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related