Any plans of including SQLite as an database type option in the online Generator, anytime soon?
This question has an accepted answers - jump to answer
No plans at the moment, but if there is enough demand for it I can look in to it .
My problem seems to be how to fill out the config.php and sql files which are created by the generator. I have played around with a test sqlite base called contacts.db which resides in the same folder as the initial contacts.html file.
-- Editor SQL for DB table contacts
-- Created by http://editor.datatables.net/generator
CREATE TABLE contacts (
contact_id integer PRIMARY KEY,
firstname text NOT NULL,
lastname text NOT NULL,
email text NOT NULL UNIQUE,
phone text NOT NULL UNIQUE
<?php if (!defined('DATATABLES')) exit(); // Ensure being used in DataTables env.
* DB connection script for Editor
* Created by http://editor.datatables.net/generator
// Enable error reporting for debugging (remove for production)
* Edit the following with your database connection options
$sql_details = array(
"type" => "Sqlite",
"user" => "",
"pass" => "",
"host" => "localhost",
"port" => "",
"db" => "contact.db",
"dsn" => "charset=utf8"
but it's still not showing the add, edit and delete functions.
Any suggestions appreciated.
What does it show? Can you use the debugger on the page? Any errors shown on the console?
Thanks Allan. It is not connecting to the database. Only showing this:
I think the problem is in the config.php file. I have put some dummy data in the db to test it.
What is the data that is being returned from the server to the Ajax request that Editor is making? Or are there any errors shown on the console? That would be the first place to start.
It looks like you're new here. If you want to get involved, click one of these buttons!
DataTables designed and created by SpryMedia Ltd.
SpryMedia Ltd is registered in Scotland, company no. SC456502.