Re: [PHP-DB] Is my Hosting service full of it?

2003-02-09 Thread Paul Chvostek
On Sat, Feb 08, 2003 at 01:13:28PM -0500, pthes wrote: Here are some claims from the hosting service: ... It is exceptionally PHP and MySQL heavy and unfortunately not the kind of application you can safely run in a shared-hosting environment. It is never safe to allow customers to upload

Re: [PHP-DB] Is my Hosting service full of it?

2003-02-09 Thread pthes
Thanks for the comments,. I'm putting some code here to hopefully get an idea of what is considered inefficient when dealing with mysql. I'm confused because all I'm doing is collecting the data from a form and writing it to the db. I have about 30 pages in the survey, so a script similar to this

RE: [PHP-DB] Is my Hosting service full of it?

2003-02-09 Thread Rich Hutchins
Beyond inspecting the posted code, are there any quality FREE tools that can monitor MySQL resource usage? I searched Google using mysql resource tools and came up with a number of tools, but all required payment. I'm figuring that if you run a monitor while testing your code locally, you'll be

Re: [PHP-DB] Confirmation e-mail

2003-02-09 Thread Addison Ellis
this is what i use. hope it helps, addison /* send email to new member */ $emess1=Thank you...\n; $emess2=Your Member ID and password are:\n; $emess3=\n\n\tID:$email\n\tPassword:$password\n\n; $emess4=Each time you submit an ad, please use your existing ID and

[PHP-DB] validate list menu selection

2003-02-09 Thread Addison Ellis
hello, what do i need to do to make sure someone has made a selection from a list menu. my foreach($HTTP_POST_VARS as $value) { if ($value == ) { unset($do); $message_new = font face=verdana size=1 color=redRequired information missing.\n

WG: [PHP-DB] Confirmation e-mail

2003-02-09 Thread [EMAIL PROTECTED]
hi, the best way for this is optin and optout method. so you can referrer if the users email exist. if the users email exists you can to assume the user is the user who would like the registration for your website. in the email you can set a link to a modul of your website. in this link you can

WG: [PHP-DB] Confirmation e-mail

2003-02-09 Thread [EMAIL PROTECTED]
hi, too please don't send password over the internet. better you ask the user if they click the link below your email. then the user get a formular and there you can ask him for his password. then you can make sure the emails wasn't read by other user. this is a secure method. andreas van loock

Re: WG: [PHP-DB] Confirmation e-mail

2003-02-09 Thread Davy Obdam
Hi Andreas, Thanks for you responce. I am also wondering how you would do that in the database, i have a table users in my MySQL database containing the users information that submitted when they registerd. Now i want to activate thier account only after they have clicked on the confirmation

[PHP-DB] RE: [PHP-WIN] Confirmation e-mail

2003-02-09 Thread Ruprecht Helms
Hi Matt Hillebrand, That sounds mighty secure, but I think he's trying to verify that the email address does indeed belong to the person creating an account. I don't think so. Normaly you identify you by typing username and password into the textfields. Sometimes the username is identical

[PHP-DB] Using CURDATE, DATE_SUB and DATE_ADD

2003-02-09 Thread Barrie Matthews
I am using the query below in attempting to control access to a web site. The idea is that today's date must be between 1 month before the start date and 1 month after the finish date. $query1 = SELECT VFT_name FROM `vft` WHERE CURDATE() DATE_SUB(VFT_date_start, INTERVAL 1 month) AND CURDATE()

[PHP-DB] Efficienty of PEAR DB

2003-02-09 Thread Hardik Doshi
Hi everyone, I have a question. How efficient a PEAR DB is? I found this information from adodb related website. http://phplens.com/lens/adodb/ I want to start implementing database abstraction layer in my applications. So i want to know which one is more efficient (PEAR DB or ADOdb?) thanks

[PHP-DB] c binary for (more securely) connecting to oracle

2003-02-09 Thread Fredrik de Vibe
Hi It's the old question all over again: How can I make my user / pass impossible to read for those who shouldn't? I've been thinking a lot the past few years about how to do this, and I've thought that one solution, a little better than keeping the information in a file in plain text, would be

[PHP-DB] Re: [PEAR-DEV] Efficienty of PEAR DB

2003-02-09 Thread Martin Jansen
On Sun Feb 09, 2003 at 04:1120PM -0800, Hardik Doshi wrote: I have a question. How efficient a PEAR DB is? I found this information from adodb related website. http://phplens.com/lens/adodb/ I want to start implementing database abstraction layer in my applications. So i want to know

RE: [PHP-DB] Confirmation e-mail

2003-02-09 Thread Ruprecht Helms
Hi Davy Obdam, [...] My question is what would be the best approach to achieve this? How is this usualy done? Storing the password in encrypted form in a database. The confirmationmail you can write with the normal mailcommand using addslashes. The securest way if the password was randomly