FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » Imported messages » comp.lang.php » Re: mysqli fetch_assoc() straight to array
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Return to the default flat view Create a new topic Submit Reply
Re: mysqli fetch_assoc() straight to array [message #186008] Fri, 30 May 2014 16:23 Go to previous message
Lew Pitcher is currently offline  Lew Pitcher
Messages: 60
Registered: April 2013
Karma:
Member
add to buddy list
ignore all messages by this user
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.

--
Lew Pitcher
"In Skills, We Trust"
PGP public key available upon request
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Re: mysqli fetch_assoc() straight to array (-> comp.lang.php)
Next Topic: ArrayAccess interface, Traversable interface and foreach
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Oct 23 22:24:31 EDT 2017

Total time taken to generate the page: 0.00653 seconds