🔒 Closed Pa help po ako sa php newbie!

[-Zetsu-]

Need help

Fatal error: Uncaught Error: Call to undefined function mysql_real_escape_string() in C:\xampp\htdocs\login\process.php:9 Stack trace: #0 {main} thrown in C:\xampp\htdocs\login\process.php on line 9

code:

<?php
//GeT values passe from form in login.php file
$username = $_POST['user'];
$password = $_POST['pass'];

// to prevent mysql injection
$username = stripcslashes($username);
$password = stripcslashes($password);
$username = mysql_real_escape_string($username);
$password = mysql_real_escape_string($password);

//connect to the server and select database
mysql_connect("localhost","root", "");
mysql_select_db("login");

//Query the database for user
$result = mysql_query("select * from users where username = '$username' and password = '$password'")
or die ("failed to query database" .mysql_error());

$row = mysql_fetch_array($result);
if ($row['username'] == $username && $row['password'] == $password ){
echo "Wait ! You are about to Log in" .$row['username'];
} else {
echo "Username or Password Incorect!";
}
?>

 

[Shiraori]

hindi na po supported ng PHP7 ang mysql, mysqli nalang po ang gamitin nyo

src: You do not have permission to view the full content of this post. Log in or register now.

 

[-Zetsu-]

change ko lang ng mysqli?

 

[Shiraori]

change ko lang ng mysqli?

opo

imbis po na

mysql_real_escape_string()

gawin nyo pong

mysqli_real_escape_string()

isama nyo nadin po yung iba

 

[-Zetsu-]

opo

imbis po na

mysql_real_escape_string()

gawin nyo pong

mysqli_real_escape_string()

isama nyo nadin po yung iba

Warning: mysqli_real_escape_string() expects exactly 2 parameters, 1 given in C:\xampp\htdocs\login\process.php on line 9

Warning: mysqli_real_escape_string() expects exactly 2 parameters, 1 given in C:\xampp\htdocs\login\process.php on line 10

Warning: mysqli_select_db() expects exactly 2 parameters, 1 given in C:\xampp\htdocs\login\process.php on line 14

Warning: mysqli_query() expects at least 2 parameters, 1 given in C:\xampp\htdocs\login\process.php on line 17

Warning: mysqli_error() expects exactly 1 parameter, 0 given in C:\xampp\htdocs\login\process.php on line 18
failed to query database

yan na ang error Haha XD

 

[Shiraori]

oops, eto po. Bali ang ginawa ko po ay inupdate yung ibang lines

<?php
//GeT values passe from form in login.php file
$username = $_POST['user'];
$password = $_POST['pass'];

//sever connection
$conn = mysqli_connect("localhost","root","","login");
if (mysqli_connect_errno()){
    echo "Failed to connect to database" . mysqli_connect_error();
}

// to prevent mysql injection
$username = stripcslashes($username);
$password = stripcslashes($password);
$username = mysqli_real_escape_string($conn,$username);
$password = mysqli_real_escape_string($conn,$password);

$sql= "SELECT * FROM users WHERE username = '$username' AND password = '$password'";
$result = $conn->query($sql);
if (!$result) {
    trigger_error('Invalid query: ' . $conn->error . $sql);
}
else {
    if ($result->num_rows > 0){
        while($row = $result->fetch_assoc()){
            if ($row['username'] == $username && $row['password'] == $password){
                echo "Wait ! You are about to Log in" .$row['username'];
            }
            else {
                echo "Username or Password Incorect!";
            }
        }
    }
    else {
        echo "Username or Password Incorect!";
    }
}
$conn->close();
?>

 

[-Zetsu-]

oops, eto po. Bali ang ginawa ko po ay inupdate yung ibang lines

<?php
//GeT values passe from form in login.php file
$username = $_POST['user'];
$password = $_POST['pass'];

//sever connection
$conn = mysqli_connect("localhost","root","","login");
if (mysqli_connect_errno()){
    echo "Failed to connect to database" . mysqli_connect_error();
}

// to prevent mysql injection
$username = stripcslashes($username);
$password = stripcslashes($password);
$username = mysqli_real_escape_string($conn,$username);
$password = mysqli_real_escape_string($conn,$password);

$sql= "SELECT * FROM users WHERE username = '$username' AND password = '$password'";
$result = $conn->query($sql);
if (!$result) {
    trigger_error('Invalid query: ' . $conn->error . $sql);
}
else {
    if ($result->num_rows > 0){
        while($row = $result->fetch_assoc()){
            if ($row['username'] == $username && $row['password'] == $password){
                echo "Wait ! You are about to Log in" .$row['username'];
            }
            else {
                echo "Username or Password Incorect!";
            }
        }
    }
    else {
        echo "Username or Password Incorect!";
    }
}
$conn->close();
?>

Yun oh working paps

 

[Shiraori]

Yun oh working paps

Welcome po. Check nyo rin po ito You do not have permission to view the full content of this post. Log in or register now. baka po makatulong sa iyong project

 

[-Zetsu-]

Welcome po. Check nyo rin po ito You do not have permission to view the full content of this post. Log in or register now. baka po makatulong sa iyong project

actually po First year palang ako, pero sa sobrang gusto ko matuto ayun maski pang 4th year inaaral ko na. Salamat po uli. HTML palang topic po namin hehe

 

[Shiraori]

actually po First year palang ako, pero sa sobrang gusto ko matuto ayun maski pang 4th year inaaral ko na. Salamat po uli. HTML palang topic po namin hehe

ooh? Sipag! ipagpatuloy mo yan. Pag master nyo na po ang PHP try nyo po gumamit ng framework. Pero sa ngayon focus lang sa pag code. yeah, haha

 

[F A L L E N]

mag pdo kanalang ts medyo di na recommended yang mysql