JSFiddle - React, Tailwind, and code Playground

by Ranganadh Paramkusam

HTML

<script src=""http://192.168.34.53/iPad/R&D/nagendra_akula/180612/database.js></script>
<script>
    function_caller = new Array();
    $(document).ready(function(){
        Database = {
    logged_userid : "",
    logged_username : "",
    logged_password : "",    
    createDatabase : function() {
        db.transaction(function (tx) {
            var user_table = 'CREATE  TABLE  IF NOT EXISTS "user" ("userid" INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE  , "Firstname" varchar, "Lastname" varchar, "Username" varchar, "Password" varchar,"email_id" varchar, "eStatus" text)';
            tx.executeSql(user_table);
        });
    },
    init : function() {
        
        try {
            db = openDatabase(database_name, database_version , database_display_name , (database_size * 1024 * 1024));
        } catch ( err ) {
            alert(err.message)
        }
        
        db.transaction(function (tx) {
                       
                       $tmp_sql = "SELECT name FROM sqlite_master WHERE type='table' AND name='user'";
                       
                       tx.executeSql($tmp_sql, [], function (tx, results) {
                                     if ( results.rows.length == 0 ) {
                                        Database.createDatabase();
                                     }
                        });
                       //SELECT name FROM sqlite_master WHERE type='table' AND name='table_name';
                       });
    },
    insert : function ( $sql , $callBack ) {
        try {
            var ValueArr = new Array();
            if ( typeof($sql) == 'object') {
                //create sql
                $tmp_array = $sql.insert_array;
                var tmpKey;
                tmpQArr = new Array();
                tmpKeyArr  = new Array();
                tmpValArr = new Array();
                for ( tmpKey in $tmp_array) {
                    tmpKeyArr.push(tmpKey);
                   ...

CSS

table{
    margin:0px auto;
    width:50%;
    text-align:center;
}