Forums

Read all data and update a a field

fatih_39 19 May, 2020
Hi,
I have a problem for update a field for all record.

1-First, i can call to all record in the table.

<?php foreach($form->data['Data'] as $detail): ?> <tr>
<td><?php echo $detail['id']; ?> </td>
<td><?php echo $detail['abstract_title_tr']; ?></td>
<td><?php echo $detail['status_1']; ?></td>
<td><?php echo $detail['abstract_lang']; ?></td>
</tr>



2- but i want update abstract_lang with selectbox

<?php foreach($form->data['Data'] as $detail): ?> <tr>
<td><?php echo $detail['id']; ?> </td>
<td><?php echo $detail['abstract_title_tr']; ?></td>
<td><?php echo $detail['status_1']; ?></td>
<td><?php echo $detail['abstract_lang']; ?><select id="$detail['abstract_lang'];" name="$detail['abstract_lang'];" style="width:150px">
<option value="0"> </option>
<option value="1">English</option>
<option value="2">Spanish</option>
</select></td>
</tr>
<?php endforeach; ?>

could you help me?
fatih_39 19 May, 2020
no body help to me?

Just i want to update some data from list
Max_admin 20 May, 2020
You are building a custom HTML/PHP page here, so you will need to loop over the data when the form is submitted and save it
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
GreyHead 20 May, 2020
Hi fatih_39,

Sorry, but I don't understand what the problem is that you are having here?

And, this looks like a project better suited to ChronoConnectivity which is designed for showing and editing tables of data.

Bob
fatih_39 20 May, 2020
Thank for informaitons,

I tried to chronoconnectivity but i didnt do it,

i want to that, for example i have 4 records of table, ref no, title, status an language (look jpeg). I want to change language(with select box) when listing all data on the table.
fatih_39 23 May, 2020
Hi again, i fixed myproblem with this page, just i need a bit help. https://www.chronoengine.com/faqs/72-chronoconnectivity/ccv5/5213-direct-list-editing

i am reading and editing with text box, but how can i edit list with select box?

i can read data for status_1 but I cannot show the selection in the selection box. Always showing first options.


My field code:;
Data.status_1: <select name="Data[{Data.id}][status_1]" value={Data.status_1}> <option value="0">None </option><option value="1">Türkçe</option><option value="2">Türkçe ve İngilizce</option></select>

Could you have any idea?
Max_admin 23 May, 2020
after you change the dropdown you should click "update list", that does not work ?
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
fatih_39 01 Jun, 2020
yes its works but i want to change two arias;

when i change on Fields box: status_10 with dropdown, i want to change to status_2 too, how can i change status_2 when i change status_10?

Columns list:
Data.id: Bildiri No
Data.abstract_title_tr: Bildiri Başlığı
Data.abstract_topic: Konu
Data.status_10: Hakem Atama
_SELECTOR_: Seçim
Data.status_2: Durumu

Fields:
Data.status_10: <select name="Data[{Data.id}][status_10]" value="{Data.status_10}" style="width:100px"> <option value="0">Hakem Seçiniz</option> <option value="151">Hakem 1 - Id 151</option> <option value="152">Hakem 2 - Id 152</option> <option value="153">Hakem 3 - Id 153</option> <option value="154">Hakem 4- Id 154</option> <option value="155">Hakem 5 - Id 155</option></select>
Max_admin 08 Jun, 2020
I think that you are looking for some javascript code to change a dropdown when another one changes, you have a very old version and you need to write this small code which will work for this situation!
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
fatih_39 10 Jun, 2020
Yes right, but i couldnt find for add javascript code to where? chronoform ver 5 - chronoconnectivity ver 5



my script;

if (document.getElementById('status_3').value="Onay Bekliyor") { document.getElementById('status_4').value=="1"; }
if (document.getElementById('status_3').value="Kabul: Poster") { document.getElementById('status_4').value=="2"; }
if (document.getElementById('status_3').value="Kabul: Sözel") { document.getElementById('status_4').value=="3"; }
if (document.getElementById('status_3').value="Yazara Gönder") { document.getElementById('status_4').value=="4"; }
if (document.getElementById('status_3').value="Kabul Edilmedi") { document.getElementById('status_4').value=="5"; }
Max_admin 10 Jun, 2020
it's difficult to give help for v5 today, you can try to get it working or download the new v7 beta5 and try to remake the whole list!
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
This topic is locked and no more replies can be posted.