DEV'S

Final - JQuery Mobile - IndexedDB Addon

index.html
<html>
    <head>
        <title>TODO supply a title</title>
        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <link rel="shortcut icon" href="">
        <link rel="stylesheet" href="css/jquery.mobile-1.4.5.min.css">
        <script src="js/jquery.js"></script>
        <script src="js/jquery.mobile-1.4.5.min.js"></script>
        <script src="js/app.js"></script>
    </head>
    <body>
        <div data-role="page" id="login">
            <div data-role="header" data-position="fixed">
                <a href="register.html" data-transition="slide" data-icon="plus" data-iconpos="notext">Register</a>
                <h1>Login</h1>
            </div>
            <div data-role="main" class="ui-content">
                <div class="ui-field-contain">
                    <label for="uname">Username</label>
                    <input type="text" placeholder="Enter Username" id="uname">
                </div>
                <div class="ui-field-contain">
                    <label for="upwd">Password</label>
                    <input type="password" placeholder="Enter Password" id="upwd">
                </div>
                <div class="ui-field-contain">
                    <label></label>
                    <a href="main.html" data-transition="slide" class="ui-btn ui-btn-corner-all">Login</a>
                </div>
            </div>
            <div data-role="footer" data-position="fixed">
                <h1>Copyrights 2016</h1>
            </div>
            <div data-role="popup" id="loginwrongpopup"  data-dismissible="false">
                <!—                <a href="#" data-rel="back" data-icon="delete" class="ui-btn ui-corner-all  ui-icon-delete ui-btn-icon-notext ui-btn-right" ></a>
               —>
                
                <div data-role="header" data-theme="b">
                    <a href="#" data-rel="back" data-iconpos="notext" data-icon="delete" class="ui-btn-right"></a>
                    <h1>Stop</h1>
                </div>
                
                <div data-role="main" class="ui-content">
                    <p>Sorry username / password wrong</p>
                </div> 
            </div>
        </div>
    </body>
</html>

register.html

<div data-role="page" id="register">
    <div data-role="header" data-position="fixed">
        <a href="#" data-rel="back" data-icon="back" data-iconpos="notext">Back</a>
        <h1>Register</h1>
    </div>
    <div data-role="main" class="ui-content">
        <div class="ui-field-contain">
            <label for="unamereg">Username</label>
            <input type="text" placeholder="Enter Username" id="unamereg">
        </div>
        <div class="ui-field-contain">
            <label for="upwdreg">Password</label>
            <input type="password" placeholder="Enter Password" id="upwdreg">
        </div>
        <div class="ui-field-contain">
            <label for="fname">Name</label>
            <input type="text" placeholder="Enter Fullname" id="fname">
        </div>
        <div class="ui-field-contain">
            <fieldset data-role="controlgroup">
                <legend>Gender</legend>
                <label for="male">Male</label>
                <input type="radio" id="male" name="gender">
                <label for="female">Female</label>
                <input type="radio" id="female" name="gender" checked>
                <label for="other">Other</label>
                <input type="radio" id="other" name="gender">
            </fieldset>
        </div>
        <div class="ui-field-contain">
            <fieldset data-role="controlgroup">
                <legend>Interested In</legend>
                <label for="business">Business</label>
                <input type="checkbox" id="business" name="int">
                <label for="travel">Travel</label>
                <input type="checkbox" id="travel" name="int">
                <label for="others">Other</label>
                <input type="checkbox" id="others" name="int">
            </fieldset>
        </div>
        <div class="ui-field-contain">
            <label></label>
            <a href="javascript:registerUser()" class="ui-btn ui-btn-corner-all">Submit</a>
        </div>
    </div>
    <div data-role="footer" data-position="fixed">
        <h1>Copyrights 2016</h1>
    </div>
</div>

main.html

