PHP website database search - mySQL query results not being displayed

Question

I am designing a website with a search bar to enter queries. However, whenever I enter a query, I get a blank page.

In index.php I have:

<?php
include_once('search.php');
?>

<head>
<title>Search</title>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  <link rel="stylesheet" type="text/css" href="style.css"/>
</head>
<body>
  <form method="POST" action="search.php">
  <input type="text" name="q" placeholder="Enter query"/>
  <input type="submit" name="search" value="Search" />
  </form>
</body>

In search.php I have

<?php
include_once('db.php'); //Connect to database
if(isset($_POST['search'])){
  $q = $_POST['q'];
  $query = mysqli_query($conn, "SELECT * FROM 'words' WHERE 'englishWord' LIKE '%$q%'");
  $count = mysqli_num_rows($query);
  if($count == "0"){
    $output = '<h2>No result found</h2>';
}else{
  while($row = mysqli_fetch_array($query)){
  $s = $row['yupikWord']; //column of results
    $output .= '<h2>'.$s.'</h2><br>';
  }
}
}
echo $output;
mysqli_close($conn);
?>

In db.php I have

<?php
$servername = "localhost";
$username = "qaneryararvik";
$password = "PASSWORD";
$database = "yupik";

// Create connection
$conn = new mysqli($servername, $username, $password, $database);
$dbcon = mysqli_select_db($conn,$database);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 
echo "Connected successfully<br>";

I am able to enter text into the search box and click the 'Search' button. When I click 'Search', all I get is a blank page that says 'Connected Successfully'. The query results do not show. What am I doing wrong?

You really shouldn't post passwords. You should delete this and start over. Even if you edit, people can see the edits. — Difster
– Difster, Commented Nov 5, 2018 at 6:02
Possible duplicate of When to use single quotes, double quotes, and back ticks in MySQL — Nick
– Nick, Commented Nov 5, 2018 at 6:03
What have you tried to debug the problem? Have you even tried to detect any error thrown by the database? — Nico Haase
– Nico Haase, Commented Nov 5, 2018 at 7:56
Remove <?php include_once('search.php'); ?> from your index.php — Nightwolf
– Nightwolf, Commented Nov 5, 2018 at 10:07

ACD · Accepted Answer · 2018-11-05 06:02:49Z

1

Quotations are wrong. Should be ` instead of ' for tables and rows:

"SELECT * FROM `words` WHERE `englishWord` LIKE '%$q%'"

answered Nov 5, 2018 at 6:02

ACD

1,4511 gold badge14 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

manish · Accepted Answer · 2018-11-05 10:56:45Z

0

In search.php should be below

include_once('db.php'); //Connect to database
$output = "";
if(isset($_POST['search'])){
   $q = $_POST['q'];
   $sql ="SELECT * FROM words  WHERE englishWord LIKE '%$q%'";

if ($result=mysqli_query($conn,$sql))
{
   while($row = mysqli_fetch_array($result)){
   $s = $row['yupikWord']; //column of results
   $output .= '<h2>'.$s.'</h2><br>';
}
   mysqli_free_result($result);
}else{
   $output = '<h2>No result found</h2>';
}
mysqli_close($conn);
}else{
   $output = '<h2>No result found</h2>';
}

echo $output;

edited Nov 5, 2018 at 10:56

answered Nov 5, 2018 at 6:24

manish

4213 silver badges9 bronze badges

1 Comment

Nico Haase Over a year ago

Please highlight the differences and explain why they could solve the problem

Collectives™ on Stack Overflow

PHP website database search - mySQL query results not being displayed

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related