jQuery + Ajax + PHP + database

jQuery + Ajax + PHP + database

Hi guys, I really need a hand over here!

So I have a WordPress HTML form and i have a SSN field with autocomplete, and based on the value that user inputs in that field I need to populate the rest of the form from the database which works fine when the user selects what autocomplete returns, but if the user inputs or copy pastes the SSN number into that field other fields aren't populated.

I've tried with Ajax but I have no experience in it and it doesn't seem to work.
Some help please :(

Here's some of my code

  1. $("#SSN").autocomplete({
  2.           source: "search.php",
  3.           select: function(event, ui) {
  4.               $("#SSN").val(ui.item.SSN);
  5.               $("#Name").val(ui.item.Name);
  6.               $("#Surname").val(ui.item.Name);
  7.           },
  8.           minLength: 0
  9.   });


  1. $('#SSN').live('change', function() {
  2.     //ajax request
  3.     $.ajax({
  4.         type: "GET",
  5.         url: "search.php",
  6.         data: {
  7.            'SSN': $('#SSN').val()
  8.         },
  9.         dataType: 'json',
  10.         success: function(data) {
  11.              $("#SSN").val(data);
  12.              $("#Name").val(ui.item.Name);
  13.               $("#Surname").val(ui.item.Name);
  14.         }
  15.     });
  16. });

The PHP script works fine for the autocomplete and basically doesn this (just part of the script)

  1. foreach($field as $data){
  2. if(stripos($data['SSN'], $term) !== false){
  3. $data['value'] = $data['SSN'];
  4. $data['label'] = "{$data['SSN']}, {$data['Name']} {$data['Surname']}";
  5. $matches[] = $data;
  6. }
  7. }
  8.  

  10. $matches = array_slice($matches, 0, 5);

  12. echo json_encode($matches);