note 78686 added to function.PDOStatement-fetchAll

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.PDOStatemen
t-fetchAll.php
Edit        -- https://master
.php.net/note/edit/78686
Del: integrated  -- h
ttps://master.php.net/note/delete/78686/integrated
Del: useless     -- http
s://master.php.net/note/delete/78686/useless
Del: bad code    -- htt
ps://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     -- http
s://master.php.net/note/delete/78686/in+docs
Del: other reasons-- https://mast
er.php.net/note/delete/78686
Reject      -- https://mast
er.php.net/note/reject/78686
Search      -- https://
master.php.net/manage/user-notes.php

-- 
PHP Notes Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub
.php