note 78686 added to function.PDOStatement-fetchAll
| From: | gabriel at orange dot fr | Date: | Tue, 23 Oct 2007 13:39:15 +0000 |
| Subject: | note 78686 added to function.PDOStatement-fetchAll | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-131660@lists.php.net to get a copy of this message | ||
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
----
Server IP: 69.147.83.197
Probable Submitter: 143.196.199.101
----
Manual Page -- http://www.php.net/manual/en/function.PDOStatement-fetchAll.php
Edit -- https://master.php.net/note/edit/78686
Del: integrated -- https://master.php.net/note/delete/78686/integrated
Del: useless -- https://master.php.net/note/delete/78686/useless
Del: bad code -- https://master.php.net/note/delete/78686/bad+code
Del: spam -- https://master.php.net/note/delete/78686/spam
Del: non-english -- https://master.php.net/note/delete/78686/non-english
Del: in docs -- https://master.php.net/note/delete/78686/in+docs
Del: other reasons-- https://master.php.net/note/delete/78686
Reject -- https://master.php.net/note/reject/78686
Search -- https://master.php.net/manage/user-notes.php