<div data-role="page" id="mainpage">
    <div data-role="header" data-position="fixed">
        <a href="#" data-rel="back" data-icon="back" data-iconpos="notext">Back</a>
        <h1>All Students</h1>
        <a href="addeditstudent.html" data-icon="plus" data-iconpos="notext">Add</a>
    </div>
    <div data-role="main" class="ui-content">
        <ul data-role="listview" id="stdlist" data-inset="true">
            
        </ul>
    </div>
    <div data-role="footer" data-position="fixed">
        <h1>Copyrights 2016</h1>
    </div>
</div>

addeditstudent.html

<div data-role="page" id="addedit">
    <div data-role="header" data-position="fixed">
        <a href="#" data-rel="back" data-icon="back" data-iconpos="notext">Back</a>
        <h1 id="headtitle">Add Student</h1>
        <a href="javascript:deleteStudentRecord();" data-icon="delete" data-iconpos="notext" id="del">Delete</a>

    </div>
    <div data-role="main" class="ui-content">
        <div class="ui-field-contain" id="rollnumblock">
            <label for="rollnum">Roll Number</label>
            <input type="text"  id="rollnum" placeholder="Roll Num" disabled>
        </div>
        <div class="ui-field-contain">
            <label for="fname">Name</label>
            <input type="text" id="fname" placeholder="Enter name">
        </div>
        <div class="ui-field-contain">
            <label for="sub">Subject</label>
            <select id="sub">
                <option value="1">Physics</option>
                <option value="2">Chemistry</option>
                <option value="3">Math</option>
                <option value="4">English</option>
            </select>
        </div>
        <div class="ui-field-contain">
            <fieldset data-role="controlgroup">
                <legend>Is Pass</legend>
                <label for="ispass">Is Pass</label>
                <input type="checkbox" id="ispass" name="ispass"  >
            </fieldset>
        </div>
        <div class="ui-field-contain">
            <label></label>
            <a href="javascript:addStudent()" id="addbtn" class="ui-btn ui-btn-corner-all">Submit</a>
            <a href="javascript:editStudent()" id="edtbtn" class="ui-btn ui-btn-corner-all">Edit</a>
        </div>
    </div>
    <div data-role="footer" data-position="fixed">
        <h1>Copyrights 2016</h1>
    </div>
    <div data-role="popup" id="warnpopup">
        <div data-role="header" data-theme="b">
            <a href="#" class="ui-btn-right" data-icon="delete" data-iconpos="notext" data-rel="back">NO</a>
            <h1>Alert</h1>
        </div>
        <div data-role="main" class="ui-content">
            <p>Do you really want to delete this entry?</p>
        </div>
        <div data-role="footer" >
            <a href="javascript:deleteStudentRecordConfirm()" style="padding: 5px;">YES</a>
        </div>
    </div>
</div>

app.js

var DBNAME = "stddb1.db";
var STDSTORE = "stdStore";
var SROLLNUM = "sRollNum";
var SNAME = "stdName";
var SSUB = "stdSub";
var SPASS = "sPass";
var READWRITE = "readwrite";
var READONLY = "readonly";
var db;
var request = window.indexedDB.open(DBNAME, 1);

$(document).ready(function () {
    sessionStorage.isLogin = "NO";

});

$(document).on("pagebeforechange", function (e, d) {

    if (d.toPage[0].id === "login") {
        //Kill session // set to NO
        sessionStorage.isLogin = "NO";
    } else if (d.toPage[0].id === "mainpage") {
        var uname = $("#uname").val();
        var pwd = $("#upwd").val();
        console.log(localStorage.uname + " , " + uname);
        if (uname === localStorage.uname && pwd === localStorage.upass) {
            sessionStorage.isLogin = "YES";
            buildStudentsList();
        } else {
            e.preventDefault();
            sessionStorage.isLogin = "NO";
            $("#loginwrongpopup").popup("open");

        }
    } else if (d.toPage[0].id === "addedit") {
        if (d.options.std) {
            //Edit
            //console.log(d.options.std);
            $("#headtitle").html("Edit Student");
            var stdObj = d.options.std;
            $("#fname").val(stdObj[SNAME]);
            $("#sub").val(stdObj[SSUB]).selectmenu("refresh");
            //checkboxradio("refresh");
            $("#rollnum").val(stdObj[SROLLNUM]);
            if (stdObj[SPASS] === "Y") {
                $("#ispass").attr("checked", true).checkboxradio("refresh");
            }
            $("#addbtn").hide();

        } else {
            //Add
            $("#rollnumblock").hide();
            $("#del").hide();
            $("#edtbtn").hide();
            console.log("New Record");
        }
    }
});

