Answers

• allan Posts: 61,972Questions: 1Answers: 10,160 Site admin

  September 2017

  No plans at the moment, but if there is enough demand for it I can look in to it .

  Allan
• mccloud Posts: 35Questions: 15Answers: 2

  September 2017

  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.

  table.contacts.sql

  -- 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
  ); 
  

  and config.php

  <?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)
  error_reporting(E_ALL);
  ini_set('display_errors', '1');
  
  /*
   * 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.
• allan Posts: 61,972Questions: 1Answers: 10,160 Site admin

  September 2017

  What does it show? Can you use the debugger on the page? Any errors shown on the console?

  Allan
• mccloud Posts: 35Questions: 15Answers: 2

  September 2017 edited September 2017

  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.

  DataTables Editor contacts.png 13.5K
• allan Posts: 61,972Questions: 1Answers: 10,160 Site admin

  September 2017 Answer ✓

  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.

  Allan