i need this script

Warlock

I need script where user can type something in search box and he got out result is query listed in database.Example at site cheaterhell.com.
Since that is script simple there is probaly avaible for download i just dont know what to write in search engine to found it.

Warlock

Anyone have idea?

bpat1434

One tip: Don't double post only 5.25 hours behind.

Well, have you googled for searching a database? Typically it means that you'd have to run an SQL statement against the database using what's in the $_POST array from the form.

The wildcard character for an SQL statement is "%". So a typical SQL search query looks like:

SELECT column1, column2, column3
FROM `table`
WHERE column1='%$_POST[userInput]%',
    OR column2 = '%$_POST[userInput]%',
    OR column3 = '%$_POST[userInput]%'

Warlock

I did searched on google but didnt found anything.And not sure will that code help me anything 🙁

bpat1434

Google Results:
Goo o o o ogle

Any of those links should give you examples, tutorials, or a full working library.

Warlock

bpat1434 wrote:
Google Results:
Goo o o o ogle

Any of those links should give you examples, tutorials, or a full working library.

It seems only first link gives what i need but for some reason that code gives error on line 36

bpat1434

This page gives a very good description of how to search a MySQL database with FULLTEXT indexes. As for the PHP-side of it, you can reference this article on how to search.

Essentially it boils down to this:

Enable FULLTEXT indexing on the table(s) you're going to search
Set up a search form
Set up the PHP script to receive the form
3.a. This script receives a GET or POST variable (we'll call it "q") and runs a query looking for matches in the database that have the term(s) "q" in them:
```
SELECT *, MATCH(`column`) AGAINST ('$term') as score
FROM `table`
ORDER BY score DESC
```
3.b. Print the information out on the page.

If you read the articles, and don't just copy & paste the code, you can learn how to create a truly robust search on your databases.

Horizon88

Bpat, you're way too nice to people like this. :/ "I need a script where user can type into a box and have results"....

You have no idea what you're even looking for, do you? Learn how to handle form inputs with PHP, database connecting and querying, and handling the output from database queries.

Might I recommend:

http://www.google.com/search?hl=en&q=handling+forms+with+PHP&btnG=Google+Search
http://www.google.com/search?hl=en&q=using+PHP+with+databases&btnG=Search

and possibly:
http://www.google.com/search?hl=en&q=building+a+simple+search+script+with+PHP&btnG=Search

:glare:

bpat1434

Yes, but you catch more flies with honey than vinegar.... plus... I'm paid to be nice...wait a minute!! I'm missing my last few months pay checks!! 🙂 (No, the mods here aren't paid).

Horizon88

Yeah, I know, I was just in a bad mood. I don't know how you mods can all do it though - it just wears me down sometimes seeing the same questions over and over, especially when they haven't even attempted something on their own, most times.

bpat1434

Oh, I've gone off plenty of times, but when I do go off, I step back, get off the computer (do something like play HALO 🙂) and then come back....

Warlock... did you get your question(s) answered? In case you haven't noticed, we are not a service to create scripts for you (although some "newer" and "nicer" users will); however, if you have something down, we will help you through it. You can't just copy & paste code and expect it to work. It's like talking underwater... just because you can do it, doesn't mean it's understandable 😉