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"> |
| 13 | - | jQuery(function($) {
|
| 13 | + | jQuery(function($) {
|
| 14 | - | $('#employeeName').bind('submit', function(){
|
| 14 | + | $('#employeeName').bind('submit', function(){
|
| 15 | - | var data = document.getElementById("employees").value;
|
| 15 | + | var data = document.getElementById("employees").value;
|
| 16 | - | $.ajax({
|
| 16 | + | $.ajax({
|
| 17 | - | type: 'post', |
| 17 | + | type: 'post', |
| 18 | - | 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", |
| 19 | - | data: {employee: data},
|
| 19 | + | data: {employee: data},
|
| 20 | - | datatype: 'json', |
| 20 | + | datatype: 'json', |
| 21 | - | success: function(json) {
|
| 21 | + | success: function(json) {
|
| 22 | - | alert("search worked");
|
| 22 | + | alert("search worked");
|
| 23 | - | var id = data[0];//get id |
| 23 | + | var id = data[0];//get id |
| 24 | - | var employee = data[1];//get employee |
| 24 | + | var employee = data[1];//get employee |
| 25 | - | var company = data[2];//get company |
| 25 | + | var company = data[2];//get company |
| 26 | ||
| 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 | ||
| 29 | - | for( |
| 29 | + | for( |
| 30 | - | var i = 0; |
| 30 | + | var i = 0; |
| 31 | - | i < data.length-1; |
| 31 | + | i < data.length-1; |
| 32 | - | i++ |
| 32 | + | i++ |
| 33 | - | ) |
| 33 | + | ) |
| 34 | - | {
|
| 34 | + | {
|
| 35 | - | var item = data[i]; |
| 35 | + | var item = data[i]; |
| 36 | - | alert(item.Test1 + item.Test2 + item.Test3); |
| 36 | + | alert(item.Test1 + item.Test2 + item.Test3); |
| 37 | - | } |
| 37 | + | } |
| 38 | - | }, |
| 38 | + | }, |
| 39 | - | error: function () {
|
| 39 | + | error: function () {
|
| 40 | - | alert("Didnt Work");
|
| 40 | + | alert("Didnt Work");
|
| 41 | - | } |
| 41 | + | } |
| 42 | - | }); |
| 42 | + | }); |
| 43 | ||
| 44 | - | return false; |
| 44 | + | return false; |
| 45 | - | }); |
| 45 | + | }); |
| 46 | - | }); |
| 46 | + | }); |
| 47 | - | </script> |
| 47 | + | </script> |
