Skip to content

Instantly share code, notes, and snippets.

@macdonst
macdonst / sqltest.js
Created December 21, 2011 21:43
Create DB from .sql file
if (localStorage.getItem("dbCreated") != true) {
html5sql.openDatabase("ScratchDB", "Scratch DB", 3 * 1024 * 1024);
var request = new XMLHttpRequest();
request.open("GET", "file:///android_asset/www/create.sql", true);
request.onreadystatechange = function(){
if (request.readyState == 4) {
if (request.status == 200 || request.status == 0) {
html5sql.process(request.responseText,
function(){
console.log("Win!");
@macdonst
macdonst / create.sql
Created December 21, 2011 21:55
Example SQL
CREATE TABLE example (id INTEGER PRIMARY KEY, data TEXT);
INSERT INTO example (data) VALUES ('First');
INSERT INTO example (data) VALUES ('Second');
INSERT INTO example (data) VALUES ('Third');
CREATE TABLE example2 (id INTEGER PRIMARY KEY, data TEXT);
INSERT INTO example2 (data) VALUES ('First');
INSERT INTO example2 (data) VALUES ('Second');
INSERT INTO example2 (data) VALUES ('Third');
@macdonst
macdonst / fileTransferDownload.js
Created December 22, 2011 18:30
FileTransfer Download Example
var fileTransfer = new FileTransfer();
fileTransfer.download(
"http://developer.android.com/assets/images/home/ics-android.png",
"/sdcard/ics.png",
function(entry) {
console.log("download complete: " + entry.fullPath);
},
function(error) {
console.log("download error source " + error.source);
@macdonst
macdonst / rwd.html
Created January 1, 2012 17:17
RWD example
<!DOCTYPE HTML>
<html>
<head>
<meta name="viewport" content="user-scalable=no" />
<meta http-equiv="Content-type" content="text/html; charset=utf-8">
<title>PhoneGap</title>
<style type="text/css">
@media all and (min-width: 801px) {
#wrapper {
width: 80%;
@macdonst
macdonst / index.html
Created January 4, 2012 21:53
Reading configuration defaults
<!DOCTYPE HTML>
<html>
<head>
<meta name="viewport" content="width=320; user-scalable=no" />
<meta http-equiv="Content-type" content="text/html; charset=utf-8">
<title>PhoneGap Config Example</title>
<link rel="stylesheet" href="master.css" type="text/css" media="screen" title="no title" charset="utf-8">
<script type="text/javascript" charset="utf-8" src="phonegap-1.3.0.js"></script>
<script type="text/javascript" charset="utf-8">
@macdonst
macdonst / video.html
Created March 28, 2012 18:17
VideoPlayer Example
<!DOCTYPE HTML>
<html>
<head>
<meta name="viewport" content="width=320; user-scalable=yes" />
<meta http-equiv="Content-type" content="text/html; charset=utf-8">
<title>PhoneGap</title>
<script type="text/javascript" charset="utf-8" src="cordova-1.5.0.js"></script>
<script type="text/javascript" charset="utf-8" src="video.js"></script>
<script type="text/javascript">
@macdonst
macdonst / download.html
Created April 18, 2012 17:17
FileTransfer Download "file://" workaround.
<!DOCTYPE HTML>
<html>
<head>
<meta name = "viewport" content = "user-scalable=no,width=device-width" />
<meta http-equiv="Content-type" content="text/html; charset=utf-8">
<title>Test Page</title>
<script type="text/javascript" charset="utf-8" src="cordova.android.js"></script>
<style type="text/css">
* {
-webkit-tap-highlight-color: rgba(0, 0, 0, 0);
@macdonst
macdonst / imei.1.5.js
Created April 20, 2012 15:07
IMEI Plugin for PhoneGap 1.5+
var IMEI = function(){};
IMEI.prototype.get = function(onSuccess, onFail){
return cordova.exec(onSuccess, onFail, 'IMEI', 'get', []);
};
cordova.addConstructor(function(){
cordova.addPlugin('imei', new IMEI());
});
@macdonst
macdonst / IMEI.java
Created April 20, 2012 15:13
IMEI Plugin for PhoneGap 1.4.1
package com.simonmacdonald.imei;
import org.json.JSONArray;
import android.content.Context;
import android.telephony.TelephonyManager;
import com.phonegap.api.Plugin;
import com.phonegap.api.PluginResult;
@macdonst
macdonst / IMEI.1.5.java
Created April 20, 2012 15:16
IMEI Plugin for PhoneGap 1.5+
package com.simonmacdonald.imei;
import org.json.JSONArray;
import android.content.Context;
import android.telephony.TelephonyManager;
import org.apache.cordova.api.Plugin;
import org.apache.cordova.api.PluginResult;