php 致命错误：未捕获的错误：调用未定义的函数 mysql_connect()
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/36470206/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Fatal error: Uncaught Error: Call to undefined function mysql_connect()
提问by Steven Surain
I am a beginner and also a diploma student... please help me solve this error... I tried many online solution but it cant help ... I'm new to php and mysql...
我是初学者，也是文凭学生......请帮我解决这个错误......我尝试了很多在线解决方案但它无济于事......我是php和mysql的新手......
<?php
$host="localhost"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="slr"; // Database name
$tbl_name="software"; // Table name
// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
// Get values from form
$soft_name=$_POST['soft_name'];
$installed_date=$_POST['installed_date'];
$expiry_date=$_POST['expiry_date'];
$product_key=$_POST['product_key'];
// Insert data into mysql
$sql="INSERT INTO $software(soft_name, installed_date, expiry_date, product_key)VALUES('$soft_name', '$installed_date', '$expiry_date', '$product_key')";
$result=mysql_query($sql);
// if successfully insert data into database, displays message "Successful".
if($result){
echo "Successful";
echo "<BR>";
echo "<a href='CreateData.php'>Back to main page</a>";
} else {
echo "ERROR";
}
// close connection
mysql_close();
?>
回答by Delphine
You should use mysqli_connectinstead of mysql_connectwhich is deprecated since PHP 5.5.0 :
您应该使用mysqli_connect的，而不是mysql_connect这是自PHP 5.5.0弃用：
$link = mysqli_connect("$host", "$username", "$password")or die("cannot connect");
mysqli_select_db($link, $db_name)or die("cannot select DB");
回答by EniGma
Try This:
尝试这个：
Old way:
旧方式：
<?php
$link = mysql_connect('localhost', 'user', 'pass');
mysql_select_db('testdb', $link);
mysql_set_charset('UTF-8', $link);
?>
New way: all you gotta do is create a new PDO object. PDO's constructor takes at most 4 parameters, DSN, username, password, and an array of driver options.
新方法：您要做的就是创建一个新的 PDO 对象。PDO 的构造函数最多接受 4 个参数，DSN、用户名、密码和一组驱动程序选项。
A DSN is basically a string of options that tell PDO which driver to use, and the connection details... You can look up all the options here PDO MYSQL DSN
DSN 基本上是一串选项，告诉 PDO 使用哪个驱动程序，以及连接详细信息...您可以在此处查找所有选项PDO MYSQL DSN
<?php
$db=new PDO('mysql:host=localhost;dbname=slr;charset=utf8mb4', 'root', '') or die("Could connect to Database");
?>
According to Here.
根据这里。
