Results 1 to 6 of 6

Thread: Search function

  1. #1

    Thread Starter
    KrisSiegel.com Kasracer's Avatar
    Join Date
    Jul 2003
    Location
    USA, Maryland
    Posts
    4,985

    Search function

    I'm not that experience with PHP yet but what I need to ddo is create a database. It'll contain entries that have keywords, data, title, date, and an ID. I need to figure out how to search it. I've used search engines before that were so bad if you too many spaces or something stupid like that it didn't find it but google has an awesome way of searching. How could I create a search function that is at least decent?

    I don't expect a post telling me how to re-create google but links and advice would be helpful

  2. #2
    Addicted Member techwizz's Avatar
    Join Date
    Apr 2005
    Location
    U.S.A.
    Posts
    246

    Thumbs up Re: Search function

    I got you covered buddy.

    I 've created an open source program to be downloaded called EZ-DATA its web based. To see an example of it.. got to

    http://www.yourcodes.com/ezdata/

    To download the newest version of it.. go to
    http://yourcodes.com/index/modules.p...download&cid=7

    If you have any probelms. Please post all questions here.

    Hope that helped. I'd suggest getting a book if you are further interested in PHP. Its my favorite language. Very robust and there are thousands of open source programs out there for free.

    As far as a serch ability.. its wonderful.. Ive not seen any errors so far.

  3. #3
    VBA Nutter visualAd's Avatar
    Join Date
    Apr 2002
    Location
    Ickenham, UK
    Posts
    4,906

    Re: Search function

    techwizz, what exactly does your program do?

    kas, in MySql you can create a Full Text index on a field. This enables you to carry out fast searches on fields which contain text:

    http://dev.mysql.com/doc/mysql/en/fulltext-search.html
    PHP || MySql || Apache || Get Firefox || OpenOffice.org || Click || Slap ILMV || 1337 c0d || GotoMyPc For FREE! Part 1, Part 2

    | PHP Session --> Database Handler * Custom Error Handler * Installing PHP * HTML Form Handler * PHP 5 OOP * Using XML * Ajax * Xslt | VB6 Winsock - HTTP POST / GET * Winsock - HTTP File Upload

    Latest quote: crptcblade - VB6 executables can't be decompiled, only disassembled. And the disassembled code is even less useful than I am.

    Random VisualAd: Blog - Latest Post: When the Internet becomes Electricity!!


    Spread happiness and joy. Rate good posts.

  4. #4
    Addicted Member techwizz's Avatar
    Join Date
    Apr 2005
    Location
    U.S.A.
    Posts
    246

    Re: Search function

    Stores and searches data. Did you look at it?

    what I need to ddo is create a database. It'll contain entries that have keywords, data, title, date, and an ID. I need to figure out how to search it.
    I've created a database. It stores entries and he can search it. Via PHP & MySQL. It has no errors. Thats what he asked for. All he has to do is change the names of the fields in MySQL and the form to match.

    Now if he wants a search engine program that can go out and get its own data. Thats a different story.

  5. #5
    VBA Nutter visualAd's Avatar
    Join Date
    Apr 2002
    Location
    Ickenham, UK
    Posts
    4,906

    Re: Search function

    Quote Originally Posted by techwizz
    Stores and searches data. Did you look at it?



    I've created a database. It stores entries and he can search it. Via PHP & MySQL. It has no errors. Thats what he asked for. All he has to do is change the names of the fields in MySQL and the form to match.

    Now if he wants a search engine program that can go out and get its own data. Thats a different story.
    Hi, I wasn't suggesting it didn't work, I just couldn't see a description anywhere about what it was and what it did.

    Does it use full text or just a general equality search?
    PHP || MySql || Apache || Get Firefox || OpenOffice.org || Click || Slap ILMV || 1337 c0d || GotoMyPc For FREE! Part 1, Part 2

    | PHP Session --> Database Handler * Custom Error Handler * Installing PHP * HTML Form Handler * PHP 5 OOP * Using XML * Ajax * Xslt | VB6 Winsock - HTTP POST / GET * Winsock - HTTP File Upload

    Latest quote: crptcblade - VB6 executables can't be decompiled, only disassembled. And the disassembled code is even less useful than I am.

    Random VisualAd: Blog - Latest Post: When the Internet becomes Electricity!!


    Spread happiness and joy. Rate good posts.

  6. #6
    Addicted Member techwizz's Avatar
    Join Date
    Apr 2005
    Location
    U.S.A.
    Posts
    246

    Re: Search function

    MY appologies mr Ad. I misunderstood.

    It uses the the like comparison statement for the query.

    I dont know how to answer that question as i dont know the technical names for the differences. Porblably should but i dont.

    It will pick up whole words or parts or words like letter combination. Much like the Find function in internet explorer or notepad.exe.

    Thanks for letting me join your PHP forum. Very nice site.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width