By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,245 Members | 1,271 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,245 IT Pros & Developers. It's quick & easy.

possible to create an interface with mysql with perl?

100+
P: 170
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
Apr 2 '08 #1
Share this Question
Share on Google+
11 Replies


eWish
Expert 100+
P: 971
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
Apr 2 '08 #2

100+
P: 170
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
Apr 2 '08 #3

eWish
Expert 100+
P: 971
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
Apr 2 '08 #4

100+
P: 170
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
:)
Apr 2 '08 #5

100+
P: 170
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
:)
Apr 2 '08 #6

100+
P: 170
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
Expand|Select|Wrap|Line Numbers
  1. MySQLMan can not find the mysql.cfg config file.
  2.  Please edit mysql.cgi and set $SCRIPT_PATH to the directory where MySQLMan resides. 
  3. 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.
  4.  
any idea what's the problem?
i just figure how to use apache from the net only
Apr 2 '08 #7

eWish
Expert 100+
P: 971
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
Apr 3 '08 #8

100+
P: 170
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 :)
Apr 3 '08 #9

eWish
Expert 100+
P: 971
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
Apr 3 '08 #10

100+
P: 170
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
Apr 3 '08 #11

100+
P: 170
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
Apr 3 '08 #12

Post your reply

Sign in to post your reply or Sign up for a free account.