jQuery DataTables ServerSide Processing Script Join Table

Question

我正在尝试使用 jQuery DataTables AJAX ServerSide script...

我需要将wp_usermeta表与wp_users表连接起来...

如何使用示例服务器端处理脚本联接wp_usermeta表？该脚本可在 https://datatables.net/examples/server_side/simple.html

相关代码是

$columns = array(
array( 'db' => 'user_login', 'dt' => 0 ),
array( 'db' => 'user_email', 'dt' => 1 ),
);

Answer 1

$this->datatables->select('um.*,u.*')
->from('wp_usermeta as um')
->join('wp_users as u','um.user_id=u.user_id')
->add_column('View','$1','<a href="example.php?id=$1" class="btn btn-warning view">View</button>')
echo $this->datatables->generate();