[PHP] Persisting MySQL connection accross scripts

2003-11-01 Thread rich
How can I establish a connection with a MySQL database and have it persist
accross multiple script files?

I've found the mysql_pconnect() function but this doesn't seem to do the job
- which is fairly logical actually because the connection is stored in a
variable:

$connect = mysql_pconnect();

and that variable $connection won't be available in another script.

I would have thought there would be a straightforward answer to this as it
seems that its someting which must be done fairly regularly.

The only workaround I can think of is sending the username, password and
database name to every script.  But how would you do this securely?

When establishing the initial connection I got the username and password
from a form which used the method=POST method.

But if I want to have a link to a script, say 'add_item.php', how can I do
it securely?

a href=add_item.php?username=? echo($_POST['username']): ?password=?
echo($_POST['password']): ?.../a

would not use the POST method.

I could use forms for every link but this seems ridiculously
over-complicated!

Thanks in advance for any pointers!

Richard.
-- 
UEA/MUS

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Persisting MySQL connection accross scripts

2003-11-01 Thread Marek Kilimajer
First, POST method is not any safer than GET method. Just because the 
username/password combination is not in the location bar does not mean 
that it is hidden. Anyone can view the html source.

The straightforward answer to this (and it is done fairly regularly) is 
that you require() a file that reads configuration (usualy another file) 
and connects to the database, and also does other usefull things.

rich wrote:
How can I establish a connection with a MySQL database and have it persist
accross multiple script files?
I've found the mysql_pconnect() function but this doesn't seem to do the job
- which is fairly logical actually because the connection is stored in a
variable:
$connect = mysql_pconnect();

and that variable $connection won't be available in another script.n

I would have thought there would be a straightforward answer to this as it
seems that its someting which must be done fairly regularly.
The only workaround I can think of is sending the username, password and
database name to every script.  But how would you do this securely?
When establishing the initial connection I got the username and password
from a form which used the method=POST method.
But if I want to have a link to a script, say 'add_item.php', how can I do
it securely?
a href=add_item.php?username=? echo($_POST['username']): ?password=?
echo($_POST['password']): ?.../a
would not use the POST method.

I could use forms for every link but this seems ridiculously
over-complicated!
Thanks in advance for any pointers!

Richard.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php