login function with php mysql error

Question

I am trying to create a login function with php.

Till now this is what I got.

<?php
include("dbconnection.php");
//select a database to work with
$mysqli->select_db("eamunter_opskrift");
Echo ("Selected the eamunter_opskrift database...<BR><BR>");
// get the username and password from the login form
$username=$_POST['username'];
$password=$_POST['password'];

//Protect username and password
$username = stripslashes($username);
$password = stripslashes($password);
$username = mysql_real_escape_string($username);
$password = mysql_real_escape_string($password);

$query ="SELECT * FROM brugerregistration WHERE username='$username' and password='$password'";
$result = $mysqli->query($query);
$count=mysqli_num_rows($result);
// If result matched $username and $password, the count of table rows should equal 1
if($count==1){
// Register session variables and redirect the user to "login_success.php" page
session_start();
$_SESSION['username']= $username;
header("location:login_success.php");
}
else {
echo "Wrong Username or Password";
}
?>

I keep getting the same error And I can't figure out what the problem is... My dbconnection.php works everywhere else.

Selected the eamunter_opskrift database...

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in /home/www/.dk/reg/post_login.php on line 13

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: No such file or directory in /home/www/.dk/reg/post_login.php on line 13

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in /home/www/.dk/reg/post_login.php on line 13

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in /home/www/.dk/reg/post_login.php on line 14

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: No such file or directory in /home/www/.dk/reg/post_login.php on line 14

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in /home/www/.dk/reg/post_login.php on line 14

Wrong Username or Password

Can anybody help me???

If important I can upload the form too, but didn't think it mattered.

Emily Shepherd · Accepted Answer · 2014-04-02 11:38:55Z

3

Replace mysql_real_escape_string with $mysqli->real_escape_string

(Also, you don't need the stripslashes calls, real_escape_string should do all that for you)

answered Apr 2, 2014 at 11:38

Emily Shepherd

1,3679 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Münter Over a year ago

Cool thanks :-) Do you know why it keeps writing post_login.php?username=user&password=1234&Submit=Login at the end of the link. Not very clever to have the password in the link...

Shankar Narayana Damodaran Over a year ago

Likely because your <form> action would have been set to GET instead of POST.

Emily Shepherd Over a year ago

In your HTML form, add method="post" so it reads <form method="post". That'll stop that showing up :) x

Shankar Narayana Damodaran · Accepted Answer · 2014-04-02 11:38:48Z

3

You are mixing up mysql_* and mysqli_* functions.

It should be

$username = $mysqli->real_escape_string($username);
$password = $mysqli->real_escape_string($password);

answered Apr 2, 2014 at 11:38

Shankar Narayana Damodaran

68.6k43 gold badges102 silver badges129 bronze badges

1 Comment

Münter Over a year ago

Thanks didn't notice. Now I just need to get it to work with the database :-) Only getting Selected the eamunter_opskrift database... Wrong Username or Password now.

Barif · Accepted Answer · 2014-04-02 11:41:37Z

Try it:

<?php
    include("dbconnection.php");
    //select a database to work with
    $mysqli->select_db("eamunter_opskrift");
    Echo ("Selected the eamunter_opskrift database...<BR><BR>");
    // get the username and password from the login form
    $username=$_POST['username'];
    $password=$_POST['password'];

    //You should use your object and current connection 
    $username = $mysqli->real_escape_string($username);
    $password = $mysqli->real_escape_string($password);

    $query ="SELECT * FROM brugerregistration WHERE username='$username' and password='$password'";
    $result = $mysqli->query($query);
    $count=mysqli_num_rows($result);
    // If result matched $username and $password, the count of table rows should equal 1
    if($count==1){
    // Register session variables and redirect the user to "login_success.php" page
    session_start();
    $_SESSION['username']= $username;
    header("location:login_success.php");
    }
    else {
    echo "Wrong Username or Password";
    }
    ?>

Community · Accepted Answer · 2023-11-14 22:27:11Z

1

see the doc of mysql_real_escape_string

replace :

$username = mysql_real_escape_string($username);
$password = mysql_real_escape_string($password);

by :

$username = $mysqli->real_escape_string($username);
$password = $mysqli->real_escape_string($password);

edited Nov 14, 2023 at 22:27

CommunityBot

11 silver badge

answered Apr 2, 2014 at 11:49

Awlad Liton

9,3513 gold badges30 silver badges53 bronze badges

Collectives™ on Stack Overflow

login function with php mysql error

4 Answers 4

3 Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related