MySQLI_RESELT :: Fetch_fields ကို အသုံးပြု. ဒေတာဘေ့စ်ရှာဖွေမှုရလဒ်များတွင်ကော်လံအချက်အလက်များကိုထုတ်ယူနည်း။

<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-keyword">echo</span></span><span> </span><span><span class="hljs-string">"သတ္တုတွင်းမှကြိုဆိုပါသည်PHPသင်ခန်းစာစာမျက်နှာ！"</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 ဒေတာဘေ့စ်စုံစမ်းမှုရလဒ်များမှကော်လံအချက်အလက်များကိုထုတ်ယူနည်း？
*/</span>

</span><span><span class="hljs-comment">// 在အသုံးပြု PHP ခဲှစိတ်ကုသ MySQL ဘယ်အချိန်မှာဒေတာဘေ့စ，မကြာခဏသင်သည်စုံစမ်းမှုရလဒ်များအတွက်ကော်လံသတင်းအချက်အလက်ရရန်လိုအပ်သည်，ဥပမာကော်လံအမည်များ、ဒေတာအမျိုးအစား、etc。mysqli ထောက်ပံ့ fetch_fields ဤအချက်အလက်အလွယ်တကူဖြည်ရန်နည်းလမ်းများ。</span></span><span>

</span><span><span class="hljs-comment">// 1. ဒေတာဘေ့စ်ကိုဆက်သွယ်ပါ</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">$database</span></span><span> = </span><span><span class="hljs-string">"test_db"</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-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">$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_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">$mysqli</span></span><span>-&gt;connect_error);
}

</span><span><span class="hljs-comment">// 2. တစ် ဦး စုံစမ်းမှု execute</span></span><span>
</span><span><span class="hljs-variable">$sql</span></span><span> = </span><span><span class="hljs-string">"SELECT id, name, email 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-comment">// 3. အသုံးပြု fetch_fields ကော်လံအချက်အလက်ထုတ်ယူ</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-keyword">echo</span></span><span> </span><span><span class="hljs-string">"&lt;h2&gt;Query ရလဒ်ကော်လံအချက်အလက်：&lt;/h2&gt;"</span></span><span>;
    </span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"&lt;ul&gt;"</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-keyword">echo</span></span><span> </span><span><span class="hljs-string">"&lt;li&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">$field</span></span><span>-&gt;name . </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">$field</span></span><span>-&gt;table . </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">$field</span></span><span>-&gt;type . </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">$field</span></span><span>-&gt;length . </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">$field</span></span><span>-&gt;max_length . </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;/li&gt;&lt;br&gt;"</span></span><span>;
    }
    </span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"&lt;/ul&gt;"</span></span><span>;

    </span><span><span class="hljs-comment">// 4. ရလဒ်ကိုကျော်ကြား</span></span><span>
    </span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"&lt;h2&gt;Query ရလဒ်ဒေတာ：&lt;/h2&gt;"</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">", Name: "</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">", Email: "</span></span><span> . </span><span><span class="hljs-variable">$row</span></span><span>[</span><span><span class="hljs-string">'email'</span></span><span>] . </span><span><span class="hljs-string">"&lt;br&gt;"</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-keyword">else</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">$mysqli</span></span><span>-&gt;error;
}

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

<span class="hljs-comment">/*
အကျဉ်းချုပ်：
- mysqli_result::fetch_fields() အားလုံးကော်လံအချက်အလက်အားလုံးပါ 0 င်သည်。
- တစ်ခုချင်းစီကို Array ဒြပ်စင်တစ်ခုအရာဝတ်ထုဖြစ်ပါတယ်，包含စာရင်းအမည်(name)、ဇယားနာ(table)、ဒေတာအမျိုးအစား(type)、အရှည်(length)စသည်တို့。
- ဤသည် dynamically ဇယားများထုတ်လုပ်ခြင်းဖြစ်ပါတယ်、ဒေတာသို့မဟုတ်ဒေတာဘေ့စ်အဆောက်အ ဦ များတင်ပို့သည့်အခါအလွန်အသုံးဝင်သည်。
*/</span>
</span><span><span class="hljs-meta">?&gt;</span></span><span>
</span></span>

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

  mysqli_result