Q:
Hi,
I am a newbie to Perl scripts.
I am writing a webpage in FrontPage but also want to include Perl 5.004
scripts which access a mySQL database as I am running on a Unix server.
I have two questions:
1. I want a different thought of the day to appear on the website
everyday. I have created a mySQL database that has a table called THOUGHT
which holds 20 thoughts and each has it's own unique id which is an
autonumber. Can you help me with the Perl script I need to write for this?
2. I want to send documents to the server via the web browser interface
and input their details into the database. I know that I can't hold the
actual deocument (e.g. Word) in the database, but I can hold the path
name. I was hoping to use a form on the webpage which lets you attach a
document and enter details about it which are input into the database. On
another page I want to then be able to display the documents as hyperlinks
to open them. Do you have any idea how I can do this?
Thanks for any help you can give me.
*NAME-DELETED*
A:
Dear *NAME-DELETED*,
1. Yes I can help you, however this does not mean that I am going to write
it for you. I have no time for that. Try to write it and if you have
questions ask them and I will try to answer.
2. As a matter of fact you can store whole documents in the MySQL
database, though it may not be a good choice. I recommend that you store
the uploaded files in a directory and provide URL to those directory
programmatically or allowing the web server to browse the directory files.
Regards,
Peter
*******************
Please take your time and rate me at AllExperts.com
I ask you to do that the way you believe I deserve.
This is a feedback that I get from allexperts but
it does not affect my life in any financial way. This
is just a mental feedback.
In case you think my answer was really good and if you feel
it appropriate do not hesitate to nominate me to volunteer
of the month.
I do this job volunteer in my free time and this is all I get
as compensation.
[ back to toc ]