Redirecting after inserting query execution not working

Question

I have been trying to redirect after inserting into the database but it's not working. The insert is working perfectly but it's not redirecting here is my code

  if (count($errors) == 0) {
    
    $query = "INSERT INTO investment (userid, amount, status, hashID, plan) 
              VALUES('$uidb', '$amount', '$status', '$id', '$plan')";
    $results = mysqli_query($db, $query);
    if (mysqli_num_rows($results) == 1) {
      exit(header('location: https://google.com'));
    }else {
        array_push($errors, "Invalid Sort Code");
    }
  }

Also, that if condition will always fail as it will be `0`. Try https://www.php.net/manual/en/mysqli.affected-rows.php — AbraCadaver, Jan 05 '21 at 22:40
`exit(header('location: https://google.com'));` - why ?!? Please separate this to `header('Location: ...'); exit;` — Honk der Hase, Jan 05 '21 at 23:00
@LarsStegelitz Why would you recommend that. It's simpler to do it in one go. Your suggestion is not an improvement at all. — Dharman, Jan 05 '21 at 23:50
For `INSERT` queries, use `mysqli_affected_rows`, not `mysqli_num_rows` — Nick, Jan 05 '21 at 23:59
thanks alot guys for all your effort all leads to it working i really appreciate — Amahle Lethabo, Jan 06 '21 at 05:37
@Dharman please any directions on where to get these materials i really dont know much am just doing the little i can thanks for your advice please any link on where to get to understand these (PDO & Mysqli) — Amahle Lethabo, Jan 06 '21 at 05:40

score -1 · Accepted Answer · answered Jan 05 '21 at 23:10

As @AbraCadaver and @Lars Stegelitz commented try this:

but even BETTER DO THIS with prepared statements for a bettter security.

if (count($errors) == 0) {

$query = "INSERT INTO investment (userid, amount, status, hashID, plan) 
          VALUES('$uidb', '$amount', '$status', '$id', '$plan')";
$results = mysqli_query($db, $query);
if (mysqli_affected_rows($db)) == 1) {
  header('location: https://google.com');
}else {
    array_push($errors, "Invalid Sort Code");
}

}

thanks alot this worked it God bless you – Amahle Lethabo Jan 06 '21 at 05:37 — Amahle Lethabo, Jan 06 '21 at 05:37

Redirecting after inserting query execution not working

1 Answers1