Jquery and PHP , autocomplete

Question

So i just found out about the jquery auto complete and i would like to add it to my web-page. I want to hook it up to my php code so i can search my sql database. However Whenever i try to run my auto complete,it doesnt seem to find the php array im passing ( im just trying to get an array to work for now) . Can someone help?

Jquery Code

<!doctype html>
<html lang="en">
<head>
  <meta charset="utf-8">
  <title>jQuery UI Autocomplete - Default functionality</title>
  <link rel="stylesheet" href="//code.jquery.com/ui/1.11.4/themes/smoothness/jquery-ui.css">
  <script src="//code.jquery.com/jquery-1.10.2.js"></script>
  <script src="//code.jquery.com/ui/1.11.4/jquery-ui.js"></script>
  <script>
  $(function() {
    $( "#tags" ).autocomplete({
      source: "test.php"
    });
  });
  </script>
</head>
<body>

<div class="ui-widget">
  <label for="tags">Tags: </label>
  <input id="tags">
</div>


</body>
</html>

PHP code

<?php
    $data[] = array(
        'c++','Java','JavScript',"c#" );
echo json_encode($data);
?>

Are you sure it is ` $data[] = array( 'c++','Java','JavScript',"c#" );` and not ` $data = array( 'c++','Java','JavScript',"c#" );` — Stefan
– Stefan, Commented Jul 7, 2015 at 22:20
I actually had the [], just didn’t copy it over correctly. That didn’t work — Andrew Kralovec
– Andrew Kralovec, Commented Jul 7, 2015 at 22:35
And you can have it as $data = array( 'c++','Java','JavScript',"c#" ); BTW — Andrew Kralovec
– Andrew Kralovec, Commented Jul 7, 2015 at 22:41
I think your issue is in your javascript not handling correctly. See my answer below. — visevo
– visevo, Commented Jul 7, 2015 at 22:51

Community · Accepted Answer · 2017-05-23 12:21:42Z

1

This is an updated version of your answer which should resolve the deprecated SQL driver and the injection issue. You need to replace the SECOND_COLUMNNAME with your actual column's name. Aside from that I think this should work.

<?php
try {
    $dbh = new PDO('mysql:host=localhost;dbname=DB','username','password');
} catch (PDOException $e) {
    print "Error!: " . $e->getMessage() . "<br/>";
    die();
}
if(empty($_REQUEST['term']))
    exit();
//require_once('connect.php'); connection to db is in this file so connection is not needed
$query =  'SELECT name, SECOND_COLUMNNAME FROM locations 
        WHERE name 
        LIKE ?
        ORDER BY id ASC 
        LIMIT 0,10';
$stmt = $dbh->prepare($query);
$stmt->execute(array(ucfirst($_REQUEST['term']) . '%'));
$data = array();
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $data[] = array(
                'label' => $row['name'],
                'value' => $row['SECOND_COLUMNNAME']
                );
}
echo json_encode($data);
flush();

Links:

http://php.net/manual/en/pdo.prepared-statements.php
http://php.net/manual/en/pdo.connections.php
https://www.owasp.org/index.php/SQL_Injection_Prevention_Cheat_Sheet
How can I prevent SQL injection in PHP?

Also not sure if there was anything else inside connect.php, you might need to bring that back.

edited May 23, 2017 at 12:21

CommunityBot

11 silver badge

answered Jul 7, 2015 at 23:45

chris85

23.9k7 gold badges36 silver badges51 bronze badges

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

1 Comment

Andrew Kralovec Over a year ago

When i added $stmt = $dbh->prepare($query); $stmt->execute(array(ucfirst($_REQUEST['term']) . '%')); $data = array();. I wasn’t working

Pratik Soni · Accepted Answer · 2015-07-07 22:25:37Z

1

The array pattern used here should be as below.

<?php
$data = array(
    array("value"=>'C++'),
    array("value"=>'Java'),
    array("value"=>'Javascript'),
    array("value"=>'C#'),
);
echo json_encode($data);

answered Jul 7, 2015 at 22:25

Pratik Soni

