samedi 11 juillet 2015

Storing a local database in a shared folder

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