File: /var/www/html/tmpr/..//tmpr/../tmpr/../real/webSQL.html
<!DOCTYPE html>
<html lang="en"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="viewport" content="user-scalable=no, initial-scale=1, maximum-scale=1, minimum-scale=1, width=device-width, height=device-height, target-densitydpi=medium-dpi" />
<script src="js/jquery-1.8.0.min.js"></script>
<script type="text/javascript" src="js/jquery-ui.min.js"></script>
<script src="js/fastclick.js"></script>
<link rel="stylesheet" href="css/mytv.css" type="text/css" charset="utf-8" />
<link rel="stylesheet" href="css/font.css" type="text/css" charset="utf-8" />
<script type="text/javascript">
/*document.addEventListener('deviceready', onDeviceReady, false);
function onDeviceReady(){
}*/
var db = window.openDatabase('MyDB', '1.0', 'My test DB', 5242880);
db.transaction(runTransaction, error, success);
function runTransaction(t){
t.executeSql('CREATE TABLE IF NOT EXISTS images (id unique, path)');
t.executeSql("INSERT INTO images (path) VALUES ('your-path-to-image.jpg')");
/*
t.executeSql('CREATE TABLE IF NOT EXISTS images (id unique, path)');
t.executeSql("INSERT INTO images (path) VALUES ('your-path-to-image.jpg')");
t.executeSql("DELETE FROM images WHERE path = 'your-path-to-image.jpg'");
t.executeSql('DROP TABLE IF EXISTS images');*/
}
function error(err){
alert('Error creating tables: '+err);
}
function success(){
alert('Successfully created tables');
}
db.transaction('runSelect', error2);
function runSelect(t){
t.executeSql('SELECT * FROM images', [], success2, error2);
}
function success2(t, results){
/*('Number of rows: '+results.rows.length);
*/ alert ('Last inserted row: '+results.insertId);
for(var i = 0; i < len; i++){
console.log('Row: '+i);
console.log('ID: '+results.rows.item(i).id);
console.log('Path: '+results.rows.item(i).path);
}
}
function error2(err){
console.log('There was an error processing the SQL: '+err);
}
</script>
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onload="onBodyLoad()">
<div class="dialog-background">
<div class="dialog-loading-wrapper">
<span class="dialog-loading-icon"></span>
</div>
</div>
<div class="header-contX3 animated fadeIn"></div>
<div class="header-contX2" style="display:none"></div>
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" width="100%" height="40" >
<table border="0" cellpadding="0" cellspacing="0" height="40" width="100%" class="header-contX animated bounce" >
<tr>
<td width="139" height="40"><a href="index.html"><img src="images/app_02.png" class="animated flash" width="139" height="40" style="-webkit-transform: translate3d(0,0,0); "></a></td>
<td width="100%" height="40" align="right" style="color: #FFF" background="images/app_03.png" >
<a href="#" class="reload" id="1"><span id="check"></span></a> </td> <td width="44" height="40"><a href='#' class='searchopen' id='1' title='Comment'><img src="images/search1.png" width="44" height="40" alt=""></a></td>
<td width="44" height="40"><a href="index.html"><img src="images/app_04.png" width="44" height="40" alt=""> </a></td>
<td width="44" height="40" > <!--<img src="images/app_05.png" width="44" height="40" alt="" class="menu-trigger" id="menu-trigger">--> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="50" valign="top">
<center>
<a href="#" class="pull-middle thumb animated pulse" >
<span id="picture"> </span>
</a>
<div id="h3" class="h3 animated pulse" style="color:#FFF" > </div>
</center>
<table border="0" cellpadding="0" width="100%" cellspacing="0" height="55" class="animated fadeIn" >
<tr>
<td width="153" height="55" >
<img src="images/following.png" alt="" width="190" height="55"></td>
<td width="100%" height="55">
</td>
<!--<td width="54" height="55" >
<a href='#' class='searchopen' id='1' title='Comment'><img src="images/buttons2_03.png" width="54" height="55" alt=""></a></td>-->
<td width="53" height="55" ><a href="followers.html"><img src="images/buttons2_03.png" width="54" height="55" alt=""></a></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="100%" height="100%" style="min-height:200px" bgcolor="#f7f7f7" valign="top" >
<section class="panel animated fadeIn" style=" margin-top:0px; color:#333;display:block" id='searchbox1'>
<form action="" class="m-b-none">
<div class="input-group m-b" style="width:100%">
<input placeholder="#hashtags or @name or term" id="searcharea1" class="form-control no-border" value="" type="text"> </div>
</form>
</section>
<div id="searchme"></div>
<section class="scrollable" >
<!--<span id="liveupdate2" ></span>
<div id='flashmessage'>
<div id="flash" ></div>
</div>
<div class="row wrapper" id="liveupdate" style="margin-top:0px; padding-top:0" >
</div>
-->
<ul id="list">
</ul>
</section>
</td>
</tr>
</table>
<div id="nav2" class="animated pulse slide-menu">
<table border="0" cellpadding="0" width="100%" cellspacing="0" height="55" style="background-image:url(images/app_16a.png);background-repeat:repeat-x" >
<tr>
<td height="55" valign="top" align="left" ><div class="swiper-container swiper-nav" id="tools">
<div class="swiper-wrapper">
<div class="swiper-slide"> <a href="notifications.html"><img src="images/app_12.png" class="swiper-slide" width="54" height="55" alt="" style="-webkit-transform: translate3d(0,0,0); "></a> </div>
<div class="swiper-slide"> <a href="contacts.html"><img src="images/app_13.png" width="54" height="55" alt="" style="-webkit-transform: translate3d(0,0,0); "></a> </div>
<div class="swiper-slide"> <a href="photos.html"><img src="images/app_15.png" width="54" height="55" alt="" style="-webkit-transform: translate3d(0,0,0); "></a> </div>
<div class="swiper-slide"> <a href="favorite.html"><img src="images/app_14.png" style="-webkit-transform: translate3d(0,0,0); " width="54" height="55" alt=""></a> </div>
<div class="swiper-slide"> <a href="profile.html"><img src="images/app2_12.png" style="-webkit-transform: translate3d(0,0,0); " width="54" height="55" alt=""></a> </div>
<div class="swiper-slide"> <a href="logout.html"><img src="images/app2_15.png" style="-webkit-transform: translate3d(0,0,0); " width="54" height="55" alt=""></a> </div>
<div class="swiper-slide"> <a href="upload.html"><img src="images/cam2.png" style="-webkit-transform: translate3d(0,0,0); " width="54" height="55" alt=""></a> </div>
</div>
</div>
<td height="55" width="59" valign="top" ><a href="profile.html"><img src="images/app_17.png" style="-webkit-transform: translate3d(0,0,0); " width="59" height="55" alt=""></a></td>
</tr>
</table>
</div>
<!-- Navigation -->
<nav id="slide-menu" class="animated pulse">
<table border="0" cellpadding="0" width="54" cellspacing="0" height="55">
<tr>
<td height="54" ><a href="upload.html"><img src="images/cam.png" width="54" height="54" alt=""></a></td>
</tr>
<tr>
<tr>
<td height="54" ><a href="logout.html"><img src="images/logout.png" width="54" height="54" alt=""></a></td>
</tr>
<!-- <tr>
<td height="54" ><a href='#' class='searchopen' id='1' title='Comment'><img src="images/search.png" width="54" height="54" alt=""></a></td>
</tr>-->
<tr>
<td height="54" ><a href="logout.html"><img src="images/logout.png" width="54" height="54" alt=""></a></td>
</tr>
<tr>
<td height="54" ><a href="http://mimy.co.ke/help.html"><img src="images/help.png" width="54" height="54" alt=""></a></td>
</tr>
<!-- <tr>
<td height="54" ><a href="profile2.html"><img src="images/settings.png" width="54" height="54" alt=""></a></td>
</tr>-->
</table>
</nav>
<!-- mainContent panel -->
<script type="text/javascript">
(function() {
var $body = document.body
, $menu_trigger = $body.getElementsByClassName('menu-trigger')[0];
if ( typeof $menu_trigger !== 'undefined' ) {
$menu_trigger.addEventListener('click', function() {
$('#nav2').css('margin-bottom', '0');
$body.className = ( $body.className == 'menu-active' )? '' : 'menu-active';
});
}
}).call(this);
(function() {
var $body = document.body
, $menu_trigger = $body.getElementsByClassName('header-contX3')[0];
if ( typeof $menu_trigger !== 'undefined' ) {
$menu_trigger.addEventListener('click', function() {
$('#nav2').css('margin-bottom', '0');
$('.header-contX2').css('margin-top', '0px');
$('.header-contX').css('margin-top', '0px');
});
}
}).call(this);
</script>
<script type="text/javascript" charset="utf-8" src="js/notification.js"></script>
<script type="text/javascript" charset="utf-8" src="js/json2.js"></script>
</body>
</html>