Check boxes

JakesSA

Ive got about 40 check boxs that need to be populated from a database.

The problem that Im having, is that these numeric values are all sitting under one column in the db. So when I populate the viewers personal details, works fine...untill I get to the check boxs... I cant seem to get the values in there.

Im useing a foreach loop to get the data


foreach($value_checkbox as $data)
{

<input type="checkbox" name="HTML" value="5"<?php if(isset
($data) && ($data == 5)) { echo 'checked'; } ?>>

}

the_Igel

you have plain html inside of php code and then one more php block inside of that html? You'd better think about what you're typing.

And, besides, that's not clear,what are you trying to do?
Why do you try to populate checkboxes with number, or whatever?
I believe that your main problem is that you haven't got the idea, what you really want.

JakesSA

I have go 40 check boxes ..... these check boxes need to be populated, when a user wants to ammend his categories that he has subscribed to.

I need to fill in these details with the corrosponding values in the database i.e

member_id category_id

3079 | 6
3079 | 13
3079 | 17
3079 | 35

member_id links to personal details(another table) & the category_id links to category name(another table).

Now, how do pull the data from a single column (i.e category_id) to fill in the check box details.

Hope this makes a bit more sence

JakesSA

I have go 40 check boxes ..... these check boxes need to be populated, when a user wants to ammend his categories that he has subscribed to.

I need to fill in these details with the corrosponding values in the database i.e

member_id category_id

3079 | 6
3079 | 13
3079 | 17
3079 | 35

member_id links to personal details(another table) & the category_id links to category name(another table).

Now, how do pull the data from a single column (i.e category_id) to fill in the check box details.

Hope this makes a bit more sence

the_Igel

Hmm...
Probably, this way:

$checks = array();
for ($i = 0; $i < NUM_OF_CATEGORIES; $i++)
   $checks[] = '';
// I believe there's a more robust way of initializing an array,
// but I'm too lazy to think of it.

$x = mysql_query(SELECT_CATEGORIES_FROM_USER);
while($r = mysql_fetch_row($x))
   $checks[$r[0]] = ' checked';
//set $checks[$i] to ' checked' if $i-th category is in the list.

for ($i = 0; $i < NUM_OF_CATEGORIES; $i++)
echo '<input type="checkbox" name="Name" value="Value"'.$checks[$i].'><br>';

HTH

JakesSA

thanks...

the problem that I was having was that I was using a foreach loop to fetch the data, but for some reason when I ran a test...it was spitting out double values.

That was all I wanted, was to see the structure of the code...

Thank you again

🙂

JakesSA

Ive tried to use your technic, but still coming short. 🙁 It brings out as many results that are in the db that are needed, but each result displays the following error:

Illegal offset type on line 34

Any idea?

Thanks in advance

the_Igel

What is line 34? And what is the type of an offset parameter in that line? think about these questions 🙂

JakesSA

That is all it said, kind of.

Warning: Illegal offset type in C:\intetpub\www\development\test.php on line 34

$checks = array();
for ($i = 0; $i < NUM_OF_CATEGORIES; $i++)
   $checks[] = '';


$x = mysql_query(SELECT_CATEGORIES_FROM_USER);
while($r = mysql_fetch_row($x))

   $checks[$r[0]] = ' checked'; //  <---error points to this value here


for ($i = 0; $i < NUM_OF_CATEGORIES; $i++)
echo '<input type="checkbox" name="Name" value="Value"'.$checks[$i].'><br>';

got any ideas

the_Igel

do
echo $r[0];
on line 33. Look what is it.
And also echo mysql_error() after the query.

Have you never before in your life debugged a script?

BTW, I hope you didn't just copy my code and run it, did you?
With all these NUM_OF_CATEGORIES and SELECT_CATEGORIES_FROM_USER...

JakesSA

is it cold where you are from?

JakesSA


$chk = array();
for($i=0; $i < 100; $i++)
 {
     $chk[]= '';
 }
if(!($result = @ mysql_query($sql1, $conn)))
    die(mysql_error());
 while($data = @ mysql_fetch_array($result))
 {
     $chk[$data] = 'checked'; //<-- error shows here here
}
 for($$i= 0; $i < 100; $i++)
 {
  echo $chk[$data] . "<br>"; // <-- just want to print see if pulling  data  through
 }

There is my source...got any ideas

the_Igel

$chk[$data] = 'checked' should be $chk[$data['id']] = 'checked'
(i.e. 'checked' is assigned to the element of $chk, index of which is the id of the option)

Not that cold now (about -10C); but it was -30C a while ago! That was cool 🙂

JakesSA

Im from africa....it gets very, very hot here... 35c here...now thats cool.

So my point is...you guys tend to do more coding then us, because we to busy frying our asses in the sun.

Thanks for the help

🙂 🙂 🙂

the_Igel

Yeah; and besides, computer produces some heat 🙂