2,57618 silver badges26 bronze badges

7 Comments

Andrew Kralovec Over a year ago

It works, but it shows all the elements, instead of the elements that contain the same letters

Andrew Kralovec Over a year ago

Also tried $data = array( "value"=>'C++', "value"=>'Java', "value"=>'Javascript', "value"=>'C#' ); This only returned c# whenever i type in anything

Pratik Soni Over a year ago

That will never work. The value key will be overwritten every time and you will get only last value.

Pratik Soni Over a year ago

I think you need to perform search here.

Pratik Soni Over a year ago

Yes sure. Do you use database here? If you are retrieving data from database table then use similar query according to you. $term = trim(strip_tags($_GET['term'])); $qstring = "SELECT * FROM your_tbl WHERE language LIKE '%".$term."%'";

|

visevo · Accepted Answer · 2015-07-07 22:50:14Z

1

If you're using PHP >= 5.4:

$data = [
    [ 'value' => 'C++' ],
    [ 'value' => 'Java' ],
    [ 'value' => 'Javascript' ],
    [ 'value' => 'C#' ]
];
echo json_encode( $data );

Here's a working example of my autocomplete code:

function get_data(type, target, min_length )
{
    $(target).autocomplete({
        source: function( request, response ) {
            var submit = {
                term: request.term,
                type: type
            };
            $.ajax({
                url: '/request/get',
                data: { thisRequest: submit},
                dataType: "json",
                method: "post",
                success: function( data ) {
                    response($.map( data.Data, function( item ) {

                        return {
                            label: item.label,
                            value: item.label
                        }
                    }));
                }
            });
        },
        minLength: min_length
    })
}

answered Jul 7, 2015 at 22:50

visevo

8618 silver badges25 bronze badges

3 Comments

visevo Over a year ago

Did you post your entire javascript handler?

Andrew Kralovec Over a year ago

Yup, maybe this cant be done by passing array by php

visevo Over a year ago

It can because I use it all the time. Your javascript is wrong. You're echoing a JSON string when autocomplete is looking for a javascript array.

ryrysz · Accepted Answer · 2015-07-07 22:39:27Z

0

<?php
    $data = array(
        'c++',
        'Java',
        'JavScript',"c#" );
echo json_encode($data);
?>

answered Jul 7, 2015 at 22:39

ryrysz

9075 silver badges11 bronze badges

2 Comments

Andrew Kralovec Over a year ago

Nope, will return everything no matter what you type in

ryrysz Over a year ago

because this code return 4 values - You must write some PHP code to filter results :D

Andrew Kralovec · Accepted Answer · 2015-07-07 23:06:56Z

-1

So i want with Pratik Soni advice and did a search. Here is the php code if anyone wants to use it

<?php
// Connect to server and select databse.
$dblink = mysql_connect('localhost','username','password') or die(mysql_error());
mysql_select_db('DB');
?>

<?php
if(!isset($_REQUEST['term']))
exit();
require('connect.php');
  $term = 
  $query = mysql_query('
SELECT * FROM locations 
WHERE name 
LIKE "'.ucfirst($_REQUEST['term']).'%" 
ORDER BY id ASC 
LIMIT 0,10', $dblink
  );
  $data = array();
  while($row = mysql_fetch_array($query, MYSQL_ASSOC)){
        $data[] = array(
    'label' => $row['name'],
    'value' => $row['name'],
   );   
 }
 echo json_encode($data);
  flush();

answered Jul 7, 2015 at 23:06

Andrew Kralovec

5114 silver badges13 bronze badges

3 Comments

chris85 Over a year ago

This is open to SQL injections and using the deprecated mysql_ functions.

Andrew Kralovec Over a year ago

Thanks for this , i would love some suggestions to make it better if you have any.

visevo Over a year ago

Start here: php.net/manual/en/book.mysqli.php and get to know it very well.

Collectives™ on Stack Overflow

Jquery and PHP , autocomplete

5 Answers 5

1 Comment

7 Comments

3 Comments

2 Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

7 Comments

3 Comments

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related