loop and array receive datas from database

Question

I recovered some information from my database and then I turn into the array using:

<?php $clients = explode(",",$data['comptes']) ; ?>

<?php $clients = explode(",",$data['comptes']) ;
    for ( $i = 0; $i < count( $clients ); $i++ ) { 
 echo '<option value="'.trim($clients[$i]).',">'.trim($clients[$i]).'</option>'; 
} ?>

I would then display all in a selection list.

Before the whole table is not empty, it displays a print_r():

Array (
    [0] => 1566 
    [1] => 1599 
    [2] =>
)

Then for the selection list so I'm doing following code:

but yet it does not return me the last selection list is empty, I do not see where I made my mistake because I have no error messages.

Your question seems to be a bit all over the place. Have you remembered a starting <select> and finishing </select>. And did you say you'd checked that clients had things in> — Pippa Rose Smith
– Pippa Rose Smith, Commented Aug 23, 2012 at 15:14
Why do you call $clients = explode(",",$data['comptes']) ; twice? — Matt
– Matt, Commented Aug 23, 2012 at 15:16
You shouldn't use count($clients) in your for loop definition. You're essentially calling that function each time you iterate. Instead, set its value to a variable, and use the variable. — Matt
– Matt, Commented Aug 23, 2012 at 15:17
It's very likely @PippaRoseSmith is right. Most browsers don't render orphan option elements — Elias Van Ootegem
– Elias Van Ootegem, Commented Aug 23, 2012 at 15:18
I did not called twice someone of staff edi my post. first I show how I get datas. — Stanislas Piotrowski
– Stanislas Piotrowski, Commented Aug 23, 2012 at 15:26

Pippa Rose Smith · Accepted Answer · 2012-08-23 15:36:12Z

1

<?php 
    $clients = explode(",",$data['comptes']) ;

    echo '<select id="selectboxname" name="selectboxname">';

    for ( $i = 0; $i < count( $clients ) - 1; $i++ ) 
    { 
        echo '<option value="'.trim($clients[$i]).',">'.trim($clients[$i]).'</option>'; 
    } 

    echo '</select>';
?>

Make sure you have

<select> </select>

round your options.

edited Aug 23, 2012 at 15:36

answered Aug 23, 2012 at 15:21

Pippa Rose Smith

1,3965 gold badges19 silver badges42 bronze badges

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

12 Comments

Stanislas Piotrowski Over a year ago

this code display to me that <select><option value=","></option></select>

Stanislas Piotrowski Over a year ago

yes I have select /select in fact the entirely code I use is the following: <select name="selection[]" size="15" id="selection" multiple class="multiple" OnDblClick="javascript:selection_champs(this.form.selection,this.form.liste_champs);listbox_selectall('selection', true);"><?php $clients = explode(",", trim($data['comptes'], ',')); for ( $i = 0; $i < count( $clients ); $i++ ) { echo '<option value="'.trim($clients[$i]).',">'.trim($clients[$i]).'</option>'; } ?> </select>

Pippa Rose Smith Over a year ago

Array position 2 doesn't seem to have a value in it. Should it have? And can you post what $data['comptes'] is? If you have put a , at the end of the string, it might be creating a final array position

Stanislas Piotrowski Over a year ago

it is because of the extra coma, I've change this now there is no more second position in aray for rhis code

Pippa Rose Smith Over a year ago

Excellent, glad you sorted it :)

|

Tchoupi · Accepted Answer · 2012-08-23 15:18:45Z

1

I am really guessing, but you probably have an extra comma in $data['comptes']. Try

$clients = explode(",", trim($data['comptes'], ','));

answered Aug 23, 2012 at 15:18

Tchoupi

14.7k5 gold badges39 silver badges71 bronze badges

1 Comment

Stanislas Piotrowski Over a year ago

I've changed the code for this it still does not work I have no error messages

Collectives™ on Stack Overflow

loop and array receive datas from database

2 Answers 2

12 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

12 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related