SweetAlert delete confirmation of table row only deletes the last row

Question

I have an HTML table with rows containing data from my SQL database, with the table body being under a for loop to display the fetchall rows. Before deleting the specific row, I want a SweetAlert to pop up for confirmation. However, it only deletes the last row instead of the row I want?

Here is my HTML table:


    
        {% for address in addressInfo %}
            
        {% endfor %}
        
        
            
                Recipient Name
                Contact number
                Street name
                Category
                Actions
            
        
        
                
                    {% if address.15 == 1 %}
                    Default
                    

                    {{address.3}}
                    {% else %}
                    {{address.3}}
                    {% endif %}
                
                
                    {{address.11}}
                
                
                    {{address.8}}
                
                
                    {{address.12}}

Here is my javascript:

$(".btn-delete-address").click(function() {
        event.preventDefault();
        swal({
            icon: "warning",
            title: "Delete address",
            text: "Do you wish to delete this address? You cannot recover this address once deleted.",
            type: "warning",
            buttons: {
                confirm: {
                    text: "Delete",
                    className: "btn btn-success"
                },
                cancel: {
                    visible: true,
                    className: "btn btn-danger",
                },
            },
        }).then((deleteValue) => {
            if (deleteValue) {
                $(".form-delete-address").submit();
            };
        });
    });

Here is my python code for SQL query:

@homepage.route('/deleteBuyerAddress/', methods=['GET', 'POST'])
def deleteBuyerAddress(addressBookID):
    if request.method=='POST':
        conn = get_db_connection()
        if conn is None:
            flash("NO DB CONNECTION", category='error')
            return redirect(url_for('homepage.home'))
        
        cursor = conn.cursor()

        try:
            cursor.execute("DELETE FROM address_book WHERE accountID=%s and addressBookID=%s", (session['accountID'], addressBookID))
            conn.commit()
            flash("Successfully deleted address!", category='success')
            return redirect(url_for('homepage.addressBook'))
        except Error as e:
            conn.rollback()
            flash(f"{e}", category='errpr')
            return redirect(url_for('homepage.addressBook'))
        finally:
            cursor.close()
            conn.close()

I've already gone from using IDs to classes, but it still doesn't work. However, when I omit SweetAlert, like I just go straight to submitting the form and not even bother showing the pop-up, it works properly. What goes wrong?

SweetAlert delete confirmation of table row only deletes the last row

Answers (1)

Related Questions