tuchfeld
asked on
auto complete Web serach
Hello,
My site is Joomla (php) based. I have an Excel (xls) file
that I need to preform a Web search on it.
The search should have the fields as the columns of the table
and have the auto complete feature.
e.g. if there are fields called "Avenue" and another "Avabla".
and the user type "av" it should suggest both options.
Also, since the xsl file has many rows (> 50,000), I prefer to transform it to a different format (like Xml maybe?) and not to an SQL table.
Thanks, Aryeh.
My site is Joomla (php) based. I have an Excel (xls) file
that I need to preform a Web search on it.
The search should have the fields as the columns of the table
and have the auto complete feature.
e.g. if there are fields called "Avenue" and another "Avabla".
and the user type "av" it should suggest both options.
Also, since the xsl file has many rows (> 50,000), I prefer to transform it to a different format (like Xml maybe?) and not to an SQL table.
Thanks, Aryeh.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Ray Paseur
OK, what is your question?
ASKER
logudotcom thanks, I need to look inside.
Ray, what do you ask?
Ray, what do you ask?
I think jQuery is how Google does its auto-suggest, and if it is good enough for Google, it should meet your needs. Are we talking about Excel files (xls) or XML Style Sheets (xsl)? Why would you not want to use a data base table?
ASKER
Hi Ray, The file is .xls extension.
I'm not familiar with JQuery but it seems that this is the direction and I should study it.
as I said there are many lines (> 50,000) so transferring the xls to MySQL DB is not suitable.
It looks like I need to transfer the xls to XML file.
Thanks, Aryeh.
I'm not familiar with JQuery but it seems that this is the direction and I should study it.
as I said there are many lines (> 50,000) so transferring the xls to MySQL DB is not suitable.
It looks like I need to transfer the xls to XML file.
Thanks, Aryeh.
50,000 rows is nothing to a MySQL DB; you may be underestimating the power of MySQL. If you want to do lookups I can guarantee that the data base is a better technology than XML. XML is a markup language and that makes it suitable for data transfer but it's not the right tool for storage and retrieval.
ASKER
I agree that XML is not the best choice. I need to see if there is really a problem using MySQL to hold large number of rows table. Thanks for the discussion.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.