Option value

[chinni_77]

hello,

if am using an arrays in my code, i modify my form fields(text box, check box) like this,

$cnt = count($HTTP_POST_VARS['id']);

for($cntr=0;$cntr<$cnt;$cntr++) {

<input type="text" name="ac[<?=$counter?>]" value="<?=$ac?>">

if (!$HTTP_POST_VARS['attach'][$cntr]) $attach=0; else $attach=1;

<input type="checkbox" name="is_enrolled[<?=$counter?>]" value="1"<? if ($isenrolled==1)echo "checked";?>>

BUT, how is with option box.

If it is like this for example,

<SELECT
size=1 name=brand>
<OPTION value ="0"<?php
if($brand==0){
echo 'selected';
}?>>NIKE</OPTION>
<OPTION value ="1"<?php
if($brand==1){
echo 'selected';
}?>>ADDIDAS</OPTION></SELECT>

Now, my question is , how can i modify the above option code with respect to an array.

could some body pls make the changes and present it to me.

many thanks

[jmcneese]

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10207021#post10210469

[goa103]

cnt ? cntr ? counter ? you should really try to use explicit variables names! I wonder how you can understand it 😃

you don't need to use a counter to make a variable an array, simply use:
<INPUT TYPE="text" NAME="lsMyName">
and you will have a lsMyName (list of MyName string) array when the form is submitted.

if you want to generate a combobox, you can both use an array or a DB table. most of the time I use a DB table because it's more reliable, I don't like arrays for such a task. specially because they are not meant to handle complex data: order by, insert, update... I prefer DB 😃. here is a simple example:

table brand: id PK, sValue

html/php:
<SELECT NAME="idBrand">
<OPTION SELECTED>Select a brand<OPTION>
?>

$resBrand = @ ("SELECT * FROM brand ORDER BY sValue") or die ("can't select brands from database");

while ($rowBrand = mysql_fetch_array ($resBrand))
{
?>
<OPTION VALUE="<?= $rowBrand ['id'] ?>"><?= $rowBrand ['sValue'] ?></OPTION>
<?PHP
}

?>
</SELECT>

then you have a nice ordered brand list 🙂. Notice that I used the @ operator, die function, ?><?PHP to escape from HTML instead of using the ugly echo mix up

Hope it helps!
JM

[chinni_77]

hmm...i guess i missed something before.

<?
Database connection
if ($HTTP_POST_VARS){
$cnt = count($HTTP_POST_VARS['id']);
for($cntr=0;$cntr<$cnt;$cntr++) {
if (!$HTTP_POST_VARS['attach'][$cntr]) $attach=0; else $attach=1;

UPDATE Statement;
}
}

SELECT STATEMENT
?>

Field headings
<?php

$counter=0;
$old_values=null;
while statement to get the fields
?>
//here comes my form fields

<td width="154" height="23">
<input type="text" name="tei[<?=$counter?>]" value="<?=$tei?>">
</td>
<td width="69" height="23">
<input type="checkbox" name="attach[<?=$counter?>]" value="1"<? if ($attach==1)echo "checked";?>>

<?php

$old_values.=' <input type="hidden" name="id['.$counter.']" value="'.$row->HS_ID.'">
';

$counter++;

}
?>
</table>
<?=$old_values?>
here is the submit button.

this works fine so far with all my text boxes and check boxes.

My problem is only with OPTION VALUE.

If i have a code like this for my selectable field,

<SELECT
size=1 name=type>
<OPTION value ="0"<?php
if($type==0){
echo 'selected';
}?>>Addidas</OPTION>
<OPTION value ="1"<?php
if($type==1){
echo 'selected';
}?>>GAP</OPTION></SELECT>

How should i make the changes with respect to my array?

many thanks

[goa103]

NAME=type
$type

what's the difference ? where does the $type come from ? I strongly advice you NOT TO USE reserved words like type, name... the list returns an id so idType, TypeId is a better name. I think you misunderstood the type HTML name and the type PHP variable.

Moreover you should use a loop to display your list. To avoid:
<OPTION value ="0"<?php
if($type==0){
echo 'selected';
}?>>Addidas</OPTION>
because you only Copy & Paste your code for the next index... 1... 2... use a function like:

function MyOption ($id, $type, $brand)
{
...
}

[chinni_77]

hello goa,

I'm still confused:-(

itz'nt working.No, this is my code:

<SELECT
size=1 name=mode>
<OPTION value ="0"<?php
if($mode==0){
echo 'selected';
}?>>Stimulus</OPTION>
<OPTION value ="1"<?php
if($mode==1){
echo 'selected';
}?>>GAP</OPTION></SELECT>

This i used before with out any arrays or loop, it was working fine.But, now since i am updating my fields in the table, i used the array and I'm done almost except with this OPTION field.
well, if youhave some free time then i would like to request you to have a look at my code.if yes, then pls gimmi your e-mail.

Thanks any way for your support.

[goa103]

Hi!

Okay let's forget about CODE and SCRIPT. Just explain me what you want to do and I will show you the way 🙂.

JM