文件名“config.php”，在其他文件中都被引用。“config.php”执行后出现“Could not open database
please check your settings in config.php”。下面是可能涉及到得代码：
$server = "localhost";
$username = "root";
$password = "123";
$database = "database_cs";
$ranks = array(
1=>"newbie",
2=>"new member",
3=>"member",
4=>"high member",
5=>"very high member",
6=>"supreme member",
7=>"ultra member",
8=>"godlike member",
9=>"god member",
10=>"low god",
11=>"medium god",
12=>"high god",
13=>"very high god",
14=>"supreme god",
15=>"ultra god",
16=>"perfect"
);
$couldNotOpenDatabase = "Could not open database
\n please check your settings in config.php";
f ($database == ""){
// Check it the database exist
$query = "use database_cs";
// If this query is succesfull, and returns a 1. this means that the database members can be used.
// If it returns 'null' then it doesn't exist.
if (mysql_query($query) == null){
//if it doesn't exist we create it and connect to it.
$query = "CREATE DATABASE database_cs";
$result = mysql_query($query);
if ($result == 1){
$conn = mysql_connect($server,$username,$password) or die ($couldNotConnectMysql);
mysql_select_db($database,$conn) or die ($couldNotOpenDatabase);
}else{echo "Error while creating database (Errornumber ". mysql_errno() .": \"". mysql_error() ."\")
";}
}
else{
// It already exist so we will connect to it.
$database= "database_cs";
$conn = mysql_connect($server,$username,$password) or die ($couldNotConnectMysql);
mysql_select_db($database,$conn) or die ($couldNotOpenDatabase);
//echo "数据库选择成功了!";
}
}
else{
// connect or show an error.
$conn = mysql_connect($server,$username,$password) or die ($couldNotConnectMysql);
mysql_select_db($database,$conn) or die ($couldNotOpenDatabase);
}
没有分了，哪位高手帮忙分析下，谢了。现在在做毕业设计“网上选课系统”，在网上下载的代码。比较急，各位救救急。
“$database=database_cs;”这条代码应该屏蔽掉；Mysql密码是“123”；
然后测试出现下面的错误提示：
Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\AppServ\www\ISC\config.php on line 92
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\AppServ\www\ISC\config.php on line 92
Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\AppServ\www\ISC\config.php on line 95
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\AppServ\www\ISC\config.php on line 95
Error while creating database (Errornumber 1045: "Access denied for user 'ODBC'@'localhost' (using password: NO)")
|
