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 = data[0];//get id
- var employee = data[1];//get employee
- var company = data[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 < data.length-1;
- i++
- )
- {
- var item = data[i];
- alert(item.Test1 + item.Test2 + item.Test3);
- }
- },
- error: function () {
- alert("Didnt Work");
- }
- });
- return false;
- });
- });
- </script>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement