JSFiddle - React, Tailwind, and code Playground
HTML
<input type="text" id="UserName" name="UserName" placeholder="Username" value="Rohit">
<input type="password" id="Password" name="Password" placeholder="Password" value="Password">
<input type="submit" id="submit" value="Log in" data-mini="true">
JavaScript
var arrcolumnName = ['UserName', 'Password'];
var tablename = 'tbl_Login'
$('#submit').click(function () {
submitForm();
});
function submitForm() {
var _UserName = $('#UserName').val();
var _Password = $('#Password').val();
var arrValue = _UserName + '|' + _Password;
var arr = arrValue.split("|");
InsertIntoTable(tablename, arrcolumnName, arr);
}
function InsertQuery(tablename, arrColumn, arrValues) {
var query = "";
query += "INSERT INTO " + tablename + " (";
for (i = 0; i < arrColumn.length; i++)
query += arrColumn[i] + ",";
query = query.substring(0, query.length - 1);
query += ") VALUES ("
for (i = 0; i < arrValues.length; i++)
query += "'" + arrValues[i] + "',";
query = query.substring(0, query.length - 1);
query += ")"
return query;
}
function InsertIntoTable(tablename, arrColumn, arrValue) {
var db = CreateDB();
var Query = InsertQuery(tablename, arrColumn, arrValue)
db.transaction(populateDB, errorDB, successDB);
function populateDB(tx) {
CreateTable(tablename, arrcolumnName, tx);
tx.executeSql(Query);
}
function errorDB(err) {
alert(err.message);
}
function successDB() {
alert('Insert Success!!!');
}
}
function CreateDB() {
var db = window.openDatabase('TrialDB1', '', 'my first database', 5 * 1024 * 1024);
return db;
}
function CreateTable(tablename, arrColumn, tx) {
var Query = CreateTableQuery(tablename, arrColumn);
tx.executeSql(Query);
}
function CreateTableQuery(tablename, arrColumn) {
var query = "";
query += "CREATE TABLE IF NOT EXISTS " + tablename + " (";
for (i = 0; i < arrColumn.length; i++)
query += arrColumn[i] + ",";
query = query.substring(0, query.length - 1);
query += ")"
return query;
}