PHPize Online / SQLize Online  /  SQLtest Online

<?php mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT); $select = $mysqli->prepare('SELECT * FROM users WHERE email=?'); $select->bind_param('s', ...['email@email']); $select->execute(); $result = $select->get_result(); $row = $result->fetch_assoc(); $newemail = 'newemail'; $newname = 'newname'; $query = "UPDATE users SET name=?, email=? WHERE id=?"; $stmt = $mysqli->prepare($query); $stmt->bind_param("ssi", $newname, $newemail, $row['Id']); $stmt->execute(); $select = $mysqli->prepare('SELECT * FROM users WHERE email=?'); $select->bind_param('s',$newemail); $select->execute(); $result = $select->get_result(); $row = $result->fetch_assoc(); var_dump($row);