Re: [PHP] search array

2013-04-11 Thread tamouse mailing lists
On Thu, Apr 11, 2013 at 1:37 PM, Russell Brackett wrote: > I need help with this code to echo all items in the general database and not > just the fields I'm searching for. > > > // filter function > function cleanInput($input) { > > $search = array('OEM Name, Category, OEM N

Re: Re: [PHP] Search for string followed by whitespace

2011-09-23 Thread Daniel Brown
On Fri, Sep 23, 2011 at 13:21, Tim Streater wrote: > > Dan, > > Thanks for the suggestion but I need to know where the string occurs as I > want to then do some excision/incision. Consider preg_replace() with that same pattern. Or, at the most involved, preg_replace_callback(). -- Networ

Re: [PHP] Search for string followed by whitespace

2011-09-19 Thread Daniel Brown
On Sun, Sep 18, 2011 at 15:12, Tim Streater wrote: > At the moment, I'm doing this: > >   $start = stripos ($body, " > You'll note the space after the ' for ' $loc'th character, and returning the location of the string in $start. > > I had a look at the PCRE and POSIX regexp functions to no avail.

RE: [PHP] search is not case insensitive

2010-11-02 Thread Tommy Pham
> -Original Message- > From: tedd [mailto:tedd.sperl...@gmail.com] > Sent: Tuesday, November 02, 2010 8:09 AM > To: Tommy Pham; g...@holisticgp.com.au; php-general@lists.php.net > Subject: RE: [PHP] search is not case insensitive > > At 10:23 PM -0700 11/1

RE: [PHP] search is not case insensitive

2010-11-02 Thread tedd
At 10:23 PM -0700 11/1/10, Tommy Pham wrote: > -Original Message- From: tedd [mailto:tedd.sperl...@gmail.com] Sent: Sunday, October 31, 2010 9:00 AM To: g...@holisticgp.com.au; php-general@lists.php.net Subject: Re: [PHP] search is not case insensitive At 3:47 PM +1100 10/31

RE: [PHP] search is not case insensitive

2010-11-01 Thread Tommy Pham
> -Original Message- > From: tedd [mailto:tedd.sperl...@gmail.com] > Sent: Sunday, October 31, 2010 9:00 AM > To: g...@holisticgp.com.au; php-general@lists.php.net > Subject: Re: [PHP] search is not case insensitive > > At 3:47 PM +1100 10/31/10, Dr Michael Daly wr

RE: [PHP] search is not case insensitive

2010-11-01 Thread Tommy Pham
> -Original Message- > From: a...@ashleysheridan.co.uk [mailto:a...@ashleysheridan.co.uk] > Sent: Sunday, October 31, 2010 2:10 AM > To: Dr Michael Daly; php-general@lists.php.net > Subject: Re: [PHP] search is not case insensitive > > This isn't a php question

Re: [PHP] search is not case insensitive

2010-10-31 Thread tedd
At 3:47 PM +1100 10/31/10, Dr Michael Daly wrote: Hi Using a php search form produces a nil return on any information that is capitalised within a mysql database; retrieval is fine for non-capitalised data. Could someone tweak this please? The relevant code I think is as follows: // Description

Re: [PHP] search is not case insensitive

2010-10-31 Thread Dr Michael Daly
thanks for this Ash...I didn't really understand but I do now! unfortunately the fix didn't work, possibly bec the mysql data is in binary format (default then becomes: case sensitive). I got a 'syntax error' result I'll find a mysql forum Michael This isn't a php question but a mysql one. Tak

Re: [PHP] search is not case insensitive

2010-10-31 Thread a...@ashleysheridan.co.uk
This isn't a php question but a mysql one. Take out the lower() part of the sql statement, as like is case insensitive by default. Thanks, Ash http://www.ashleysheridan.co.uk - Reply message - From: "Dr Michael Daly" Date: Sun, Oct 31, 2010 04:47 Subject: [PHP] search is not case insens

Re: [PHP] Search Query on two tables not working (RESOLVED)

2009-07-21 Thread Miller, Terion
Yep, sure was the spacesOMG...will I ever get it... On 7/21/09 12:29 PM, "Ashley Sheridan" wrote: On Tue, 2009-07-21 at 13:24 -0400, Andrew Ballard wrote: > On Tue, Jul 21, 2009 at 1:20 PM, Miller, > Terion wrote: > > Here it is...I see where it's doing the restaurant.name LIKE statement 2x

Re: [PHP] Search Query on two tables not working

