Error: Getting error while creating simple php & mysql login :(

Question

1.00/5 (1 vote)

See more:

This is first time I am trying to do a simple PHP & MySql login but am getting this error --> Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in C:\wamp\www\login_form\dbConfig.php on line 11

and what is the difference between mysql and mysqli ?

here is my login.php code and dbConfig.php code respectively:
login.php

XML

<?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

<?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");

?>

Posted 1-Sep-14 23:26pm

Member 10551326

Updated 29-Jan-18 15:34pm

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

thatraja · Answer 1 · 2014-09-01T23:30:00

Solution 1

Did you search Google for this? And Error message clearly tells you about the issue. Check these threads for details
The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead[^]
Deprecated: mysql_connect()[^]

Posted 1-Sep-14 23:30pm

thatraja

Kornfeld Eliyahu Peter · Answer 2 · 2014-09-01T23:33:00

I din't read your code - it's irrelevant.
Read the error message carefully! It tells you use an old MySQL driver extension of PHP and tells you should use the new one as the old may be removed in future PHP distributions...
The only different is that you should write mysqli_connect instead of mysql_connect, and the same for other methods...
http://php.net/manual/en/book.mysqli.php[^]