Advertisement
Guest User

Untitled

a guest
Sep 22nd, 2017
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.73 KB | None | 0 0
  1. <form>
  2. <input id="search" type="text" size="30" onkeyup="showresult(this.value)" >
  3. <div id="suggest"></div>
  4. </form>
  5.  
  6.  
  7. <script>
  8. function showresult(val){
  9. if(val.trim() == ""){
  10.  
  11. }else{
  12. var xttp = new XMLHttpRequest() ;
  13. xttp.onreadystatechange = function () {
  14. try {
  15. var s = xttp.responseText ;
  16. }
  17. catch (e){
  18. window.alert(e.message) ;
  19. }
  20.  
  21. if(s.match("zerorow")){
  22. document.getElementById("suggest").innerHTML = "zero" ;
  23. }else {
  24. try {
  25. window.alert(s) ;
  26. var arr = JSON.parse(s) ;
  27.  
  28. }
  29. catch(err) {
  30. document.getElementById("suggest").innerHTML = err.message;
  31. }
  32.  
  33.  
  34.  
  35. }
  36. };
  37. xttp.open("POST" , "tst.php" ,true) ;
  38. xttp.setRequestHeader("Content-type", "application/x-www-form-urlencoded") ;
  39. xttp.send("val="+val) ;
  40. }
  41. }
  42.  
  43. <?php
  44. $servername = "localhost";
  45. $dbusername = "mamad";
  46. $dbpassword = "";
  47. $dbname = "t1" ;
  48.  
  49. // Create connection
  50. $conn = mysqli_connect($servername, $dbusername, $dbpassword , $dbname);
  51.  
  52. if (!$conn) {
  53. echo die("Connection failedddddddddd: " . mysqli_connect_error());
  54.  
  55. }else{
  56.  
  57. $val = $_POST["val"] ;
  58. $sql = "SELECT tag FROM tags WHERE tag LIKE '$val%'";
  59. $result = mysqli_query($conn, $sql);
  60.  
  61. if($result){
  62. if(mysqli_num_rows($result) > 0){
  63. $arr = mysqli_fetch_all($result , MYSQLI_NUM) ;
  64. echo json_encode($arr) ;
  65. }else{
  66. echo "zerorow" ;
  67. }
  68. }else{
  69. echo die("faileddd " . mysqli_connect_error());
  70. }
  71.  
  72. }
  73. ?>
  74.  
  75. $arr = mysqli_fetch_all($result , MYSQLI_NUM) ;
  76. echo json_encode($arr) ;
  77.  
  78. var arr = JSON.parse(s) ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement