Advertisement
Guest User

Untitled

a guest
Aug 23rd, 2016
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.53 KB | None | 0 0
  1. function searchBuy() {
  2. //alert("search Loaed");
  3. $.ajax({
  4. url: 'searchBuyCriteria.php',
  5. type: 'POST',
  6. //dataType: "json",
  7. data: {
  8. cat: $('#SelectCat').val(),
  9. MaxArea:$('#SelectMaxArea').val()
  10. }
  11. }).success(function(data){
  12. console.log("Success"+data);
  13. alert(JSON.stringify(data));
  14. }).error(function(data){
  15. console.log("Error"+data);
  16. });
  17. } </scipt>
  18.  
  19. <?php
  20.  
  21. include_once('_secure/conn.php');
  22.  
  23. $city = $_POST['SelectCity'];
  24. $cat= $_POST['SelectCat'];
  25. $rooms = $_POST['SelectRooms'];
  26. $minRange = $_POST['SelectMinRange'];
  27. $maxRange = $_POST['SelectMaxRange'];
  28. $minArea = $_POST['SelectMinArea'];
  29. $maxArea = $_POST['SelectMaxArea'];
  30.  
  31. $conn=mysql_connect(DB_HOST,DB_USER,DB_PWD,DB_NAME);
  32. mysql_select_db(DB_NAME);
  33.  
  34. $Searchqry ="Select * from tblcategory where category_title like '%".$cat."%' ";
  35. $searchExec = mysql_query($Searchqry) or die(mysql_error());
  36. $searchRow = mysql_fetch_array($searchExec);
  37. //echo $searchRow;
  38. echo json_encode($searchRow);
  39. ?>
  40.  
  41. <?php
  42. session_start();
  43. ob_start();
  44. if(!isset($path))
  45. $path="./";
  46. elseif($path=="")
  47. $path="../";
  48.  
  49. require_once("settings.inc.php");
  50. $database='srijanip';
  51. $user='srijanip';
  52. $pass='********';
  53. $host='example.*****.in';
  54.  
  55. define("DB_HOST", "$host");
  56. define("DB_NAME", "$database");
  57. define("DB_USER", "$user");
  58. define("DB_PWD", "$pass");
  59. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement