how to create several select drop down listbox using php

Question

I am new to php, I would like to generate the same select drop down list box. This is the code I have, but it only works for the first drop down, not for the second one...

This is the code I am using without any success :

<?php 
 while($row = mysqli_fetch_array($result))  
      {  
           $output .= '  
                <tr>  
                     <td>'.$row["id"].'</td>  
     				 <td class="last_name"  >
					 <select id="t1"><option>'.$row["t1"].'</option>';			
							 while($rowcode=mysqli_fetch_array($resulttasks))
									{ $output .= '<option value="'.$rowcode["id"].'">'.$rowcode["code"].'</option>' ; }
							 $output .='</select>
					 </td>  
					 <td class="last_name"  >
					 <select id="t2"><option>'.$row["t2"].'</option>';			
							 while($rowcode=mysqli_fetch_array($resulttasks))
									{ $output .= '<option value="'.$rowcode["id"].'">'.$rowcode["code"].'</option>'; }
							 $output .='</select>
					 </td>  
			</tr>';
?>

Thanks in advance for the help !

id="t1" ID will not repeat use different IDs or use class here. — devpro
– devpro, Commented Apr 10, 2019 at 10:36
before the second loop of "t2", try putting mysqli_data_seek($resulttasks,0); — Danish Hakim Khan
– Danish Hakim Khan, Commented Apr 10, 2019 at 10:39

Danish Hakim Khan · Accepted Answer · 2019-04-10 10:56:26Z

2

Duplicate identifiers is not the issue, before the second loop of "t2" select, try putting mysqli_data_seek($resulttasks,0);

Explanation: duplicate identifiers are only for DOM and it has nothing to do with parsing HTML in PHP. If you guys notice, he is using the same result set two times, PHP does not run another loop on same data once process already. So, we have to reset to 0th row if we want to run another loop on the same result set.

edited Apr 10, 2019 at 10:56

answered Apr 10, 2019 at 10:40

Danish Hakim Khan

2631 silver badge13 bronze badges

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

2 Comments

drb Over a year ago

Thanks a lot ! can you tell me why I have to do this ?

Danish Hakim Khan Over a year ago

You can check my comment above in the first answer, and if my solution works for you then do some favor :).

Zakaria Acharki · Accepted Answer · 2019-04-10 10:37:30Z

0

The id attribute must be unique, replace the duplicate ones by common classes :

<select id="t1">

Must be :

<select class="t1">

So when you loop through the $result you'll not generate duplicate identifiers.

answered Apr 10, 2019 at 10:37

Zakaria Acharki

67.5k15 gold badges79 silver badges106 bronze badges

5 Comments

drb Over a year ago

I think it's already unique <select id="t1"> & <select id="t2"> or am i mistaken ?

devpro Over a year ago

@drb, u are using loop

Zakaria Acharki Over a year ago

Inside a foreach, it will be duplicated if the foreach will loop 3 times we'll end up with 3 duplicate id's.

Danish Hakim Khan Over a year ago

duplicate identifiers are only for DOM and it has nothing to do with parsing HTML in PHP. If you guys notice, he is using the same result set two times, PHP does not run another loop on same data once process already. So, we have to reset to 0th row if we want to run another loop on the same result set.

Zakaria Acharki Over a year ago

Good catch @DanishHakimKhan +1

Rahul Baraiya · Accepted Answer · 2019-04-10 13:00:22Z

0

hope this helps you change your id with loop example

$index = 1;
    for($i = 0; $i < $count_array; $i ++) {
        echo '<select id="t1' . $index . '"></select>';
        $index ++;
    }

answered Apr 10, 2019 at 13:00

Rahul Baraiya

612 silver badges12 bronze badges

Collectives™ on Stack Overflow

how to create several select drop down listbox using php

3 Answers 3

2 Comments

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related