RE: Oracle web application

Aida - Now that you have described your situation more clearly, I would second the advice you received from Sean - use PHP if you can. While this task can be accomplished with just about any language, with some choices you will spend a lot of time getting everything set up. And you probably would have to use more than one language to accomplish some aspects. PHP was pretty much designed for quick Web pages and database interactivity. Some people here have been very successful with it. As a bonus, it sounds like you are already pretty accomplished in PHP. May the force be with you! (guess which movie I saw this weekend).
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Monday, May 20, 2002 10:29 AM
To: Multiple recipients of list ORACLE-L

Hi Dennis, my name is Aida, (my fault about this)

Keith is my husband (I love to bother him).

Thank you for answering to me, I really appreciate it.

Let me explain more clear the situation.

I am a graduate student at Stephen F. Austin State University in computer science department.

I will graduate next summer. As part of my graduation the department has assigned me the project

of Computer Science Programming Contest that is done every year. The way the contest is organized

is this: There is a web site in which the student can register in teams of 3 or 4, they need to give their info

(first name, last name, phone, class, address, for each member, the name of the team) and a user name

and password is assigned to each team so they can come back and change it at any time.

At the contest day, to each time is given their account on TITANS and password and directions how

they can send their answers back by mail form their account to the jury. Every team-member can program in

C, C++ or COBOL (languages that are taught at our university). After the e-mail is sent, the judge sends

back the result of the answer.

The way that is done until last time is this. A faculty member used the PHP to make the registration and

humans do all the other part. (this is what they want to avoid mainly and this time I think they are

going to use also UNIX accounts for students)

I took an oracle class (is the first time that is offered) this spring and they assigned me to do this project using oracle.

I have learned SQL and PL/SQL and some of the basics of Oracle. I have designed some web sites before

with forms, but never any one in interaction with the user and a database. That's why I need help for basically

everything. (even for the general concept). Should I still use PHP or is there any better choice? This is my first

big question right now but to tell you the truth I have everything under question mark. But one thing at a time

and I am hunting around to get more comfortable with this problem.

Thank you very much for your time

AIDA

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Sunday, May 19, 2002 9:03 PM

> Keith - Usually you need to create some sort of application that will
> respond to user requests, extract data from Oracle, and format an HTML
page
> to send back to the user. That is basically what you described in your
> email. How that program interfaces to Oracle will depend on what
programming
> language you choose. Usually your program is executed by a software called
a
> "web server" or an "application server". Before you need to worry about
> Oracle, you need to learn a lot more about Web programming. If by "web"
you
> mean the Internet, then you also need to learn about Web security. If your
> application is within your company intranet, then this concern isn't so
> significant.
> Suggestions: Find someone in your company that is an experienced Web
> programmer, and discuss your situation with them. That will teach you a
lot
> quicker.
> Go to http://www.google.com, and type terms like "HTML Tutorial". A
> good site I found was http://www.mcli.dist.maricopa.edu/tut/. This won't
> teach you about connecting to a database, but you've got learn the basics
> before you progress on to advanced topics.
> http://www.computerworld.com/departments/technology/quickstudies offers
> explanations of some of the important concepts so simple even a manager
can
> understand.
> If you encounter more specific questions, write back
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
>
> -----Original Message-----
> Sent: Saturday, May 18, 2002 11:43 AM
> To: Multiple recipients of list ORACLE-L
>
>
> hi,
> I am a beginner in Oracle and I need help.
> I need to implement a interactive connection of oracle with web. I need to
> save data from web to database, make a kind of processing and send a
> response to the web. I have no idea even how to make the implementation.
Can
> somebody help me ?
>
> Thanks
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Keith Carney
> INET: kcarney_at_cox-internet.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Keith Carney
  INET: kcarney_at_cox-internet.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).