PHP，无法连接到MySQL服务器

Question

What might be the reason of the following problem.

PHP function mysql_connect() works fine if I execute it from command line (php -r "mysql_connect('127.0.0.1', 'db_user', 'db_pass');").

The same call with the same parameters fails for PHP running as an Apache module.

MySQL server is running remotely, connection to it is forwarded using SSH: ssh -fN -L 3306:localhost:3306 remote_host

Any ideas what might be wrong?

Answer 1

You'll want to be looking at using MySQLi or PDO as the older MySQL functions are deprecated.

This should help get you started:

<?php
//establish conection
$link = mysqli_connect("host","user","pass","bd") or die("Error: " . mysqli_error($link));

$query = "SELECT name FROM mytable" or die("Error: " . mysqli_error($link));

//execute query
$result = $link->query($query);

//display information
while($row = mysqli_fecth_array($result)) {
  echo $row["name"] . "<br>";
} 
?>