我收到错误:未选择数据库这是代码:
<?php
$host = "localhost";
$user = "root";
$password = "";
$database_name = "Student";
mysql_connect($host, $user, $password);
mysql_select_db($database_name);
?>
此代码适用于 php-connect.php 类和表单:
<!DOCTYPE html>
<html>
<body>
<?php
//load database connection
include("php-connect.php");
$id = "1";
$name = "Elena";
$city = "Lahore";
//Command to insert into table
$query = "INSERT INTO studentdata (id,name,city) VALUES ('$id','$name','$city')";
//run the query to insert the person.
$result = mysql_query($query) OR die(mysql_error());
//let them know the person has been added.
echo "Data successfully inserted into the database table ... ";
?>
</body>
</html>
这是表单的代码。我已经尝试了很多方法来修复此错误,但它不起作用。我的数据库有问题吗?
试试这个...
<?php
$host = "localhost";
$user = "root";
$password = "";
$database_name = "Student";
$mLink = mysql_connect($host, $user, $password) or die(mysql_error());
mysql_select_db($database_name , $mLink);
另一个文件
<?php
require 'php-connect.php';
//...... etc..
但是,请先阅读以下内容:
此扩展从 PHP 5.5.0 开始已弃用,并将在 未来。相反,应该使用 MySQLi 或 PDO_MySQL 扩展。 另请参阅 MySQL:选择 API 指南和相关常见问题解答以获取更多信息 信息。此功能的替代方法包括: mysqli_select_db() PDO::__construct() (dsn 的一部分)
http://br.php.net/mysql_select_db