我如何使用此代码重定向到用户主页

Question

i am trying to redirect my login page to user-home page. my code is not showing any error but login page is not redirecting to user-home page. badly expecting a proper solution. Thanks in advance. the following image is the databse details of signup page.

enter image description here

here is my code of index page

enter code here

<tr> 
<td width="200px" height="70px" style="color: gray;"><b>ENTER USERNAME</b></td>
                            <td width="100px" height="70px" style="border-bottom: 1px solid black;color: gray;" ><input type="text" name="username" placeholder="ENTER USERNAME" style="width: 150px;height: 35px;background:none; border: none;"></td>
                        </tr>
                        <tr>
                            <td width="200px" height="70px" style="color: gray;"><b>ENTER PASSWORD</b></td>
                            <td width="200px" height="70px" style="border-bottom: 1px solid black;color: gray;" ><input type="PASSWORD" name="password" placeholder="ENTER PASSWORD"style="width: 150px;height: 35px;background: none; border: none;"></td>

                        </tr>
                        <tr>
                            <td><input type="submit" name="login" value="login"style="width: 150px;height: 35px;  background:none;border-radius: 10px; border-color: gray; padding: 10px  "></td>
                        </tr>
                    </form>

                        <h2>dont have an account signup here</h2>
                        <li><a href="signup-form.php">signup</a></li>





                    </table>

                    <?php
    if(isset($_POST['login']))
                    {
    $username = $_POST['username'];
    $password = $_POST['password'];

    $query = $db->query("select * from signup where username = '$username' && password = '$password'");
    $count = $query->rowcount();
    $row = $query->fetch();
    if ($count > 1){
    session_start();
    $_SESSION['id'] = $row['user_id'];
     header('location:user-home.php'); 
    }else{
     header('location:index.php'); 
    }
    }
    ?>

Answer 1

The problem is with the following condition

if($count > 1){
}

If there's an entry with the associated username and password in the database then $query->rowcount(); will return the no of rows selected which should be one(1). The condition should be

if($count == 1){
  //home-page
}
else{
 //index page
}