2009-07-21 Thread Ashley Sheridan
On Tue, 2009-07-21 at 13:24 -0400, Andrew Ballard wrote: > On Tue, Jul 21, 2009 at 1:20 PM, Miller, > Terion wrote: > > Here it is...I see where it's doing the restaurant.name LIKE statement 2x > > which is prob messing it up right...but in the code why is it doing that > > twice.. > > > > SELECT

Re: [PHP] Search Query on two tables not working

2009-07-21 Thread Ashley Sheridan
On Tue, 2009-07-21 at 12:59 -0400, Miller, Terion wrote: > > > On 7/21/09 11:47 AM, "Dan Shirah" wrote: > > Why isn't this working for searching? > > // Run query on submitted values. Store results in $SESSION and redirect to > restaurants.php$sql = "SELECT name, address, inDate, in

Re: [PHP] Search Query on two tables not working

2009-07-21 Thread Andrew Ballard
On Tue, Jul 21, 2009 at 1:20 PM, Miller, Terion wrote: > Here it is...I see where it's doing the restaurant.name LIKE statement 2x > which is prob messing it up right...but in the code why is it doing that > twice.. > > SELECT name, address, inDate, inType, notes, critical, cviolations, > noncri

Re: [PHP] Search Query on two tables not working

2009-07-21 Thread Ashley Sheridan
On Tue, 2009-07-21 at 10:07 -0700, Miller, Terion wrote: > > > On 7/21/09 12:04 PM, "Ashley Sheridan" wrote: > > On Tue, 2009-07-21 at 12:59 -0400, Miller, Terion wrote: > > > > > > On 7/21/09 11:47 AM, "Dan Shirah" wrote: > > > > Why isn't this working for searching? > > > > // Run query on

Re: [PHP] Search Query on two tables not working

2009-07-21 Thread Miller, Terion
Here it is...I see where it's doing the restaurant.name LIKE statement 2x which is prob messing it up right...but in the code why is it doing that twice.. SELECT name, address, inDate, inType, notes, critical, cviolations, noncritical FROM restaurants, inspections WHERE restaurants.name <> '' AN

Re: [PHP] Search Query on two tables not working

2009-07-21 Thread Dan Shirah
On Tue, Jul 21, 2009 at 12:41 PM, Miller, Terion < tmil...@springfi.gannett.com> wrote: > Turned off the redirects on the whole script and tried to the the query to > echo and these are the errors I got: > > Notice: Undefined offset: 1 in /var/www/vhosts/ > getpublished.news-leader.com/httpdocs/Re

Re: [PHP] Search Query on two tables not working

2009-07-21 Thread Miller, Terion
Turned off the redirects on the whole script and tried to the the query to echo and these are the errors I got: Notice: Undefined offset: 1 in /var/www/vhosts/getpublished.news-leader.com/httpdocs/ResturantInspections/processRestaurantSearch.php on line 89 Warning: mysql_fetch_array(): supplie

Re: [PHP] Search Query on two tables not working

2009-07-21 Thread Miller, Terion
On 7/21/09 12:04 PM, "Ashley Sheridan" wrote: On Tue, 2009-07-21 at 12:59 -0400, Miller, Terion wrote: > > > On 7/21/09 11:47 AM, "Dan Shirah" wrote: > > Why isn't this working for searching? > > // Run query on submitted values. Store results in $SESSION and redirect to > restaurants.php

Re: [PHP] Search Query on two tables not working

2009-07-21 Thread Miller, Terion
On 7/21/09 11:47 AM, "Dan Shirah" wrote: Why isn't this working for searching? // Run query on submitted values. Store results in $SESSION and redirect to restaurants.php$sql = "SELECT name, address, inDate, inType, notes, critical, cviolations, noncritical FROM restaurants, inspe

Re: [PHP] Search Query on two tables not working

2009-07-21 Thread Dan Shirah
> > Why isn't this working for searching? > > // Run query on submitted values. Store results in $SESSION and redirect > to restaurants.php$sql = "SELECT name, address, inDate, inType, > notes, critical, cviolations, noncritical FROM restaurants, inspections > WHERE restaurants.name <> ''

Re: [PHP] Search Query on two tables not working

2009-07-21 Thread Andrew Ballard
On Tue, Jul 21, 2009 at 12:26 PM, Miller, Terion wrote: > Why isn't this working for searching? Check your concatenation in the query. You need some white space padding your SQL segments, otherwise the text all starts to run together. (I had to reformat it. For some reason, most of the code snip

Re: [PHP] Search/Replace in entire database?

