I can not connect to mySQL database

[TheCop]

Hi, I apologize in advance for my English.
I bought the fifth edition of the Italian version of the book by Kevin Yank "Build Your Own Website Using PHP And MySQL Database".
I followed the guide in the appendix to manually install in Linux, I use Ubuntu 12.10, MySQL and PHP.
Understood to 4 explains how to connect to a database, created in advance, via PDO.
Shows the result of the following script:

<?php
	try
	{
		$pdo = new PDO('mysql:host=localhost;dbname=ijdb', 'ijdbuser', 'mypassword');
		$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
		$pdo->exec('SET NAMES "utf-8"');
	}
	
	catch (PDOException $e)
	{
		$output = 'Impossibile connettersi al server di database: ' .
		$e->getMessage();
		include 'output.html.php';
		exit();	
	}
	
	$output = 'Connessione al database stabilita.';
	include 'output.html.php';

I get the following error:
Impossibile connettersi al server di database: could not find driver

How can I fix?

[Rubble]

I would guess PDO is not installed or activated.

I found this on the web somewhere:

<?php
// Is PDO installed?
if (!defined('PDO::ATTR_DRIVER_NAME')) {
echo 'PDO is unavailable<br/>';
}
elseif (defined('PDO::ATTR_DRIVER_NAME')) {
echo 'PDO is available<br/>';
}

[TheCop]

I would guess PDO is not installed or activated.

I found this on the web somewhere:

`php

<?php
// Is PDO installed?
if (!defined('PDO::ATTR_DRIVER_NAME')) {
echo 'PDO is unavailable
';
}
elseif (defined('PDO::ATTR_DRIVER_NAME')) {
echo 'PDO is available
';
}

`

Running the script posted by you visualize this:
PDO is available

[Rubble]

That is a supprise; I wonder if the mysql driver is missing or not setup.

[TheCop]

To configure PHP I used the following command:

./configure --prefix=/usr/local/php --with-apxs2=/usr/local/apache2/bin/apxs --with-mysqli=/usr/local/mysql/bin/mysql_config

It is possible that I should recompile using

--with-mysql=/usr/local/mysql/bin/mysql_config

instead

--with-mysqli=/usr/local/mysql/bin/mysql_config

[TheCop]

Could be a problem of phpMyAdmin

I just downloaded and extracted the tar.gz file from the site http://www.phpmyadmin.net/home_page/downloads.php and I extracted the directory on my localhost.

[Rubble]

I am not sure as I have never had to do it but you are using Mysql on this line not mysqli:

$pdo = new PDO('mysql:host=localhost;dbname=ijdb', 'ijdbuser', 'mypassword');

[TheCop]

How do I use mysqli?

[TheCop]

If I run this script:

<?php
				
					$mysqli = new mysqli("localhost", "ijdbuser", "mypassword", "ijdb");
					if ($mysqli->connect_errno) {
					    echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
					}
					echo $mysqli->host_info . "\
";
					
					$mysqli = new mysqli("127.0.0.1", "ijdbuser", "mypassword", "ijdb", 3306);
					if ($mysqli->connect_errno) {
					    echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
					}
					
					echo $mysqli->host_info . "\
";
					
				?>

I get the following result:

Localhost via UNIX socket 127.0.0.1 via TCP/IP

[pssingh1001]

Hi All;

you can try this code...

<?php
// Create connection
$con=mysqli_connect("example.com","peter","abc123","my_db");

// Check connection
if (mysqli_connect_errno($con))
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
?>

thanks

[SpacePhoenix]

If I run this script:

`php

<?php

$mysqli = new mysqli("localhost", "ijdbuser", "mypassword", "ijdb");
if ($mysqli->connect_errno) {
echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}
echo $mysqli->host_info . "\
";

$mysqli = new mysqli("127.0.0.1", "ijdbuser", "mypassword", "ijdb", 3306);
if ($mysqli->connect_errno) {
echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}

echo $mysqli->host_info . "\
";

?>

`

I get the following result:

Localhost via UNIX socket 127.0.0.1 via TCP/IP

That proves that you're able to connect to the mysql server ok.

To get PDO going:

[LIST=1]
[*]Run this script

<?php phpinfo(); ?>

[*]With the output from the script in step 1 look for the line "Loaded Configuration File"
[*]Open up the file called php.ini that is located at the location given in "Loaded Configuration File"
[*]Find a line that reads

extension=php_pdo_mysql.dll
there is probably a ; at the start of that line, remove the ; from the start of that line and save the file.
[*]Restart the server (whenever you make configuration changes to a server as a rule of thumb the server will normally need to be restarted for the changes to take affect).
[/LIST]

You should now find that PDO is available for use

[TheCop]

Hi All;

you can try this code...

<?php
// Create connection
$con=mysqli_connect("example.com","peter","abc123","my_db");

// Check connection
if (mysqli_connect_errno($con))
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
?>

thanks

Thanks, but I need to connect to the database with PDO.

[TheCop]

That proves that you're able to connect to the mysql server ok.

To get PDO going:

[LIST=1]
[*]Run this script
php
<?php phpinfo(); ?>


[*]With the output from the script in step 1 look for the line "Loaded Configuration File"
[*]Open up the file called php.ini that is located at the location given in "Loaded Configuration File"
[*]Find a line that reads there is probably a ; at the start of that line, remove the ; from the start of that line and save the file.
[*]Restart the server (whenever you make configuration changes to a server as a rule of thumb the server will normally need to be restarted for the changes to take affect).
[/LIST]

You should now find that PDO is available for use

Thanks to you, I have already enabled PDO.
The strange thing is this.

[serverack]

Bro, use mysqli_connect. Also check your phpinfo() to check whether PDO is on or not.

[TheCop]

Bro, use mysqli_connect. Also check your phpinfo() to check whether PDO is on or not.

This is the part related to PDO running:

<?php
	phpinfo();

[system]