Edit one or more table fields from the TV

Got something cool to share with AppGini users? Feel free to post it here!
Post Reply
gatenet
Veteran Member
Posts: 45
Joined: 2016-07-26 09:34
Location: Greece
Contact:

Edit one or more table fields from the TV

Post by gatenet » 2019-10-08 15:15

Hello team, has anyone done this? Edit one or more fields from the table view?

User avatar
jsetzer
AppGini Super Hero
AppGini Super Hero
Posts: 1807
Joined: 2018-07-06 06:03
Location: Kiel, Germany
Contact:

Re: Edit one or more table fields from the TV

Post by jsetzer » 2019-10-08 16:24

Yes, have a look at HTML's content editable attributes. And you will need AJAX on client-side (browser) to send edited values and some PHP on server-side to retrieve the new values, check permissions and store the data.

Best,
Jan
Kind regards,
<js />

My AppGini Blog:
https://appgini.bizzworxx.de/blog

You can help us helping you:
Please always put code fragments inside [code]...[/code] blocks for better readability

AppGini 24.10 Revision 1579 + all AppGini Helper tools

gatenet
Veteran Member
Posts: 45
Joined: 2016-07-26 09:34
Location: Greece
Contact:

Re: Edit one or more table fields from the TV

Post by gatenet » 2019-10-08 16:55

Thank you for your reply my friend, can you give me a simple example?

User avatar
jsetzer
AppGini Super Hero
AppGini Super Hero
Posts: 1807
Joined: 2018-07-06 06:03
Location: Kiel, Germany
Contact:

Re: Edit one or more table fields from the TV

Post by jsetzer » 2019-10-08 17:46

Final result:
<img src="PATH_TO_IMAGE" />

Use the concat function of SQL to concatenate the first part + the image path + the last part.

Something like concat( '<img src="', imagepathfieldname, '" />')

Sorry, I'm on holiday and typing on the phone. There may be typos, but it should poibt you into a good direction.

Be careful with single and double qoutes as they have a special meaning in SQL.

Hope this helps!
Best,
Jan
Kind regards,
<js />

My AppGini Blog:
https://appgini.bizzworxx.de/blog

You can help us helping you:
Please always put code fragments inside [code]...[/code] blocks for better readability

AppGini 24.10 Revision 1579 + all AppGini Helper tools

Post Reply