Nube: Editing contents of table

Hi all,

I've been looking at chronoforms for data entry into a database table, and chronoconnectivity to view the contents of a database table.
But how would I go about editing the contents of the data entered into a database table.
Is there a way of doing this?.

Regards

Hi potato,

I think that you can edit in the back-end of ChronoConnectivity.

Or, the EasySQL extension will let you do pretty much anything with a database.

Bob

Hi Bob,

Thanks for the reply,

>I think that you can edit in the back-end of ChronoConnectivity

Does this mean that there is not a way of displaying the table data and allowing a user to edit the data, without using a back end non user friendly way to achieve this? , I'm confused.

I want to be able to present the user with the ability to enter a load of data, but then go back and view and edit this data if required, but in a user friendly
way, i.e. on some kind of form, like the chrono forms.

>... the EasySQL extension will let you do pretty much anything with a database.

Will the 'EasySQL extension' help me provide the user with an interface to achieve the above?, if so where can I get this (Joomlaextension.com?)

Thanks,

Hi potato,

Sorry, you didn't mention users so I assumed that you were talking about admins.

If you want front-side editing then use a ChronoForms form and set the field values from the database table.

Bob

Hi potato,

each user will have how many records ? is there a field in your table to tell which user's record is this ?

Cheers
Max

Hi Max,

>each user will have how many records ? is there a field in your table to tell which user's record is this ?

There will be a single, psuedo admin person, who will enter data that needs to end up in the mysql database. There will be lots of tables structures (say 10 of),each with each structure holding maybe up to a hundred row entries.

We want to allow the psuedo admin person to be able to enter the data, and edit it, but be presnted with a GUI (form) that allows him/her to do this.

Other users will simply be presented with this data, and won't be allowed to edit it.

Regards

Hi Potato,

I'm sure that you can do this with a ChronoForm to give the GUI, it's quite possible to limit forms to certain users or user groups. You'd need to add logic in the ChronoForm to look up user data on one page and then redisplay the data in an editable form on a second page. This is the functionality that is standard in most of the Joomla admin pages.

Bob

Hi Bob,

>...redisplay the data in an editable form on a second page.

Sounds good, but how would I go about doing this?

Regards

Hi Potato,

Simple version:[list]

create Form A which is a 'manager view' and just has a series of links or buttons that say Edit Table XXX and link to form XXX

create Form XXX which displays a list of entries from Table XXX each with a link saying Edit Entry 999

Form XXX_999 which gets the info for entry XXX_999 and displays it in a form for editing.

[/list]In practice you use php in the form html to do the heavy lifting for you and display the appropriate results depending on the values in the calling url.

Bob

Hi Potato,

Bob is talking about the way to do this in Chronoforms, there is another way in ChronoConnectivity with less coding, read the ChronoConnectivity tutorial here:
http://www.chronoengine.com/tutorials/18-tutorials/40-chronoconnectivity-tutorial-1.html

cheers
Max