PHP - Assigning values in a while loop and Accessing them individually outside the loop

Question

PLATFORM:

PHP, mySQL

WHAT I HAVE:

I have a Database table. Within my application, I am able to fetch all the rows. When I am querying the database, I have set the records fetch limit dynamically.

WHAT I AM TRYING TO DO:

I am trying to pull out all the rows of data until the record fetch limit is reached, in a loop. I want to assign these results to another array(in the loop) so that I can access these values via this new array, outside the loop. I need the PHP code to do so. I want to be able to apply the same logic of coding in Javascript. Will that be possible?

EXAMPLE:

//TABLE STRUCTURE
fname   lname    city
Ed       Al      SA
Bob     B       MN
Chris     V       KJ

PHP QUERY:

$result = mysql_query("SELECT fname, lname, city FROM table LIMIT 3");

while( $row = mysql_fetch_array($result) ) {    

        $new_rows_data['fname'] .= $row['fname'];
        $new_rows_data['lname'] .= $row['lname'];
        $new_rows_data['city']  .= $row['city'];
    }

DESIRED OUTPUT:

echo $new_rows_data['fname'][0].'   '.$new_rows_data['lname'][0].'   '.$new_rows_data['city'][0].
//Want the above to show: Ed        Al      SA
echo $new_rows_data['fname'][1].'   '.$new_rows_data['lname'][1].'   '.$new_rows_data['city'][1].
//Want the above to show: Bob       B       MN
echo $new_rows_data['fname'][2].'   '.$new_rows_data['lname'][2].'   '.$new_rows_data['city'][2].
//Want the above to show: Chris     V       KJ

Thank you in advance.

John Parker · Accepted Answer · 2010-01-09 11:58:49Z

3

If you change the PHP query bits to...

$new_rows_data['fname'][] = $row['fname'];
$new_rows_data['lname'][] = $row['lname'];
$new_rows_data['city'][]  = $row['city'];

...you should be good to go. (At the moment, you're appending the contents into a single string each time.)

Incidentally, I presume this data is 'known good', as you don't appear to be output escaping it at all. (Cross site scripting is bad, etc.)

answered Jan 9, 2010 at 11:58

John Parker

54.5k11 gold badges133 silver badges131 bronze badges

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

3 Comments

Devner Over a year ago

Thank you for the answer. Any ideas on how can I implement the same in jQuery using the $.each function?

Devner Over a year ago

@middaparka Thank you for the security alert. As I am fetching the data directly from the database, do I still need to escape it. If so, could you please tell me how? Thanks much!

John Parker Over a year ago

As a general rule, use mysql_real_escape_string when putting data into the database and htmlentities when outputting. That said, this is a deep topic - see stackoverflow.com/questions/71328/…

Community · Accepted Answer · 2017-05-23 12:18:38Z

3

Although middaparka's answer is right, be sure to first declare the individual new arrays before entering the while loop:

$result = mysql_query("SELECT fname, lname, city FROM table LIMIT 3");

$new_rows_data['fname'] = array();
$new_rows_data['lname'] = array();
$new_rows_data['city'] = array();
while( $row = mysql_fetch_array($result) ) {
    // the following (two brackets []), automatically pushes a value on the end of the array
    $new_rows_data['fname'][] = $row['fname'];
    $new_rows_data['lname'][] = $row['lname'];
    $new_rows_data['city'][]  = $row['city']
}

edited May 23, 2017 at 12:18

CommunityBot

11 silver badge

answered Jan 9, 2010 at 12:09

Decent Dabbler

22.8k11 gold badges77 silver badges107 bronze badges

1 Comment

John Parker Over a year ago

+1 He speaks the truth. Whilst PHP will let you do 'lazy initialisation', defining things prior to usage is good practice.

Collectives™ on Stack Overflow

PHP - Assigning values in a while loop and Accessing them individually outside the loop

2 Answers 2

3 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related