Forums

I build a form, data is sending to the mysql database everything works fine but when I click show data I just see a view of the data, I can not edit it.

please advice how to edit and update data sent by chronoform to mysql, is there a good tutorial about this.



thank you,

bora.

Hi bora,

There are many ways of doing this. If you just need to make the occasional change then you can do it with PHPMyAdmin or another MySQL tool. If you need to make frequent changes then the usual method is to re-display the data in the form and edit it there.

Bob

Hi GreyHead,

I need frequent changes so phpmyadmin is not the best tool.

is there not a quick dirty way to transform the show_data.php to show our data in text boxes so that we can update it with a submit button from the show_data.php

is this possible ??

Hi bora,

Not at present. There was in CFv3 I think but the editor wasn't reliable. In ChronoForms the solution is to use you form, or a copy of it, to re-display the data.

If PHPMyAdmin is too remote, try AceSQL - it's a port of EasySQL to Joomla! 2.5 and is quite a nice little MySQL tool that you can run from the site Admin.

Bob

PS Personally I use MySQL WorkBench - a very nice desktop tool that will work with your site - provided that your host allows remote access to the database.

If i use any SQL browser, then there is no drop down field for different records, but my form has them.

If you need to make frequent changes then the usual method is to re-display the data in the form and edit it there.
Bob

This sounds good. What is there an already comfortable way to do this or do i need to program it from scratch?

Hi Montezuma,

Assuming that you used a form to create the data then use a copy of it as an editor and use the DB Record Loader action to re-load the data.

Bob