pdo mysql select_使用PDO从MySQL获取结果

小编典典

例。 这是您的dbc类

class dbc {

public $dbserver = 'server';

public $dbusername = 'user';

public $dbpassword = 'pass';

public $dbname = 'db';

function openDb() {

try {

$db = new PDO('mysql:host=' . $this->dbserver . ';dbname=' . $this->dbname . ';charset=utf8', '' . $this->dbusername . '', '' . $this->dbpassword . '');

} catch (PDOException $e) {

die("error, please try again");

}

return $db;

}

function getAllData($qty) {

//prepared query to prevent SQL injections

$query = "select * from TABLE where qty = ?";

$stmt = $this->openDb()->prepare($query);

$stmt->bindValue(1, $qty, PDO::PARAM_INT);

$stmt->execute();

$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);

return $rows;

}

?>

您的PHP页面：

require "dbc.php";

$getList = $db->getAllData(25);

foreach ($getList as $key=> $row) {

echo $row['columnName'] .' key: '. $key;

}

2020-05-17