All pastes #74287 Raw Edit

Avenger

public text v1 · immutable
#74287 ·published 2006-06-28 21:23 UTC
rendered paste body
/** snip **/

/** IN FUNCTION THAT PERFORMS QUERY **/
$status = $stmt->execute();
$result = array();

$stmt->store_result();
if ($stmt->num_rows() > 0) {
	
	$data = $stmt->result_metadata();
	
	$fields = array();
	while($field = $data->fetch_field()) {
		$fields[] = &$result[$field->name];
	}
	
	call_user_func_array(array($stmt, 'bind_result'), $fields);
} else {
	return false;
}

return $status;

/*** IN FUNCTION THAT IS CALLED TO GET EACH ROW ***/
$res = $stmt->fetch();

if ($res === true) {
	$row = array();
	
	foreach($result as $k => $v) $row[$k] = $v;
	return $row;
} else return false;

/** snip **/