note 78686 deleted from function.PDOStatement-fetchAll by felipe
| From: | felipe@php.net | Date: | Sun, 16 Dec 2007 11:52:12 +0000 |
| Subject: | note 78686 deleted from function.PDOStatement-fetchAll by felipe | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-133677@lists.php.net to get a copy of this message | ||
Note Submitter: gabriel at orange dot fr
Reason: 5
----
Using fetchAll(PDO::FETCH_ASSOC) for extract datas from database
<?php
$db = new
PDO('mysql:host='.$serverAddress.';dbname='.$databaseName.'',
$login,$password, array(PDO::ATTR_PERSISTENT => true));
$delete = "DELETE FROM table";
$stmt01 = $db -> prepare($delete);
$stmt01 -> execute();
$insert = "INSERT INTO table VALUES (:null,:rid,:indice,:titre,:nom,:page,:index)";
$stmt = $db -> prepare ($insert);
$stmt -> bindParam (":null", $null);
$stmt -> bindParam (":rid", $rid);
$stmt -> bindParam (":indice", $indice);
$stmt -> bindParam (":titre", $titre);
$stmt -> bindParam (":nom", $nom);
$stmt -> bindParam (":page", $page);
$stmt -> bindParam (":index", $index);
$datas = array (
array(null,'5182CQZSKB9XLRD','1.1.5','Mon chapitre
PDO','pdo.pdf','5','3'),
array(null,'5182CQZSKB8XLRD','1.1.6','Mon chapitre
PDO','pdo.pdf','6','3'),
);
foreach ($datas as $row) {
$null = $row[0];
$rid = $row[1];
$indice = $row[2];
$titre = $row[3];
$nom = $row[4];
$page = $row[5];
$index = $row[6];
$stmt -> execute();
}
$select = "SELECT * FROM table";
$stmt02 = $db -> prepare($select);
$stmt02 -> execute();
$result = $stmt02 -> fetchAll(PDO::FETCH_ASSOC);
foreach ( $result as $array) {
foreach ( $array as $field=> $value) {
print_r($field.":".$value);
print("<br/>");
}
print("<br/><br/>");
}
?>
Results :
id:32
rid:5182CQZSKB9XLRD
indice:1.1.5
titre:Mon chapitre PDO
nom:pdo.pdf
page:5
index:3
id:33
rid:5182CQZSKB8XLRD
indice:1.1.6
titre:Mon chapitre PDO
nom:pdo.pdf
page:6
index:3