Ошибка: получение ошибки при создании простого логина php &mysql :(
Это первый раз, когда я пытаюсь сделать простой PHP & MySql login, но получаю эту ошибку --> Deprecated: mysql_connect(): расширение mysql устарело и будет удалено в будущем: используйте mysqli или PDO вместо этого в C:\wamp\www\login_form\dbConfig.php на линии 11
а в чем разница между mysql и mysqli ?
вот мой login.php код и dbConfig.php код соответственно:
login.php
<?php include "dbConfig.php";
$msg = "";
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$name = $_POST["name"];
$password = md5($_POST["password"]);
if ($name == '' || $password == '') {
$msg = "You must enter all fields";
} else {
$sql = "SELECT * FROM members WHERE name = '$name' AND password = '$password'";
$query = mysql_query($sql);
if ($query === false) {
echo "Could not successfully run query ($sql) from DB: " . mysql_error();
exit;
}
if (mysql_num_rows($query) > 0) {
header('Location: www.google.com');
exit;
}
$msg = "Username and password do not match";
}
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>discussdesk.com - Login form in PHP mysql</title>
<meta name="description" content=""/>
<meta name="keywords" content=""/>
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<body>
<form name="frmregister"action="<?= $_SERVER['PHP_SELF'] ?>" method="post" >
<table class="form" border="0">
<tr>
<td></td>
<td style="color:red;">
<?php echo $msg; ?></td>
</tr>
<tr>
<th><label for="name"><strong>Name:</strong></label></th>
<td><input class="inp-text" name="name" id="name" type="text" size="30" /></td>
</tr>
<tr>
<th><label for="name"><strong>Password:</strong></label></th>
<td><input class="inp-text" name="password" id="password" type="password" size="30" /></td>
</tr>
<tr>
<td></td>
<td class="submit-button-right">
<input class="send_btn" type="submit" value="Submit" alt="Submit" title="Submit" />
<input class="send_btn" type="reset" value="Reset" alt="Reset" title="Reset" /></td>
</tr>
</table>
</form>
<div style="line-height: 30px; margin-left: 307px;"><b>Name:</b> discussdesk <br/> <b>Password:</b> discussdesk</div>
<div style="line-height: 30px; margin-left: 207px;">For More Info: <a href="http://www.discussdesk.com">Visit our Website</a></div>
</body>
</html>
dbConfig.php
<?php
define ("DB_HOST", "localhost"); // set database host
define ("DB_USER", "root"); // set database user
define ("DB_PASS",""); // set database password
define ("DB_NAME","innodb"); // set database name
$link = mysql_connect(DB_HOST, DB_USER, DB_PASS) or die("Couldn't make connection.");
$db = mysql_select_db(DB_NAME, $link) or die("Couldn't select database");
?>