From 11414a13b6528b2381434f638efbeafdf4b136b8 Mon Sep 17 00:00:00 2001
From: Steve Sutton <steve@gaslightmedia.com>
Date: Thu, 2 Jul 2015 17:00:09 -0400
Subject: [PATCH] Data

Working on getting page and paragraph data.
---
 index.php | 15 ++++++++++++++-
 1 file changed, 14 insertions(+), 1 deletion(-)

diff --git a/index.php b/index.php
index 3303dc1..f3f4133 100644
--- a/index.php
+++ b/index.php
@@ -20,8 +20,21 @@ if (!$dbh) {
     die('Error: no $dbh');
 }
 
-$sql = "
+$pageSql = "
   SELECT *
     FROM pages
+ORDER BY parent,pos";
+$pageData = $dbh->query($pageSql)->fetchAll(PDO::FETCH_ASSOC);
+$paragraphSql = "
+  SELECT *
+    FROM paragraphs
+   WHERE page = :page
 ORDER BY pos";
+$paraStmt = $dbh->prepare($paragraphSql);
+foreach ($pageData as &$page) {
+    $paraStmt->bindParam(':page', $page['id'], PDO::PARAM_INT);
+    $paraStmt->execute();
+    $page['paragraphs'] = $paraStmt->fetchAll(PDO::FETCH_ASSOC);
+}
+echo '<pre>'.print_r($pageData, true).'</pre>';
 echo 'here';
-- 
2.17.1