<span><span><span class="hljs-meta"><?php</span></span><span>
</span><span><span class="hljs-comment">// 前置部分示例,與文章內容無關</span></span><span>
</span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"這是一個PHP示例程序\n"</span></span><span>;
</span><span><span class="hljs-variable">$time</span></span><span> = </span><span><span class="hljs-title function_ invoke__">date</span></span><span>(</span><span><span class="hljs-string">"Y-m-d H:i:s"</span></span><span>);
</span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"當前時間: <span class="hljs-subst">$time</span></span></span><span>\n";
</span><span><span class="hljs-meta">?></span></span><span>
<hr>
</span><span><span class="hljs-meta"><?php</span></span><span>
</span><span><span class="hljs-comment">// 正文開始</span></span><span>
<span class="hljs-comment">/*
文章標題: 怎麼用 mysqli::get_charset 判斷數據庫字符編碼是否正確?
*/</span>
</span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"<h1>怎麼用 mysqli::get_charset 判斷數據庫字符編碼是否正確?</h1>"</span></span><span>;
</span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"<p>在PHP中使用MySQL數據庫時,確保數據庫連接的字符編碼正確非常重要。字符編碼錯誤可能導致中文或其他非ASCII字符顯示異常。PHP提供了 <code>mysqli::get_charset
' ; echo " if ($mysqli->connect_error) {
die("連接失敗: " . $mysqli->connect_error);
}
' ; echo " $charset = $mysqli->get_charset();
echo "當前數據庫連接字符集: " . $charset->charset;
' ; echo "返回的$charset->charset就是當前連接使用的字符編碼。例如,如果顯示utf8mb4 ,說明數據庫連接使用的是UTF-8 編碼,適合存儲大部分字符,包括Emoji。
"; echo "$mysqli = new mysqli("localhost", "username", "password", "database");
if ($mysqli->connect_error) {
die("連接失敗: " . $mysqli->connect_error);
}
$charset = $mysqli->get_charset();
echo "當前數據庫連接字符集: " . $charset->charset;
' ; echo "通過上述方法,你可以快速判斷數據庫連接的字符編碼是否正確,避免字符顯示異常問題。
" ; ?> <?php // 尾部示例,與文章內容無關 echo "文章示例結束,以上內容僅作PHP練習用途。
" ; ?>