Auto Complete

Question

spluskhan -2 Junior Poster

11 Years Ago

Hello Every One.

i have a database name products
id
Pr_name
price etc

I want auto complete script that they retrive product name from (Pr_name).
i want that my search enging display auto name from my database.

php seo

Edited 11 Years Ago by spluskhan because: spelling

5 Contributors
29 Replies
472 Views
6 Days Discussion Span
Latest Post 11 Years Ago Latest Post by spluskhan

All 29 Replies

diafol

11 Years Ago

So what do you want? You want us to write code for you? Where's your code?

This is my Search Code:

That's not code, it's markup, and use CSS if possible instead of inline styling. If you post your php code, we can have a look at it.

diafol

11 Years Ago

Like I said, that's markup, not 'code'. It doesn't actually do anything, just display a searchbox/button. I'm referring to your php/mysql code. Where's that? That's what we need to see in order to help you with any difficulties that you may be experiencing.

So, post your code...

diafol

11 Years Ago

Well, this is a help forum, but it's mainly to help you with your own code. It's not expected of contributors to write code from scratch.

How about you look at the php.net manual or look at some online php tutorials to get started? There are hundreds of tutes out there.

here's a starter for mysqli to make a db connection: http://uk3.php.net/manual/en/mysqli.construct.php

t_thakar 0 Newbie Poster

11 Years Ago

does the above code give you results..?
i mean does it output product name, good price, ... etc?

if not could it be mysql_select_db("table") or die(mysql_error());
you should have database name where you written table?

Edited 11 Years Ago by t_thakar because: spelling mistake

diafol

11 Years Ago

http://www.jqueryautocomplete.com/jquery-autocomplete-php-mysql-json-example.html

http://beski.wordpress.com/2009/11/20/jquery-php-mysql-ajax-autocomplete/

http://www.simonbattersby.com/blog/jquery-ui-autocomplete-with-a-remote-database-and-php/

http://devmanuals.com/tutorials/php/autocomplete.html

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

spluskhan -2 Junior Poster · Answer 1 · 2013-03-12T19:02:57+00:00

This is my Search Code:

<div id="wb_Form2" style="position:absolute;width:483px;height:112px;">
<form name="search" method="get" action="db1.php" id="Form2" onsubmit="return Validatesearch(this)">
<input type="text" id="Editbox8" style="position:absolute;left:11px;top:17px;width:456px;height:38px;line-height:38px;z-index:18;" name="query" value="" autocomplete="off" input type="text" name="query">
<input type="submit" id="Button3" name="" value="Add" style="position:absolute;left:192px;top:71px;width:96px;height:37px;z-index:19;">
</form>
</div>

spluskhan -2 Junior Poster · Answer 2 · 2013-03-12T19:36:00+00:00

Thats my search code.
i have one other code which is for print search data.

spluskhan -2 Junior Poster · Answer 3 · 2013-03-12T20:25:46+00:00

spluskhan -2 Junior Poster

11 Years Ago

i didn't have any code thats why i need help..

spluskhan -2 Junior Poster · Answer 4 · 2013-03-13T05:17:35+00:00

This is my search code ....

<html>
<body>
<head>
<font size="3"><strong>
<?php // Connects to your Database 
    mysql_connect("host", "user", "pass") or die(mysql_error());
    mysql_select_db("table") or die(mysql_error());
$q = mysql_real_escape_string($_GET['query']);
$data = mysql_query("SELECT * FROM Products where name LIKE '%$q%'")
    or die(mysql_error()); 
    while($info = mysql_fetch_array( $data ))
    { 
echo "Product Name: $info[name]<br>";
echo "Good Price: $info[good]<br>";
echo "Poor Price: $info[poor]<br>";
echo "Faculty Price: $info[faulty]<br><br>";
    } 
    ?>

spluskhan -2 Junior Poster · Answer 5 · 2013-03-13T08:04:36+00:00

spluskhan -2 Junior Poster

11 Years Ago

ys its ok

spluskhan -2 Junior Poster · Answer 6 · 2013-03-13T08:05:42+00:00

my prob is just auto complete or suggestion in search blank

spluskhan -2 Junior Poster · Answer 7 · 2013-03-13T10:48:26+00:00

spluskhan -2 Junior Poster

11 Years Ago

any bdy have any idea

diafol · Answer 8 · 2013-03-13T23:42:26+00:00

There are loads of scripts available online, without having to write one from scratch (or ask contributors to write one) - e.g. http://www.htmlblog.us/jquery-autocomplete

Googled: "autocomplete php mysql"

skkishor 0 Newbie Poster · Answer 9 · 2013-03-14T05:11:25+00:00

skkishor 0 Newbie Poster

11 Years Ago

Thanks diafol, the link you provided was useful

spluskhan -2 Junior Poster · Answer 10 · 2013-03-14T06:15:47+00:00

spluskhan -2 Junior Poster

11 Years Ago

ok i'm checking

spluskhan -2 Junior Poster · Answer 11 · 2013-03-16T05:29:47+00:00

spluskhan -2 Junior Poster

11 Years Ago

this is not helping

spluskhan -2 Junior Poster · Answer 12 · 2013-03-16T12:28:02+00:00

spluskhan -2 Junior Poster

11 Years Ago

it didn't show anything

diafol · Answer 13 · 2013-03-16T13:20:24+00:00

it didn't show anything

What didn't? The tutorials were not whta you wanted or you couldn't get the scripts to work?
Unless you post your updated code with errors/problems, we don't know what you're trying.

spluskhan -2 Junior Poster · Answer 14 · 2013-03-17T11:44:48+00:00

Thgis is Scripts:

autocompletemain.php

