JQuery Autocomplete suggestion retrieved from database

Question

I need to to do autocomplete suggestion for my thesis and the data should be retrieved from database. here is my code but it doesn't work! this is my html file.

<!DOCTYPE HTML>
<html>
<head>
<title>Fetching saved records</title>
<script src="jquery-3.2.1.js"></script>
<script src="typeahead.js"></script>
<script type="text/javascript"> </script>

 <script>
        $(document).ready(function() {

            $('input.city').typeahead({
                name: 'city',
                remote: 'samp5.php?query=%QUERY'
            });

        })
    </script>
</head>

<body>

    <form>
        Enter the name to search data:<br/>
        <input type="text" name="city" id="city" class="city"
         autocomplete="off">
            <input type="submit" name="find" id="find" value="Find Data"/>
        </form>
    </body>
    </html>

and this is my php file.

    <?php
  include "connection.php";

  if(isset($_REQUEST['query'])) {
   $query = $_REQUEST['query'];

    $sql = mysqli_query("SELECT city, area FROM tbl_loc WHERE city LIKE '%{$query}%' OR area LIKE '%{$query}%'");
      $array = array();
    while ($row = mysqli_fetch_array($sql)) {
        $array[] = array (
            'label' => $row['city'].', '.$row['area'],
            'value' => $row['city'],
        );
    }

    echo json_encode ($array);
}

  ?>

I don't know why it doesn't work cause there's no error in my codes.

console errors

Have you checked the developer console? I see one big gigantic error in your "codes". — Jay Blanchard, Aug 22 '17 at 19:02
@JayBlanchard may i ask if what is developer console? im sorry im just a beginner. — Bajongjong, Aug 22 '17 at 19:04
A bit off-topic, but your code is vulnerable to SQL injection. You have to make sure that $query doesn't contain plain apostrophe characters. — BlobbyBob, Aug 22 '17 at 19:05
That's not all @BlobbyBob. Apostophe's alone do not open the door for SQL injection. — Jay Blanchard, Aug 22 '17 at 19:06
@Bajongjong have you tried running the PHP script by itself? — Jay Blanchard, Aug 22 '17 at 19:06
@CaiqueRomero i already posted the screen shot of the console errors. — Bajongjong, Aug 22 '17 at 19:16
@CaiqueRomero i already updated the photo above. can you look at it again. thank you — Bajongjong, Aug 22 '17 at 19:56
What was the results @Bajongjong? Have you checked your web server's error logs? — Jay Blanchard, Aug 22 '17 at 21:20
@JayBlanchard there's no error in my server's error logs. i don't know why it doesn't work.. — Bajongjong, Aug 23 '17 at 02:26
You're not including a connection in `mysqli_query()` which requires 2 arguments. Your error reporting must not be on. — Jay Blanchard, Aug 23 '17 at 11:27
If an answer solved your problem, consider accepting the answer. Here's how http://meta.stackexchange.com/questions/5234/how-does-accepting-an-answer-work then return here and do the same with the tick/checkmark till it turns green. This informs the community, a solution was found. Otherwise, others may think the question is still open and may want to post (more) answers. You'll earn points and others will be encouraged to help you. *Welcome to Stack!* — Jay Blanchard, Aug 23 '17 at 11:31

score 0 · Answer 1 · answered Aug 23 '17 at 11:29

mysqli_query() requires 2 arguments, the connection and the query, i.e.:

$sql = mysqli_query($connection, "SELECT city, area FROM tbl_loc WHERE city LIKE '%{$query}%' OR area LIKE '%{$query}%'")

Warning!

Little Bobby says your script is at risk for SQL Injection Attacks. Learn about prepared statements for MySQLi. Even escaping the string is not safe!

You may want to...

Add error reporting to the top of your file(s) right after your opening <?php tag

error_reporting(E_ALL); 
ini_set('display_errors', 1);

Add error checking, such as or die(mysqli_error($connection)) to your queries and other database operations. If not, you can typically find the issues in your current error logs.

JQuery Autocomplete suggestion retrieved from database

1 Answers1

Warning!

You may want to...