请教phpl连接mysql问题
小弟刚刚学习php 作了一个连接mysql的小程序 可是怎么都不成功 请各位高手指点平台 windows 2000 p
apache 2.0.48
php 5.1.1
mysql 4.0.14
mysql 用的图形化界面 是sqlyog
数据库bookdb里有两个表
测试目的是连接数据库 如果成功 则输出 yes 成功后关闭数据库 并输出 close the database
结果只是输出了find
代码如下
----------------------------------------------
testDb.php
<html>
<head>
<title>
testDb
</title>
</head>
<body>
<?
require("dbInterface.inc");
$testDb=new dbInterface;
$testDb->setHost("localhost:3306","root","look");
$db=$testDb->dbConnect();
$testDb->dbClose($db);
?>
</body>
</html>
----------------------------------------------------------------
dbInterface.inc
<?
class dbInterface
{
var $dbId=1;
var $dbHost;
var $dbUser;
var $dbPassword;
function setHost($host,$user,$password)
{
$this->dbHost=$host;
$this->dbUser=$user;
$this->dbPassword=$password;
echo "find";
}
function dbConnect()
{
switch($this->dbId)
{
case 1;
@mysql_connect($this->dbHost,$this->dbUser,$this->dbPassword);
echo "yes";
case 2;
echo "连接SQLSERVER数据库";
case 3;
echo "连接其他数据库";
}
}
function dbClose($dbHandle)
{
switch($this->dbId)
{
case 1;
mysql_close($dbHandle);
echo "close the database";
case 2;
echo "close sqlserver database";
case 3;
echo "close other database";
}
}
}
?>
