Databases
StackOverflow2013
Postsdbo
POJoomla 1.7 multiple SQL list is not preselected on edit
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POJoomla 1.7 multiple SQL list is not preselected on edit
    primarykey
    data
    text
    <p>In my joomla custom component I used the SQL field type (item.xml):</p> <pre><code> &lt;field name="colors" type="sql" query="SELECT id ,name FROM #__products_colors" multiple="multiple" key_field="id" value_field="name" class="inputbox" label="colors" description="COM_PRODUCTS_FORM_DESC_ITEM_COLORS" /&gt; </code></pre> <p>In my view I call the field like this:</p> <pre><code>&lt;?php echo $this-&gt;form-&gt;getInput('colors'); ?&gt; </code></pre> <p>Which gives me a nice and smooth selectbox like this:</p> <pre><code>&lt;select id="jform_colors" class="inputbox" multiple="multiple" name="jform[colors][]" aria-invalid="false"&gt; &lt;option value="1"&gt;blue&lt;/option&gt; &lt;option value="2"&gt;yellow&lt;/option&gt; &lt;option value="3"&gt;red&lt;/option&gt; &lt;option value="4"&gt;green&lt;/option&gt; &lt;option value="5"&gt;purple&lt;/option&gt; </code></pre> <p> When I save this colors field, after selecting blue and red for example it gets saved as 1,3 in my database. Joomla does all the work for me... (THANKS Joomla) </p> <p>Now maybe I am getting greedy, but somehow I expect Joomla to preselect these values for me when I edit an entry after saving. It does this with every other type of field, so why not here? Is there anything Im forgetting?</p> <p>Thanks in adv!</p> <p>edit: the bind function in the answer, I tweaked it a bit.</p> <pre><code> public function bind($array, $ignore = '') { if (isset($array['params']) &amp;&amp; is_array($array['params'])) { $registry = new JRegistry(); $registry-&gt;loadArray($array['params']); $array['params'] = (string) $registry; } //print_r($array); if (key_exists('colors', $array) &amp;&amp; is_array($array['colors'])) { echo "pwn"; $array['colors'] = implode(',', $array['colors']); } if (isset($array['metadata']) &amp;&amp; is_array($array['metadata'])) { $registry = new JRegistry(); $registry-&gt;loadArray($array['metadata']); $array['metadata'] = (string) $registry; } return parent::bind($array, $ignore); } </code></pre> <p>And DONT use filter="safehtml" :)</p> <p>Good luck all!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USHans Wassink
    1. USHans Wassink
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POJoomla 1.7 multiple SQL list is not preselected on edit
      1. USHans Wassink
      1. VTBountyStart
    2. VO
      singulars
      1. POJoomla 1.7 multiple SQL list is not preselected on edit
      1. This table or related slice is empty.
      1. VTUpMod
    1. COCan you show the php code, where you are getting the form?
      singulars
      1. POJoomla 1.7 multiple SQL list is not preselected on edit
      1. USGaurav
    2. COUh, well yes, most of it is there <?php echo $this->form->getInput('colors'); ?> surrounded by form like so :<form action="<?php echo JRoute::_('index.php?option=com_products&layout=edit&id=' . (int) $this->item->id); ?>" method="post" name="adminForm" id="item-form" class="form-validate"> </form>
      singulars
      1. POJoomla 1.7 multiple SQL list is not preselected on edit
      1. USHans Wassink
    3. COCan you the code of module? how are you getting form object?
      singulars
      1. POJoomla 1.7 multiple SQL list is not preselected on edit
      1. USGaurav
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload