Using mysqli_result::fetch_column to Extract Data and Integrate with External API

<span><span><span class="hljs-meta">&lt;?php</span></span><span>
</span><span><span class="hljs-comment">// This is a PHP code example unrelated to the article content, demonstrating database connection and a simple query</span></span><span>
</span><span><span class="hljs-variable">$mysqli</span></span><span> = </span><span><span class="hljs-keyword">new</span></span><span> </span><span><span class="hljs-title function_ invoke__">mysqli</span></span><span>(</span><span><span class="hljs-string">"localhost"</span></span><span>, </span><span><span class="hljs-string">"user"</span></span><span>, </span><span><span class="hljs-string">"password"</span></span><span>, </span><span><span class="hljs-string">"database"</span></span><span>);
</span><span><span class="hljs-keyword">if</span></span><span> (</span><span><span class="hljs-variable">$mysqli</span></span><span>-&gt;connect_errno) {
    </span><span><span class="hljs-keyword">die</span></span><span>(</span><span><span class="hljs-string">"Connection failed: "</span></span>. </span><span><span class="hljs-variable">$mysqli</span></span><span>-&gt;connect_error);
}
<p></span>// Query the user ID list<br>
$sql = "SELECT id FROM users";<br>
$result = $mysqli->query($sql);</p>
<p>if (!$result) {<br>
die("Query failed: ". </span>$mysqli->error);<br>
}</p>
<p>// Use fetch_column to extract all user IDs as an array<br>
$user_ids = [];<br>
while ($id = $result->fetch_column(0)) {  // Parameter 0 indicates the first column<br>
$user_ids[] = $id;<br>
}</p>
<p>// Free the result set<br>
$result->free();</p>
<p>// Simulate calling an external API to batch fetch user information based on IDs<br>
// Here we use a simple function to mimic the API call<br>
function getUserInfoFromApi(array $ids): array {<br>
$data = [];<br>
foreach ($ids as $id) {<br>
// Simulated API response structure<br>
$data[$id] = [<br>
'id' => $id,<br>
'name' => "User_$id",<br>
'email' => "user{$id}@example.com",<br>
];<br>
}<br>
return $data;<br>
}</p>
<p>// Call the API to get detailed information<br>
$user_details = getUserInfoFromApi($user_ids);</p>
<p>// Process and output the results<br>
foreach ($user_details as $user) {<br>
echo "User ID: {$user['id']}<br>";<br>
echo "Name: {$user['name']}<br>";<br>
echo "Email: {$user['email']}<br><hr>";<br>
}</p>
<p data-is-last-node="" data-is-only-node="">$mysqli->close();<br>
?><br>

• Related Tags:

  mysqli_result API