鍦≒HP涓紝鑾峰彇鏁版嵁搴撴煡璇㈢粨鏋滈€氬父闇€瑕佷娇鐢ㄦ暟鎹簱鎵╁睍绋嬪簭锛堝MySQLi鎴朠DO锛夋潵杩炴帴鏁版嵁搴撳苟鎵ц鏌ヨ銆備互涓嬫槸涓€涓畝鍗曠殑绀轰緥浠ｇ爜锛屾紨绀哄浣曡幏鍙栨暟鎹簱鏌ヨ缁撴灉锛?/p>

浣跨敤MySQLi鎵╁睍绋嬪簭锛?/p>

// 杩炴帴鍒版暟鎹簱
$mysqli = new mysqli("localhost", "username", "password", "database_name");

// 妫€鏌ヨ繛鎺ユ槸鍚︽垚鍔?/span>
if ($mysqli->connect_error) {
    die("杩炴帴澶辫触锛?quot; . $mysqli->connect_error);
}

// 鎵ц鏌ヨ
$result = $mysqli->query("SELECT * FROM table_name");

// 妫€鏌ユ煡璇㈢粨鏋?/span>
if ($result->num_rows > 0) {
    // 寰幆杈撳嚭鏌ヨ缁撴灉
    while ($row = $result->fetch_assoc()) {
        echo "ID: " . $row["id"] . " - Name: " . $row["name"] . "<br>";
    }
} else {
    echo "0 缁撴灉";
}

// 鍏抽棴杩炴帴
$mysqli->close();

浣跨敤PDO鎵╁睍绋嬪簭锛?/p>

// 杩炴帴鍒版暟鎹簱
$dsn = "mysql:host=localhost;dbname=database_name";
$username = "username";
$password = "password";
$pdo = new PDO($dsn, $username, $password);

// 鎵ц鏌ヨ
$stmt = $pdo->query("SELECT * FROM table_name");

// 妫€鏌ユ煡璇㈢粨鏋?/span>
if ($stmt->rowCount() > 0) {
    // 寰幆杈撳嚭鏌ヨ缁撴灉
    while ($row = $stmt->fetch()) {
        echo "ID: " . $row["id"] . " - Name: " . $row["name"] . "<br>";
    }
} else {
    echo "0 缁撴灉";
}

// 鍏抽棴杩炴帴
$pdo = null;

涓婅堪浠ｇ爜涓紝棣栧厛杩炴帴鍒版暟鎹簱锛岀劧鍚庢墽琛屾煡璇㈠苟妫€鏌ユ煡璇㈢粨鏋溿€傚鏋滄煡璇㈣繑鍥炵粨鏋滐紝灏卞惊鐜緭鍑烘瘡涓€琛岀殑鏁版嵁銆傛渶鍚庯紝璁板緱鍏抽棴鏁版嵁搴撹繛鎺ャ€?/p>