Re: Update mySQL row with PHP using sproc

[Peter Brawley]

The code you showed for processing the multi_query() call looks insufficient, the model is ...

if( $res ) {
  $results = 0;
  do {
    if ($result = $mysqli->store_result()) {       // STORE RESULT
      printf( "Result #%u:", ++$results );
      echo nl2br("\n"};
      while( $row = $result->fetch_row() ) {       // FETCH RESULT
        foreach( $row as $cell ) echo $cell, " ";
      }
      $result->close();                            // CLOSE RESULT
      if( $mysqli->more_results() ) echo nl2br("\n");
    }
  } while( $mysqli->next_result() );               // NEXT RESULT
}
$mysqli->close();

> $personId = $mysqli -> real_escape_string($_REQUEST['personId']);

Your script had named the connection var $conn not $mysqli.

> $personId = $mysqli_real_escape_string($_REQUEST['personId']);

Lose the $ at the beginning of the func name, check the PHP manual for mysqli_real_escape_string() syntax ... first param is connection param.



Edited 2 time(s). Last edit at 06/15/2020 12:48PM by Peter Brawley.