如何使用SQLite数据创建Javascript var
How do I create a Javascript var using SQLite data?
我能够使用Missing Manual系列JavaScript版本提供的示例非常有帮助!
奥格·我环顾四周,尝试了几种不同的方法,但未能找到解决方案。
我想做什么。
- 将用户输入保存在 sglite 数据库中,已完成。.
- 将sqlite数据作为javascript变量检索,我认为这是我的问题。
- 使用变量作为 ajaxURL 来检索 json,或者这可能是问题所在。
爪哇语
<script>
$(document).ready(function() {
var db = openDatabase ("Test", "1.0", "Test", 65535);
$db.transaction (function (transaction)
{
var sql = "SELECT * FROM scprofiles";
transaction.executeSql (sql, undefined,
function (transaction, result)
{
//I think this is the problem host, id and name are stored in sqlite
var URL = "http://" + host + "/web/" + id + "/1/" + name + "/";
var jsonFormat = "?format=json&callback=?";
var ajaxURL = URL + jsonFormat;
$.getJSON(ajaxURL,function(data) {
$('h1').text(data.displayName);
$('#stuff').text(data.user.info);
});
}error);
});
}); //db.transaction
function ok ()
{
}
function error (transaction, err)
{
alert ("DB error : " + err.message);
return false;
}
}); // end ready
</script>
然后是 HTML
<div class="content">
<div class="main">
<h1>JSON Data</h1>
<div id="stuff"></div>
<br class="clearLeft">
</div>
</div>
任何建议都非常感谢!
布伦特-
解决方案
<!DOCTYPE html>
<html lang="en">
<head>
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale = 1.0">
<meta charset="utf-8">
<title>Read Text</title>
<link rel="stylesheet" href="inc/jquery/j.m-1.3.2.css" />
<link rel="stylesheet" href="inc/jquery/ld.min.css" />
<script src="inc/jquery/jquery-1.10.2.min.js"></script>
<script type="text/javascript" src="inc/jquery/scdata-10.js"> </script>
<script src="inc/jquery/j.m-1.3.2.js"></script>
<script>
function saveData() {
var bnetName = document.getElementById("bnetName").value;
localStorage["bnetName"] = bnetName;
var bnetID = document.getElementById("bnetID").value;
localStorage["bnetID"] = bnetID;
var bnetRegion = document.getElementById("bnetRegion").value;
localStorage["bnetRegion"] = bnetRegion;
location.reload();
}
function loadData() {
var bnetName = localStorage["bnetName"];
var bnetID = localStorage["bnetID"];
var bnetRegion = localStorage["bnetRegion"];
if (bnetName != null) {
document.getElementById("bnetName").value = bnetName;
}
if (bnetID != null) {
document.getElementById("bnetID").value = bnetID;
}
if (bnetRegion != null) {
document.getElementById("bnetRegion").value = bnetRegion;
}
}
$(document).ready(function () // Call function when page is ready for load..
{
var URL = "http://" + localStorage.bnetRegion + "/api/sc2/profile/" + localStorage.bnetID + "/1/" + localStorage.bnetName + "/";
var jsonFormat = "?format=json&callback=?";
var ajaxURL = URL + jsonFormat;
$.getJSON(ajaxURL,function(data) {
$('#results').html( data.displayName + " " + localStorage.bnetRegion + " " + localStorage.bnetID + " <button onclick=' "+ loadData() + " '>Edit</button>" );
});
});
</script>
</head>
<body>
<div data-role="page" id="home">
<div data-role="header">
<h1>Add StarCraft II Profile</h1>
<a href="data.html" data-shadow="false" data-iconshadow="false" data-icon="arrow-l" data-iconpos="notext" data-ajax="false">Back</a>
</div>
<div data-role="content">
<fieldset>
<span> bnet Name </span>
<input type="text" id="bnetName"><br />
<span> bnet ID </span>
<input type="text" id="bnetID"><br />
<label for="bnetRegion" class="label">Region Host</label>
<select name="bnetRegion" id="bnetRegion" data-mini="true" data-inline="true" title="Please choose region host.">
<option>--Please select one--</option>
<option value="us.battle.net">US</option>
<option value="eu.battle.net">EU</option>
<option value="kr.battle.net">KR</option>
<option value="tw.battle.net">TW</option>
<option value="www.battlenet.com.cn">CN</option>
<option value="sea.battle.net">SEA</option>
</select>
</fieldset>
<div>
<button onclick="saveData()">Save</button>
</div>
<div id="results">
</div>
</div>
</body>
</html>
相关文章:
- 如何使用javascript var引用Mongo DB集合's字段
- php中的javascript var太长
- 如何让这个javascript var在HTML页面上工作
- Javascript:var%20C与常规var相比意味着什么
- 可以将单数 Javascript var 视为数组
- 从 JSON 制作 javascript var(数组)
- Javascript var 不会改变
- Joomla javascript var with HTML code
- 如何将所有动态id的arrey值获取到javascript VAR CID,以便在sql中找到匹配项
- 带有右胡萝卜的javascript var给出了奇怪的结果
- 最快的PHP等效javascript `var a=var1||var2||var3;`表示
- JavaScript: var {left, ...props} = this.props;
- 如何从html元素中获取javascript var数据?(使用canvasjs)
- JavaScript var 未正确传递给支持 Bean
- JavaScript var getElementById if 语句不起作用
- Javascript var === 2 && console.log('true').
- 在刀片语法上传递 javascript var
- JavaScript var 在等待 jQuery 完成动画处理时被覆盖
- 将 JavaScript var 传递给 php 函数
- JavaScript var 值,重定向 URL 为空