1. fetch()
方法
<?php
try {
$conn = new PDO("mysql:host=localhost;dbname=orig", 'admin', 'admin');
$conn -> setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$conn->exec("SET NAMES utf8");
} catch(PDOException $e) {
echo "conn_error:<br/>" . $e -> getMessage();
}
$sql = "select * from ip_segments limit 10;";
$result = $conn->query($sql);
$arr = array();
while ($row = $result->fetch(PDO::FETCH_ASSOC)){
array_push($arr,$row);
}
echo "<pre>";
print_r($arr);
?>
2. fetchAll()
方法
<?php
try {
$conn = new PDO("mysql:host=localhost;dbname=orig", 'admin', 'admin');
$conn -> setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$conn->exec("SET NAMES utf8");
} catch(PDOException $e) {
echo "conn_error:<br/>" . $e -> getMessage();
}
$sql = "select * from ip_segments limit 10;";
$result = $conn->query($sql)->fetchAll(PDO::FETCH_ASSOC);
echo "<pre>";
print_r($result);
?>
3. fetchColumn()
方法
<?php
try {
$conn = new PDO("mysql:host=localhost;dbname=orig", 'admin', 'admin');
$conn -> setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$conn->exec("SET NAMES utf8");
} catch(PDOException $e) {
echo "conn_error:<br/>" . $e -> getMessage();
}
$sql = "select * from ip_segments limit 10;";
$result = $conn->query($sql);
$arr = array();
while ($row = $result->fetchColumn(0)){
array_push($arr,$row);
}
echo "<pre>";
print_r($arr);
?>