SAVING DATA TO DATABASE

Question

1.00/5 (3 votes)

See more:

i'm validating the user input data using jquery but i can't figure out how to save this data into my database after validation, is it posible.?

Posted 13-Oct-13 16:36pm

careLess - Eric

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Answer 1 · 2013-10-13T19:21:00

Solution 1

Submit your data, open a database connection through your service and save the database.

Posted 13-Oct-13 19:21pm

Abhinav S

Comments

careLess - Eric 14-Oct-13 2:13am

thanks, but how can i do that? this is my current code in jquery..

$( "#dialog-form" ).dialog({
autoOpen: false,
height: 300,
width: 350,
modal: true,
buttons: {
"Create an account": function() {
var bValid = true;
allFields.removeClass( "ui-state-error" );

bValid = bValid && checkLength( username, "username", 3, 16 );
bValid = bValid && checkLength (password, "password", 3, 100);
bValid = bValid && checkLength( accesslvl, "accesslvl", 1, 5 );

bValid = bValid && checkRegexp( username, /^[a-z]([0-9a-z_])+$/i, "Username may consist of a-z, 0-9, underscores, begin with a letter." );
// From jquery.validate.js (by joern), contributed by Scott Gonzalez: http://projects.scottsplayground.com/email_address_validation/
bValid = bValid && checkRegexp( password, /^([0-9a-zA-Z])+$/, "Password field only allow : a-z 0-9" );
bValid = bValid && checkRegexp( username, /^[a-z]([A-Z])+$/i, "Access Level must be consist of letters only." );

if ( bValid ) {
$( "#users tbody" ).append( "<tr>" +
"<td>" + username.val() + "</td>" +
"<td>" + password.val() + "</td>" +
"<td>" + accesslvl.val() + "</td>" +

"</tr>" );

$.ajax({
type: 'POST',
cache: false,
contentType: "application/json; charset=utf-8",
url: 'functions.php/f1',
data: "{'var1':'" + document.getElementById('username').value + "', 'var2':'" + document.getElementById('password').value + "', 'var3':'" + document.getElementById('accesslvl').value + "'}",
async: false,
success: function (response) {
$('#username').val('');
$('#password').val('');
$('#accesslvl').val('');
alert("Record Has been Saved in Database");
},
error: function ()
{ console.log('there is some error'); }
});

$( this ).dialog( "close" );
}
},
Cancel: function() {
$( this ).dialog( "close" );
}
},
close: function() {
allFields.val( "" ).removeClass( "ui-state-error" );
}
});

this is my code in functions.php:

Abhinav S 14-Oct-13 2:45am

You are using PHP, so you will open a connection in the PHP script.
http://php.net/manual/en/function.mysql-connect.php is an example using PHP with mySQL.

careLess - Eric 14-Oct-13 8:44am

yah of course i open a mysql connection and selecting dbase just dont know how can i pass this validated data through my functions.php: for me to insert.

can you help me with this part of jquery:

$.ajax({
type: 'POST',
cache: false,
contentType: "application/json; charset=utf-8",
url: 'functions.php/f1',
data: "{'var1':'" + document.getElementById('username').value + "', 'var2':'" + document.getElementById('password').value + "', 'var3':'" + document.getElementById('accesslvl').value + "'}",
async: false,
success: function (response) {
$('#username').val('');
$('#password').val('');
$('#accesslvl').val('');
alert("Record Has been Saved in Database"); },

error: function ()
{ console.log('there is some error'); } });

Abhinav S 14-Oct-13 12:14pm

Use a form instead of directly passing data.
Form.Submit should help you.