数据表，在数据集中添加另一列，但不在表中显示

我的数据库中有一个表格，我想在中显示内容datatable。该表有3列id, name and datecreated。我希望用户能够通过单击delete button每行中的来从此表中删除行，因此其图形表示如下

|name |title| date|Delete Button|

在我像这样设置内容之前datatable，只需拉动数据库中的所有行并iterating遍历它们，就可以在其中加载数据

                       <table id="example23" class="display nowrap table table-hover table-striped table-bordered" cellspacing="0" width="100%">
                         <thead>
                            <tr>
                            <th>Name</th>
                            <th>Delete</th>
                            </tr>
                            </thead>

                            <tfoot>
                            <tr>
                            <th>Name</th>
                            <th>Delete</th>
                            </tr>
                            </tfoot>
                            <?php foreach ($messages as $message) {?>
                             <tr class="info">
                            <td><?php echo  $message['name']; ?> </td>
                            <td> <?php echo date('d-M-Y', strtotime($message['datecreated'])); ?></td>
                             <td><a href="<?php echo  $_SERVER['PHP_SELF'].'?delete='.$message['id']; ?>"
                            <form   method="get">
                            <button class="btn btn-success btn-rounded" type="button" type="submit" name="submit">DELETE</button>
                            </form>
                            </td> 
                            </tr>
                            <?php } ?>
                        </table>

这很容易，但是加班时间我发现它对1000多个行不利，它的表现确实很差，所以我决定switch to server side processing使用Ajax发出这样的请求

('#example123').DataTable({   
  "bProcessing": true,
     "ajax":{
        url :"../public/messages", 
        type: "POST",  
       error: function(xhr, status, error) {
          console.log('Error::'+xhr.responseText);
           $('#loader').hide();
        },

        beforeSend: function(){
            $('#loader').show();
        },
        complete: function(){
            $('#loader').hide();
        }
      },

用我的后端设置

   public function fetchMessages($draw, $start, $length, $query, $orderColumn, $orderDir){

//*getting total number records without any search
$sql = "SELECT id, name, datecreated from messages";
$stmt = $this->conn->prepare($sql);
$stmt->execute();
$stmt->store_result();
$totalData = $stmt->affected_rows;
$totalFiltered = $totalData; 

//*Search
$sql = "SELECT id, name, datecreated from messages";
if(!empty($query)) {
    $query = "%{$query}%";  
    $sql.=" WHERE name LIKE ? )";

$stmt = $this->conn->prepare($sql);
$stmt->bind_param("sss", $query, $query, $query);
}
$stmt->execute();
$stmt->store_result();
$totalFiltered = $stmt->affected_rows;


$sql.=" ORDER BY ". $orderColumn."   ".$orderDir."  LIMIT ".$start." ,".$length."  ORDER BY e.datecreated DESC";   
$stmt->execute();
$events = array();
$stmt->bind_result($id, $name, $datecreated);



    while($stmt->fetch()) 
    {
        $message = array();
        //$message[] = $id; Once I include id, it goes into the name column and the name goes into the datecreated column
        $message[] = $name; 
        $message[] = $datecreated; 
        $messages[] =  $message;

    }

 $json_data = array(
        "draw"            => intval($draw),
        "recordsTotal"    => intval($totalData), 
        "recordsFiltered" => intval($totalFiltered),
        "data"            => $messages 
        );   

return $json_data;
}

这样就可以加载数据了。我的问题与第一个解决方案不同，在第一个解决方案中，我使用ID删除了该表中没有ID的内容，当我ID在其中包含json要替换name和name替换的那一刻datecreated。我一直在寻找一种方法，可以将其包括ID在data尚未隐藏的地方，并使用与本官方数据表教程中所使用的类似的逻辑来获取ID并使用其删除所需的行。