Databases
StackOverflow2013
Postsdbo
POHow to remove this mysqli warning?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to remove this mysqli warning?
    primarykey
    data
    text
    <p>I am doing an update in my php/mysqli. The update works fine but the problem I have is that I keep getting this warning:</p> <p>Warning: mysqli_stmt::fetch() [mysqli-stmt.fetch]: (HY000/2053): Attempt to read a row while there is no result set associated with the statement in on line 44.</p> <p>Because I keep getting this warning, it means that after the user submits the form, even with the correct username typed it, it still displays the message "The Username you Entered is not Valid. Try Entering it Again." when really it should navigate the user to the thankyou.php page.</p> <p>So my question is how do I remove this warning?</p> <pre><code> $username = (isset($_POST['username'])) ? $_POST['username'] : ''; $newpassword = (isset($_POST['newpassword'])) ? $_POST['newpassword'] : ''; $loggedIn = false; if (isset($_POST['submit'])) { // don't use $mysqli-&gt;prepare here $query = "UPDATE Teacher SET TeacherSalt = ?, TeacherPassword = SHA1(CONCAT(?,?)) WHERE TeacherUsername = ? LIMIT 1"; // prepare query $stmt=$mysqli-&gt;prepare($query); // You only need to call bind_param once $stmt-&gt;bind_param("ssss",$salt,$newpassword,$salt,$username); // execute query //bind results $stmt-&gt;bind_result($dbTeacherUsername,$dbTeacherPassword,$dbTeacherSalt); $stmt-&gt;execute(); while($stmt-&gt;fetch()) { if ($username == $dbTeacherUsername) { $loggedIn = true; } } /* close statement */ $stmt-&gt;close(); /* close connection */ $mysqli-&gt;close(); if ($loggedIn == true){ $_SESSION['username'] = $dbTeacherUsername; header( 'Location: thankyou.php' ) ; die(); } } if ($loggedIn == false &amp;&amp; $_POST) { echo "The Username you Entered is not Valid. Try Entering it Again."; } ?&gt; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USuser1394925
    1. USuser1394925
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COCalling **fetch** for update query?
      singulars
      1. POHow to remove this mysqli warning?
      1. USDr. Dan
    2. CO@Dr.Dan What I did was use the same template I had made for a previous Select statement and just changed the select statement with the update statement.
      singulars
      1. POHow to remove this mysqli warning?
      1. USuser1394925
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload