Untitled

<!doctype html>
<html>
    <head>
        <meta charset="utf-8">
        <meta name="viewport" content="width=device-width; initial-scale=1.0; user-scalable=no;">
        <link rel="stylesheet" href="css/style.css" />
        <script src="js/iscroll.js"></script>
        <script type="text/javascript">myScroll = new iScroll('wrapper', {});myScroll.options.onBeforeScrollStart = function(e) {var target = e.target;while (target.nodeType != 1) target = target.parentNode;if(target.tagName != 'SELECT' && target.tagName != 'INPUT' && target.tagName != 'TEXTAREA'){e.preventDefault();}}</script>
        <script src="js/cordova-2.2.0.js"></script>
        <script>
        //Give the forms some variables
            Title = oForm.elements["title"].value;
            Desc = oForm.elements["desc"].value;
            Url = oForm.elements["url"].value;
            User = oForm.elements["user"].value;
            Pass = oForm.elements["pass"].value;
        </script>
<script>
        document.addEventListener("deviceready", onDeviceReady, false);

var db = "";

function populateDB(tx) {
   // tx.executeSql('DROP TABLE IF EXISTS SoccerPlayer');
    tx.executeSql('CREATE TABLE IF NOT EXISTS SoccerPlayer (Title TEXT NOT NULL, Desc TEXT NOT NULL, Url TEXT NOT NULL, User TEXT NOT NULL, Pass TEXT NOT NULL)');
    tx.executeSql('INSERT INTO SoccerPlayer(Title,Desc,Url,User,Pass) VALUES (Title, Desc, Url, User, Pass)');
}

function queryDB(tx) {
    tx.executeSql('SELECT * FROM SoccerPlayer', [], querySuccess, errorCB);
}


function querySuccess(tx,result){
        var playerlist = document.getElementById("SoccerPlayerList");
        var players = "";
        //alert("The show is on");
        var len = result.rows.length;
        for (var i=0; i<len; i++){
            //alert(result.rows.item(i).Name + result.rows.item(i).Club);
            players = players + '<li><a href="#"><p>'+result.rows.item(i).Title+'</p></li>';
        }

        playerlist.innerHTML = players;
        $("#SoccerPlayerList").listview("refresh");
}


function errorCB(err) {
    //alert("Error processing SQL: "+err.code);
}


function successCB() {
    db.transaction(queryDB, errorCB);
}


function onDeviceReady() {
    db = window.openDatabase("Database", "1.0", "PhoneGap Demo", 200000);
    db.transaction(populateDB, errorCB, successCB);
}
</script>
</head>
<body>
    <header>
        <a class="edit" href="index.html"><img class="gear" src="img/back.png" width="33" height="33" /></a>
        <p class="heading">iLOCKER</p>
        <img class="newItem" src="img/add.png" width="30,9" height="31,5" />
    </header>

    <div class="headerShadow"></div>
    <div id="wrapper">
       <div>
            <div class="centerplacing">
                <form class="input"><input name="title" type="search" placeholder="Title"></form>
                <form class="input"><input name="desc" type="search" placeholder="Description"></form>
                <form class="input"><input name="url" type="search" placeholder="URL"></form>
                <form class="input"><input name="user" type="search" placeholder="E-mail / Username"></form>
                <form class="input"><input name="pass" type="password"placeholder="Password"></form>
                <a class="button" onclick="populateDB()" id="button" href="#">Save</a>
            </div>
    </div>
    </div>
</body>
</html>