request.onsuccess = function (event) {
    db = event.target.result;
};

request.onerror = function (event) {

};

request.onupgradeneeded = function (event) {
    db = event.target.result;
    var objStore = db.createObjectStore(STDSTORE, {keyPath: SROLLNUM, autoIncrement: true});
    objStore.createIndex(SNAME, SNAME, {unique: false});
    objStore.createIndex(SSUB, SSUB, {unique: false});
    objStore.createIndex(SROLLNUM, SROLLNUM, {unique: true});

};

function addStudent() {
    //console.log($("#ispass").is(":checked"));
    var stdObj = {};
    stdObj[SNAME] = $("#fname").val();
    stdObj[SSUB] = $("#sub").val();
    if ($("#ispass").is(":checked")) {
        stdObj[SPASS] = "Y";
    } else {
        stdObj[SPASS] = "N";
    }
    console.log(stdObj);
    var transaction = db.transaction([STDSTORE], READWRITE);
    var stdObjStore = transaction.objectStore(STDSTORE);
    var request = stdObjStore.add(stdObj);
    request.onsuccess = function (ev) {
        $.mobile.back();
    };

}

function editStudent() {
    var stdObj = {};
    stdObj[SROLLNUM] = parseInt($("#rollnum").val());
    stdObj[SNAME] = $("#fname").val();
    stdObj[SSUB] = $("#sub").val();
    if ($("#ispass").is(":checked")) {
        stdObj[SPASS] = "Y";
    } else {
        stdObj[SPASS] = "N";
    }
    console.log(stdObj);
    var transaction = db.transaction([STDSTORE], READWRITE);
    var stdObjStore = transaction.objectStore(STDSTORE);
    var request = stdObjStore.put(stdObj);
    request.onsuccess = function (ev) {
        $.mobile.back();
    };
}

function buildStudentsList() {
    var transaction = db.transaction([STDSTORE], READONLY);
    var stdObjStore = transaction.objectStore(STDSTORE);
    var request = stdObjStore.openCursor(null, ‘prev’);
    request.onsuccess = function (ev) {
        var cursor = ev.target.result;
        if (cursor) {
            var stdObj = cursor.value;
            console.log(stdObj);
            var liDom = jQuery("<li><a href=\"#\">" + stdObj[SNAME] + "</a></li>");
            liDom.click({std: stdObj}, function (e) {
                $.mobile.pageContainer.pagecontainer("change", "addeditstudent.html", {std: e.data.std, transition: "slide"});
            });
            $("#stdlist").append(liDom);
            $("#stdlist").listview("refresh");
            cursor.continue();
        }
    };
}

function deleteStudentRecord() {

    $("#warnpopup").popup("open");

}

function deleteStudentRecordConfirm() {
    var transaction = db.transaction([STDSTORE], READWRITE);
    var stdObjStore = transaction.objectStore(STDSTORE);
    var stdId = $("#rollnum").val(); // string format "2";
    var request = stdObjStore.delete(parseInt(stdId)); // supply integer = 2
    request.onsuccess = function (ev) {
        $.mobile.back(); // to dismiss the popup
        $.mobile.back(); // go back to previous page
    };
}
function registerUser() {

    localStorage.uname = $("#unamereg").val();
    localStorage.upass = $("#upwdreg").val();
    $.mobile.back();
}

HTML5