2009-06-15 Thread tedd
At 9:17 PM -0700 6/14/09, Chris Payne wrote: Hi everyone, I am in the middle of creating an editor where you can search and replace on an individual column in a single table then I came across something I need to be able to do but not sure how. Is it posible (And if so please how :-) to search

Re: [PHP] Search/Replace in entire database?

2009-06-15 Thread Caner Bulut
Hi Chris, MySQL introduced full - text indexing and searching capabilities back in version 3.23.23. The implementation is straightforward and easy to use — define a FULLTEXT index and use MATCH / AGAINST in the query. Consider this example: CREATE TABLE SOCIAL_EVENT ( EVENT_ID INTEGER UNSIGNE

Re: [PHP] Search functionality in website.

2008-12-29 Thread tedd
At 8:17 PM +0530 12/29/08, Tiji varghese wrote: Hi all,I would like to set up search functionality on my website. I'm using PHP and Mysql. Most of the pages contain static text in the html and is not database driven. I need some idea on how should I go about it without moving everything to data

Re: [PHP] Search functionality in website.

2008-12-29 Thread Richard Heyes
> Hi all,I would like to set up search functionality on my website. I'm using > PHP and Mysql. Most > of the pages contain static text in the html and is not database driven. I > need some idea on how > should I go about it without moving everything to database driven > functionality. You could

Re: [PHP] Search functionality in website.

2008-12-29 Thread John Corry
Or even a google search widget... Miles Thompson wrote: > On Mon, Dec 29, 2008 at 10:47 AM, Tiji varghese wrote: > ht-dig (or digg) > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Search functionality in website.

2008-12-29 Thread Miles Thompson
On Mon, Dec 29, 2008 at 10:47 AM, Tiji varghese wrote: > Hi all,I would like to set up search functionality on my website. I'm using > PHP and Mysql. Most of the pages contain static text in the html and is not > database driven. I need some idea on how should I go about it without moving > every

Re: [PHP] search for person by comparing his data with data in mysql

2008-12-20 Thread Andrew Ballard
On Sat, Dec 20, 2008 at 7:01 AM, Jochem Maas wrote: > c...@l-i-e.com schreef: >> select >> first_name like '%$first_name%' >> + 3 * last_name like '%$last_name%' >> + 7 * email = '$email' >> as score, > > that works?? I guess the expressions (e.g. email = '$email') > evaluate to bools and are au

Re: [PHP] search for person by comparing his data with data in mysql

2008-12-20 Thread Jochem Maas
c...@l-i-e.com schreef: > select > first_name like '%$first_name%' > + 3 * last_name like '%$last_name%' > + 7 * email = '$email' > as score, that works?? I guess the expressions (e.g. email = '$email') evaluate to bools and are auto-cast to ints. Im guess there needs to be some parenthesis i

Re: [PHP] search for person by comparing his data with data in mysql

2008-12-19 Thread ceo
select first_name like '%$first_name%' + 3 * last_name like '%$last_name%' + 7 * email = '$email' as score, first_name, last_name, email, person_id from person . . . order by score desc limit 10 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.

Re: [PHP] Search functionality

2008-09-24 Thread Bastien Koert
On Wed, Sep 24, 2008 at 4:47 PM, Dan Shirah <[EMAIL PROTECTED]> wrote: > Its pretty straight forward, you create a query that extracts the name >>> and id of the records with a relevant where clause created on the fly. When >>> outputing the data, each record gets created as a link that then loa

Re: [PHP] Search functionality

2008-09-24 Thread Dan Shirah
> > Its pretty straight forward, you create a query that extracts the name >> and id of the records with a relevant where clause created on the fly. When >> outputing the data, each record gets created as a link that then loads >> another page/div with the total dataset for that record. The quest

Re: [PHP] Search functionality

2008-09-22 Thread Bastien Koert
On Mon, Sep 22, 2008 at 4:07 PM, Dan Shirah <[EMAIL PROTECTED]> wrote: > Hello all, > > I'm looking for suggestions on how to create a search function within my > application. First I'll give you an overview. > > At the top of my page I have a form that contains name and date fields. > When a use

Re: [PHP] Search Suggestions

2008-08-31 Thread Jochem Maas
Dan Shirah schreef: Hello, I'm hoping to get a few good ideas on the best way to perform a search of PHP results. Currently I have a page that returns a list of collapsed customer data: Example + John Smith + Jane Doe + Robert Jones + Dale Bennett If the user clicks on a customer name it will

Re: [PHP] Search Suggestions

2008-08-27 Thread tedd
At 9:31 AM -0400 8/26/08, Dan Shirah wrote: Any ideas? Dan: Yes, a few of them. 1. Use LIMIT in your MySQL query to get the number of records provided down to a manageable size. 2. Use pagination to keep the page size to a manageable size. Here's an example: http://php1.net/b/pagination-

RE: [PHP] Search Suggestions

2008-08-26 Thread Simcha Younger
You could have (and I assume you already have) an id for each customer_name-DIV . This id should correspond to the customer id in your DB. You can then send out an AJAX request with the search term and have it return a list of the ids of the customer-DIV's to expand. A similar solution is to send

Re: [PHP] Search thoughts

2008-07-19 Thread Richard Heyes
http://framework.zend.com/manual/en/zend.search.lucene.html Nice one, thanks. -- Richard Heyes -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Search thoughts

2008-07-19 Thread Eric Butera
On Sat, Jul 19, 2008 at 4:06 PM, Richard Heyes <[EMAIL PROTECTED]> wrote: > Hi, > >> I've been playing around with the zend search lucene and it is really >> powerful too. > > Worth looking into? > > -- > Richard Heyes Most definitely. But with all that power and optional stuff comes complexity t

Re: [PHP] Search thoughts

2008-07-19 Thread Richard Heyes
Hi, I've been playing around with the zend search lucene and it is really powerful too. Worth looking into? -- Richard Heyes -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Search thoughts

2008-07-19 Thread Richard Heyes
> the entire King James Bible in a dB -- interesting read That's debateable... :-) -- Richard Heyes -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Search thoughts

2008-07-19 Thread Eric Butera
On Sat, Jul 19, 2008 at 3:40 PM, tedd <[EMAIL PROTECTED]> wrote: > At 1:56 PM -0400 7/19/08, Eric Butera wrote: >> >> >> Ever play with fulltext search? > > > Never in public. :-) > > You could throw all text into your database and then do a fulltext search to > give back the related pages -- that

