ဒေတာများကိုထုတ်ယူပြီးပြင်ပ APIs နှင့်ပေါင်းစပ်ပါ။

<span><span><span class="hljs-meta">&lt;?php</span></span><span>
</span><span><span class="hljs-comment">// ဤသည်ဆောင်းပါး၏အကြောင်းအရာနှင့်ဆက်စပ်သောမဟုတ်ပါဘူးPHPCode Page，ဒေတာဘေ့စ်ဆက်သွယ်မှုများနှင့်ရိုးရှင်းသောမေးမြန်းချက်များကိုသရုပ်ပြပါ</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">"ဆက်သွယ်မှုမအောင်မြင်ပါ: "</span></span><span> . </span><span><span class="hljs-variable">$mysqli</span></span><span>-&gt;connect_error);
}
</span><span><span class="hljs-variable">$query</span></span><span> = </span><span><span class="hljs-string">"SELECT id, name FROM users LIMIT 5"</span></span><span>;
</span><span><span class="hljs-variable">$result</span></span><span> = </span><span><span class="hljs-variable">$mysqli</span></span><span>-&gt;</span><span><span class="hljs-title function_ invoke__">query</span></span><span>(</span><span><span class="hljs-variable">$query</span></span><span>);
</span><span><span class="hljs-meta">?&gt;</span></span><span>

&lt;hr&gt;

</span><span><span class="hljs-meta">&lt;?php</span></span><span>
<span class="hljs-comment">/*
 * အသုံးပြု mysqli_result::fetch_column ဒေတာနှင့်ပြင်ပထုတ်ယူ API ပေါင်းစပ်အပြောင်းအလဲနဲ့
 *
 * တည်နေPHPအလယ်ပိုင်း，mysqliextension တစ်ခုသည်စစ်ဆင်ရေးတစ်ခုဖြစ်သည်MySQL数据库的常အသုံးပြုနည်းလမ်း之一。
 * မှPHP 8.1တက်，mysqli_resultအမျိုးအစားအသစ်ကဆက်ပြောသည်fetch_columnနည်းလမ်း，
 * 可以直接提取查询结果အလယ်ပိုင်း的某一列，အဆင်ပြေလွယ်ကူ。
 *
 * 本文将介绍如何使အသုံးပြုfetch_columnတစ်ခုတည်းသောကော်လံဒေတာထုတ်ယူ，နှင့်ပြင်ပမှထုတ်ယူဒေတာထည့်ပါAPIပေါင်းစပ်အပြောင်းအလဲနဲ့，
 * 例如调အသုံးပြု一个အာရုံဖော်ခြင်း的API，获取每个အသုံးပြု户的详细信息。
 */</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">"ဆက်သွယ်မှုမအောင်မြင်ပါ: "</span></span><span> . </span><span><span class="hljs-variable">$mysqli</span></span><span>-&gt;connect_error);
}

</span><span><span class="hljs-comment">// 查询အသုံးပြု户IDစာရင်း</span></span><span>
</span><span><span class="hljs-variable">$sql</span></span><span> = </span><span><span class="hljs-string">"SELECT id FROM users"</span></span><span>;
</span><span><span class="hljs-variable">$result</span></span><span> = </span><span><span class="hljs-variable">$mysqli</span></span><span>-&gt;</span><span><span class="hljs-title function_ invoke__">query</span></span><span>(</span><span><span class="hljs-variable">$sql</span></span><span>);

</span><span><span class="hljs-keyword">if</span></span><span> (!</span><span><span class="hljs-variable">$result</span></span><span>) {
    </span><span><span class="hljs-keyword">die</span></span><span>(</span><span><span class="hljs-string">"စုံစမ်းမှုမအောင်မြင်ပါ: "</span></span><span> . </span><span><span class="hljs-variable">$mysqli</span></span><span>-&gt;error);
}

</span><span><span class="hljs-comment">// 使အသုံးပြုfetch_column提取所有အသုံးပြု户ID，ခင်းကျင်းရန်</span></span><span>
</span><span><span class="hljs-variable">$user_ids</span></span><span> = [];
</span><span><span class="hljs-keyword">while</span></span><span> (</span><span><span class="hljs-variable">$id</span></span><span> = </span><span><span class="hljs-variable">$result</span></span><span>-&gt;</span><span><span class="hljs-title function_ invoke__">fetch_column</span></span><span>(</span><span><span class="hljs-number">0</span></span><span>)) {  </span><span><span class="hljs-comment">// တေးရေး0ပထမကော်လံယူပြီးညွှန်ပြ</span></span><span>
    </span><span><span class="hljs-variable">$user_ids</span></span><span>[] = </span><span><span class="hljs-variable">$id</span></span><span>;
}

