Editor PHP libraries with a join
Editor PHP libraries with a join
Hello
How can i use a join with Editor PHP librairies in my php file.
I would like to use a syntaxe like this with on join between two tables.
include_once( $_SERVER['DOCUMENT_ROOT']."/php/DataTables.php" );
$countries = $db
->select( 'country', ['id as value', 'name as label'], ['continent' => $_REQUEST['values']['continent']] )
->fetchAll();
Thanks for your help.
Lionel
This discussion has been closed.
Answers
Many join examples here:
https://editor.datatables.net/examples/advanced/index.html
Take a look at the respective server scripts.
And take a look at this:
https://editor.datatables.net/manual/php/joins
Thnks for your help. I understand how i must do.
Thank you.
Lionel