The Bakery Everything CakePHP

if you get this error, it's probably because you're using 1.2.x

here's the solution.

replace the setFormTag line with this.

$this->_initInputField($fieldName);

and you're done.

with the new 1.2 multiple=>checkbox magic, the output is fairly ugly. a long list of checkboxes, no scrolling, not lined up with the other input fields, etc. here are some simple bits of code that make it much nicer looking.

in the view, add:
$html->tags['checkboxmultiplestart'] = '<div class="checkboxmultiple">';
$html->tags['checkboxmultipleend'] = '</div>'; or i guess you could use $this->HtmlHelper->tags in the controller. that will put a div wrapper around the list of checkboxes so you can format it.

then add a css blob to your css file, or inline, or whatever:
div.checkboxmultiple {
    clear: none;
    height: 6em;
    overflow: auto;
    max-width: 250px;
    border: 1px solid gray;
} of course those values might need to be tweaked for your site.

Let cake do this automatically now by adding the following code to your view:
echo $form->input('Model', array('multiple'=>'checkbox'));

I dunno but is
'checked'=>($this->data["Model"]["id"][$id] == 1 ? 'checked' : false
really OK?

If I pr($this->data), the HABTM array is like:
[Model][0][id] [Model][1][id]

In my case, list is like
$options = $this->Model1->Model->find('list');
tho.

I have a code in controller:

foreach($this->data as $user){
foreach($user['user_id'] as $userid){
// If User already assigned then Update else Insert
if($this->Project->query("SELECT id,user_id,project_id FROM tts_users_projects ProjectUser WHERE user_id = '".$userid."' AND project_id = '".$id."'")){
//$this->Project->query("UPDATE tts_users_projects SET user_id = '".$userid."' AND project_id = '".$id."' WHERE project_id = ".$id." AND user_id = ".$userid);
}else{
if (!$this->Project->query("INSERT INTO tts_users_projects(`user_id`,`project_id`) VALUES ('".$userid."','".$id."')")){
$error[] = $user; // fetch Error(s)
}
}

}
}

I dont understand why when I save data, and forexample I have checkboxes in the sequence below:
[ ] Waqar
[X] Mohsin
[X] Mubashir
[ ] Test

if i check the "Test" it will be saved, but if I check "Waqar" which is above the checked checkboxes, it doesn't save.

Any idea? Its confusing me.

I have a code in controller:

foreach($this->data as $user){
foreach($user['user_id'] as $userid){
// If User already assigned then Update else Insert
if($this->Project->query("SELECT id,user_id,project_id FROM tts_users_projects ProjectUser WHERE user_id = '".$userid."' AND project_id = '".$id."'")){
//$this->Project->query("UPDATE tts_users_projects SET user_id = '".$userid."' AND project_id = '".$id."' WHERE project_id = ".$id." AND user_id = ".$userid);
}else{
if (!$this->Project->query("INSERT INTO tts_users_projects(`user_id`,`project_id`) VALUES ('".$userid."','".$id."')")){
$error[] = $user; // fetch Error(s)
}
}

}
}

I dont understand why when I save data, and forexample I have checkboxes in the sequence below:
[ ] Waqar
[X] Mohsin
[X] Mubashir
[ ] Test

if i check the "Test" it will be saved, but if I check "Waqar" which is above the checked checkboxes, it doesn't save.

Any idea? Its confusing me.

In Cake 1.2 I find that with an options variable generated from Model->find('list'):

Controller Class:

<?php 
$options = $this->Model->find('list');
$this->set('options', $options);
?>

View Template:


<?php
foreach ($options as $id=>$label) {
    echo $form->input("Model.id.$id", 
        array(
            'label'=>$label,
            'type'=>'checkbox',
            'checked'=>($this->data["Model"]["id"][$id] == 1 ? 'checked' : false)
            )
        );
}
?>

Works fine if you'd rather not use yet another helper.

im so sorry..

previously, i was using cake 1.2.0.5875 pre-beta then i try it on cake 1.2.0.6311 beta and its working..

thanx ambiguator

i dont know is it what you really mean or not...but why did i get a selectbox when i use

View Template:


<?php echo $form->input('Post.Tag', array('type'=>'select', 'multiple'=>'checkbox', 'options'=>$tags, 'label'=>'Tags:'));?>

didn't we talk about checkbox ???


i'm sorry if i was mistaken

I just noticed that multiple checkboxes can be used inherently in the current beta version of CakePHP 1.2. It can easily be used via the following method:

View:
<?php echo $form->input('Post.Tag', array('type'=>'select', 'multiple'=>'checkbox', 'options'=>$tags, 'label'=>'Tags:'));?>

Selecting list data is a bit different in this most recent version as well.

Model:
<?php
class Tag {
    // The column value to show in SELECT OPTION's.
    var $displayField = 'name';
}
?>

Controller:
<?php
function index() {
    $this->set('tags', $this->Tag->find('list'));
}
?>


I'm sure this is my stupidity, but can some explain the reason for the hidden field before the checkboxes? I get an empty array element before the actual checkbox values when I submit the form... I've removed the code creating it, but as I'm not entirely sure why its there I thought I'd better check...
Cheers!

check php manual for array_search() -
sometimes it returns 0 - which is not false, so manually check for false

} else if (is_array($selected) && array_search($name , $selected)!==false) {

Hey guys,

If your checkboxes are being selected in wierd ways (ie: if you select 3 our of 10 at random spots, after a save error the first 3 are ticket not the ones you wanted, there is a simple solution.

Change the following line:

} else if (is_array($selected) && array_key_exists($name, 
$selected)) { 

To:

} else if (is_array($selected) && array_search($name, $selected)) {


I receive an amount of error messages equal to the amount of checkboxes it needs to show... although the checkboxes seem to be fine!

The error message is:


Notice: Uninitialized string offset: 0 in D:\TYPO3\Apache\htdocs\cake\app\views\helpers\habtm.php on line 36

EDIT: It seems I based this bug on older code... which I don't understand because I copied it just last week. Anyway, the problem I have using the code mentioned in the article is that the checkboxes don't keep their current state when the form does not validates.

This does seem to work for me:


<?php
class HabtmHelper extends HtmlHelper {
    
    /**
     * Returns a list of checkboxes.
     *
     * @param string $fieldName Name attribute of the SELECT
     * @param array $options Array of the elements (as 'value'=>'Text' pairs)
     * @param array $selected Selected checkboxes
     * @param string $inbetween String that separates the checkboxes.
     * @param array $htmlAttributes Array of HTML options
     * @param  boolean $return         Whether this method should return a value
     * @return string List of checkboxes
     */
    function checkboxMultiple($fieldName, $options, $selected = null, $inbetween = null, $htmlAttributes = null, $return = false) {
        $this->setFormTag($fieldName);
        if ($this->tagIsInvalid($this->model, $this->field)) {
            if (isset($htmlAttributes['class']) && trim($htmlAttributes['class']) != "") {
                $htmlAttributes['class'] .= ' form_error';
            } else {
                $htmlAttributes['class'] = 'form_error';
            }
        }
        if (!is_array($options)) {
            return null;
        }    
        if (!isset($selected)) {
            $selected = $this->tagValue($fieldName);
        }
        foreach($options as $name => $title) {
            $optionsHere = $htmlAttributes;
            if (($selected !== null) && ($selected == $name)) {
                $optionsHere['checked'] = 'checked';
            } else if (is_array($selected) && count($selected) >0) {
                foreach($selected as $array) {
                    if($array == $name) {
                        $optionsHere['checked'] = 'checked';
                    }
                }
            }
            $optionsHere['value'] = $name;
            $checkbox[] = "<li>" . sprintf($this->tags['checkboxmultiple'], $this->model, $this->field, $this->parseHtmlOptions($optionsHere), $title) . "</li>\n";
        }
        return "\n" . sprintf($this->tags['hiddenmultiple'], $this->model, $this->field, null, $title) . "\n<ul class=\"checkboxMultiple\">\n" . $this->output(implode($checkbox), $return) . "</ul>\n";
    }
    
}
?> 


Using 1.2.0.5427alpha I recieved Method tagValue() is deprecated in HtmlHelper: see HtmlHelper::value.

Using value insterad of tagValue seems to work great. Thanks to all for putting this together.

If we want it to work with the SecurityComponent without blackholing everything, another change is needed.

It has to use FormHelper::input .. and actually this could be done by a little hack.

$form->input('Model.field][');
By appending ][ to the end the result will be
[Model][field][] Something like we wanted all along.

I have 2 methods in my controller for binding the selected checkboxes

function _explode($model, $field)
{ return((explode(",",$this->data[$model][$field])));
}
function _populateChkBoxList($model, $field){
$tmp1=$this->_explode($model, $field);
$tmpArr=array();
foreach($tmp1 as $val){
$tmpArr[$val]=$val;
}
return $tmpArr;
}

This is working fine..

but how do i get a CSV from the add action ?

Kristoffer,

Thanks for the heads up on the changes to "model()" and "field()". Regarding the other two errors, I solved those by putting the tag definitions right at the top of the function definition for checkboxMultiple.

Like this:
function checkboxMultiple($fieldName, $options, $selected = null, $inbetween = null, $htmlAttributes = null, $return = false) {
# Tag template for an input type='hidden' tag.
$hiddenmultiple = '';

# Tag template for a input type='checkbox ' tag.
$checkboxmultiple = '%s';

$this->setFormTag($fieldName);

----------------------------------------->
I came up with this quick solution in order to get the checkboxes to recognize existing selections. In my setup cars and sites have a habtm relationship between each other.

if($this->data['Site'])
{
foreach($this->data['Site'] as $sv)
{
$selectedSites[$sv['id']] = $sv['name'];
}
}
else
{
$selectedSites = '';
}

I put that in the "edit" method of my controller. Hope that helps.

At least changeing $this->model to $this->model() and $this->field to $this->field() seems to get rid of thoses errors. I don't know if the meaning is equavilent to the old way.

But I get two other errors as well.
Notice (8): Undefined index: checkboxmultiple [CORE/app/views/helpers/habtm.php, line 51]
And:
Notice (8): Undefined index: hiddenmultiple [CORE/app/views/helpers/habtm.php, line 55]
They are not defined anywhere. I can't figure out why it works in 1.1 either. Well i solved it this way.

I added

$this->tags['checkboxmultiple'] = '%s';

AND

$this->tags['hiddenmultiple'] = '%s';

in the beginning of the code directly above $this->setForm.

Thanks for the awesome helper and detailed steps to implement it! This is totally going to save me a ton of time. I'm attempting to use this with 1.2.0.4798alpha version and I'm seeing the following error messages.I tried searching the google groups and online in general and couldn't find anyone encountering similar issues.

Notice (8): Undefined property: HabtmHelper::$model [CORE/app/views/helpers/habtm.php, line 20]
Notice (8): Undefined property: HabtmHelper::$field [CORE/app/views/helpers/habtm.php, line 20]
Any help is appreciated. Thanks again!

I've been playing around with the checkbox helper some more and getting some very odd results (using PHP 4.4.3) - basically if I attempt to save a data and it is invalid so you return to a view with the error message, the wrong checkboxes are ticked (although the $selected array is correct).

Anyway I ended up rewriting part of the function (using while instead of foreach) - I was wondering if you had any ideas what the problem was - perhaps PHP4 vs 5?
/**
* Returns a list of checkboxes.
*
* @param string $fieldName Name attribute of the SELECT
* @param array $options Array of the elements (as 'value'=>'Text' pairs)
* @param array $selected Selected checkboxes
* @param string $inbetween String that separates the checkboxes.
* @param array $htmlAttributes Array of HTML options
* @param boolean $return Whether this method should return a value
* @return string List of checkboxes
*/
function checkboxMultiple($fieldName, $options, $selected = null, $inbetween = null, $htmlAttributes = null, $return = false)
{

$this->setFormTag($fieldName);
if ($this->tagIsInvalid($this->model, $this->field))
{
if (isset($htmlAttributes['class']) && trim($htmlAttributes['class']) != "")
{
$htmlAttributes['class'] .= ' form_error';
}
else
{
$htmlAttributes['class'] = 'form_error';
}
}

if (!is_array($options))
{
return null;
}

if (!isset($selected))
{
$selected = $this->tagValue($fieldName);
}

while(list($key, $name) = each($options))
{
$optionsHere = $htmlAttributes;

if(in_array($key, $selected))
{
$optionsHere['checked'] = 'checked';
}

$optionsHere['value'] = $key;
$checkbox[] = "