I have 2 tables in Mysql with texts. Can Zoom Search Engine search using directly those tables?
Keyword search query in PHP MySQL table::
Read how dynamically generate SQL query based on user inputs for searching a database table · Ajax based Keyword search on MySQL table
http://www.plus2net.com/sql_tutorial/search-keyword.phpHOME |
Thanks a lot
Depending on what you already have on your site, it might take a small amount of work to set up. But yes you can search database content.
Joining MySQL database and searching results in PHP - PHP example::
Joining MySQL database and searching results in PHP - PHP example.
http://www.wellho.net/resources/ex.php4?item=h113/agents.phpHOME |
See this FAQ question for details,
http://www.wrensoft.com/zoom/support/faq_howto.html#sql
--------
David
Zoom does not create a database, at least not a mySQL database. It does create a set of index files that are in some respects like a database. I assume it is these index files that you are refering to.
The index files created by Zoom will be smaller that the mySQL database becuase the data in the index is compressed.
If you want to reduce the size of the index files further then turn off the display of the "context description" in Zoom.
All good search engines create index files to allow for the fast searching of key words. If you want a search solution that doesn't use index files and avoids any duplication of data in the mySQL database, then the best solution is to code up your own search solution using mySQL & PHP. But if you do that, it will only work for your particualar database on not for any normal HTML pages that you have.
---------
David
Thanks for the reply. I have 2 tables in mysql with a large set of texts.
I already have the list of page (like page.php?ID=X) but if I inser the list of the page in Zoom, it creates a second database with the same data!
So I have a first database and a second database created by Zoom... and I don't want that because it's a very large database :(
 Nortel Unveils Vision, Strategy for Israeli High-Performance Net
 Busy Friday Leads to Strong Close for Net Stocks
|
MySQL Database searching