SHOW:
|
|
- or go back to the newest paste.
1 | //php file to get results | |
2 | $table_name = $wpdb->prefix . "leads"; | |
3 | ||
4 | $var = $_POST['employee']; | |
5 | ||
6 | $results = "SELECT * FROM $table_name WHERE employee = $var"; | |
7 | $resultat = $wpdb->get_results($results) or die(mysql_error()); | |
8 | echo json_encode($resultat); | |
9 | ||
10 | // the ajax | |
11 | ||
12 | - | <script type="text/javascript"> |
12 | + | < script type = "text/javascript" > jQuery(function($) { |
13 | - | jQuery(function($) { |
13 | + | $('#employeeName').bind('submit', function() { |
14 | - | $('#employeeName').bind('submit', function(){ |
14 | + | var data = document.getElementById("employees").value; |
15 | - | var data = document.getElementById("employees").value; |
15 | + | $.ajax({ |
16 | - | $.ajax({ |
16 | + | type: 'post', |
17 | - | type: 'post', |
17 | + | url: "http://swofficesystems.com/wp-content/themes/pnw-design/inc/leads-results-ajax.php", |
18 | - | url: "http://swofficesystems.com/wp-content/themes/pnw-design/inc/leads-results-ajax.php", |
18 | + | data: { |
19 | - | data: {employee: data}, |
19 | + | employee: data |
20 | - | datatype: 'json', |
20 | + | }, |
21 | - | success: function(json) { |
21 | + | dataType: 'json', |
22 | - | alert("search worked"); |
22 | + | success: function(json) { |
23 | - | var id = data[0];//get id |
23 | + | alert("search worked"); |
24 | - | var employee = data[1];//get employee |
24 | + | var id = json[0]; //get id |
25 | - | var company = data[2];//get company |
25 | + | var employee = json[1]; //get employee |
26 | var company = json[2]; //get company | |
27 | - | $('#output').html("<p>Lead ID: <\/p>"+id+"<p> Employee Name: <\/p>"+employee+"<p>Company Name:<\/p>"+company); |
27 | + | $('#output').html("<p>Lead ID: </p>" + id + "<p> Employee Name: </p>" + employee + "<p>Company Name:</p>" + company); |
28 | for ( | |
29 | - | for( |
29 | + | var i = 0; |
30 | - | var i = 0; |
30 | + | i < json.length - 1; |
31 | - | i < data.length-1; |
31 | + | i++) { |
32 | - | i++ |
32 | + | var item = json[i]; |
33 | - | ) |
33 | + | $('#output').html("<p>Lead ID: </p>" + id + "<p> Employee Name: </p>" + employee + "<p>Company Name:</p>" + company); |
34 | - | { |
34 | + | } |
35 | - | var item = data[i]; |
35 | + | }, |
36 | - | alert(item.Test1 + item.Test2 + item.Test3); |
36 | + | error: function() { |
37 | - | } |
37 | + | alert("Didnt Work"); |
38 | - | }, |
38 | + | } |
39 | - | error: function () { |
39 | + | |
40 | - | alert("Didnt Work"); |
40 | + | return false; |
41 | - | } |
41 | + | |
42 | - | }); |
42 | + | }); < /script> |