Info sqlite-remote (npm) npm install tb-sqlite-remote or npm install tb-sqlite-remote --legacy-peer-deps

Makes sqlite3 tables and queries useable in react.

Get started

Setup

const ExecQuery = require('tb-sqlite-remote');

const {ExecQuery, UrlQuery, ScriptQuery, TableShow} = require('tb-sqlite-remote')

const dbserver = "http://localhost/jsonengine.php"; default server.

or

upload : jsonengine.php : chmod 777

const dbserver = "http://yourhost/yourfolder/jsonengine.php";

Create a table

var queryCreate = await ExecQuery("single", "CREATE TABLE Pages (ID INTEGER PRIMARY KEY, Title TEXT, Html TEXT)", "react","react", dbserver);

Insert element

var queryInsert = await ExecQuery("single", "INSERT INTO Pages (Title, Html) VALUES ('', '')", "react","react", dbserver);

Edit an element

var queryUpdate = await ExecQuery("single", "UPDATE Pages SET Title = 'aa' WHERE ID == 1", "react","react", dbserver);

var querySingle = await ExecQuery("single", "SELECT Title From Pages WHERE ID == 1", "react","react", dbserver);

var queryresp = await ExecQuery("", "SELECT * From Pages", "react","react", dbserver);

please use an async function running the queries

Examples

//ExecQuery("single/array/empty", "DBQuery", "username", "password", "optional server address")

async function runquerys() {
	var queryCreate = await ExecQuery("", "CREATE TABLE Pages (ID INTEGER PRIMARY KEY, Title TEXT, Html TEXT)", "react","react", dbserver);
	var queryInsert = await ExecQuery("single", "INSERT INTO Pages (Title, Html) VALUES ('', '')", "react","react");
	var querySelect = await ExecQuery("", "SELECT * From Pages", "react","react");
	alert(querySelect);
	
	const jsonArr = await ExecQuery("array", "SELECT * From Pages", "react","react");
	var tabledata = "";
	for (let indexa = 0; indexa < jsonArr.length; ++indexa) {
	for (let indexb = 0; indexb < jsonArr[0].length; ++indexb) {
		tabledata += jsonArr[indexa][indexb]['key'] + ": " + jsonArr[indexa][indexb]['value'] + "\n";

	}
	}
	alert(tabledata);
	
	
	//Other functions
	var urlupdate = await UrlQuery("single", "INSERT INTO Pages (Title, Html) VALUES ('', '')", "react","react", dbserver);
	var scriptupdate = await ScriptQuery("single", "INSERT INTO Pages (Title, Html) VALUES ('', '')", "react","react", dbserver);
	var tableoverview = await TableShow('Pages', 'react', 'react', dbserver) 
	}

Example other db server:

var queryCreate = await ExecQuery("", "CREATE TABLE Pages (ID INTEGER PRIMARY KEY, Title TEXT, Html TEXT)", "react","react", dbserver);

var queryInsert = await ExecQuery("single", "INSERT INTO Pages (Title, Html) VALUES ('', '')", "react","react", dbserver);

var queryresp = await ExecQuery("", "SELECT * From Pages", "react","react", dbserver);

var querySingle = await ExecQuery("single", "SELECT Title From Pages WHERE ID == 1", "react","react", dbserver);

var queryresp = await ExecQuery("", "SELECT * From Pages", "react","react", "http://localhost/jsonengine.php");