Closed. This question is
not reproducible or was caused by typos. It is not currently accepting answers.
Answer
Solution:
$result = mysqli_stmt_get_result($stmt);
At this part, $result
will have a bool value (true) If it successfully inserts record (false) if it fails.
If you want to update userstatus in this profileimg
table, use this code
$last_id = $conn->insert_id;
mysqli_stmt_bind_param($stmt, "ssss", $name, $email, $tel, $pwdHashed);
if (mysqli_stmt_execute($stmt)) {
$last_id = $conn->insert_id;
$sql = "INSERT INTO profileimg (usersId, status) VALUES ('$last_id', 1);";
$result = mysqli_query($conn, $sql);
header("Location: ../EditAccount.php");
}
Source