PHP foreach loop with sequential numbers while displaying MySQL results

Question

I have a feeling I'm going to get scolded for this but here is the question.

$seq_numbers = range('1', '24');
foreach($seq_numbers as $seq_number) 
{
    Bullet <?php echo $seq_number;?>  
    // (this successfully creates - Bullet 1, Bullet 2, etc. - 
        below is the problem.

    <?php echo $db_rs['bullet_($seqnumber)'];?>
}   // this one doesn't work.

I've tried with curly brackets {}

I basically have a few columns that are named same except for number at the end (bullet_1, bullet_2, bullet_3, etc.) and want to get the results using a loop.

The given code would probably give a syntax error. Using PHP tags withing PHP tags just makes no sense. — Deep Frozen
– Deep Frozen, Commented Jan 18, 2013 at 8:30

Till Helge · Accepted Answer · 2013-01-18 08:35:13Z

5

Your problem is, that PHP doesn't replace variables inside strings enclosed with single quotes. You need to use $db_rs["bullet_{$seq_number}"] or one of those:

<?php
foreach ($seq_numbers as $seq_number) {
   $key = 'bullet_' . $seq_number;
   echo $db_rs[$key];
}

Even shorter, but a little less clear:

<?php
foreach ($seq_numbers as $seq_number) {
   echo $db_rs['bullet_' . $seq_number];
}

An entirely different approach would be to loop over the result array. Then you don't even need $seq_numbers. Just as an afterthought.

<?php
foreach ($db_rs as $key => $value) {
   if (substr($key, 0, 7) == 'bullet_') {
      echo $value;
   }
}

Oh...and watch out for how you spell your variables. You are using $seq_number and $seqnumber.

edited Jan 18, 2013 at 8:35

answered Jan 18, 2013 at 8:29

Till Helge

9,3212 gold badges43 silver badges56 bronze badges

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

1 Comment

LITguy Over a year ago

This is a very detailed explanation. Now I completely understand it! I hate asking questions where the answer is there but I don't quite understand. Thank you! Another tool in the belt.

open source guy · Accepted Answer · 2013-01-18 08:29:23Z

1

<?php echo $db_rs['bullet_'.$seqnumber];?>

answered Jan 18, 2013 at 8:29

open source guy

2,78710 gold badges40 silver badges62 bronze badges

Comments

jmadsen · Accepted Answer · 2013-01-18 08:31:57Z

1

why not:

$db_rs['bullet_'.$seqnumber]

If not, what are your fields, and what does a var_dump of $db_rs look like?

answered Jan 18, 2013 at 8:31

jmadsen

3,6552 gold badges37 silver badges49 bronze badges

Comments

Gaurav Gandhi · Accepted Answer · 2013-01-18 08:41:17Z

0

try this...

$seq_numbers = range('1', '24');
foreach($seq_numbers as $seq_number) 
{
    Bullet <?php echo $seq_number;?>  
    // (this successfully creates - Bullet 1, Bullet 2, etc. - 
        below is the problem.

    <?php echo $db_rs["bullet_($seqnumber)"];?>
}   // now it works.

answered Jan 18, 2013 at 8:41

Gaurav Gandhi

3,2112 gold badges30 silver badges40 bronze badges

Collectives™ on Stack Overflow

PHP foreach loop with sequential numbers while displaying MySQL results

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related