| Re: mysqli fetch_assoc() straight to array [message #186022 is a reply to message #186013] |
Sat, 31 May 2014 14:32   |
Lew Pitcher
Messages: 60
Registered: April 2013
Karma:
|
Member |
|
|
On Friday 30 May 2014 17:36, in comp.lang.php, "richard"
<noreply(at)example(dot)com> wrote:
> On Fri, 30 May 2014 16:25:10 -0400, Lew Pitcher wrote:
>
>> On Friday 30 May 2014 16:23, in comp.lang.php, "Lew Pitcher"
>> <lew(dot)pitcher(at)digitalfreehold(dot)ca> wrote:
>>
>>>
>>> On Friday 30 May 2014 07:59, in comp.databases.mysql, "richard"
>>> <noreply(at)example(dot)com> wrote:
>>>
>>>>
>>>> Is there a way to make it simpler to just load an array based upon the
>>>> results of $row?
>>>> Rather than having to assign each individual column one at a time?
>>>
>>> /This/ is the sort of posting that I was talking about earlier.
>>>
>>> Richard, this isn't a mysql issue. Mysql does not define how PHP manages
>>> array assignments, PHP does.
>>>
>>>> $array=$row
>>>> Versus
>>>> $array[col1]=$row[col1]
>>>> $array[col2]=$row[col2]
>>>>
>>>>
>>>> while ($y<=69){
>>>> while ($n<=40){
>>>>
>>>> if ($n<10){$n="0".$n;}
>>>> $x=$y.$n;
>>>> $sql = "SELECT * FROM top20 where songs='$x'";
>>>> $result = $mysqli->query($sql);
>>>> $row = $result->fetch_assoc();
>>>>
>>>> echo $n.") ".$row['songs']."<br>";
>>>>
>>>> $n++;
>>>>
>>>> }
>>>> $n=1;
>>>> $y++;
>>>> }
>>>
>>> Followup set to comp.lang.php
>>>
>>> FWIW, PHP permits assignment of arrays, so
>>> $row = $result->fetch_assoc();
>>> $array = $row;
>>> echo $n.") ".$array['songs']."<br>";
>>> is legal PHP code.
>>
>> As is, FWIW
>> $row = $result->fetch_assoc();
>> $array[$n] = $row;
>> echo $n.") ".$array[$n]['songs']."<br>";
>>
>> Or even
>> $row[$n] = $result->fetch_assoc();
>> echo $n.") ".$row[$n]['songs']."<br>";
>
> I wasn't sure if that would work or not.
All the above suggestions work.
First off, the PHP language guarantees that they work, so they work in
principle. Secondly, I've tried them all, and they work in practice
> But I only have a few columns in the table anway so I just did the
> assignments one item at a time.
Your problem, your loss.
--
Lew Pitcher
"In Skills, We Trust"
PGP public key available upon request
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]