不推荐: mysql_connect()：ERROR

Question

我不知道我做错了什么，但我收到了这个错误：-

弃用: mysql_connect()：mysql扩展被废弃，将来将被删除:在第7行的C:\wamp\www\includes\config.php中使用mysqli或PDO

我怎么才能解决这个问题？

<?php
$mysql_hostname = "localhost";
$mysql_user = "bootstrapadmin";
$mysql_password = "";
$mysql_database = "bootstrap";

$bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password) or die("Mate you fucked something up!");
mysql_select_db($mysql_database, $bd) or die("Mate you fucked something up!");
?>

现在我遇到了登录页面的问题

Warning: mysqli_query() expects at least 2 parameters, 1 given in C:\wamp\www\login.php on line 12
Call Stack
#   Time    Memory  Function    Location
1   0.0012  140512  {main}( )   ..\login.php:0
2   0.0079  149352  mysqli_query ( )    ..\login.php:12

( ! ) Warning: mysql_num_rows() expects parameter 1 to be resource, null given in C:\wamp\www\login.php on line 13
Call Stack
#   Time    Memory  Function    Location
1   0.0012  140512  {main}( )   ..\login.php:0
2   0.0960  149752  mysql_num_rows ( )  ..\login.php:13

<?php

session_start();
include("includes/config.php");

if ($_SERVER["REQUEST_METHOD"] == "POST") {
    //username and password sent from form
    $myusername = addslashes($_POST['username']);
    $mypassword = md5(addslashes($_POST['password']));

    $sql = "SELECT userid FROM tbl_users WHERE username='$myusername' and password='$mypassword'";
    $result = mysqli_query($sql);
    $count = mysql_num_rows($result);

    // If result matched $myusername and $mypassword, table row must be 1 row
    if ($count == 1) {
        //$session_register("myusername");
        $_SESSION['login_admin'] = $myusername;
        header("location: http://localhost/admin/");
    }
}
?>

Answer 1

不再支持mysql_*函数。您可以使用mysqli_*函数代替。例如：

<?php
$mysql_hostname = "localhost";
$mysql_user = "bootstrapadmin";
$mysql_password = "";
$mysql_database = "bootstrap";

$bd = mysqli_connect($mysql_hostname, $mysql_user, $mysql_password) or die("Mate you messed something up!");
mysqli_select_db($mysql_database, $bd) or die("Mate you messed something up!");
?>

Answer 2

你搜索过MySQLi或PDO吗？旧的mysql_*方法被废弃，并将在以后的版本中删除。

在我看来，PDO是最好的方法，但是仅仅转换到MySQLi就足够了。只要稍微研究一下，并使用这些更新的技术之一。

对于MySQLi，只需将最后两行更改为：

$connection = mysqli_connect($mysql_hostname, $mysql_user, $mysql_password) or die("Mate you fucked something up!");

mysqli_select_db($connection, $mysql_database) or die("Mate you fucked something up!");

(在"mysql“之后添加了"i”/还切换了db-selection上的参数)

关于MySQLi：mysqli.asp的更多信息