I have looked at other sqlite issues in forum and nothing helps.
Moving a test project from local server to EXEOut and cannot get connected to the sqlite database. Here is my connect config:
<?php $storagelocation = exo_getglobalvariable('HEPubStorageLocation', ''); //$dbname = $storagelocation.'db2/salespage.sqlite3'; $dbname = $_SERVER['DOCUMENT_ROOT'].'/db2/salespage.sqlite3'; $conn = new PDO('sqlite:$dbname'); $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $query = "CREATE TABLE IF NOT EXISTS english (english_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, eng001 TEXT, eng002 TEXT, eng003 TEXT, eng004 TEXT, eng005 TEXT, eng006 TEXT, eng007 TEXT, eng008 TEXT, eng009 TEXT, eng010 TEXT, eng011 TEXT, eng012 TEXT, eng013 TEXT, eng014 TEXT, eng015 TEXT, eng016 TEXT, eng017 TEXT, eng018 TEXT, eng019 TEXT, eng020 TEXT)"; $conn->exec($query); ?>
I have the folder “db2” inside the “Data” folder which resides with the software exe.
Have even tried using the $storagelocation. just for fun and still no work.
Have both sqlite and pdo_sqlite extensions complied into the exe…
Everything works fine on local server (even tried on line server), but stumped on EXEOut.
Any input be greatly appreciated.