Re: [PHP] connecting to mysql db

2003-03-25 Thread Chris Hayes
At 14:49 25-3-2003, you wrote: hi, I am trying to play and learn php along with mysql and I have a question about connecting to a db. Is the following code necessary on every php page where I am retrieving some data from a db or is there any way to connect once (something like index.php) and have t

Re: [PHP] connecting to mysql db

2003-03-25 Thread skate
leaving the connection open creates security questions, and also leaves resources open, what if a user closes his browser window, how do you know to close the connection? if you really want to make it simple, you can edit your php.ini to have the username and password as default in there, but a

RE: [PHP] connecting to mysql db

2003-03-25 Thread Mirco Ellis
: Tuesday, March 25, 2003 16:03 To: [EMAIL PROTECTED] Subject: RE: [PHP] connecting to mysql db But is it always necessary to do this or can you open this connection once and have it open throughout the next few pages (or as needed) and then close it? > -Original Message- > From: Mirco

RE: [PHP] connecting to mysql db

2003-03-25 Thread Jon Haworth
Hi Iggy, > I mean the difference between having that code on > every page or calling it from an external page > doesn't tell me if it is realy necessary to do it > all the time. Yes, you do have to connect to the database in every script that needs to access it. Usually this is done at the st

RE: [PHP] connecting to mysql db

2003-03-25 Thread Mirco Ellis
No dude. Create a file called whatever.inc that includes the code that you are using to connect to the db. In every php script ,that needs this connection to the db, you simply put: Mirco Ellis I-Soft Solutions e-mail: [EMAIL PROTECTED] Tel: +27414847161 -Original Message- From: Iggy [

Re: [PHP] connecting to mysql db

2003-03-25 Thread Iggy
This really doesn't explain me much. I mean the difference between having that code on every page or calling it from an external page doesn't tell me if it is realy necessary to do it all the time. I guess I am looking for more generic explanation of the whole process rather than what you said. Ho

RE: [PHP] connecting to mysql db

2003-03-25 Thread Rankin, Randy
Place the code in a file ( ie; dbcon.php ) and include that file in any page which may need it using an include statement: include("dbcon.php"); Randy -Original Message- From: Iggy [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 7:50 AM To: [EMAIL PROTECTED] Subject: [PHP] connec