我正在尝试连接到我的数据库,但当我运行代码时,出现了错误。请问有人可以告诉我是什么问题,还有我的PHP代码中是否有任何错误吗?谢谢。
Error: No database selected
PHP 代码:
include('.conf.php');
$prof = $_GET['profile'];
$prof = addslashes(htmlentities($prof));
$query = "SELECT * FROM aTable where id = '".mysql_real_escape_string($prof)."'";
$info_array = mysql_query($query, $con) or die (mysql_error()).;
while($row = mysql_fetch_array( $info_array ))
{
echo $row['num1'];
echo "</br>";
echo $row['num2'];
echo "</br>";
echo $row['num3'];
echo "</br>";
echo $row['num4'];
};
mysql_close($con);
.conf.php文件:
<?php
$conf['db_hostname'] = "xxx";
$conf['db_username'] = "xxx";
$conf['db_password'] = "xxx";
$conf['db_name'] = "xxx";
$conf['db_type'] = "mysql";
$con = mysql_connect('xxx', 'xxx', 'xxx') or die (mysql_error());
$db = mysql_select_db("aTable", $con);
?>
select_db()
行上加上or die (mysql_error());
,以查看是否输出任何错误。 - Bojanglesxxx
对数据库aTable
的访问权限。 - Michael Berkowski