field type sql, but checkboxes instead of dropdown list?

[rockuman_ex]

Hi,

I'm developing a custom component, my question is:

Is there away to create checkboxes based on sql?

eg:

Code: Select all

<field name="category_id" type="sql" class="inputbox"
			 query="SELECT id, title FROM #__mycomp_category order by title asc" 
			 key_field="id" 
			 value_field="title"
			filter="safehtml" />

From the above, i will get a drop down list, but how do make it as checkboxes?
eg:
[] Category 1
[] Category 2
[] etc...


Help?

[rockuman_ex]

I got it.

I have to create custom_fields

Now that i have created the custom fields, how do i capture the checkboxes values and store it as 1,3,4 etc?

I have created a new file in
\administrator\components\com_mycomp\models\fields\CategoryCheckBoses.php

and inside this file i have:

Code: Select all

<?php
defined('JPATH_BASE') or die;

jimport('joomla.html.html');
jimport('joomla.form.formfield');

class JFormFieldCategoryCheckBoxes extends JFormField
{
	protected $type = 'checkboxes';
	protected function getInput()
	{
		//Get form details
		$db =& JFactory::getDBO();
		$query = "SELECT id, title FROM #__copmitips_category WHERE state = 1 ORDER BY title";
		$db->setQuery($query);
		$categories = $db->loadObjectList();
		$var_list ='';
		foreach($categories as $category){
			$var_list.= '<input name="'.$this->name.'" type="checkbox" value="'.$category->id.'">'.$category->title.'<br />';
		}
		return $var_list;
	}
}

When i checked multiple check boxes, the only value that were captured is the last checkbox.

And this is my xml file:

Code: Select all

<field name="category_id" type="CategoryCheckBoxes" required="true" />

And how do i make the checkboxes ticked when it's being edited?

Thank you[Mod Note: Bump post by you deleted. Please do not bump your messages. Read the Forum Rules for full details.

[humvee]

[Mod note: Moved from General Forum to 2.5 coding Forum;]

[rockuman_ex]

[Mod note: Moved from General Forum to 2.5 coding Forum;]

thank you.

Didn't know where to post. Sorry newbie here.

Can anyone please guide me to the right direction?

[Webdongle]

http://docs.joomla.org/Standard_form_field_types

Check box (singular) http://docs.joomla.org/Checkbox_form_field_type

Check boxes (plural) http://docs.joomla.org/Checkboxes_form_field_type

You may prefer radio buttons http://docs.joomla.org/Radio_form_field_type

[rockuman_ex]

webdongle, thank you.

This is what i've done.
on my /administrator/components/com_mycomp/models/fields/CategoryCheckBoxes.php

Code: Select all

class JFormFieldCategoryCheckBoxes extends JFormField
{
	protected $type = 'checkboxes';
	protected function getInput()
	{
		$db =& JFactory::getDBO();
		$query = "SELECT id, title FROM #__copmitips_category WHERE state = 1 ORDER BY title";
		$db->setQuery($query);
		$categories = $db->loadObjectList();
		$var_list ='';
		foreach($categories as $category){
			$var_list.= '<li><input name="'.$this->name.'[]" type="checkbox" value="'.$category->id.'"><label for="jform_category_id'.$category->id.'">'.$category->title.'</label></li>';
		}
		return '<fieldset id="jform_category_id" class="checkboxes"><ul>'.$var_list.'</ul></fieldset>';
	}
}

On my administrator/components/com_mycomp/models/forms/item.xml

Code: Select all

<field name="category_id" type="CategoryCheckBoxes" required="true" />

then on my administrator/components/com_mycomp/tables/item.php

Code: Select all

public function bind($array, $ignore = '')
	{
		if (isset($array['category_id']) && is_array($array['category_id'])) {
			$array['category_id'] = implode(',', $array['category_id']);
		}
		return parent::bind($array, $ignore);
	}

I can save the value no problem (eg. 1,2,3)

But when I'm editing the form, the checkboxes aren't ticked.

Where do I make it ticked?

I'm stuck... please help.

[Webdongle]

Best guess

You are using 'CheckBoxes' (plural) not 'CheckBox' (singular)

The checkboxes form field type provides a multiple checkboxes. Unlike most used standard form field types like textfield or checkbox, this field is not "out of the box" solution. It will create checkboxes for you, and submit their values in form of an array, but it will not store them in database.

http://docs.joomla.org/Checkboxes_form_field_type

<field name="mycheckbox" type="checkbox" label="Show title" description="" value="1" />

http://docs.joomla.org/Checkbox_form_field_type

[rockuman_ex]

Webdongle, once again thank you.

yes, i'm wanting to have checkboxes, so user can select multiple options.

I can save the values no problem (eg. as 2,4,5) etc.

The problem is, when i go to edit page, the checkboxes aren't ticked (when it was already ticked). See attached image.

Untitled-1.jpg

I'm using a custom field (please see my previous post for my code).

Any idea?

[Webdongle]

Best guess
value="1"

But like the wiki said 'It will create checkboxes for you, and submit their values in form of an array, but it will not store them in database'

Not used checkboxes only checkbox and radio buttons sorry. Can only point you to the documentation on this one.

[rockuman_ex]

Best guess
value="1"

But like the wiki said 'It will create checkboxes for you, and submit their values in form of an array, but it will not store them in database'

Not used checkboxes only checkbox and radio buttons sorry. Can only point you to the documentation on this one.

I can save the values into the database by adding the following code into the bind function

Code: Select all

 if (isset($array['category_id']) && is_array($array['category_id'])) {
         $array['category_id'] = implode(',', $array['category_id']);
      }
      return parent::bind($array, $ignore);

My problem is to retrieve the values, and make the checkboxes ticked when you are editing the data.

[rockuman_ex]

OMG...

SILLY ME!
To get the value -> $this->value

ARRGGHHHH!!!

SOLVED!

[joomlyste]

hello
I'm newbie
I have the same problem when I edit the recording?
how you retrieve the value checked?
thank you in advance
(Excuse my english)

[joomlyste]

hello
I add the variable $ checked with a function to evaluate the recover $ this-> value (array) and I did call to getValues ​​()
//
foreach ($ categories as $ category) {
$ checked = $ this-> getValues ​​($ category-> id);
$ var_list. = '<input <li> name="'.$this-> name. [] "type =" checkbox "
value = "'. $ category-> id.'" '. $ checked. '>
<label for="jform_category_id'.$category-> id. '">'. $ category-> title. '</ label> </ li>';
}
return '<fieldset id="jform_category_id" class="checkboxes"> <ul>'. $ var_list. '</ ul> </ fieldset>';
}
protected function getValues ​​($ categoryid) {
$ categoryid = (int) $ categoryid;
foreach ($ this-> value as $ values)
{
if ($ categoryid == $ values​​) {
$ checked = 'checked = "checked"';
}

}
return $ checked;
}

[oorzaak]

So glad with people like you who share their knowledge. Thanks!

Frits

[jaimeu]

the getValues function you're gonna want is actually this

Code: Select all

protected function getValues($catId, $values){
    $checked = '';
    $values = explode(',', $values);
    if(in_array($catId, $values)){
      $checked = 'checked="checked"';
    }
    return $checked;
}

and you want to call it in getInput() function like so

Code: Select all

$checked = $this->getValues($category->id, $this->value);

then lastly just drop it into the input as $checked

My first coding contribution to the Joomla Forum, yay.