Have php/mysql experience & want to make a few $$$?

fs5

Lifer
Jun 10, 2000
11,774
1
0
if you want to do it yourself and are any bit tech savvy you could try to use phpmyadmin.
It is a basic web interface into any mysql database. Simply export your excel file to .csv and then import it w/ phpmyadmin. Then it gives you a nice query page to look up information int he tables.

http://www.phpmyadmin.net/home_page/index.php

demos available on that site also.
 

esun

Platinum Member
Nov 12, 2001
2,214
0
0
Can I do it in Perl instead of PHP? If so, let me know. I like coding in Perl so it'd be more for fun than for pay (though a little compensation would be nice). Seems like an easy project, anyway.
 
Mar 8, 2005
126
0
0
Yeah, sounds like a relatively easy project with PHP and MySQL. As for updating and expanding the databases, it wouldn't be too hard to create a form that will insert new data into the table (or you could just do it in phpmyadmin).
 

esun

Platinum Member
Nov 12, 2001
2,214
0
0
You actually could just update the Excel file and run a script to extract the data again. Perl has some libraries for getting data from an Excel file, so assuming the format was relatively unchanged it should be pretty easy. (Presumably you wouldn't want to do the search queries directly on it, though, since that'd be slow.)
 

imported_KuJaX

Platinum Member
May 29, 2004
2,428
0
0
The problem is that I don't think he wants to sit there within phpmyadmin (doesn't know any mysql query codes???)

I think, what he is asking, is that he wants a page where he can select the criteria visually (drop down boxes) and click "search" and it will bring the query to him. I may be wrong.
 

oz838

Junior Member
Jul 20, 2007
2
0
0
List the column titles/headers, and some sample data please, so that somebody can start on the project immediately.