RE: [PHP-DB] Weird Problem In mysql_connect();
| From: | Dave Watkinson | Date: | Fri, 31 Aug 2001 21:03:33 +0000 |
| Subject: | RE: [PHP-DB] Weird Problem In mysql_connect(); | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-12067@lists.php.net to get a copy of this message | ||
err... neither!
Originally I had
function dbConnect (){
$link =
mysql_connect("ipaddress","username","password");
}
And what I tried to do was
require('somefile');
who's contents were:
<?
$host = "ipaddress";
$user = "username";
$pass = "password";
?>
and then edit the function on the first file to show
function dbConnect (){
$link = mysql_connect($host,$user,$pass);
}
When I saw that this wasn't working, I tried to put the three variable
at the top of the file and it still wouldn't work. I think Dan's on the
case with the IP Address thing ... I'll see what I can do about users
and stuff. I'm running Win2K here :-(
Cheers
Dave
-----Original Message-----
From: Jonathan Hilgeman [mailto:jhilgeman@ecx.com]
Sent: 31 August 2001 21:55
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Weird Problem In mysql_connect();
You mean you had all this inside a function? Like:
function dbConnect ()
{
$link = mysql_connect($host,$user,$pass);
}
?
If so, did you pass $host, $user, and $pass to the function by
global-ing
them like:
function dbConnect ()
{
global $host;
global $user;
global $pass;
$link = mysql_connect($host,$user,$pass);
}
-OR-
function dbConnect ($host,$user,$pass)
{
$link = mysql_connect($host,$user,$pass);
}
- Jonathan
"Dave Watkinson" <d.watkinson@mightymatch.com> wrote in message
news:7CB9A13377EBE542BA2C8146178E8C7B0883C3@bigbertha.mmhome.co.uk...
yeah - everything's fine! All the variables are being stored, but
they're not getting passed to mysql_connect() for some really strange
reason!
:-(
I've done a temporary fix - moved the entire database connection
function to a separate file, and required that from the first required
file (!), and it's working, but the original problem has still got me
confused!!!
Dave
-----Original Message-----
From: Brunner, Daniel [mailto:daniel.brunner@duni.com]
Sent: 31 August 2001 21:32
To: Dave Watkinson
Subject: RE: [PHP-DB] Weird Problem In mysql_connect();
Hello!!
Have your tried to echo the $host??
like
$host=123.100.321.1
echo $host;
Dan
> ----------
> From: Dave Watkinson
> Sent: Friday, August 31, 2001 3:17 PM
> To: PHP-DB List (E-mail)
> Subject: [PHP-DB] Weird Problem In mysql_connect();
>
> Hey all
>
> I can connect with $conn =
> mysql_connect("IP_Address","username","password");
>
> but I can't connect with
> $host = "IP_Address";
> $user = "username";
> $pass = "password";
>
> $conn = mysql_connect($host,$user,$pass);
>
> Any ideas? All I get is "Can't connect to MySQL Server on 'localhost',
> which is kinda weird cos I'm actually specifying a (different) IP
> address in the host argument.
>
> I know it wasn't broken, but I decided to try and fix it anyways!!!
>
> TIA!
>
>
> Dave
>
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
For additional commands, e-mail: php-db-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net