[mySqli_result :: Fetch_fields သည်ရှုပ်ထွေးသောမေးမြန်းချက်များကိုအကောင်အထည်ဖော်ရန် MySQLI_FETCE_AFT_ASTSOC ကိုမည်သို့အသုံးပြုရမည်နည်း။

<span><span><span class="hljs-meta">&lt;?php</span></span><span>
</span><span><span class="hljs-comment">// ဤသည်ဆောင်းပါး၏အကြောင်းအရာနှင့်ဆက်စပ်သောမဟုတ်ပါဘူးPHPကုဒ်အပိုင်း，မည်သည့်ကန ဦး သို့မဟုတ် configuration ကုဒ်နိုင်ပါတယ်</span></span><span>
</span><span><span class="hljs-variable">$servername</span></span><span> = </span><span><span class="hljs-string">"localhost"</span></span><span>;
</span><span><span class="hljs-variable">$username</span></span><span> = </span><span><span class="hljs-string">"root"</span></span><span>;
</span><span><span class="hljs-variable">$password</span></span><span> = </span><span><span class="hljs-string">""</span></span><span>;
</span><span><span class="hljs-variable">$dbname</span></span><span> = </span><span><span class="hljs-string">"test_db"</span></span><span>;

</span><span><span class="hljs-variable">$conn</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-variable">$servername</span></span><span>, </span><span><span class="hljs-variable">$username</span></span><span>, </span><span><span class="hljs-variable">$password</span></span><span>, </span><span><span class="hljs-variable">$dbname</span></span><span>);
</span><span><span class="hljs-keyword">if</span></span><span> (</span><span><span class="hljs-variable">$conn</span></span><span>-&gt;connect_error) {
    </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">$conn</span></span><span>-&gt;connect_error);
}

</span><span><span class="hljs-variable">$query</span></span><span> = </span><span><span class="hljs-string">"SELECT users.id, users.name, orders.order_date, orders.amount FROM users LEFT JOIN orders ON users.id = orders.user_id"</span></span><span>;
</span><span><span class="hljs-variable">$result</span></span><span> = </span><span><span class="hljs-variable">$conn</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_fields() နှင့် mysqli_fetch_assoc() ပူးတွဲအသုံးပြုမှု
 * ရှုပ်ထွေးသောစုံစမ်းမှုရလဒ်များ၏တက်ကြွစွာလုပ်ဆောင်မှုကိုအကောင်အထည်ဖော်ရန်အသုံးပြုသည်
 *
 * ရှုပ်ထွေးသောစုံစမ်းမှု，များစွာသောလယ်ပြင်အမည်များရှိနိုင်ပါသည်，နှင့်ထပ်တူသို့မဟုတ် alias ရှိပါတယ်，အသုံးပြုfetch_fieldsField Meta သတင်းအချက်အလက်ရယူနိုင်သည်，
 * ပေါင်းစပ်ထားသောfetch_assocAssociative Array တွင်ဒေတာများကိုလိုင်းအားဖြင့်အတန်းဖြင့်ဖတ်နိုင်သည်，ပိုပြီးပြောင်းလွယ်ပြင်လွယ်ဒေတာစစ်ဆင်ရေးအောင်မြင်ရန်。
 */</span>

</span><span><span class="hljs-comment">// 1. လယ်ပြင်သတင်းအချက်အလက်ရယူပါ</span></span><span>
</span><span><span class="hljs-variable">$fields</span></span><span> = </span><span><span class="hljs-variable">$result</span></span><span>-&gt;</span><span><span class="hljs-title function_ invoke__">fetch_fields</span></span><span>();

</span><span><span class="hljs-comment">// 2. အားလုံးလယ်ကွင်းအမည်များကိုပုံနှိပ်ပါ（Demo အသုံးပြုမှု）</span></span><span>
</span><span><span class="hljs-variable">$fieldNames</span></span><span> = [];
</span><span><span class="hljs-keyword">foreach</span></span><span> (</span><span><span class="hljs-variable">$fields</span></span><span> </span><span><span class="hljs-keyword">as</span></span><span> </span><span><span class="hljs-variable">$field</span></span><span>) {
    </span><span><span class="hljs-variable">$fieldNames</span></span><span>[] = </span><span><span class="hljs-variable">$field</span></span><span>-&gt;name;
}
</span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"Query Fields ရှိသည်: "</span></span><span> . </span><span><span class="hljs-title function_ invoke__">implode</span></span><span>(</span><span><span class="hljs-string">", "</span></span><span>, </span><span><span class="hljs-variable">$fieldNames</span></span><span>) . </span><span><span class="hljs-string">"&lt;br&gt;&lt;br&gt;"</span></span><span>;

</span><span><span class="hljs-comment">// 3. ဒေတာလိုင်းကိုလိုင်းဖြင့်ရယူပါ</span></span><span>
</span><span><span class="hljs-keyword">while</span></span><span> (</span><span><span class="hljs-variable">$row</span></span><span> = </span><span><span class="hljs-variable">$result</span></span><span>-&gt;</span><span><span class="hljs-title function_ invoke__">fetch_assoc</span></span><span>()) {
    </span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"အသုံးပြုသူID: "</span></span><span> . </span><span><span class="hljs-variable">$row</span></span><span>[</span><span><span class="hljs-string">'id'</span></span><span>] . </span><span><span class="hljs-string">"&lt;br&gt;"</span></span><span>;
    </span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"အသုံးပြုသူ名: "</span></span><span> . </span><span><span class="hljs-variable">$row</span></span><span>[</span><span><span class="hljs-string">'name'</span></span><span>] . </span><span><span class="hljs-string">"&lt;br&gt;"</span></span><span>;
    </span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"အမိန့်နေ့စွဲ: "</span></span><span> . (</span><span><span class="hljs-variable">$row</span></span><span>[</span><span><span class="hljs-string">'order_date'</span></span><span>] ?? </span><span><span class="hljs-string">'အမိန့်မရှိပါ'</span></span><span>) . </span><span><span class="hljs-string">"&lt;br&gt;"</span></span><span>;
    </span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"အမိန့်ပမာဏ: "</span></span><span> . (</span><span><span class="hljs-variable">$row</span></span><span>[</span><span><span class="hljs-string">'amount'</span></span><span>] ?? </span><span><span class="hljs-string">'ငွေပမာဏမရှိပါ'</span></span><span>) . </span><span><span class="hljs-string">"&lt;br&gt;"</span></span><span>;
    </span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"&lt;hr&gt;"</span></span><span>;
}

</span><span><span class="hljs-comment">// 4. ဆက်သွယ်မှုကိုပိတ်ပါ</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-variable">$conn</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