fetch_array()
是 PHP 中用于從數(shù)據(jù)庫(kù)結(jié)果集中獲取一行數(shù)據(jù)并將其轉(zhuǎn)換為數(shù)組的函數(shù)
mysqli_fetch_array()
函數(shù)。這個(gè)函數(shù)屬于 MySQLi 擴(kuò)展,用于從 MySQL 數(shù)據(jù)庫(kù)查詢結(jié)果集中獲取一行數(shù)據(jù)。示例代碼:
$mysqli = new mysqli("localhost", "username", "password", "database");
$result = $mysqli->query("SELECT * FROM table_name");
while ($row = mysqli_fetch_array($result)) {
// 處理每一行數(shù)據(jù)
}
fetch()
或 fetchAll()
方法。這些方法屬于 PDOStatement 類,用于從各種數(shù)據(jù)庫(kù)(如 MySQL、PostgreSQL、SQLite 等)查詢結(jié)果集中獲取一行或多行數(shù)據(jù)。示例代碼:
$dsn = "mysql:host=localhost;dbname=database";
$pdo = new PDO($dsn, "username", "password");
$stmt = $pdo->query("SELECT * FROM table_name");
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
// 處理每一行數(shù)據(jù)
}
pg_fetch_array()
函數(shù)。這個(gè)函數(shù)屬于 PostgreSQL 擴(kuò)展,用于從 PostgreSQL 數(shù)據(jù)庫(kù)查詢結(jié)果集中獲取一行數(shù)據(jù)。示例代碼:
$conn = pg_connect("host=localhost dbname=database user=username password=password");
$result = pg_query($conn, "SELECT * FROM table_name");
while ($row = pg_fetch_array($result)) {
// 處理每一行數(shù)據(jù)
}
sqlite_fetch_array()
函數(shù)。這個(gè)函數(shù)屬于 SQLite 擴(kuò)展,用于從 SQLite 數(shù)據(jù)庫(kù)查詢結(jié)果集中獲取一行數(shù)據(jù)。示例代碼:
$db = sqlite_open("database.db");
$result = sqlite_query($db, "SELECT * FROM table_name");
while ($row = sqlite_fetch_array($result)) {
// 處理每一行數(shù)據(jù)
}
請(qǐng)注意,這些示例代碼僅適用于相應(yīng)的數(shù)據(jù)庫(kù)和擴(kuò)展。要在不同數(shù)據(jù)庫(kù)之間切換,您需要根據(jù)所選數(shù)據(jù)庫(kù)更改連接參數(shù)和查詢語句。