Dear all,
How to update record depend on multiple autocompleter value? I have a table that will appear on autocompleter.
id_pertel | nomor | status
the status column will update to '1' if user choose nomor on autocompleter. If the only one number submitted, it will work, but if multiple number submitted, it won't work. picture on attach.
How to update record depend on multiple autocompleter value? I have a table that will appear on autocompleter.
id_pertel | nomor | status
the status column will update to '1' if user choose nomor on autocompleter. If the only one number submitted, it will work, but if multiple number submitted, it won't work. picture on attach.
Hi Yudhizth ,
You have the values that you need as a comma separated string. You will need to use Custom Code to convert that to an array of entries that you can save to separate records.
Bob
You have the values that you need as a comma separated string. You will need to use Custom Code to convert that to an array of entries that you can save to separate records.
Bob
Thank you Bob,
I solved this problem with Custom Code to update the record.
Here's the code
But, do you have any advice to convert that code into Custom Code and still using DB Save?
I solved this problem with Custom Code to update the record.
Here's the code
<?php
$user =& JFactory::getUser();
$db =& JFactory::getDBO();
$str = $form->data['nomor'];
$exp = explode(",",$str);
//$text = implode(",", $exp);
$text = "'".implode("','", $exp)."'";
$query = "UPDATE `tbl_m_pertel` AS `update` SET `status` = '1' WHERE `update`.`nomor` IN ($text)";
$db->setQuery($query); // add this line
$db->query(); // and this line
?>
But, do you have any advice to convert that code into Custom Code and still using DB Save?
Hi Yudzith,
Something like this would let you use pertel as the Model ID in a DB Save action with Multiple save enabled:
Bob
Something like this would let you use pertel as the Model ID in a DB Save action with Multiple save enabled:
<?php
$pertel = array();
$exp = explode(",", $form->data['nomor']);
foreach ( $exp as $k => $v ) {
$pertel[$k] = array( 'nomor' => $v, 'status' = 1 ):
}
$form->data['pertel'] = $pertel;
?>
Bob
Thank you Bob,
Your code is works very well for inserting data, but not works when I put the condition inside DB Save
Your code is works very well for inserting data, but not works when I put the condition inside DB Save
<?php
$str = $form->data['nomor'];
return array('nomor' => explode(",",$str));
?>
Array
(
[6] => Array
(
[DB Save] => Array
(
[Queries] => Array
(
[0] => UPDATE `tbl_m_pertel` AS `pertel` SET `nomor` = '91187', `status` = '1' WHERE `pertel`.`nomor` IN ('91187', '91185');
[1] => UPDATE `tbl_m_pertel` AS `pertel` SET `nomor` = '91185', `status` = '1' WHERE `pertel`.`nomor` IN ('91187', '91185');
)
)
)
)
One more question,
can we set a maximum record on multiple autocompleter? on my screenshot above, i put two record, can we set the maximum record to five?
can we set a maximum record on multiple autocompleter? on my screenshot above, i put two record, can we set the maximum record to five?
This topic is locked and no more replies can be posted.