Menu
If I click on the button "Send", a message will be placed inside a client sql database and a notification is shown.
However, this only works if I refresh the page first!
How do I make the function to start working immediately? I've already tried to place the function "addMessage" inside the $(document).ready(function() but then the function stops working entirely. See the code below:
<script>
var db;
$(document).ready(function() {
//Opens the database
try
{
if (!window.openDatabase) {
alert('Not supported -> Please use a webkit browser');
} else {
var shortName = 'Rvpk';
var version = '1.0';
var displayName = 'The Rvpk databse';
var maxSize = 3072*1024; // = 3MB in bytes 65536
db = openDatabase(shortName, version, displayName, maxSize);
}
}
catch(e)
{
if (e == 2) {
alert("Invalid database version.");
} else {
alert("Unknown error "+e+".");
}return;
}
//If needed creates the messagetable
db.transaction(function (tx) {
tx.executeSql('CREATE TABLE IF NOT EXISTS message (id INTEGER PRIMARY KEY, name)')
});
});
//The function addMessage takes the entered message from the message inputfield and places it inside the messagetable
function addMessage(){
var message = $('input:text[name=message]').val();
db.transaction(function (tx) {
tx.executeSql("INSERT INTO message (id, name) VALUES (NULL, ?)", [message]);
});
console.log("Message "+ message +" added to database");
//Shows a notification that sending the message was a success
alert('The message has been sent');
//Update the messages
updateMessages();
}
</script>
</head>
<body>
<?php include("includes/header2.php"); ?>
<div data-role="content">
<form>
<fieldset>
<label id="messagelabel" for="message">Message:</label>
<input id="message" type="text" name="message" value="This can't go on like this">
<button onClick="addMessage()" data-theme="g">Send</button>
</fieldset>
</form>
</div>
896
asked Dec 04 '25 16:12
Please try this:
document.ready is run only on page load. Instead use it in a separate function and call that function whenever you want. copy and paste following script.
<script>
var db;
function runThis()
{
//Opens the database
try
{
if (!window.openDatabase) {
alert('Not supported -> Please use a webkit browser');
} else {
var shortName = 'Rvpk';
var version = '1.0';
var displayName = 'The Rvpk databse';
var maxSize = 3072*1024; // = 3MB in bytes 65536
db = openDatabase(shortName, version, displayName, maxSize);
}
}
catch(e)
{
if (e == 2) {
alert("Invalid database version.");
} else {
alert("Unknown error "+e+".");
}return;
}
//If needed creates the messagetable
db.transaction(function (tx) {
tx.executeSql('CREATE TABLE IF NOT EXISTS message (id INTEGER PRIMARY KEY, name)')
});
}
//The function addMessage takes the entered message from the message inputfield and places it inside the messagetable
function addMessage(){
//call db access function.
runThis();
var message = $('input:text[name=message]').val();
db.transaction(function (tx) {
tx.executeSql("INSERT INTO message (id, name) VALUES (NULL, ?)", [message]);
});
console.log("Message "+ message +" added to database");
//Shows a notification that sending the message was a success
alert('The message has been sent');
//Update the messages
updateMessages();
}
</script>
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