</span><span><span class="hljs-comment">// စုံစမ်းမှုရလဒ်ကိုပိတ်ပါ</span></span><span>
</span><span><span class="hljs-variable">$result</span></span><span>-&gt;</span><span><span class="hljs-title function_ invoke__">free</span></span><span>();

</span><span><span class="hljs-comment">// အာရုံဖော်ခြင်း调အသုံးပြု外部API，根据အသုံးပြု户ID批量获取အသုံးပြု户信息</span></span><span>
</span><span><span class="hljs-comment">// 这里我们အသုံးပြု一个简单函数代替真实API调အသုံးပြု</span></span><span>
</span><span><span class="hljs-function"><span class="hljs-keyword">function</span></span></span><span> </span><span><span class="hljs-title">getUserInfoFromApi</span></span><span>(</span><span><span class="hljs-params"><span class="hljs-keyword">array</span></span></span><span> </span><span><span class="hljs-variable">$ids</span></span><span>): </span><span><span class="hljs-title">array</span></span><span> {
    </span><span><span class="hljs-variable">$data</span></span><span> = [];
    </span><span><span class="hljs-keyword">foreach</span></span><span> (</span><span><span class="hljs-variable">$ids</span></span><span> </span><span><span class="hljs-keyword">as</span></span><span> </span><span><span class="hljs-variable">$id</span></span><span>) {
        </span><span><span class="hljs-comment">// အာရုံဖော်ခြင်းAPIဒေတာဖွဲ့စည်းပုံကိုပြန်သွားပါ</span></span><span>
        </span><span><span class="hljs-variable">$data</span></span><span>[</span><span><span class="hljs-variable">$id</span></span><span>] = [
            </span><span><span class="hljs-string">'id'</span></span><span> =&gt; </span><span><span class="hljs-variable">$id</span></span><span>,
            </span><span><span class="hljs-string">'name'</span></span><span> =&gt; </span><span><span class="hljs-string">"User_<span class="hljs-subst">$id</span></span></span><span>",
            </span><span><span class="hljs-string">'email'</span></span><span> =&gt; </span><span><span class="hljs-string">"user<span class="hljs-subst">{$id}</span></span></span><span>@example.com",
        ];
    }
    </span><span><span class="hljs-keyword">return</span></span><span> </span><span><span class="hljs-variable">$data</span></span><span>;
}

</span><span><span class="hljs-comment">// 调အသုံးပြုAPIအသေးစိတ်အချက်အလက်များကိုရယူပါ</span></span><span>
</span><span><span class="hljs-variable">$user_details</span></span><span> = </span><span><span class="hljs-title function_ invoke__">getUserInfoFromApi</span></span><span>(</span><span><span class="hljs-variable">$user_ids</span></span><span>);

</span><span><span class="hljs-comment">// လုပ်ငန်းစဉ်နှင့်ရလဒ်ထုတ်ယူ</span></span><span>
</span><span><span class="hljs-keyword">foreach</span></span><span> (</span><span><span class="hljs-variable">$user_details</span></span><span> </span><span><span class="hljs-keyword">as</span></span><span> </span><span><span class="hljs-variable">$user</span></span><span>) {
    </span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"အသုံးပြု户ID: <span class="hljs-subst">{$user['id']}</span></span></span><span>&lt;br&gt;";
    </span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"နံမယ်: <span class="hljs-subst">{$user['name']}</span></span></span><span>&lt;br&gt;";
    </span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"စာပို့: <span class="hljs-subst">{$user['email']}</span></span></span><span>&lt;br&gt;&lt;hr&gt;";
}

</span><span><span class="hljs-variable">$mysqli</span></span><span>-&gt;</span><span><span class="hljs-title function_ invoke__">close</span></span><span>();
</span><span><span class="hljs-meta">?&gt;</span></span><span>
</span></span>

• သက်ဆိုင်သောတက်(ဂ်)များ:

  mysqli_result API