Below is my code.Just need to take value from user and display it.When i run this it shows database created successfully but the values arent getting added and the data isn't displaying. I have searched many places but i am not getting the solution.
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8" />
<meta name="format-detection" content="telephone=no" />
<meta name="viewport" content="user-scalable=no, initial-scale=1, maximum-scale=1, minimum- scale=1, width=device-width, height=device-height, target-densitydpi=device-dpi" />
<title>Hello World</title>
<script type="text/javascript" src="cordova.js"></script>
<script type="text/javascript">
document.addEventListener("deviceready",onDeviceReady,false);
var database = null;
function onDeviceReady()
{
database = window.openDatabase("Test","1.0","Testing Select",200000);
database.transaction(PopulateDatabase,errorDB,successDB);
}
function PopulateDatabase(tx)
{
tx.executeSql("Create Table IF NOT EXISTS Test (FirstName text)");
}
function errorDB(error)
{
alert("Error on databse Creation : " + error);
}
function successDB()
{
alert("databse created suceess");
}
function successSelect(){
}
function GetRecords(){
database = window.openDatabase("Test","1.0","Testing Select",200000);
database.transaction(SelectData,errorDB,successSelect);
}
function SelectData(tx){
tx.executeSql("select * from Test", {} ,resultSuccess,resultError);
}
function resultSuccess(tx, response)
{
var div = document.getElementById("responsediv");
var temp ="<table border=\"1\"><tr><th>First name</th></tr>";
for(var i=0;i<response.rows.length;i++)
{
temp += "<tr><td>" + response.rows.item(i).FirstName +"</td></tr>"
div.innerHTML = temp;
}
}
function resultError(error)
{
alert(error);
}
function AddRecords(){
database = window.openDatabase("Test","1.0","Testing Select",200000);
database.transaction(insertNewLine,errorDB,successSelect);
}
function insertNewLine(tx)
{
var var1 = document.getElementById("myText").value;
tx.executeSql("INSERT INTO Test (FirstName) VALUES (?)", [ var1 ]);
}
</script>
</head>
Aucun commentaire:
Enregistrer un commentaire