I cannot get CodeIgnitor to insert into MySQL checkbox values that originate from an array. I’ve seen other similar threads, although somewhat different in many cases. I don’t even care about validation. I just want the insert to be completed.

What I’ve got is a routine PHP checkbox array in a form:

In the controller, I tried adding my old PHP “for each loop” to append the array values into a string, ending ultimately with $Request which is the name of the field in the database:

This isn’t working. I get two errors:

AND ...

It just tries to insert—> Array ... Anyone have any ideas?

It appears you’re attempting to insert the array itself instead of the values (as a comma-delimited string.)

I would suggest replacing the foreach with something like this (untested)

Update: added the else condition in case none of the checkboxes are ticked.

PHP functions serialize() and unserialize() may be of some use to you on this.

This worked, thanks.

But I also changed the name of the field in my database from “Request” to “Lead Request.”

Thanks guys, that worked really well for me too

Greetings from the 3rd World.

I’m by no means an experienced php writer or even the worse writer, as sad as it seems i’m nothing but a poser, but willing to learn.

on the past days i’ve benn struggling with something like’s described on this thread but seems that my lack of knowleadge is so great that i can’t get to understand the examples. (i’ve been searching all over the net for this answer for almost two months now.)

The Issue:
I have an Indert Record page to submit data to a MySQL database and a couple of fields have the option for the user to insert more than one value into it and i’m baking my brains off to figure out how, cos (as u all might already know very well) a regular select box or group of checkboxes only post the last value in the array selected. So i heard from a dude that the answer is an array, but the best i cud get is to post into the table the word “ARRAY” instead of my values.

This is what i’m doing (the actual table contains 32 fields to fill up, so i will post just a few, i’ll fill the blanks later)

For the HEAD tag of the PHP page:

and for the BODY:

Explanation: The selectbox named “playeras” is filled dynamically from another table from the DB (cos is very possible that the options might change on the future) and for this example that’s exactly the one i need to array so the multiple values get posted on the DB table and not just the last selected or the “ARRAY” word.

Any help for a newby?
Please?
i pay on mexican soda.

Please don’t misinterpret this as sounding unfriendly, but this forum is reserved for the discussion of PHP as it relates to the Code Igniter framework. You might have more success with general PHP questions in a news group such as comp.lang.php.

That said, your example is somewhat convoluted so my advice is to start simple. For learning and testing purposes, scale back your form to a couple of checkboxes. Once you’re able to successfully insert the array values, you can gradually add the other elements back in—performing regression testing along the way.

El Brujo - 05 February 2007 11:21 AM

i pay on mexican soda.

Do you mean the kind that comes in a bag? haha

You’ll need to either join the values into a string or store each one separately as it’s own record in a separate table. The first one is the simplest, but not the best in terms of db design.

Which ever you choose, you’ll need to rebuild your array when selecting from the db again.

Another way (in my view the most elegant) would be to work with bytes - that way you can even search for any combination of checkboxes in the database.

this is how i encode data for storage in the database:

for($i=0;$i<30;$i+=3)
{
  $options += $_POST[‘option’][$i] << $i;
}

mysql then allows you to search for records where individual bits are set.

And back to normal values:

  for($i=0; $i<30; $i+=3)
  {
      $option$i]=0;
     
      if($row[‘option’]>>$i &1)
      {
        $option[$i]=1;
      }
}
}

andreas

Bacteria Man - 05 February 2007 01:38 PM

Please don’t misinterpret this as sounding unfriendly, but this forum is reserved for the discussion of PHP as it relates to the Code Igniter framework. You might have more success with general PHP questions in a news group such as comp.lang.php.

That said, your example is somewhat convoluted so my advice is to start simple. For learning and testing purposes, scale back your form to a couple of checkboxes. Once you’re able to successfully insert the array values, you can gradually add the other elements back in—performing regression testing along the way.

Pues que fresa, no?

joeles - 05 February 2007 08:16 PM

El Brujo - 05 February 2007 11:21 AM

i pay on mexican soda.

Do you mean the kind that comes in a bag? haha

 

No, i meant the kind that is served on paper cups, lol

joeles - 05 February 2007 08:16 PM

You’ll need to either join the values into a string or store each one separately as it’s own record in a separate table. The first one is the simplest, but not the best in terms of db design.

$_POST['playeras'] = implode('|', $_POST['playeras']);

insert as usual ...

Which ever you choose, you’ll need to rebuild your array when selecting from the db again.

$row = $this->db->get('table')->row();
$row->playeras = explode('|', $row->playeras);

continue with code ...

Problem solved, not exactly with this code, but the aproaching of the problem was inspiration enough for a bit od JavaScript that closed the deal. Thanks a bunch to all that participated, even when this ain’t the right place to ask such small problems when other people have larger egos.

Thanks a bunch again.. stay tuned for your paper cups