datatable save updates to sqlite

Site and Services
1

Hi,

This could sound funny for experts, but more than a week i am trying to understand how dataconnector works and push updates in datatable to sqlite. I read manuals, checked example, but definitely i still missing some parts. My serverside script data.php:

    $common = dirname(__FILE__);
    require_once($common."/connector/data_connector.php");
    require_once($common."/connector/db_sqlite3.php");
    $conn = new SQLite3($common.'/db.sqlite');
    $data = new JSONDataConnector($conn, "SQLite3");
    $data->render_table("atable","fid","fid,fname,flastname");

and webix part in index.html:

    webix.ui({
        view:"datatable",
        id:"grid",
        editable:true,
        autoheight:true,
        autowidth:true,
        url:"data.php",
        save:"connector->data.php",
        columns:[
            { id:"fid"},
            { id:"fname", editor:"text"},
            { id:"flastname", editor:"text"}
        ],
        url:"data.php",
        save:"connector->data.php",
        on:{"onAfterEditStop": function(id){
            webix.message("Edited");
            }
        }
    });

It successfully loads the data to datatable. I can edit it, but when i refresh the page - it remain unchanged. It means data was not send to database.

Could someone tell what i am missing here?

Thanks in advance

PetrasL

2

Bingo! found example (samples/40_serverside/03_php_custom/02_datatable_saving_rest.html) and solved!
Meanwhile there was another interesting issue. Apache (or other httpd server user) must have write permissions on folder where sqlite db is. It creates temporary files while updating tables.