DMXzone App Connect Support Product Page

Answered

I want to use a button to delete a record in a form or as a row on a grid.

Asked 08 May 2017 10:03:58
2
have this question
08 May 2017 10:03:58 Steven Irwin posted:
I have been trying to work this out for hours. Can you show how?

I have been looking for some way to do this like with HTML5 Data Bindings using behaviors.

Replies

Replied 09 May 2017 01:42:11
09 May 2017 01:42:11 Ben Pleysier replied:
1. Create a modal with a form that includes a text input with the ID value of the to be deleted record.
2. Link the grid delete button to the modal.

As a side note, this is a great improvement from the Data Bindings method because you can include a warning message before actually deleting the record.

Replied 09 May 2017 05:09:24
09 May 2017 05:09:24 Steven Irwin replied:
Thanks Ben, that will do it for now.
I understand DMXZone will have an AppConnect way at some time but I can't wait.

Cheers

Steve
Replied 23 May 2017 20:35:50
23 May 2017 20:35:50 manuel pinto replied:
Is there any improvements on this ... i wish to delete a record on my table using appconnect
Replied 24 May 2017 00:55:17
24 May 2017 00:55:17 Ben Pleysier replied:
Server Connect
RecordDelete
$_POST variable (e.g. deleteID)
Database Connection
Database Query - filter on $_POST variable (e.g. {{$_POST.deleteID}})
Database Delelete

Document
Within the repeat region create a form with a
hidden input for name="deleteID" with a value of the selected record ID
submit button (e.g. <button type="submit" class="text-danger"><i class="fa fa-times-circle">[/i]</button>

App Connect
action the form to RecordDelete from the Server Connect step.

As a real life illustration, my code looks like
<form action="../dmxConnect/api/Images/ImageDelete.php" method="post" class="form-horizontal" id="form" role="form" is="dmx-serverconnect-form" dmx-generator="bootstrap3" dmx-on:success="scImages.load({filter: query.id})">
<input name="deleteID" type="hidden" id="deleteID" dmx-bind:value="imageID">
<button type="submit" class="top-right text-danger"><i class="fa fa-times-circle">[/i]</button>
</form>

My code refers to deleting images (image + thumb) as well as remove the database entry
Replied 10 Aug 2017 10:11:52
10 Aug 2017 10:11:52 Teodor Kuduschiev replied:
Hello,
Along with the other video tutorials we've updated this summer, we also updated the delete record tutorial, please check it: www.dmxzone.com/go/23306/delete-database-records

Reply to this topic