CODEWITHSUNDEEP
phpmysql
Ch Muhammad Sohaib
Ch Muhammad Sohaib

Reputation: 19

Check of If an account exists

MY CODE

<?php
session_start();
require './SIGNUP/connects1010101.php';
require './LOGIN/connects1010101.php';
$srausername = $_SESSION['SRAUSERNAME'];
$srapassword = $_SESSION["SRAPASSWORD"];
if ($srausername && $srapassword) {
    $data0 = mysqli_query($con, "SELECT * FROM `INFO` WHERE `USERNAME` = '$srausername' AND `PASSWORD` = '$srapassword'");
    $data1 = mysqli_fetch_array($data0);
}
?>

I am beginner in PHP. My question is that I am making account register in mysql but how can I check if an account exists or not?

Upvotes: 0

Views: 316

Answers (2)

Praveen
Praveen

Reputation: 642

Please change your code like this,

<?php
session_start();
require './SIGNUP/connects1010101.php';
require './LOGIN/connects1010101.php';
$srausername = $_SESSION['SRAUSERNAME'];
$srapassword = $_SESSION["SRAPASSWORD"];
if ($srausername && $srapassword) {
    $data0 = mysqli_query($con, "SELECT * FROM `INFO` WHERE `USERNAME` = '$srausername' AND `PASSWORD` = '$srapassword'");
    //$data1 = mysqli_fetch_array($data0);

    if (mysqli_num_rows($data0) > 0) {
        // Account already exists
    }else {
        // No account exists and you can save the details here
    }
}
?>

Upvotes: 1

M.Hamza Mehmood
M.Hamza Mehmood

Reputation: 123

Try this code:

   <?php
    session_start();
    require './SIGNUP/connects1010101.php';
    require './LOGIN/connects1010101.php';
    $srausername = $_SESSION['SRAUSERNAME'];
    $srapassword = $_SESSION["SRAPASSWORD"];



    if ($srausername != '' && $srapassword != '') {
        $data0 = mysqli_query($con, "SELECT * FROM `INFO` WHERE `USERNAME` = '$srausername' AND `PASSWORD` = '$srapassword'");
        if(mysqli_num_rows($data0) > 0){
            // new entry
            $sql = mysqli_query($con, "INSERT INTO `INFO` (`USERNAME`,  `PASSWORD`) VALUES ('$srausername', '$srapassword') ");
            if($sql == true){
                echo 'Account has been registered';
                exit();
            }
        }else{
            // account exists
            echo 'Can not register. Account already exists';
            exit();
        }
    }else{
        echo 'Fields should not be empty!';
        exit();
    }
?>

Upvotes: 0

Related Questions