Page 1 of 1

Edit one or more table fields from the TV

Posted: 2019-10-08 15:15
by gatenet
Hello team, has anyone done this? Edit one or more fields from the table view?

Re: Edit one or more table fields from the TV

Posted: 2019-10-08 16:24
by jsetzer
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

Re: Edit one or more table fields from the TV

Posted: 2019-10-08 16:55
by gatenet
Thank you for your reply my friend, can you give me a simple example?

Re: Edit one or more table fields from the TV

Posted: 2019-10-08 17:46
by jsetzer
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