Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • What Is Wrong With Number Of Rows Count Function ?

    @UniqueIdeaMan
    Recommendations Offline Message

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 594
    Answer it

    Guys & Ladies,

    This LOGIN.php was working lastnight and so I don't know why not now.

    The ELSE at 53 gets triggered even though I have typed the right password!

    What do you think of line 16 ? ...

    if($numrows >1)

    I tried the following but no luck:

    if($numrows)

    if($numrows !=0)

    if($numrows ==2)

     

    In the past, they worked, though. What is wrong, do you reckon?

    1. [php]
    2.  
    3. <?php
    4. session_start();
    5. require "conn.php";
    6. require "site_details.php";
    7.  
    8. if(isset($_POST["member_login_submit"]))
    9. {
    10.     if(!empty($_POST["member_login_username_or_email"]) && !empty($_POST["member_login_password"]))
    11.     {
    12.         $member_login_username_or_email = trim(strip_tags(strtolower(mysqli_real_escape_string($conn,$_POST["member_login_username_or_email"]))));
    13.         $member_login_password = trim(strip_tags(mysqli_real_escape_string($conn,$_POST["member_login_password"])));
    14.         
    15.         $sql = "SELECT * FROM users WHERE usernames='".$member_login_username_or_email."' OR emails='".$member_login_username_or_email."' AND passwords='".$member_login_password."'";
    16.         $result = mysqli_query($conn,$sql);
    17.         $numrows = mysqli_num_rows($result);
    18.         if($numrows >1)
    19.         {        
    20.             while ($row = mysqli_fetch_assoc($result))
    21.             {
    22.                 $db_username = $row["usernames"];
    23.                 $db_password = $row["passwords"];
    24.                 $db_email = $row["emails"];
    25.                                         
    26.                 if  ($member_login_username_or_email == $db_username && $member_login_password == $db_password || $member_login_username_or_email == $db_email && $member_login_password == $db_password)            
    27.                 {
    28.                     $_SESSION["user"] = $member_login_username_or_email;           
    29.                     if(!empty($_POST["member_login_remember"]))
    30.                     {
    31.                         setcookie("member_login_username_or_email", $member_login_username_or_email, time()+ (10 * 365 * 24 * 60 * 60));
    32.                         setcookie("member_login_password", $member_login_password, time()+ (10 * 365 * 24 * 60 * 60));                        
    33.                     }
    34.                     else
    35.                     {
    36.                         if(isset($_COOKIE["member_login_username_or_email"]))
    37.                         {    
    38.                             setcookie("member_login_username_or_email", "", "");
    39.                         }
    40.                         if(isset($_COOKIE["member_login_password"]))
    41.                         {    
    42.                             setcookie("member_login_password", "", "");
    43.                         }        
    44.                     }
    45.                     header("location:home.php");            
    46.                 }
    47.                 else
    48.                 {
    49.                     $message = "Invalid login!";
    50.                 }    
    51.             }
    52.         }
    53.         else
    54.         {
    55.             $message = "Something is wrong! Try again later!";
    56.         }        
    57.     }
    58.     else
    59.     {
    60.         $message = "You must input your Username and Password!";    
    61.     }
    62. }    
    63.  
    64. ?>
    65. <!DOCTYPE html>
    66. <html>
    67. <head>
    68. <title><?php $site_name?> Member Login Page</title>
    69.   <meta charset="utf-8">
    70. </head>
    71. <body>
    72. <div class = "container">
    73. <form method="post" action="">
    74. <center><h3><?php $site_name ?> Member Login Form</h3></center>
    75. <div class="text-danger">
    76. <?php
    77. if(isset($message))
    78. {
    79.     echo $message;
    80. }
    81. ?>
    82. <div class="form-group">
    83. <center><label>Username/Email:</label>
    84. <input type="text" placeholder="Enter Username or Email" name="member_login_username_or_email" value="<?php if(isset($_COOKIE["member_login_username_or_email"])) echo $_COOKIE["member_login_username_or_email"]; ?>"</center>
    85. </div>
    86. <div class="form-group">
    87. <center><label>Password:</label>
    88. <input type="password" placeholder="Enter password" name="member_login_password" value="<?php if(isset($_COOKIE["member_login_password"])) echo $_COOKIE["member_login_password"]; ?>"></center>
    89. </div>
    90. <div class="form-group">
    91. <center><label>Remember Login Details:</label>
    92. <input type="checkbox" name="member_login_remember" /></center>
    93. </div>
    94. <div class="form-group">
    95. <center><input type="submit" name="member_login_submit" value="Login" class="button button-success" /></center>
    96. </div>
    97. <div class="form-group">
    98. <center><font color="red" size="3"><b>Forgot your password ?</b><br><a href="member_login_password_reset.php">Reset it here!</a></font></center>
    99. <center><font color="red" size="3"><b>Not registered ?</b><br><a href="member_register.php">Register here!</a></font></center>
    100. </form>
    101. </div>
    102. </body>
    103. </html>
    104.  
    105. [/php]

     

    php mysql
    Answer it

 0 Answer(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Reset Password
Fill out the form below and reset your password: