database search

[SomeOne]

hello,

I would like first of all to know where i can find a ready made php script that search a given mysql db and get the result organized and 2nd how can i convert an excel database (sheet) into mysql?
thank you

[sedarious]

More information needed. Do you already have a database? If so, what kind of setup does it have? Unless you have an EXTREMELY generic setup, then you are going to have to at least customize a script. MySQL.com has a lot of documentation on how to create and convert...

http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html#Database_use

[_underdog]

I think that DBTools can import an excel spread sheet. http://www.dbtools.com.br/EN/

[iDxMan]

For the excel conversion, you could save it as a CSV file and then use a myriad of tools to import. (I believe phpMyAdmin has a CSV import option)


-r

[Grizzly]

The easiest way to go from Excel => MySQL, would be to first convert it to Access format. Then, you can easily do an ODBC export through Access. The entire process is only minutes if you know what you're doing.

Good luck with it.

[SomeOne]

Thank you guys specially _underdog coz I found DBTools very usefull and has converted my excel database without any problem :) i didn't get yet any reply concerning the search script ,now that i have converted my excel to mysql where can i find an easy to use db search?
10x :)

[iDxMan]

I would suggest searching on freshmeat, sf or google.

eg:

http://freshmeat.net/projects/dadabik/?topic_id=68
http://www.google.com/search?sourceid=navclient&q=mysql+search+script+php

I build in various search methods into my apps, so I'm not sure posting code would help.

-r

[SomeOne]

thank you iDxMan the dadabik is what i'm looking for . and 10x u all for ur posts :):)