Re: [PHP] Search thoughts

2008-07-19 Thread tedd
At 1:56 PM -0400 7/19/08, Eric Butera wrote: Ever play with fulltext search? Never in public. :-) You could throw all text into your database and then do a fulltext search to give back the related pages -- that would work. I think I saw that as an example in one of the books I read. PHP C

Re: [PHP] Search thoughts

2008-07-19 Thread Richard Heyes
Ever play with fulltext search? Yes, though it's not suitable in this instance. -- Richard Heyes -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Search thoughts

2008-07-19 Thread Eric Butera
On Sat, Jul 19, 2008 at 5:47 AM, Richard Heyes <[EMAIL PROTECTED]> wrote: > Hey, > > I was hoping to get some ideas on improving a sites search. Currently I have > two - not a lot but I've been thinking about this for a few minutes. > > Currently the site in question uses a very basic LIKE in MySQL

Re: [PHP] Search thoughts

2008-07-19 Thread Mark Kelly
Hi. Just noticed I replied direct rather than to the list last time, sorry about that. On Saturday 19 July 2008, Richard Heyes wrote: > How much traffic do you have and what's your hardware? Are your queries > cached and subsequently repeated? Do you pre cache common queries? I've done this kin

Re: [PHP] Search thoughts

2008-07-19 Thread Richard Heyes
I'm sure that would work, but just how many LIKE items do you want to show the user? For me, I would rather not show them anything if there is nothing on my site that matches their exact search criteria. Certainly an idea, but something like "We also found..." might be helpful in regard to typ

Re: [PHP] Search thoughts

2008-07-19 Thread tedd
At 10:47 AM +0100 7/19/08, Richard Heyes wrote: Hey, I was hoping to get some ideas on improving a sites search. Currently I have two - not a lot but I've been thinking about this for a few minutes. That'll leave a mark. :-) Currently the site in question uses a very basic LIKE in MySQL, eg

Re: [PHP] Search thoughts

2008-07-19 Thread Richard Heyes
Mark Kelly wrote: Hi. On Saturday 19 July 2008, Richard Heyes wrote: Currently the site in question uses a very basic LIKE in MySQL, eg %blah%, but naturally this finds terms such as hjkblahbjkk - which is not desired. Or such matches should be ranked lower than something that matches the exact

Re: [PHP] Search like php.net's URL thingy

2008-06-05 Thread Ryan S
great, but plagiarism is faster! - Smile, everyone loves a moron. :-) - Original Message From: Bernhard Kohl <[EMAIL PROTECTED]> To: Ryan S <[EMAIL PROTECTED]> Sent: Thursday, June 5, 2008 9:25:46 PM Subject: Re: [PHP] Search like php.net's URL thingy you should familiar

