这是一个使用mysqli的示例（对象语法-如果需要，可以很容易地转换为函数语法）：
$db = new mysqli("host","user","pw","database");$stmt = $db->prepare("SELECt * FROM mytable where userid=? AND category=? ORDER BY id DESC");$stmt->bind_param('ii', intval($_GET['userid']), intval($_GET['category']));$stmt->execute();$stmt->store_result();$stmt->bind_result($column1, $column2, $column3);while($stmt->fetch()){ echo "col1=$column1, col2=$column2, col3=$column3 n";}$stmt->close();另外，如果您想要一种简单的方法来获取关联数组（供SELECT *使用），而不必确切指定要绑定的变量，那么这是一个方便的函数：
function stmt_bind_assoc (&$stmt, &$out) { $data = mysqli_stmt_result_metadata($stmt); $fields = array(); $out = array(); $fields[0] = $stmt; $count = 1; while($field = mysqli_fetch_field($data)) { $fields[$count] = &$out[$field->name]; $count++; } call_user_func_array(mysqli_stmt_bind_result, $fields);}要使用它，只需调用它而不是调用bind_result即可：
$stmt->store_result();$resultrow = array();stmt_bind_assoc($stmt, $resultrow);while($stmt->fetch()){ print_r($resultrow);}
