PDO cannot connect if password contains spaces

Question

I am making a PHP website with PDO with PHP, but my DSN (for Postgresql) does not connect to the database, and Mysql is working fine.

I am trying with the password abc .

Error: a PDOException exception with the message "SQLSTATE [08006] [7] is missing" = "after" b "in the connection information line in / var / www / owncloud / pg _test.php: 11
Stack trace:
# 0 / var / www / owncloud / pg_test.php (11): PDO → __ construct ('pgsql: dbname = te ...', 'test', 'ab c')
# 1 {main}
it works!

Code example :

 <?php /** createuser -d -R -S -P test * => set password to "abc" */ $dsn = "pgsql:dbname=test;host=localhost"; $user = "test"; $psw = "abc"; try{ $db = new PDO($dsn,$user,$psw); echo "Oh gosh!\n"; }catch(PDOException $e){ echo "Error :" . $e."\n"; } $e_user = addslashes($user); $e_password = addslashes($psw); $psw = $user = null; $dsn .= ";user='$e_user';password='$e_password'"; try{ $db = new PDO($dsn,$user,$psw); echo "it working!\n"; }catch(PDOException $e){ echo "Error :" . $e."\n"; } 

Answer 1

This is an error in php ( no Bug # 62479 ) that when you try to connect to the Postgresql database with a password containing 1 or more spaces, pdo will fail to connect

you need to use as goget2me (space in password)