2018-11-27 21:35:02
1) Ionic - Angular Videos
2018-06-29 05:46:32
2) Service - Broadcast Receiver
2018-06-28 03:55:43
3) Activity - Bundle - Option Menu - ActionBar
2018-06-27 03:27:57
4) Relative Layout
2018-06-25 03:14:55
5) LinearLayout Calc
2018-02-08 05:14:15
6) PHP HelloWorld
2018-01-19 04:57:25
7) Angular 5 - Material Design - Reactive Form - Continued
2018-01-19 04:06:05
8) Feedback
2018-01-19 02:07:18
9) Angular 5 - Material Design
2018-01-18 03:05:47
10) Angular 5 - Custom Directives,Pipes - Promise And Observables
2018-01-17 22:51:45
11) Angular 5 - Component Interaction
2018-01-17 03:14:26
12) Angular 5 - Registration Form - WebService
2018-01-17 01:46:34
13) Angular 5 - Directives
2018-01-16 23:13:47
14) Angular 5 - Lifecycle Hooks - Routing
2018-01-16 21:36:25
15) CRUD Example - TS - LocalStorage - Delete
2018-01-16 13:34:40
16) Shopping App - Api Calls - JSON
2018-01-16 03:17:09
17) CRUD Example - TS - LocalStorage - View - Add
2018-01-15 23:57:32
18) TypeScript - Part 2
2018-01-15 23:02:07
19) TypeScript - Part 1
2018-01-15 04:46:29
20) TypeScript To JavaScript
2018-01-15 00:48:22
21) First Angular5 App
2016-01-17 23:47:13
22) JQuery Mobile - My Account Page Addon
2016-01-16 02:38:09
23) HTML5 - CSS - JavaScript Exam Preparation
2016-01-14 02:34:08
24) JQuery Validation Plugin - Basics
2016-01-13 02:35:46
25) Final - JQuery Mobile - IndexedDB Addon
2016-01-12 03:23:20
26) JQuery Mobile - IndexedDB Addon
2016-01-11 00:08:42
27) Students Record - JQuery Mobile App
2016-01-09 04:03:04
28) JQuery Mobile PageChange Event
2016-01-08 03:51:55
29) Beginning JQuery Mobile
2016-01-07 03:47:24
30) WebWorker Example
2016-01-06 04:11:18
31) IndexedDB - ObjectStore - Tansaction - Cursor - Part 2
2016-01-05 03:46:35
32) Student Record - IndexedDB Migration
2016-01-04 23:47:55
33) IndexedDB - ObjectStore - Tansaction - Cursor
2016-01-04 04:48:33
34) Single Page Design And Geolocation Example With Ajax
2016-01-03 23:39:19
35) Drag And Drop Example
2016-01-03 01:57:50
36) Beginning Responsive WebDesign Using JQuery
2016-01-03 01:56:17
37) HTML5 Canvas Simple Example
2016-01-03 01:55:11
38) JQuery Object - Context - Function Callbacks
2015-12-29 23:28:49
39) JQuery DOM Manipulation And LocalStorage
2015-11-30 23:50:59
40) JavaScript EventListeners
2015-11-30 04:34:08
41) MultiPage Design
2015-11-28 03:02:52
42) HTML Box Design
2015-07-03 03:09:55
43) KO Custom Component
2015-07-02 23:25:36
44) KO Custom Binding And Template Binding
2015-07-01 23:27:04
45) KO Simplelist
2015-07-01 01:44:40
46) KO Introduction And JQuery Simple List
2015-01-29 00:34:17
47) Canvas - DragDrop - Video - Audio Example
2015-01-28 03:57:05
48) CSS Media Type - IndexedDB WHERE And LIKE Clause
2015-01-27 02:24:12
49) IndexedDB Simple Example
2015-01-24 00:11:32
50) Students Record - JQueryMobile - GeoLocation - Ajax Addon
2015-01-24 00:08:19
51) GeoLocation And Ajax Example
2015-01-21 05:23:32
52) Students Record - JQueryMobile - SessionStorage - Login State
2015-01-19 23:33:29
53) JQueryMobile - Page Change - Popup Addon
2015-01-19 00:21:28
54) JQueryMobile - Data-Role Introduction
2015-01-17 03:22:07
55) Handle PageLinks
2015-01-16 04:28:20
56) Simple HTML5 Calculator
2015-01-16 03:03:45
57) Load External DOM - Ajax In Simple Way
2015-01-16 03:01:48
58) JQuery Document Ready - Placement Of Script Tag
2015-01-13 22:54:25
59) Dynamic Layout Technique Using JQuery
2015-01-13 04:04:19
60) JQuery - Introduction
2015-01-12 23:45:02
61) LocalStorage - CRUD
2015-01-12 00:06:03
62) JSON - LocalStorage Example
2015-01-11 22:47:24
63) JavaScript - Data Persistency Using LocalStorage - SessionStorage
2015-01-10 03:17:01
64) HTML - JavaScript - Dynamic Table
2015-01-10 00:32:26
65) JavaScript Introduction
2015-01-09 04:07:47
66) CSS - Continued
2015-01-08 03:26:39
67) CSS - Margin - Padding - HTML5 Semantic Elements
2015-01-07 22:44:01
68) HTML-CSS Introduction
2014-11-25 14:27:00
69) Angular JS Simple Example
2014-10-16 05:01:39
70) CSS Media Example - Different CSS For Desktop - Tablet - Phone Screen Sizes
2014-10-15 04:20:11
71) Miscellaneous In Addition To Previous Exercises
2014-10-15 04:13:45
72) Some Useful RegEx
2014-10-14 02:57:45
73) Shopping List App Using IndexedDB
2014-10-14 00:04:10
74) IndexedDB Introduction
2014-10-14 00:00:01
75) JavaScript Prototyping
2014-10-11 03:50:47
76) Introduction To Canvas Drawing - Tabs - Popup Warning Dialog
2014-10-11 00:03:50
77) Popup - Validation - Shopping List App Updated
2014-10-10 22:34:42
78) RegEx Pattern For Validation - Shopping List App
2014-10-10 05:12:13
79) Password Lock-Shopping List App
2014-10-09 22:49:34
80) JQuery Shopping - Updated
2014-10-09 05:10:00
81) JQuery Mobile Forms - Save Checkbox - Radio Button Checked States
2014-10-08 22:18:40
82) JQuery Mobile Forms - Additional Data-role Attribute Values
2014-10-08 02:17:48
83) JQuery Shopping List Alternate Approach. JQ Append & Pagechange
2014-10-07 03:02:43
84) JQuery Mobile Page Change Events
2014-10-06 02:19:53
85) JQuery Mobile Data- Attribute Reference
2014-10-06 00:13:01
86) Shopping List Using LocalStorage
2014-10-06 00:10:02
87) JQuery Mobile Introduction
2014-10-06 00:07:40
88) JQuery Page Loading Technique
2014-10-06 00:05:39
89) Mobile Ready Page Extended - Load Multiple Pages Using JQuery
2014-10-06 00:00:27
90) A Mobile First Design Using JQuery - Window-Size
2014-10-05 23:58:01
91) JavaScript Array - Create - Update - Delete
2014-10-05 23:55:43
92) JQuery CSS Capabilities - A Mobile Ready Page
2014-10-05 23:52:42
93) JQuery Introduction - Unit Conversion Using JQuery
2014-10-05 23:49:58
94) JavaScript - DOM Manipulation-Table-Calculator
2014-10-05 23:40:06
95) GeoLocation
2014-10-05 23:37:36
96) Margin And Border Radius
2014-10-05 23:34:06
97) HTML5 Semantic Elements, CSS,SVG Examples
2014-10-05 23:28:45
98) HTML,CSS Selectors

© Vasudev.H / Email: tech3in@live.com