Response title
This is preview!
Move this topic
[RESOLVED] jquery multiple autocomplete, remove selected item from the sql array
in Using jQuery UI
•
7 years ago
Hi Everyone,
I am new to php and sql so apologise for not being very clear.
I am doing a Multiple Answer Survey where people can select 3 of
there "best" friends.
I have all the friends name in a MySQL table.
I want people to be able to select from a very long list of names
so I have implemented autocomplete.
The issue is that I don't want them to put the same name twice.
Ideally I want the selected name not to appear on the list when
typing on the next textareas.
I came across this which does the job I want:
The only problem is that the source of my availableTags is not a
list of options, but it is another php page doing a sql query to get
all the names in a table and create a JSon array (using json_encode($return_arr))
Any idea how to implement such a thing?
All the best
Eliott
1
Replies(23)
Use $.ajax()
to retrieve the list.
Leave a comment on watusiware's reply
Thanks for this but can you tell me a bit more?
Where should i add this and how?
Leave a comment on Eliott D. Champault's reply
If you have less than 80 or so suggestions, you can just add
- var availableTags;
- $.get("yourPhp.php", function(data) {
- availableTags = data;
- })
to the top of the script.
If you want to pass a query to your PHP, it’s a bit more code.
JΛ̊KE
Leave a comment on jakecigar's reply
This will tell you not only a bit more, but everything!can you tell me a bit more?
Leave a comment on watusiware's reply
I have 5000 records...
what would this do?
- var availableTags;
- $.get("yourPhp.php", function(data) {
- availableTags = data;
- })
Leave a comment on Eliott D. Champault's reply
I have use this tuto. (in case that helps...)
Leave a comment on Eliott D. Champault's reply
No. You will need to do a more classic php query. Similar to Autocomplete |
jQuery UI
or your link. But you need to either pass all the values that have been
selected to prevent them from being in the result OR just make sure you
don’t present them to the user.
JΛ̊KE
Leave a comment on jakecigar's reply
Leave a comment on Eliott D. Champault's reply
I don't know how to get the table with name as a dataType:
"json"
You don’t need to specify a dataType if you set the header in PHP, which
you should!
JΛ̊KE
Leave a comment on Eliott D. Champault's reply
For today, you can use the code I shared. But to optimize you need to
use some more clever code. People don’t want to load 5000 records if
they can avoid it.
JΛ̊KE
Leave a comment on jakecigar's reply
I know it is not ideal but I need to have those 5000 records available
to select from.
So far my code works but you can select a name multiple time which
I need to disable...
Leave a comment on Eliott D. Champault's reply
Basically I need to do something like:
If (name already in one of
the input) do not show in the array.
Leave a comment on Eliott D. Champault's reply
Do people really have 5000 friends?
Or is this a global list of people in your system?
You do realize, I hope, that it would be easy for anybody to grab
the list. Does this violate your users privacy?
If you were Facebook, with a universe of billions of friends, you
would HAVE to do remote autocomplete. While it will introduce a slight
delay, it's commonly done and has been used with great success.
e.g. Google search suggestions.
Somewhere between 5000 and billions, your approach becomes impractical/impossible.
Leave a comment on watusiware's reply
I wouldn't show it at all.If (name already in one of the input) do not show in the array.
Nobody
wants to scroll through a list of 5000 names. And at some length it
will cause technical issues in the browser.
Just
remote auto-complete. After they type a small number of characters
(3 is typical), return the matches.
Leave a comment on watusiware's reply
I understand.
The fact that I am a newbe made me go toward this solution.
Yes it does violate the users privacy but I do not know what to do...
I have no idea what is a remote autocomplete.
The task I have been assigned is to do a Multiple Answer
questionaire where the user has to answer its close friends whithin a
list of 5000 people.
I don't really know what is the best solution for them to
select them so I started with a simple <select>.
A dropdown of 5000 names...
Then I thought about auto complete which is better but as you
mentioned, not ideal.
What to do??
PS: Thanks for helping me as I am sure this sounds very stupid...
Leave a comment on Eliott D. Champault's reply
Remote autocomplete has been solved in this forum over and over. Do a
search here, and then feel free to ask questions!
You will need to write some code on the PHP side. While we
don't generally deal with PHP code here, this one has been solved
so many times, that I'll bet you find a post with some PHP code to
go with it.
Leave a comment on watusiware's reply
Will it allow me to get the thing I am looking for?
Not being able to input same name twice?
Leave a comment on Eliott D. Champault's reply
Will it allow me to get the thing I am looking for?Not being able to input same name twice?
They
will type a few letters, get a list of choices, and pick one from the
list. You will then add it to an array. If it's already in the
array, don't add it again.
You
will probably also want to show the user the list that they have built so-far.
Leave a comment on watusiware's reply
I don't understand the bit about the textareas. What's with the
multiple textareas?
You haven't shown us any HTML, so we have to guess!
I thought we were talking about an autocomplete text input here,
not textareas.
Are you wanting a separate text input for each name?
Actually, avoiding duplicates has nothing to do with your list you
get from the server. You don't need to know the names, unless you
want to limit to THAT list. That's a completely separate problem
from avoiding duplicates.
Just add names to an array. Check first to see if the name is
already there.
If you use an object instead of an array, it's even easier.
var
selectedNames = {};
Then to add a name:
// I used a
static example here, you would get the name from the input
var name =
'John Smith';
if
(selectedNames[name]) {
alert("You
already added this name!");
} else {
selectedNames[name] = true;
}
"true" is just an
arbitrary value. It can be anything (other than false or undefined or 0!)
Leave a comment on watusiware's reply
http://jsfiddle.net/jakecigar/gupuufqc/3/ is an adaptation of my
previous fiddle that search first names. You can only choose each one
only once.
The PHP is classic PHP for jQuery autocomplete. There are many examples out there on the web.
The PHP is classic PHP for jQuery autocomplete. There are many examples out there on the web.
JΛ̊KE
Leave a comment on jakecigar's reply
Jake you are a genius! totally worked for me!
Glad you liked it. Hopefully others will find the code too.
After playing with it, I added code to turn off browser
autocomplete and spellcheck, you may want to turn them off in your code.
Leave a comment on Eliott D. Champault's reply
Change topic type
Link this topic
Provide the permalink of a topic that is related to this topic
Reply to Eliott D. Champault's question
{"z59275642":[14737000006485816,14737000006485825,14737000006485827,14737000006485829,14737000006485831,14737000006485833,14737000006485835,14737000006485837,14737000006485841,14737000006485843,14737000006485877],"z7664639":[14737000006482927,14737000006482931,14737000006482943,14737000006482945,14737000006482949,14737000006482955,14737000006482957],"z2950240":[14737000006486451,14737000006486455,14737000006486459,14737000006486457,14737000006486467,14737000006486593]}
Statistics
- 23 Replies
- 10903 Views
- 1 Followers