Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //php file to get results
- $table_name = $wpdb->prefix . "leads";
- $var = $_POST['employee'];
- $results = "SELECT * FROM $table_name WHERE employee = $var";
- $resultat = $wpdb->get_results($results) or die(mysql_error());
- echo json_encode($resultat);
- // the ajax
- < script type = "text/javascript" > jQuery(function($) {
- $('#employeeName').bind('submit', function() {
- var data = document.getElementById("employees").value;
- $.ajax({
- type: 'post',
- url: "http://swofficesystems.com/wp-content/themes/pnw-design/inc/leads-results-ajax.php",
- data: {
- employee: data
- },
- dataType: 'json',
- success: function(json) {
- alert("search worked");
- var id = json[0]; //get id
- var employee = json[1]; //get employee
- var company = json[2]; //get company
- $('#output').html("<p>Lead ID: </p>" + id + "<p> Employee Name: </p>" + employee + "<p>Company Name:</p>" + company);
- for (
- var i = 0;
- i < json.length - 1;
- i++) {
- var item = json[i];
- $('#output').html("<p>Lead ID: </p>" + id + "<p> Employee Name: </p>" + employee + "<p>Company Name:</p>" + company);
- }
- },
- error: function() {
- alert("Didnt Work");
- }
- });
- return false;
- });
- }); < /script>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement