Page 1 of 1

Oracle and PHP help

Posted: Fri Nov 14, 2003 12:57 am
by wncgnet
Hi Group,

I am a new member here and new to PHP. I have read through most of the manual that comes with PHP and searched in it for my answers. I am running PHP on a Sun Box with Oracle 8i using Apache 1.3.9
My question: I want to create a form to accept a users Fname, Lname, and email for a newsletter and store this in the database, when they sign up for the newsletter though I want to be able to check and confirm that they haven’t already been added to the database (prevent duplicate entries). I have done this in Perl so it’s not entirely new to me, however doing it in PHP is. If anyone could take a minute to give me a sample of code to do this I would greatly appreciate it.

Regards,
C

Posted: Fri Nov 14, 2003 5:57 am
by devork
check this out php tutorials -> oracle
http://hotwired.lycos.com/webmonkey/programming/php/
you can also find help about oracle functions from php manual http://www.php.net/doc

Posted: Fri Nov 14, 2003 12:36 pm
by Weirdan
and you can enforce the uniqueness of the data entered on db level. I'm not familiar with Oracle so it's up to you to read the manual ;)

Posted: Sat Nov 15, 2003 2:03 am
by devork
rest of queries are according to oracle, a little practise will do the trick :)