countries.php is missing from the download

olivervogt

Hi - I am trying out some functionality of the Editor - of particular interest is the example with cascading lists https://editor.datatables.net/examples/advanced/cascadingLists.html

It seems however there are (at least) two files missing from the downloads:
- cascadingLists.php (which can be copied from the example page)
- countries.php

This is the error from Chrome DevTools:
jquery-3.5.1.js:10099 POST http://192.168.100.188/EditorSamples/controllers/countries.php 404 (Not Found)

Where would I find the file?

Thanks.

allan

Hi,

Apologies for that - the cascadingLists example shouldn't actually be in the 2.0.5 release of Editor. The examples have got slightly out of sync with the demo packages there - it will be correct in 2.0.6!

In the meantime, this is the countries.php file:

<?php

// DataTables PHP library
include( "../lib/DataTables.php" );

$values = $_REQUEST['values']['team.continent'];
if (! $values) {
    echo json_encode( [] );
    return;
}

$countries = $db
    ->select( 'country', ['id as value', 'name as label'], ['continent' => $_REQUEST['values']['team.continent']] )
    ->fetchAll();

echo json_encode( [
    'options' => [
        'team.country' => $countries
    ]
] );

Allan

olivervogt

Thanks. This works well now.