I need to add values received from MySQL into an array (PHP). Here is what I've got:
$players = array();
while ($homePlayerRow = mysql_fetch_array($homePlayerResult)) {
$players[] = $homePlayerRow['player_id'];
}
Is this the only way of doing it?
Also, is the following faster/better?
$players = array();
while ($homePlayerRow = mysql_fetch_array($homePlayerResult)) {
array_push($players, $homePlayerRow['player_id']);
}
It depends...
Documentation says,
"If you use array_push() to add one element to the array it's better to use $array[] = because in that way there is no overhead of calling a function."
Source: https://www.php.net/array_push
So it boils down to how much data you want to cram into that array at any particular moment.
Additionally, there's a fall-back. If the array-referenced doesn't exist when you call it using array_push, you'll bump an error. If you use $array[], the array will be created for you.
$arr = array()) before using $arr[] = X. It's also useful if your $arr[] statements are inside some control logic - you still have a variable at the end, an array with no elements.
You can run it and see that array_push is slower in some cases:
http://snipplr.com/view/759/speed-test-arraypush-vs-array/
Run your code. Enjoy.
mysql_fetch_assoc. You could also usemysql_fetch_rowthen$homePlayerRow[0], which is slightly faster.