Nube: Editing contents of table

potato 13 Jan, 2009
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
GreyHead 13 Jan, 2009
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
potato 13 Jan, 2009
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,
GreyHead 13 Jan, 2009
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
Max_admin 13 Jan, 2009
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
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
potato 14 Jan, 2009
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
GreyHead 14 Jan, 2009
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
potato 14 Jan, 2009
Hi Bob,

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

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

Regards
GreyHead 14 Jan, 2009
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
    This topic is locked and no more replies can be posted.