New PDO connects to non-existing host!

Dev Shed Forums Sponsor:

October 11th, 2012, 10:15 PM

zxcvbnm

A Change of Season

Join Date: Mar 2004

Posts: 1,599

Time spent in forums: 2 Weeks 4 Days 22 h 2 m 10 sec
Reputation Power: 70

New PDO connects to non-existing host!

It is ignoring the wrong hots name (HOST) and echos connected regardless of what I assign to HOST! I am on localhost!

Please note when I change the username to a non-existing username, it fails to connect and gives me Access denied. So it is partially working!

PHP Code:


		
			
 define(HOST, 'loch??$?$?$$$$$alhost');

define(DATABASE, 'test');

define(USER, 'test');

define(PASS, '');

private function __construct()

            {

            try {

                    $this->conn = new PDO('mysql:'.HOST.'=;dbname='.DATABASE.'', USER, PASS);

                    echo "Connected";    

            }

            catch (PDOException $e)

                {

                    print "Error!: " . $e->getMessage() . "<br/>";

                    die();

                }

            }

October 11th, 2012, 11:12 PM

kicken

Wiser? Not exactly.

Dev Shed God 1st Plane (5500 - 5999 posts)

Join Date: May 2001

Location: Bonita Springs, FL

Posts: 5,654

Folding Points: 2670569 Folding Title: Super Ultimate Folder - Level 6

Time spent in forums: 2 Months 2 Weeks 2 Days 5 h 1 m 44 sec
Reputation Power: 3436

It fails to connect just fine for me when I try something like that. You do have an extra = after your host parameter.

Check your phpinfo() settings to see if something like sql.safe_mode is enabled.

__________________
Recycle your old CD's, don't just trash them

Spidermonkey Tutorial;

If I helped out out, show some love with some reputation, or tip with Bitcoins to 1N645HfYf63UbcvxajLKiSKpYHAq2Zxud

October 12th, 2012, 01:14 AM

zxcvbnm

A Change of Season

Join Date: Mar 2004

Posts: 1,599

Time spent in forums: 2 Weeks 4 Days 22 h 2 m 10 sec
Reputation Power: 70

Quote:

Originally Posted by kicken

Hey Kicken. I dont understand what you meant. I just used php.net's example:
define("CONSTANT", "Hello world.");

And sql.safe_mode is off.

October 12th, 2012, 05:31 AM

kicken

Wiser? Not exactly.

Join Date: May 2001

Location: Bonita Springs, FL

Posts: 5,654

Time spent in forums: 2 Months 2 Weeks 2 Days 5 h 1 m 44 sec
Reputation Power: 3436

I see what you did upon closer inspection

Code:

$this->conn = new PDO('mysql:'.HOST.'=;dbname='.DATABASE.'', USER, PASS);

The proper syntax for the mysql DSN is a string that looks like
mysql:host=somehost.tld;dbname=somedb

You messed up the host parameter by replacing the parameter name instead of trying to insert it's value.

Since you did not specify any host in your DSN, mysql is just going to assume localhost.

Code:

$this->conn = new PDO('mysql:host='.HOST.';dbname='.DATABASE.'', USER, PASS);

October 12th, 2012, 09:34 AM

zxcvbnm

A Change of Season

Join Date: Mar 2004

Posts: 1,599

Time spent in forums: 2 Weeks 4 Days 22 h 2 m 10 sec
Reputation Power: 70

Quote:

Originally Posted by kicken

I see what you did upon closer inspection

Code:

$this->conn = new PDO('mysql:'.HOST.'=;dbname='.DATABASE.'', USER, PASS);

Code:

$this->conn = new PDO('mysql:host='.HOST.';dbname='.DATABASE.'', USER, PASS);

AH! Good eyes! Thanks.

New PDO connects to non-existing host!

Developer Shed Advertisers and Affiliates