I have a WebSQL database that I would like to share over a network so that anyone who accesses the html files linked with the database will be viewing/editing the same copy of the database.
So, essetially, is there any way of changing the location which the browser (Chrome) saves the database?
I know WebSQL was deprecated, however it's necessary for me to use for my project.
<script>
if (window.openDatabase) {
var mydb = openDatabase("students2_db", "0.1", "A Database of Students", 1024 * 1024);
mydb.transaction(function (t) {
t.executeSql("CREATE TABLE IF NOT EXISTS student (id INTEGER PRIMARY KEY ASC, fname TEXT, lname TEXT, mclass TEXT, aclass TEXT, com TEXT, lates INTEGER DEFAULT 0)");
t.executeSql("CREATE TABLE IF NOT EXISTS lates (lid INTEGER PRIMARY KEY ASC, flname TEXT, llname TEXT, time TEXT, reason TEXT, date TEXT, nextdet TEXT)"); });
} else {
alert("WebSQL is not supported by your browser!");
}
function ClearFunction() {
document.getElementById("morningclass").value = "";
document.getElementById("afternoonclass").value = "";
}
function addStudent() {
if (mydb) {
var fname = document.getElementById("firstname").value;
fname = fname.replace(/\s/g, '');
fname = fname.toLowerCase();
var lname = document.getElementById("lastname").value;
lname = lname.replace(/\s/g, '');
lname = lname.toLowerCase();
var mclass = document.getElementById("morningclass").value;
var aclass = document.getElementById("afternoonclass").value;
var com = document.getElementById("comments").value;
if (fname !== "" && lname !== "" && mclass !== "" && aclass !== "") {
mydb.transaction(function (t) {
t.executeSql("INSERT INTO student (fname, lname, mclass, aclass, com) VALUES (?, ?, ?, ?, ?)", [fname, lname, mclass, aclass, com]);
alert("Entry succesfully added");
document.getElementById("firstname").value = "";
document.getElementById("lastname").value = "";
document.getElementById("morningclass").value = "";
document.getElementById("afternoonclass").value = "";
document.getElementById("comments").value = "";
});
} else {
alert("You must fill out all the empty information!");
}
} else {
alert("db not found, your browser does not support web sql!");
}
}
</script>
Aucun commentaire:
Enregistrer un commentaire