entering names dynamically using php for loop

Question

ive got number of textboxes that will be filled in with name from database.

i create 5 textinputs, using for.. loop

for($i=1; $i<=5; $i++) {
  echo '<input type="text" value="">';
}

my question is how do i enter the names to the each textboxes dynamically.

i tried:

$q = $db->query("SELECT * FROM att WHERE id_bs_res='$id_bs_res'");  

for($i=1; $i<=5; $i++) {
    while($r = $q->fetch_assoc()) {
        echo '<input type="text" value="'.$r['att_name'].'">';
    }
}

if there are 3 names in database, it will only show 3 instead of 5 textboxes? i want it shows all the textboxes even if the rest of textboxes will be blank.

sample textboxes
1. names
2. names
3. names
4. ------
5. ------

Maxim Krizhanovsky · Accepted Answer · 2011-07-21 17:01:35Z

2

remove the inner while loop.

$q = $db->query("SELECT * FROM att WHERE id_bs_res='$id_bs_res'");  

for($i=1; $i<=5; $i++) {
    $r = $q->fetch_assoc();
    echo '<input type="text" value="'.isset($r['att_name'])?$r['att_name']:''.'">';
}

of course, better check count of the returned rows, and do not call fetch_assoc() after you've displayed the 3 rows, just output the next 2

answered Jul 21, 2011 at 17:01

Maxim Krizhanovsky

26.8k5 gold badges62 silver badges91 bronze badges

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

Comments

Chris Rasys · Accepted Answer · 2011-07-21 17:04:13Z

1

Not always a big fan of using function returns and setting a variable inside an if statement, but this should do what you want:

$q = $db->query("SELECT * FROM att WHERE id_bs_res='$id_bs_res'");  

for($i=1; $i<=5; $i++) {
    if($r = $q->fetch_assoc()) {
        echo '<input type="text" value="'.$r['att_name'].'">';
    } else {
        echo '<input type="text" value="">';
    }
}

Basically, if there's a valid row, it will echo an input box with the proper values, if there isn't it will simply echo a blank box.

answered Jul 21, 2011 at 17:04

Chris Rasys

1,33511 silver badges18 bronze badges

1 Comment

Chris Rasys Over a year ago

This is effectively the same as Darhazer's answer, just without using a ternary

Milaan · Accepted Answer · 2011-07-21 17:01:00Z

0

Maybe you can use this: http://php.net/manual/en/control-structures.foreach.php I think that solves all youre problems :) (if i'm correct)

Oh, and I don't understand youre last question? Do you want to show atleast 5 boxes, even when there are only 3 names? Or not?

answered Jul 21, 2011 at 17:01

Milaan

2435 silver badges14 bronze badges

Collectives™ on Stack Overflow

entering names dynamically using php for loop

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related