<?php
$host="host.com"; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name=""; // Database name


    $con = mysql_connect($host,$username,$password)   or die(mysql_error());
    mysql_select_db($db_name, $con)  or die(mysql_error());

$q = strtolower($_GET["q"]);
if (!$q) return;

$sql = "select Products name as name from name where name LIKE '%$q%'";
$rsd = mysql_query($sql);
while($rs = mysql_fetch_array($rsd)) {
    $cname = $rs['name'];
    echo "$cname\n";
}
?>

And Form

<?php
session_start();
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>

<title>jQuery Autocomplete Plugin</title>
<script type="text/javascript" src="js/jquery-1.4.2.js"></script>
<script type='text/javascript' src="js/jquery.autocomplete.js"></script>
<link rel="stylesheet" type="text/css" href="js/jquery.autocomplete.css" />

<script type="text/javascript">
$().ready(function() {
    $("#course").autocomplete("autoCompleteMain.php", {
        width: 260,
        matchContains: true,
        //mustMatch: true,
        //minChars: 0,
        //multiple: true,
        //highlight: false,
        //multipleSeparator: ",",
        selectFirst: false
    });
});
</script>
</head>
<body>
<h2 id="banner">Autocomplete using jQuery, Ajax, PHP</h1>
<div id="content">
    <form autocomplete="off">
        <p>
            Enter Language Name <label>:</label>
            <input type="text" name="name" id="name" />
        </p>
        <input type="submit" value="Submit" />
    </form>
</div>
</body>
</html>

spluskhan -2 Junior Poster · Answer 15 · 2013-03-17T11:45:11+00:00

spluskhan -2 Junior Poster

11 Years Ago

its show nothing

spluskhan -2 Junior Poster · Answer 16 · 2013-03-17T15:52:00+00:00

spluskhan -2 Junior Poster

11 Years Ago

it show blank

diafol · Answer 17 · 2013-03-17T23:31:50+00:00

Have you tried out a dummy page with this script, e.g.

In your php page, just have:

<?php

echo "boo\nfoo\nbar";

?>

Also, look at the console to see if you have any js issues. If using Chrome, this can be found with right-click > 'Inspect element' > 'Console'

spluskhan -2 Junior Poster · Answer 18 · 2013-03-18T04:10:53+00:00

spluskhan -2 Junior Poster

11 Years Ago

ys its ok

diafol · Answer 19 · 2013-03-18T06:35:04+00:00

OK you're problem seems to be the php/mysql then. Fix it and it should work.

spluskhan -2 Junior Poster · Answer 20 · 2013-03-18T10:11:00+00:00

spluskhan -2 Junior Poster

11 Years Ago

no prob there i re chked it 2 times

diafol · Answer 21 · 2013-03-18T14:19:11+00:00

so if autocomplete js is working with hard coded php and your php/mysql is working (tested by you), sorry I'm lost, can't see any reason why your code won't work.

IIM 163 Master Poster · Answer 22 · 2013-03-18T15:28:37+00:00

there is difference in the name of the file.While calling "M" is capital of autocompletemain.php
```
$("#course").autocomplete("autoCompleteMain.php", {
```
2nd problem is of the id "course" that you are using

Instead of "course" ,it should be the id of textbox i.e,"name".

Replace this,
```
 $("#course").autocomplete("autoCompleteMain.php", {
```
with
```
 $("#name").autocomplete("autoCompleteMain.php", {
```
Replace the two problems,and hope autocomplete is working.If still there is problem do ask along with the error.

Also keep note of first point.Either change file name or change it here.

spluskhan -2 Junior Poster · Answer 23 · 2013-03-19T10:28:06+00:00

thankx for your suggestions prob was in database. but here is some ting that you gyz provide help.

i hhave my own form this is code: (searchform.php)

<div id="wb_Form2" style="position:absolute;width:483px;height:112px;">
<form name="search" method="get" action="db1.php" id="Form2" onsubmit="return Validatesearch(this)">
<input type="text" id="Editbox8" style="position:absolute;left:11px;top:17px;width:456px;height:38px;line-height:38px;z-index:4;" name="query" value="" autocomplete="off" input type="text" name="query">
<input type="submit" id="Button3" name="" value="Add" style="position:absolute;left:192px;top:71px;width:96px;height:37px;z-index:5;">
</form>
</div>

And this is jave script form (javascript.php)

<?php
session_start();
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>

<title>Autocomplete</title>
<script type="text/javascript" src="js/jquery-1.4.2.js"></script>
<script type='text/javascript' src="js/jquery.autocomplete.js"></script>
<link rel="stylesheet" type="text/css" href="js/jquery.autocomplete.css" />

<script type="text/javascript">
$().ready(function() {
    $("#name").autocomplete("autoCompleteMain.php", {
        width: 260,
        matchContains: true,
        //mustMatch: true,
        //minChars: 0,
        //multiple: true,
        //highlight: false,
        //multipleSeparator: ",",
        selectFirst: false
    });
});
</script>
</head>
<body>
<h2 id="banner">Autocomplete</h1>
<div id="content">
    <form autocomplete="off">
        <p>
            Enter Product Name <label>:</label>
            <input type="text" name="name" id="name" />
        </p>
        <input type="submit" value="Submit" />
    </form>
</div>
</body>
</html>

My Prob is i want to implement my autosearch java function into my own form code (searchform.php)

spluskhan -2 Junior Poster · Answer 24 · 2013-03-19T10:30:54+00:00

spluskhan -2 Junior Poster

11 Years Ago

what kind of changes i do ?

Auto Complete

Recommended Answers Collapse Answers

All 29 Replies

Recommended Answers