If you run run a WordPress, you understand the potential headaches you may face when updating your plugins and themes. Do you choose to update on the fly and risk taking down your site; or do you set up a staging, keep it in sync with your live site and use that to test updates?
COURSE of the MONTH
14 days, 22 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
php search box
Posted on 2013-01-09
I have a dropdown box which is populated by a large number of list items
Can someone suggest a working php script that will carry out a predictive search when someone starts typing in the list box such that a list of possible values comes up after typing the first couple of characters
Can someone suggest a working php script that will carry out a predictive search when someone starts typing in the list box such that a list of possible values comes up after typing the first couple of characters
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
12
10
2
24 Comments
I used this and it worked perfectly
http://www.marcofolio.net/webdesign/a_fancy_apple.com-style_search_suggestion.html
http://www.marcofolio.net/webdesign/a_fancy_apple.com-style_search_suggestion.html
Active 5 days ago
you have a simple and basic demo button on the first, right click on it, choose view source
Active 4 days ago
I se the source but it accesses "status.php" and " states_abbrev.php" page. Where is the code for these ?
Active 4 days ago
Response to Roads_Roads:
http://www.marcofolio.net/webdesign/a_fancy_apple.com-style_search_suggestion.html
I have been trying to adapt this for a local database but just cannot get it to work
Any help please
http://www.marcofolio.net/webdesign/a_fancy_apple.com-style_search_suggestion.html
I have been trying to adapt this for a local database but just cannot get it to work
Any help please
Active 4 days ago
Here is the edited code for my local database
rpc.php
rpc.php
Active 5 days ago
your script return html instead a json object...
Autocomplete need something like this (here I put << ar >> in the textfield) :
http://www.jensbits.com/demos/autocomplete/states.php?term=ar
To see what your script return try your script by trying url to rpc.php directly in your web browser address bar :
http://your_site_web_address/path/to/your/application/folder/rpc.php?queryString=a
Autocomplete need something like this (here I put << ar >> in the textfield) :
http://www.jensbits.com/demos/autocomplete/states.php?term=ar
To see what your script return try your script by trying url to rpc.php directly in your web browser address bar :
http://your_site_web_address/path/to/your/application/folder/rpc.php?queryString=a
Active 5 days ago
anyway your script return HTML and not a JSON object as you saw it in the first link :
<p id="searchresults">
<span class="category">foo</span>
<a href="sdksks.php">
<img src="search_images/pic.jpg" alt="" />
<span class="searchheading">dldldl</span>
</p>
Active 5 days ago
read the first link... the part you're looking for is : PDO version:
update your code
update your code
Active 4 days ago
Comment from:
leakim971
http://www.jensbits.com/2010/03/29/jquery-ui-autocomplete-widget-with-php-and-mysql/
I have attached the files I have created from the website above but I keep getting the following error for the index page:
PHP Parse error: syntax error, unexpected '(', expecting T_VARIABLE or '$' in C:\Websites\Dreamweaver\De
All the files reside in the same folder. Can someone help please
index.php
states.php
states-abbrev.php
leakim971
http://www.jensbits.com/2010/03/29/jquery-ui-autocomplete-widget-with-php-and-mysql/
I have attached the files I have created from the website above but I keep getting the following error for the index page:
PHP Parse error: syntax error, unexpected '(', expecting T_VARIABLE or '$' in C:\Websites\Dreamweaver\De
All the files reside in the same folder. Can someone help please
index.php
states.php
states-abbrev.php
Active 5 days ago
This is Javascript code, not php...
<?php
$(function() {
$('#abbrev').val("");
$("#state").autocomplete({
source: "states.php",
minLength: 2,
select: function(event, ui) {
$('#state_id').val(ui.item.id);
$('#abbrev').val(ui.item.abbrev);
}
});
$("#state_abbrev").autocomplete({
source: "states_abbrev.php",
minLength: 2
});
});
?>
Active 5 days ago
yes, after this line :
<script src="http://ajax.googleapis.com/ajax/libs/jqueryui/1/jquery-ui.min.js"></script>
<script src="http://ajax.googleapis.com/ajax/libs/jqueryui/1/jquery-ui.min.js"></script>
Active 4 days ago
Here is the latest:
I have now managed to get the page working to the extent that when I type in more then 2 characters in the "State (abbreviaton in separate field): " text box (id=state), the text box extends downwards by as much as the number of rows it is getting from the status.php page.
The problem is that these rows show no text but if I click on one of the rows the second text box (id = abbrev) is populated but the "state" text box isn't
It is a real shame to have gone so far but not to get it working - any ideas please
index.php
states.php
I have now managed to get the page working to the extent that when I type in more then 2 characters in the "State (abbreviaton in separate field): " text box (id=state), the text box extends downwards by as much as the number of rows it is getting from the status.php page.
The problem is that these rows show no text but if I click on one of the rows the second text box (id = abbrev) is populated but the "state" text box isn't
It is a real shame to have gone so far but not to get it working - any ideas please
index.php
states.php
Active 5 days ago
when I type in more then 2 characters in the "State (abbreviaton in separate field): " text box (id=state), the text box extends downwards by as much as the number of rows it is getting from the status.php page
Thanks for this good news ! Yes, you set : minLength: 2, so it wiat for 2 chars !
please post your latests script or provide a link to see you page
Featured Post
Just getting started with Linux? Here's a quick start guide that has 7 commands that we believe will come in handy.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article discusses how to implement server side field validation and display customized error messages to the client.
There are times when I have encountered the need to decompress a response from a PHP request.
This is how it's done, but you must have control of the request and you can set the Accept-Encoding header.
The viewer will learn how to dynamically set the form action using jQuery.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
Suggested Courses
Course of the Month14 days, 22 hours left to enroll
770 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.