Re: [PHP] Search like php.net's URL thingy

2008-06-05 Thread Daniel Brown
On Thu, Jun 5, 2008 at 3:07 PM, Ryan S <[EMAIL PROTECTED]> wrote: > Hey, > one of the things that make the php.net site so cool is how easy it is to > find info for a function or a list of topics.. eg: > > http://php.net/arrays > http://php.net/count > [snip!] > > since i couldnt find the answer v

Re: [PHP] Search engines and cookies

2008-04-07 Thread tedd
At 3:29 PM +0200 4/7/08, Emil Edeholt wrote: Hi, Do you guys how search engines like cookies? One site I'm working on now requires the user to select which region he/she is from on the start page. That value is stored in a cookie. So without cookies you can't get past the start page. Does thi

Re: [PHP] Search engines and cookies

2008-04-07 Thread Evert Lammerts
Search engines won't come past that page. How about setting a default region when a user enters a different page then your main page? Daniel Brown wrote: On Mon, Apr 7, 2008 at 9:29 AM, Emil Edeholt <[EMAIL PROTECTED]> wrote: Hi, Do you guys how search engines like cookies? One site I'm w

Re: [PHP] Search engines and cookies

2008-04-07 Thread Daniel Brown
On Mon, Apr 7, 2008 at 9:29 AM, Emil Edeholt <[EMAIL PROTECTED]> wrote: > Hi, > > Do you guys how search engines like cookies? One site I'm working on now > requires the user to select which region he/she is from on the start page. > That value is stored in a cookie. So without cookies you can't g

Re: [PHP] Search function not working...

2008-02-01 Thread Jim Lucas
Jason Pruim wrote: So I said in another thread that I would be asking another question about functions... So here it goes, I am attempting to write a function to search the database, which used to work just fine when I wrote it without using a function (Would that be considered static?) Now tha

Re: [PHP] Search function not working...

