Guest User

Untitled

a guest
Nov 5th, 2018
130
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.15 KB | None | 0 0
  1. <?php
  2. include_once('search.php');
  3. ?>
  4.  
  5. <head>
  6. <title>Search</title>
  7. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  8. <link rel="stylesheet" type="text/css" href="style.css"/>
  9. </head>
  10. <body>
  11. <form method="POST" action="search.php">
  12. <input type="text" name="q" placeholder="Enter query"/>
  13. <input type="submit" name="search" value="Search" />
  14. </form>
  15. </body>
  16.  
  17. <?php
  18. include_once('db.php'); //Connect to database
  19. if(isset($_POST['search'])){
  20. $q = $_POST['q'];
  21. $query = mysqli_query($conn, "SELECT * FROM 'words' WHERE 'englishWord' LIKE '%$q%'");
  22. $count = mysqli_num_rows($query);
  23. if($count == "0"){
  24. $output = '<h2>No result found</h2>';
  25. }else{
  26. while($row = mysqli_fetch_array($query)){
  27. $s = $row['yupikWord']; //column of results
  28. $output .= '<h2>'.$s.'</h2><br>';
  29. }
  30. }
  31. }
  32. echo $output;
  33. mysqli_close($conn);
  34. ?>
  35.  
  36. <?php
  37. $servername = "localhost";
  38. $username = "qaneryararvik";
  39. $password = "yupik9lang";
  40. $database = "yupik";
  41.  
  42. // Create connection
  43. $conn = new mysqli($servername, $username, $password, $database);
  44. $dbcon = mysqli_select_db($conn,$database);
  45.  
  46. // Check connection
  47. if ($conn->connect_error) {
  48. die("Connection failed: " . $conn->connect_error);
  49. }
  50. echo "Connected successfully<br>";
  51.  
  52. "SELECT * FROM `words` WHERE `englishWord` LIKE '%$q%'"
  53.  
  54. <?php
  55. // comment these two line when page started working fine
  56. error_reporting(E_ALL);
  57. ini_set('display_errors',1);
  58.  
  59. include_once('db.php');
  60. if(isset($_POST['search'])){
  61. $q = $_POST['q'];
  62. $query = mysqli_query($conn, "SELECT yupikWord FROM 'words' WHERE 'englishWord' LIKE '%$q%'") or die(mysqli_error($conn));
  63. $count = mysqli_num_rows($query);
  64. if($count == "0"){
  65. $output = '<h2>No result found</h2>';
  66. }else{
  67. while($row = mysqli_fetch_assoc($query)){
  68. $s = $row['yupikWord']; //column of results
  69. $output .= '<h2>'.$s.'</h2><br>';
  70. }
  71. }
  72. }
  73. echo $output;
  74. mysqli_close($conn);
  75. ?>
  76.  
  77. <?php
  78. $servername = "localhost";
  79. $username = "qaneryararvik";
  80. $password = "yupik9lang";
  81. $database = "yupik";
  82.  
  83. // Create connection
  84. $conn = mysqli_connect($servername, $username, $password, $database) or die(mysqli_connect_error()); // use either procedural or object-oriented approach
Add Comment
Please, Sign In to add comment