note 107153 added to mysqli.prepare

For those learning mysqli::prepare and mysqli_stmt::bind_params for the first time, here is a commented block of code which executes prepared queries and returns data in a similar format to the return values of mysqli_query. I tried to minimize unnecessary classes, objects, or overhead for two reasons: 1) facilitate learning 2) allow relativity interchangeable use with mysqli_query My goal is to lower the learning curve for whoever is starting out with these family of functions. I am by no means an expert coder/scripter, so I am sure there are improvements and perhaps a few bugs, but I hope not =) <?php /* Function: mysqli_prepared_query() Executes prepared querys given query syntax, and bind parameters Returns data in array format Arguments: mysqli_link mysqli_prepare query mysqli_stmt_bind_param argmuent list in the form array($typeDefinitinonString, $var1 [, mixed $... ]) Return values: When given SELECT, SHOW, DESCRIBE or EXPLAIN statements: returns table data in the form resultArray[row number][associated field name] Returns number of rows affacted when given other queries Returns FALSE on error */ function mysqli_prepared_query($link,$sql,$bindParams = FALSE){ if($stmt = mysqli_prepare($link,$sql)){ if ($bindParams){ $bindParamsMethod = new ReflectionMethod('mysqli_stmt', 'bind_param'); //allows for call to mysqli_stmt->bind_param using variable argument list $bindParamsReferences = array(); //will act as arguments list for mysqli_stmt->bind_param $typeDefinitionString = array_shift($bindParams); foreach($bindParams as $key => $value){ $bindParamsReferences[$key] = &$bindParams[$key]; } array_unshift($bindParamsReferences,$typeDefinitionString); //returns typeDefinition as the first element of the string $bindParamsMethod->invokeArgs($stmt,$bindParamsReferences); //calls mysqli_stmt->bind_param suing $bindParamsRereferences as the argument list } if(mysqli_stmt_execute($stmt)){ $resultMetaData = mysqli_stmt_result_metadata($stmt); if($resultMetaData){ $stmtRow = array(); //this will be a result row returned from mysqli_stmt_fetch($stmt) $rowReferences = array(); //this will reference $stmtRow and be passed to mysqli_bind_results while ($field = mysqli_fetch_field($resultMetaData)) { $rowReferences[] = &$stmtRow[$field->name]; } mysqli_free_result($resultMetaData); $bindResultMethod = new ReflectionMethod('mysqli_stmt', 'bind_result'); $bindResultMethod->invokeArgs($stmt, $rowReferences); //calls mysqli_stmt_bind_result($stmt,[$rowReferences]) using object-oriented style $result = array(); while(mysqli_stmt_fetch($stmt)){ foreach($stmtRow as $key => $value){ //variables must be assigned by value, so $result[] = $stmtRow does not work (not really sure why, something with referencing in $stmtRow) $row[$key] = $value; } $result[] = $row; } mysqli_stmt_free_result($stmt); } else { $result = mysqli_stmt_affected_rows($stmt); } mysqli_stmt_close($stmt); } else { $result = FALSE; } } else { $result = FALSE; } return $result; } ?> Here's hoping the PHP gods don't smite me. ---- Server IP: 69.147.83.197 Probable Submitter: 24.5.125.223 ---- Manual Page -- http://www.php.net/manual/en/mysqli.prepare.php Edit -- https://master.php.net/note/edit/107153 Del: integrated -- https://master.php.net/note/delete/107153/integrated Del: useless -- https://master.php.net/note/delete/107153/useless Del: bad code -- https://master.php.net/note/delete/107153/bad+code Del: spam -- https://master.php.net/note/delete/107153/spam Del: non-english -- https://master.php.net/note/delete/107153/non-english Del: in docs -- https://master.php.net/note/delete/107153/in+docs Del: other reasons-- https://master.php.net/note/delete/107153 Reject -- https://master.php.net/note/reject/107153 Search -- https://master.php.net/manage/user-notes.php