[PHP-NOTES] note 130383 added to mysqli-stmt.fetch

<?php
// This is my simple way to load an unique data.
// Load cliente - return my cliente id,nome and email.

// Connect to Mysqli
$mysqli = new mysqli("localhost", "my_user", "my_password", "clientes");

// Prepare your query
$stmt = $mysqli->prepare("SELECT id, nome, email FROM clientes WHERE id = ?");

// Set your cliente id to load
$id = 1;

$stmt->bind_param('i', $id);

// Execute your query
$stmt->execute();

// Get result
$result = $stmt->get_result();

// Fetch table fields (id,nome and email)
$fields = $result->fetch_fields();

// Fetch your rows into array
$rows = $result->fetch_array();

$data = array();

// Combine the fields of your table with your rows array result.
foreach($fields as $field) {
	$data[$field->name] = $rows[$field->name];
}

// Close the dataset
$stmt->close();

// Debug to see data return
echo "<pre>";
print_r($data);
echo "</pre>";

// I hope I helped!
// Julio Leles ([email protected])
?>
----
Server IP: 45.112.84.4
Probable Submitter: 80.90.5.137 (proxied: 2804:14c:5b80:8141:f97f:6b45:e6db:5a15)
----
Manual Page -- https://php.net/manual/en/mysqli-stmt.fetch.php
Edit        -- https://main.php.net/note/edit/130383
Del: integrated  -- https://main.php.net/note/delete/130383/integrated
Del: useless     -- https://main.php.net/note/delete/130383/useless
Del: bad code    -- https://main.php.net/note/delete/130383/bad+code
Del: spam        -- https://main.php.net/note/delete/130383/spam
Del: non-english -- https://main.php.net/note/delete/130383/non-english
Del: in docs     -- https://main.php.net/note/delete/130383/in+docs
Del: other reasons-- https://main.php.net/note/delete/130383
Reject      -- https://main.php.net/note/reject/130383
Search      -- https://main.php.net/manage/user-notes.php