possible to create an interface with mysql with perl?

[poolboi]

hi all,

i'm in the process of exploring mysql database and need to design it at a later stage
but just a query,
i know perl has modules that can link to mysql database
but is it possible for perl to create a program such that a user accessing the database need only to input fields he wants to query when prompted by the program, say for eg:

a) user name
b) date and time duration
c) activities

'cos i'm thinking of designing one so that a user accessing the database avoid as much of mysql statement as possible
thanks

[eWish]

It sounds like you are after phpMyAdmin or MySQLman. Which are third party software that already does what you want.

Can it be done in perl? Yes, MySQLMan is written in perl.

--Kevin

[poolboi]

wow..that's cool
there's like so many support software for mysql

i found like..
mySQL admin which comes with mySQL, navicat for mysql, sqlyog

but still requires you to pay to use but worth considering

hm..alright
then i know there's modules like DBI and sort
these also helps to take out data from yr databases right?
if u were to want to do some simple programming yrself that is

[eWish]

The DBI is very useful, I just don't see the need to rewrite a program that works well and has a bigger support community than I can offer myself. At least for the tasks that you are wanting. I have been using MySQLMan for about 5 years now and love it. I also use phpMyAdmin too.

--Kevin

[poolboi]

ok great
it's free right? cos i saw this demo and buy it portion
hm..how do i get it installed? i just download the zip file for version 1.09
:)

[poolboi]

i guess i really need an installation guide
the only clue i get is i've downloaded the zip file
and from there
i have no idea how to install mysqlman
thanks
:)

[poolboi]

The DBI is very useful, I just don't see the need to rewrite a program that works well and has a bigger support community than I can offer myself. At least for the tasks that you are wanting. I have been using MySQLMan for about 5 years now and love it. I also use phpMyAdmin too.

--Kevin

hm....
i got this msg when i was loading my cgi script into my browser
[CODE=text]
MySQLMan can not find the mysql.cfg config file.
Please edit mysql.cgi and set $SCRIPT_PATH to the directory where MySQLMan resides.
Error Message was: Can't locate mysql.cfg in @INC (@INC contains: C:/Program Files/Apache Software Foundation/Apache2.2/cgi-bin C:/perl/site/lib C:/perl/lib .) at C:/Program Files/Apache Software Foundation/Apache2.2/cgi-bin/mysql.cgi line 3175.
[/CODE]

any idea what's the problem?
i just figure how to use apache from the net only

[eWish]

It appears that the mysql.cfg file is not where it is expecting it to be. Make sure that you have uploaded that file is the same place where mysql.cgi resides.

--Kevin

[poolboi]

alright it's done...
hm..now they say i got some libraries missing
haha..
does mySQLman require the GT::CGI and GT::Template module?
'cos i think they did a check on both these modules?
i'm using perl version 5.10 anyway :)

[eWish]

Im my experience I just uploaded the files in the directories that they were included in at the time of download. Then it worked. Have you read the readme file?

It should be a real simple installation. I could almost do it in my sleep. :)

--Kevin

[poolboi]

yup
they updated it i guess
they removed the cgi.pm and use the GT libraries instead now

well i just discovered the GT libraries are downloaded together with the mysqlman file
but i dunno how to install them into perl

[poolboi]

hey kevin i got it figured out
some of my pathname was specified correctly it's working now

anyway i tried the mySQLman it's really great
just a question though about exporting

cos i realise exporting to excel file, there's things like delimitor and escape character i'm not sure what they do

but do they help ya to export data say eg. into excel into each of excels cells? cos when i tried exporting as per default settings, the data were all lump together in excel and not in neat cells