I am trying to develop a phonegap application which has a multiple choice question that choice are as radio button. The HTML code is:
<p>First question</p>
<form action="question.js" method="post">
<label><input type="radio" id="mans1a" name="Mans1" value="excellent">option a</label>
<label><input type="radio" id="mans1b" name="Mans1" value="good">option b</label>
<label><input type="radio" id="mans1c" name="Mans1" value="average">option c</label>
<label><input type="radio" id="mans1d" name="Mans1" value="poor">option d</label>
</form>
<p>second question?</p>
<form action="question.js" method="post">
<label><input type="radio" id="mans2a" name="Mans2" value="yes">yes</label>
<label><input type="radio" id="mans2b" name="Mans2" value="no">no</label>
</form>
This is javascript:
var db = window.openDatabase("test","1.0","Test DB",2000000);
function MediAns()
{
db.transaction(PopulateDB, errorCB, successCB);
}
function PopulateDB(tx)
{
tx.executeSql('CREATE TABLE IF NOT EXISTS medicalshop (medicalshop_rating TEXT)');
tx.executeSql('INSERT INTO medicalshop VALUES ("-MEDICAL SHOP-")');
tx.executeSql('INSERT INTO medicalshop VALUES ("Excellent")');
tx.executeSql('INSERT INTO medicalshop VALUES ("Good")');
tx.executeSql('INSERT INTO medicalshop VALUES ("Average")');
tx.executeSql('INSERT INTO medicalshop VALUES ("Poor")');
}
function queryDB(tx)
{
tx.executeSql('SELECT * FROM medicalshop', querySuccess, errorCB);
}
function errorCB(tx, err)
{
alert("Error Processing SQL: "+err);
}
function successCB()
{
var db = window.openDatabase("test", "1.0", "Test DB", 200000);
db.transaction(queryDB, errorCB);
}
function querySuccess(tx, results)
{
var len = results.rows.length;
alert(len);
for (var i=0; i<len; i++)
{
var a = results.rows.item(i)['medicalshop_rating'];
alert(a);
}
}
I want to know how to save the radio butter entry to the local sqlite and display. Thanks in advance
Aucun commentaire:
Enregistrer un commentaire