cordova_test1

cordova camera test

by bsorrentino

HTML

<script src="/cordova.js"></script>
    <h1>TEST-21</h1>
	<h3>Enter name and picture</h3>
	<div id="userProfile">
        <button onclick="takePhoto();">Capture Photo</button> <br/>
        <img style="display:none;width:100px;height:100px;" id="smallImage" src=""/>
	<p></p>
        <input id="userName" type="text" placeholder="FirstName"/> name<br/>

        <input id="saveProfile" type="button" value="Save" onclick="insertEntry();location.href='Createtask.html'"/> <br/>

        <input id="allUsers" type="button" value="All users" onclick="queryDB();"/> <br/>
	</div>

JavaScript

var db;

function onFail(message) {
    alert('Failed because: ' + message);
}

function createTable(tx) {
    var sqlStr = ('CREATE TABLE IF NOT EXISTS USERS(id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, image BLOB)');
    tx.executeSql(sqlStr, [], function() {console.log("Users table created");} , errorCB);

}

function insertEntry() {

  db.transaction( function(tx) {
    var tmpName = document.getElementById("userName").value;
    var tmpImage = document.getElementById("smallImage").src;
    var sqlStr = ('INSERT INTO USERS (name, image) VALUES (?,?)');
    tx.executeSql(sqlStr, [tmpName, tmpImage], function(tx,res) { onSqlSuccess(tx,res); alert('record entered'); } , errorCB);
  });
}

// Query the success callback
function onSqlSuccess(tx, results) {
    var len = results.rows.length;
    console.log("USERS table: " + len + " rows found.");
    for (var i = 0; i < len; i++) {
        console.log("Row = " + i + " ID = " + results.rows.item(i).id + " Name =  " + results.rows.item(i)['name']);
    }
}

// Query the database
//
function queryDB() {
    var sqlStr = ('SELECT * FROM USERS ORDER BY id ASC');
    db.transaction( function(tx) {
      tx.executeSql(sqlStr, [], onSqlSuccess, errorCB);
      });
}

// Transaction error callback
//
function errorCB(tx,err) {
    console.log("Error processing SQL: " + err.message);
}

// Transaction success callback
//
function successCB() {
    console.log('');
}

var pictureSource;   // picture source
var destinationType;

function onDeviceReady()
{

  alert("device ready!");

  db = window.openDatabase("database", "1.0", "Profiles", 5000);
  if(db) {
        pictureSource = "navigator.camera.PictureSourceType";
        destinationType = "navigator.camera.DestinationType";

      db.transaction( function(tx) {
          createTable(tx)
          } ); // only do stuff if db exists
        console.log('The database is working');
  }
  else {
        //alert("device ready!");
       ...