PHP and MYSQL don't shake hands

[Frank Tudor <frank_tudor@yahoo.com>]

Guys,

I have moved from a foxserv(apache, php, mysql, all in one
install tool) windows test environment to a Linux apache php
mysql setup specifically mandrake linux production server.

The problem I am having is that when I try to pass values to the
database the php fails.

I think I have singled it down to the connection string but I am
not sure.

basically, I have tested the sample code in the book 'beginning
php' by (wrox).

I have made no changes.

I think that the dbhost is the problem.

when I look at the phpinfo page it shows me not localhost but a
'name.com'

so I try $dbhost = 'name.com';

and then i also try $dbhost = 'localhost';

and neither seem to work.

Can anyone tell me what I'm doing wrong?

Here is my sample code:

My db connect include file::::::

<?php
//common_db.inc
$dbhost = 'localhost';
$dbusername = 'name';
$dbuserpassword = 'pass';
$default_dbname = 'test';

$MYSQL_ERRNO = '';
$MYSQL_ERROR = '';

function db_connect() {
   global $dbhost, $dbusername, $dbuserpassword,
$default_dbname;
   global $MYSQL_ERRNO, $MYSQL_ERROR;

   $link_id = mysql_connect($dbhost, $dbusername,
$dbuserpassword);
   if(!$link_id) {
      $MYSQL_ERRNO = 0;
      $MYSQL_ERROR = "Connection failed to the host $dbhost.";
      return 0;
   }
   else if(empty($dbname) && !mysql_select_db($default_dbname))
{
      $MYSQL_ERRNO = mysql_errno();
      $MYSQL_ERROR = mysql_error();
      return 0;
   }
   else return $link_id;
}

function sql_error() {
   global $MYSQL_ERRNO, $MYSQL_ERROR;

   if(empty($MYSQL_ERROR)) {
      $MYSQL_ERRNO = mysql_errno();
      $MYSQL_ERROR = mysql_error();
   }
   return "$MYSQL_ERRNO: $MYSQL_ERROR";
}
?>

My php sample code:::::::

<?php
//db_connect.php
include "common_db.inc";
error_reporting(0);

$link_id = db_connect();
if(!$link_id) die(sql_error());
else echo "Successfully made a connection to $dbhost.<BR>";
?>

My error is a white screen

and this is simple code out of the book.

Could it be my dbhost is incorrect. I checked my services and
Mysql is running.

Apache running and parsing other php pages that don't do a db
connect so I'm pretty sure it's the db connect stuff.

Thanks,
Frank

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php