I'd like users to edit form data after they have submitted it. 
Autor: Ciro S.
Visitado 1077,
Seguidores 1,
Compartilhado 0
Hi, I would like users to recall certain data they have submitted and allow them to change it without the ability to change other user's data (i.e. changing an address in their personal login page). The Database table viewer allows changes to be made to a database table, but you have to give the user access to the entire table (as opposed to only their record). Is there a way to filter only their record and seed that record into an editable form for modification (either the same form they originally submitted the data on or one that is similarly built)? If not, do you know of any websites where I can build this functionality and import into Website X5?
Publicado em
There is the "Dynamic Content" object, which allows certain users who are registered in the access management to change information on a page.
However, the data or the changed data are then only on the page, but not in the database. Would that be enough or will the data entered by users be used in the database and for other purposes?
See my test page (German) with "Dynamic Content" object
>> http://finde-links.de/123shop-hosteurope/dynamisches-objekt-2.php
...
----- Here are the input fields for the users -----
Autor
No it has to go into a database. I'm familiar with dynamic content, but this is not what I am after.
The “Dynamic Object” can also store the entered data in a database.
It depends on what you want to do with the data afterwards.
So describe what the data is used for, then the Incomedia staff or the moderators can say whether this is possible with WebSiteX5 alone or whether an external PHP script is required.
-----
Autor
Well essentially, imagine I have a user who logs in to my website. Perhaps they have entered their email address, phone number, or other information specific to them in a contact form. This information is stored in a database. Now, they want to edit their phone number. How can I set the site up to do that? The table/database viewer that is an "add-on" to website X5 seems to show all rows...not just their specific row of data. Essentially, it would be slickest to allow them to alter only their information.
You could use a tool like: AppGini https://bigprof.com/appgini/
With this tool you can have a table for which you set rights.
You can have right to edit only own records.
You can set no rights to create new records for one group and rights to create new records for another group.
If you want only one record per user, you could attach a user to a group with rights to create new records. Log in as this user and then create a record. Then attach this user to a group with rights to edit own records but not create new records.
I have an example made with AppGini here: http://eksempelsite.dk/udstillinger/Udstilling_view.php
You have the records shown ( 4 records)
Clicking on a record opens the detail view. This is where your users should edit their records.
In the example a detail table is attached/joined to the table.
Another example: http://eksempelsite.dk/biz/biz_firms_view.php
The examples is old. The has now more functionality. It is not free, but take a look at the price. I think you will find it worth the money.
You can use the software to create as many applications you wish, on as many servers you wish.
There is a kmoney-back guarantee and there is demo applications you can try online and if you try the software out, you can download a demo project and work on it by yourself.
Hello,
here a demo of free code to edit data from sql db
https://wsx5demo.afsoftware.fr/db-1.php
Could be the solution ?
Axel