xxxxxxxxxx
$pdo = pdoConnect();
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql = 'SELECT id, name, street, city, state, zip FROM accountHolders';
$stmt = $pdo->query($sql);
$allRows = $stmt->fetchAll(PDO::FETCH_OBJ);
$members = array();
foreach ($allRows as $row) {
array_push($members, $row->id, $row->name, $row->street, $row->city, $row->state, $row->zip);
}
xxxxxxxxxx
$pdo = new PDO('mysql:host=$host; dbname=$database;', $user, $pass);
$stmt = $pdo->prepare('SELECT * FROM auction WHERE name = :name');
$stmt->bindParam(':name', $_GET['searchdivebay']);
$stmt->execute(array(':name' => $name);