.-.-.-.-.-

<?php
if (!isset($_SESSION)) {
    session_start();
    require_once 'lang.php';
}
?>
<!doctype html>
<html lang="en">

<head>
    
    <script async src="https://www.googletagmanager.com/gtag/js?id=G-1E36PCHGC7"></script>
    <script>
        window.dataLayer = window.dataLayer || [];

function gtag() {
            dataLayer.push(arguments);
        }
        gtag('js', new Date());

gtag('config', 'G-1E36PCHGC7');
    </script>
    
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <title>Die Liste</title>

<body>
    <div class="cover-container d-flex w-100 h-100 p-3 mx-auto flex-column">
        <?php
       require_once 'menu.php';
       require_once 'DAO/DBConnection.php';
       require_once 'DAO/settings.config.php';
       require_once 'DAO/suspect.php';
       $database = new DBConnection($config);
       $suspectsObj = new Suspect($database);
       $suspectsCount = $suspectsObj->getTotalSuspects();
    ?>
    </div>
    <div class="container">
        <div class="row">
            <div class="col">
                <table id="table" data-toggle="table" data-pagination="true" data-search="true" data-total-rows="<?=$suspectsCount?>"  data-ajax="ajaxRequest" data-side-pagination="server" > 
                    
                    
                    <thead>
                        <tr>
                            <th data-sortable="true" data-field="Vorname">Vorname</th>
                            <th data-sortable="true" data-field="Nachname">Nachname</th>
                            <th data-field="Titel">Titel</th>
                            <th data-sortable="true" data-field="Beruf">Beruf</th>
                            <th data-field="Strasse">Strasse</th>
                            <th data-sortable="true" data-field="PLZ">PLZ</th>
                            <th data-sortable="true" data-field="Ort">Ort</th>
                            <th data-field="Tel-Nr">Tel-Nr</th>
                            <th data-sortable="true" data-field="Kanton">Kanton</th>
                        </tr>
                    </thead>
                </table>
            </div>
        </div>
    </div>
    <script src="https://cdn.jsdelivr.net/npm/jquery/dist/jquery.min.js"></script>
    <script>
		function ajaxRequest(params) {
            var url = 'dataService.php';
            // $.post(url + '?' + $.param(params.data)).then(function(res) {
            //     params.success(res)
            //     $('#table').bootstrapTable({
            //         'load' : res
            //     })
            // })
            $.ajax({
                type: "POST",
                url: url + '?' + $.param(params.data),
                dataType:"json",
                success: function(data) {
                    console.log('data.rows = '+data.rows);
                    console.log('data.length =' + data.length );
                    console.log('data.total =' + data.total );
                    params.success({
                        "rows":data.rows,
                        "total":data.length
                    })
                },
                error: function(request, err) {
                    console.log('error = ' + err);
                    params.error(err);
                }
            });
        }
        // $(document).ready(function(){
        //     $.ajax({
        //         method: 'POST',
        //         url: 'dataService.php?search=&sort=&order=&offset=0&limit=10',
        //         dataType: 'json',
        //         success: function(data) {
        //             $('#table').bootstrapTable({
        //                 data: data
        //             });
        //         },
        //         error: function(e) {
        //             console.log(e.responseText);
        //         }
        //         });
        //     });
        $table = $('#table');
        $table.on('load-success.bs.table', function(e, data){
            console.log(data, e);
            var table = $(this).data('bootstrap.table');
            table.initData();
            table.initBody();
        });
    </script>
    <script src="https://cdn.jsdelivr.net/npm/popper.js@1.16.0/dist/umd/popper.min.js"></script>
    <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js"
        integrity="sha384-JjSmVgyd0p3pXB1rRibZUAYoIIy6OrQ6VrjIEaFf/nJGzIxFDsf4x0xIM+B07jRM" crossorigin="anonymous">
    </script>
    <script src="https://unpkg.com/bootstrap-table@1.19.0/dist/bootstrap-table.min.js"></script>
</body>

</html>

/home/wirbesti/nuernberg2punkt0.ch/src/list.php