2008-02-01 Thread David Giragosian
> > Jason, > > Untested, but try this... > > function search($searchvar, $table, $num_rows, $FName, $LName, $Add1, > $Add2) { >$qstring = "SELECT * FROM ".$table." WHERE FName like > '%$searchvar%' > or LName like '%$searchvar%' or Add1 like > '%$searchvar%' or Add2

Re: [PHP] Search function not working...

2008-02-01 Thread David Giragosian
On 2/1/08, Jason Pruim <[EMAIL PROTECTED]> wrote: > > On Feb 1, 2008, at 2:20 PM, David Giragosian wrote: > > On 2/1/08, Jason Pruim <[EMAIL PROTECTED]> wrote: > > > > [snip long explanation of problem] > > > function search($searchvar, $table, $num_rows, $FName, $LName, $Add1, > $Add2) { >

Re: [PHP] Search function not working...

2008-02-01 Thread Jason Pruim
On Feb 1, 2008, at 2:20 PM, David Giragosian wrote: On 2/1/08, Jason Pruim <[EMAIL PROTECTED]> wrote: [snip long explanation of problem] function search($searchvar, $table, $num_rows, $FName, $LName, $Add1, $Add2) { $qstring = "SELECT * FROM ".$table." WHERE FName like '% $searchvar

Re: [PHP] Search function not working...

2008-02-01 Thread David Giragosian
On 2/1/08, Jason Pruim <[EMAIL PROTECTED]> wrote: > > So I said in another thread that I would be asking another question > about functions... So here it goes, I am attempting to write a > function to search the database, which used to work just fine when I > wrote it without using a function (Woul

Re: [PHP] Search function

2007-05-09 Thread Chris
Ryan A wrote: Hey! .A little background: We have a site that has already been made.. a couple of hundred pages displayed via SMARTY templates, the site's in Swedish. The navigation and other parts except for the center is taken care of by the templates and other scripts... the center main

Re: [PHP] Search function

2007-05-09 Thread Richard Lynch
On Wed, May 9, 2007 7:34 am, Ryan A wrote: > Now they want to add a "search function" to the site... a simpe > textbox where a user enters a word or sentance and they get 20 results > per page... with a "x.xx % closest to your query" can anybody give me > basic pointers on where to start? > Any li

Re: [PHP] Search script problem

2007-01-07 Thread Jochem Maas
top posting. what sucks? - still having trouble keeping your posts on lists? if you want to put me in my place, that's fine but please keep it on list where it belongs - if only because private flames wars are so boring.

Re: [PHP] Search script problem

2007-01-07 Thread Jochem Maas
please keep it on the list. Wikus Moller wrote: > Let me repeat myself, SIMPLE, this was just the starting point. niether 'simple' or 'starting point' equate to 'ugly' or 'shit' though do they. even simple scripts deserve error checking and a managable layout. I wasn't pointing that out to make

Re: [PHP] Search script problem

2007-01-07 Thread Jochem Maas
Wikus Moller wrote: > Hi. > > I am having problems with a script I wrote which searches keywords > from a field in a mysql db table. > > It is a very simple, one-page script. My site is a toplist, very > basic, still in it's infancy. When I go to the page, key in the > keywords and press submit,

RE: [PHP] Search Results Accuracy

2006-12-18 Thread zoticaic
elcomed. TIA Jervin -- > Outsource Now | GetAFreelancer <http://www.getafreelancer.com/affiliates/shockx/> _ From: Shafiq Rehman [mailto: [EMAIL PROTECTED] Sent: Tuesday, December 19, 2006 2:07 PM To: zoticaic Subject: Re: [PHP] Search Results Accuracy Hello, Your question is not v

Re: [PHP] Search Results Accuracy

2006-12-18 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2006-12-19 09:33:02 +0800: > Hello, > > > > I'm just wondering, from a list of search results from a database query, how > do > we trim down and return the most accurate one? > > > > Hints, links and suggestions are most welcome. is this what you're looking for? ht

RE: [PHP] Search Results Accuracy

2006-12-18 Thread zoticaic
ROTECTED] Sent: Tuesday, December 19, 2006 2:07 PM To: zoticaic Subject: Re: [PHP] Search Results Accuracy Hello, Your question is not very clear, please elaborate it. btw, Are you talking about the fulltext search? -- Shafiq Rehman Sr. Web Engineer http://www.phpgurru.com <http://www.

Re: [PHP] search string

2006-07-21 Thread Andrew Kreps
You can use a regular expressions with a function called preg_match to find the values. For example, (Assuming your sql statement is $sql) preg_match("/(tbl_chassis.chasis_model LIKE \'\%[a-zA-Z0-9-]+\%\'/)", $sql, $matches); That will return $matches[0] with the matched data. Similarly, pre

RE: [PHP] Search files in a directory!

2006-01-23 Thread Richard Correia
Hey, Checkout the following example. This example lists the directory content; you can do a simple string matching. http://www.weberdev.com/get_example-1572.html Thanks, Richard Correia -Original Message- From: Nicholas Couloute [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006

[PHP] Re: PHP Search Engine

2005-11-08 Thread Nadim Attari
> HI All, > > Has anyone on here created a search engine in PHP? > > I have project to create a search engine that will search about 50K or > so pages of information on 100 or so various domain names. > > What have you all done in the past? PHPdig was a failure. > > Do you recommend any of the

[PHP] Re: PHP search

2005-06-27 Thread Jason Barnett
Bruce Gilbert wrote: Hello, I am fairly new to PHP, and I am looking to create a search functionality on a website using php. Can anyone point me to a good tutorial that can walk me through this? Between Google / Codewalkers / PHPFreaks you should be able to find something. -- NEW? | http:/

Re: [PHP] Search problem

2005-05-23 Thread Kristen G. Thorson
Jim Moseby wrote: Hi, I need to build up a search module for a shop. If I make a basic search (product title for example) it is ok. $query = "SELECT product_id FROM products WHERE title LIKE '%$title%'"; But i need an advance search for more than one field (title, description, price, wei

RE: [PHP] Search problem

2005-05-23 Thread Jim Moseby
> Hi, > > I need to build up a search module for a shop. If I make a > basic search (product title for example) it is ok. > > $query = "SELECT product_id FROM products WHERE title LIKE > '%$title%'"; > > But i need an advance search for more than one field (title, > description, price, weight

Re: [PHP] Search problem

2005-05-22 Thread Joe Wollard
I used to search the same way until someone on this list mentioned using a fulltext index in mysql. Doing this almost eliminated all my headaches with searching. Easiest way to create a fulltext index is to use phpMyAdmin. Once you've created the fulltext index on `title`,`description`,`price`,`

Re: [PHP] Search problem

2005-05-21 Thread Richard Lynch
On Sat, May 21, 2005 1:35 pm, [EMAIL PROTECTED] said: > I need to build up a search module for a shop. If I make a basic search > (product title for example) it is ok. > > $query = "SELECT product_id FROM products WHERE title LIKE '%$title%'"; > > But i need an advance search for more than one fiel

Re: [PHP] Search problem

2005-05-21 Thread Rory Browne
On 5/21/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hi, > > I need to build up a search module for a shop. If I make a basic search > (product title for example) it is ok. > > $query = "SELECT product_id FROM products WHERE title LIKE '%$title%'"; > > But i need an advance search for mor

Re: [PHP] Search Agents...

2005-04-28 Thread Richard Lynch
On Thu, April 28, 2005 3:17 pm, Nick Zukin said: > I have a request from a client that has me a little confounded. He wants > to > have a system where when someone posts a public request with certain > criteria, that criteria is then used to find established profiles/agents > that fit the criteria

Re: [PHP] Search Engine with MySQL

2005-01-25 Thread Richard Lynch
Phillip S. Baker wrote: > Greetings all, > > I just serached the records and found this topic. > This nearly answers my question but not completely. > > I have a search field and a class that I found that will explode queries > into an array based on boolean values and such. > Which is great so I g

Re: [PHP] Search engine

2005-01-20 Thread Jordi Canals
On Thu, 20 Jan 2005 14:04:44 +0200, Rosen <[EMAIL PROTECTED]> wrote: > > Hi, > Can someone recommend me a search engine script in PHP for inside one site? > http://www.phpdig.net/ Regards, Jordi -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.p

Re: [PHP] Search indexing.. Re: [PHP] Search engine

2005-01-20 Thread Greg Donald
On Thu, 20 Jan 2005 8:16:28 -0500, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Just out of curiosity.. relating to this subject.. does anyone have any good > documentation on creating your own site index so you can create your own > search engine? http://www.devshed.com/c/a/PHP/Search-This/ -

Re: [PHP] Search engine

2005-01-20 Thread Greg Donald
On Thu, 20 Jan 2005 14:04:44 +0200, Rosen <[EMAIL PROTECTED]> wrote: > Can someone recommend me a search engine script in PHP for inside one site? Use HTDig. Here's a tutorial on how to use it and how to write a PHP wrapper around the result set for total customization of the display results: ht

[PHP] Search indexing.. Re: [PHP] Search engine

2005-01-20 Thread tg-php
Just out of curiosity.. relating to this subject.. does anyone have any good documentation on creating your own site index so you can create your own search engine? That is.. do search engines like Google take every word in a web page and if you search for that specific word it has a list of a

Re: [PHP] Search engine

2005-01-20 Thread Robert Sossomon
Why not use PHP to create static pages from your dynamic info (say 5 minutes after the data is update?) and allow for the system to search the site then? I have noticed that I don't even have to do that for the search spiders from Google and yahoo to trawl my site and get everything, so maybe l

Re: [PHP] Search engine

2005-01-20 Thread Rosen
But here the problem is, that the texts in database uses from different scripts and on the search engine I should show and link to the sctipt, thath shows searched data. My idea was for search script, who explore the whole site (as generated from PHP scripts - via links ). "Ben Edwards" <[EMAIL

Re: [PHP] Search engine

2005-01-20 Thread Ben Edwards
Looks like you will have to write your own. Have a look at the scripts you have and see how they do it. One option is to write the 'static' pages into the database as well as the file system. I personaly put all content into a database and do not really have any static pages atall. Ben On Thu,

Re: [PHP] Search engine

2005-01-20 Thread Rosen
I try many scripts for searching, but they don't work how I want. The problem is, that part of site is static text ( not in database ) , other part ( products ) are in MySQL database - this part is generating from PHP scripts. "Ben Edwards" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTEC

Re: [PHP] Search engine

2005-01-20 Thread Ben Edwards
This kind of depends on what database you are using (I am asuming you mean you have a data driven site you want to search so strictly speaking it is the database that you want to search). Mysl has free text search facilities (i.e. you can pass it a number of words and it can search for them in a s

Re: [PHP] Search Engine Friendly URLs

2005-01-16 Thread Greg Donald
On Fri, 14 Jan 2005 13:46:54 -0500, Josh <[EMAIL PROTECTED]> wrote: > I am converting a site to use includes instead of a Dreamweaver template. I > want the URLs to look like this: www.my-site1234.com/contact instead of > www.my-site1234.com/default.php?p=contact. > > I found some tutorials on ed

Re: [PHP] Search Engine Friendly URLs

2005-01-15 Thread Robby Russell
On Fri, 2005-01-14 at 13:46 -0500, Josh wrote: > I am converting a site to use includes instead of a Dreamweaver template. I > want the URLs to look like this: www.my-site1234.com/contact instead of > www.my-site1234.com/default.php?p=contact. > > I found some tutorials on editing the .htaccess f

Re: [PHP] Search engine : build a new one or use an alreadry existing one ?

2004-11-08 Thread Ben Ramsey
Greg Donald wrote: I need to improve my current "search mecanism" but got stuck in a dilema : build one or use an existing engine? I recently put together a large company intranet site search using htdig and a simple php wrapper script: http://www.devshed.com/c/a/PHP/Search-This/ http://www.htdig.o

Re: [PHP] Search engine : build a new one or use an alreadry existing one ?

2004-11-08 Thread Greg Donald
On Sun, 7 Nov 2004 19:10:32 -0400, robert mena <[EMAIL PROTECTED]> wrote: > I need to improve my current "search mecanism" but got stuck in a > dilema : build one or use an existing engine? I recently put together a large company intranet site search using htdig and a simple php wrapper script: h

RE: [PHP] Search engine : build a new one or use an alreadry existing one ?

2004-11-07 Thread Nick Le Mouton
I believe swish-e does Unicode, but I'm not 100% sure Nick -Original Message- From: Sadeq Naqashzade [mailto:[EMAIL PROTECTED] Sent: Monday, 8 November 2004 2:57 p.m. To: Noodles Cc: [EMAIL PROTECTED] Subject: Re: [PHP] Search engine : build a new one or use an alreadry existin

Re: [PHP] Search engine : build a new one or use an alreadry existing one ?

2004-11-07 Thread Sadeq Naqashzade
Hi Can I use them (swish-e & HtDig) for unicode scripts? Sadeq On Mon, 08 Nov 2004 13:49:32 +1300, Noodles <[EMAIL PROTECTED]> wrote: > Curt Zirzow wrote: > > > > * Thus wrote robert mena: > > > >>Hi, > >> > >>I need to improve my current "search mecanism" but got stuck in a > >>dilema : build

Re: [PHP] Search engine : build a new one or use an alreadry existing one ?

2004-11-07 Thread Noodles
Curt Zirzow wrote: * Thus wrote robert mena: Hi, I need to improve my current "search mecanism" but got stuck in a dilema : build one or use an existing engine? My site, that uses php/smarty allows my users to browse products in a category listing or search. Currently my search only performs a 'se

Re: [PHP] Search engine : build a new one or use an alreadry existing one ?

2004-11-07 Thread Curt Zirzow
* Thus wrote robert mena: > Hi, > > I need to improve my current "search mecanism" but got stuck in a > dilema : build one or use an existing engine? > > My site, that uses php/smarty allows my users to browse products in a > category listing or search. Currently my search only performs a > 'sel

Re: [PHP] Search a word in multiple tables

2004-11-05 Thread raditha dissanayake
Phpu wrote: Hi, How can i search a specific word in 2 tables I use this but it is not working sql = "SELECT a.product_id, a.".select_language('product_name_en', 'product_name_fr').", b.brand_name FROM products_accessories as a, brands as b WHERE (a.".select_language('product_name_en', 'pro

RE: [PHP] Search a word in multiple tables

2004-11-05 Thread Murray @ PlanetThoughtful
> Hi, > How can i search a specific word in 2 tables > I use this but it is not working > > sql = "SELECT a.product_id, a.".select_language('product_name_en', > 'product_name_fr').", b.brand_name FROM products_accessories as a, brands > as b > WHERE (a.".select_language('product_name_en',

RE: [PHP] search string / query format

2004-07-09 Thread Ed Lazor
> -Original Message- > > I'm going to create a search page that accepts input similar to places > like > > Yahoo and Google. > [snip] > > Also, I've heard that MySQL's indexing can > > support some of this, but I'm not sure how much. > > Using a FULLTEXT index and searching in BOOLEAN m

Re: [PHP] search string / query format

2004-07-09 Thread John Taylor-Johnston
>>Keyword AND keyword2 >>"keyword keyword2" -keyword3 It doesn't support AND or OR but it does use - + * and others. >Consult thine manual!! (The MySQL one) ;) http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html The problem is getting a FULLTEXT to sort by relevancy. This was a real pain, un

Re: [PHP] search string / query format

2004-07-09 Thread John W. Holmes
Ed Lazor wrote: I'm going to create a search page that accepts input similar to places like Yahoo and Google. [snip] > Also, I've heard that MySQL's indexing can support some of this, but I'm not sure how much. Using a FULLTEXT index and searching in BOOLEAN mode supports the type of search stri

  1   2   3   4   >