search

How can I use a php array in a mysql search query?

I was going to use the scuttle solution on: http://www.pui.ch/phred/archives/2005/04/tags-database-schemas.html for handling searches on my website. I was wondering how I could take the search input from a user and turn it into a single query. For instance, let's say a user inputted 'blue dogs' in their search query... How could I dyna...

how so select similarities in MySQL?

Currently, I am doing a search function. Lets say in my database, I have this data: Keyword1 Keyword2 Keyword3 Keysomething Key and the user entered: "Key" as the keyword to search. This is my current query: Q1: SELECT * FROM data WHERE (data_string LIKE '$key%' OR data_string LIKE '%$key%' OR data_string LIKE '...

How to get search results in XML format

Hi, I am planning to make an iPhone search app. the user types in the search string. the string will be searched by some search engines like Google, Live, Yahoo ... I need to get the search result in the XML format. Is there any way to do this. Help needed. Please. Thanks and regards, Shibin ...

Sharepoint - Discussion replies show as ‘Dispform.aspx’ in search results

In a sharepoint search search, the results page shows 'dispform.aspx' as the page title on replies to discussion posts. Ideally i'd want it to say 'RE: discussion title'. Does anyone have any idea how to achieve this? EDIT - should probably point out that we have dozens of discussion forums and new ones are being created all the time....

Situations to prefer Apache Lucene over Solr?

There are several advantages to use Solr 1.4 (out-of-the-box facetting search, grouping, replication, http administration vs. luke, ...). Even if I embed a search-functionality in my Java application I could use SolrJ to avoid the HTTP trade-off when using Solr. Is SolrJ recommended at all? So, when would you recommend to use "pure-Luc...

Searching a column containing CSV data in a MySQL table for existence of input values

Hi, I have a table say, ITEM, in MySQL that stores data as follows: ID FEATURES -------------------- 1 AB,CD,EF,XY 2 PQ,AC,A3,B3 3 AB,CDE 4 AB1,BC3 -------------------- As an input, I will get a CSV string, something like "AB,PQ". I want to get the records that contain AB or PQ. I realized that we've to write a MyS...

Is there any loopholes or facilities not available in Endeca?

We are evaluating an ecommerce site as part of our academic project/casestudy. We are from India. We don't have access to any Endeca Systems or any enterprise systems. we use only internet for the details. We have few basic questions as part of our study. Is Endeca the best or the Solr? Do the people who have implemented Endeca satisfi...

Vim: search and replace across multiple lines with conversion to lower case

Hi! Here's what I'd like to do, for each one of many files: search for all occurrences of "<a href" then begin block selection select until the first occurrence of ">" convert the entire match to lowercase Thanks again, Olivier Pons ...

Spotlight search with PHP

Hi. I want to add a spotlight search functionality - search results being displayed with rich contents like thumbnail etc in a drop down menu changing on each keyup event - just like the apple.com search - to a site, having data in MySQL InnoDB tables. So basically that is displaying search results based on the part of the query that has...

Javascript searcing and replacing?

I want to change a string which start 'a' and end 'n'. For example: "action" I want to replace 'ctio' and all starting 'a' and finishing 'n' with ''. How can do it? ...

IE Address bar search. I need to add a list of other results at the end of current result list.

Currently, if you type in the address bar in IE, you see a dropdown list of url search results depending on what you type. I'd like any hint, anything, about how to access the address bar object throught a BHO in C++, so that i can append url results from my bho at the end the current list. Thank you. If anyone need precisions, please as...

TreeMap - Search Time Complexity

What is the time complexity of a get() and put() in a TreeMap? Is the implementation same as a Red-Black Tree? ...

Hiding ListViewItem based on a filter

I want to hide some items based on a text filter in a ListView (WinForms). Basically the listview loads the items from a text file, and I don't want it to be read and/or written when the user searches the list. The search is done in a combobox's KeyDown event, but there is no "Visible" property of the ListViewItem. Is there any easy way...

How to search for closest value in a lookup table?

I have a simple one dimmensional array of integer values that represent a physical set of part values I have to work with. I then calculate and ideal value mathematically. How could I write an efficient search algorithm that will find the smallest abosulte difference from my ideal value in the array? The array is predetermined and con...

Are there any context-sensitive code search tools?

I have been getting very frustrated recently in dealing with a massive bulk of legacy code which I am trying to get familiar with. Say I try to search for a particular function call, I get loads of results that turn out to be completely irrelevant; some of them are easy to spot, eg a comment saying // Fixed functionality in foo() so d...

Storing Video and Indexing Content

Revisiting this in case someone has a suggestion: I've been asked to either create or find a system that meet the following requirements... 1) Allow upload of video files - Current solution: PHP to upload to a directory above the web root, and then I'll verify users before allowing access to stream. 2) Tag the files with meta info abo...

jQuery table filter with text, checkboxes, selects

Need to filter a table from outside of the table, with a text search, checkboxes, and selects. PicNet Table Filter for jQuery works for both searching and using checkboxes outside of the table... though I can't find any examples of how to get a select box to work. Anyone know? *I might be getting too specific here, but thought I'd at le...

How to get related / similar search results?

Hello Guys! What's the best way in ASP.NET MVC to get a few questions related to the current question (like on stackoverflow) without using tags? ...

Transform Search String into FullText Compatible Search String?

I'm working with the fulltext search engine of MSSQL 2008 which expects a search string like this: ("keyword1" AND "keyword2*" OR "keyword3") My users are entering things like this: engine 2009 "san francisco" hotel december xyz stuff* "in miami" 1234 something or "something else" I'm trying to transform these into fulltext e...

How to handle XML string %Like% search in C#

Hi, As I know I can search DB with Sql syntax %like%. Now I am working with XML, how can I handle the same search condition for XML file in C#? I want to search the string and find it with part of the Keyword. Not the full text of keyword. <bookstore> <book genre="autobiography"> <title>The Autobiography of Benjamin F...