Connect to DB including "mysql_select" convert to pdo

Question

This is my connect page to sql server

<?php
$user="test";
$parola="test1";
$bazadate="test";  //Numele bazei de date sql//
$host="localhost"; //In general se foloseste localhost//
mysql_connect($host,$user,$parola);
@mysql_select_db($bazadate) or die( "Nu ma pot conecta la baza ta de date! <br/ > 
Sigur ai completat userul, parola si numele bazei de date?");
?>

I've tried the down code, but i receive "No database selected":

<?php
/* SQL connect PDO */
$dsn = 'mysql:dbname=test;host=localhost';
$user = 'test';
$password = 'test1';

try {
$dbh = new PDO($dsn, $user, $password);

} catch (PDOException $e) {
echo 'Conectare SQL nereusita: ' . $e->getMessage();
}
?>

PDO class kills me completley...

yes i am receive no database selected when use second connect code (PDO) but first code works good — Domuta Marcel, Jan 15 '13 at 10:39

david strachan · Accepted Answer · 2013-01-15T13:08:52.110

2

In

$dsn = 'mysql:dbname=test;host=localhost';

the parameters are in the wrong order

The order in documentation is

$dbn = new PDO('mysql:host=$host;dbname=$bazadatet', $user, $parola);

Where

$user="test";
$parola="test1";    //table
$bazadate="test";  //Numele bazei de date sql//
$host="localhost"; //In general se foloseste localhost//

Change the order to host & dbname

edited Jan 15 '13 at 13:08

answered Jan 15 '13 at 11:57

david strachan

7,174
2
23
33

Thx David, i've plused you and for other users in my situation the correct code is: `getMessage(); } ?>` – Domuta Marcel Jan 15 '13 at 14:51

score -2 · Answer 2 · edited May 23 '17 at 11:43

-2

http://www.phpro.org/tutorials/Introduction-to-PHP-PDO.html

Taken from: Are there good tutorials on how to use PDO?

edited May 23 '17 at 11:43

Community

1
1

answered Jan 15 '13 at 10:45

John

87
4

1

Please post solutions here and not just links to them. – Sirko Jan 15 '13 at 11:15

Connect to DB including "mysql_select" convert to pdo

2 Answers2