subscribers.php

<!DOCTYPE html>
<html>
<head>
    <title>Searchable Table with DataTables</title>
    <link rel="stylesheet" href="https://cdn.datatables.net/2.0.5/css/dataTables.dataTables.css" />
    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
    <script src="https://cdn.datatables.net/2.0.5/js/dataTables.js"></script>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-EVSTQN3/azprG1Anm3QDgpJLIm9Nao0Yz1ztcQTwFspd3yD65VohhpuuCOmLASjC" crossorigin="anonymous">
</head>
<body>
    <table id="example" class="table table-striped" style="width:100%">
        <thead>
            <tr>
                <th>Name</th>
                <th>Position</th>
                <th>Office</th>
                <th></th>
            </tr>
        </thead>
        <tfoot>
            <tr>
                <th>Name</th>
                <th>Position</th>
                <th>Office</th>
                <th></th>
            </tr>
        </tfoot>
    </table>
    <script>
        $(document).ready(function() {
            // Initialize DataTable
            var table = $('#example').DataTable({
                "ajax": {
                    "url": "subscribersLogic.php",
                    "dataSrc": ''
                },
                "columns": [
                    { data: "siteName" },
                    { data: "networkName" },
                    { data: "prefixName" },
                    { data: null, defaultContent: '<button id="deleteBtn">Delete!</button>' },
                    { data: null, defaultContent: '<button>Click!</button>' }   

                ]
            });

            // Event handler for button click
            $('#example').on('click', 'button#deleteBtn', function (e) {
                var data = table.row($(this).parents('tr')).data();
                var siteName = data["siteName"]
                $.post("deleteRowFromDb.php", {siteName},
                    function(data)
                    {
                    alert(data);
                    table.ajax.reload();
                    } 
                );
            });
        });
    </script>
</body>
</html>