jquery ajax how to validate if a record exists in the db

Question

using jquery ajax i have a text field where a name is entered how can i have it where when a user enters a name ajax checks to see if the name already exists in the db and if it does a message is displayed that this name already exists and the form cannot be submitted until a name is entered that does not exist?

this would be the php

<?php
$name = $security->secure($_POST['name']) //security->secure() cleans the field
$query = $db->query("select name from table where name = '$name'");
if($db->num_rows($query) != 0) { "that record already exists"; }
//disable the form button until a name is entered that does not exist.
?>

i found a good explanation thnx: vimeo.com/4173282

Exploit
– Exploit

2010-12-07 23:55:49 +00:00
Commented Dec 7, 2010 at 23:55 — Exploit
– Exploit, Commented Dec 7, 2010 at 23:55

Rabea · Accepted Answer · 2010-12-07 23:11:22Z

2

in Jquery you can use the method $.ajax, $.post , and even $.get to make an easy ajax call example:

$(document).ready(function(){
  $.ajax({
     type: 'POST', /*the method u are using*/
     url: url, /* http://yourdomain.com/post.php */
     success: function(data){alert('Name exists')} /* What to do in case of success */
  });
});

I hope this was helpful enough to do the job for u .

answered Dec 7, 2010 at 23:11

Rabea

2,03420 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

kobe · Accepted Answer · 2010-12-07 23:02:02Z

1

@sammen

you need to use jquery ajax

http://api.jquery.com/jQuery.ajax/

send the user name to the backend , and execute your php and send a status to the UI.

on the success handler of ajax , you can call a method or show a error that name is not valid

you can use jquery ajax for this

answered Dec 7, 2010 at 23:02

kobe

15.9k15 gold badges67 silver badges93 bronze badges

Collectives™ on Stack Overflow

jquery ajax how to validate if a record exists in the db

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related