php - mysqli_fetch_assoc not working with mysqli_stmt_get_result

Question

302 votes

1 answers

php - mysqli_fetch_assoc not working with mysqli_stmt_get_result

Get the solution ↓↓↓

Undefined answered · Answer 1 · 2022-02-5

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 thisprofileimg 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");
}

Popular technologies

Latest questions:

php - mysqli_fetch_assoc not working with mysqli_stmt_get_result

Answer