From d895b852a6e160496ffc760d46d3719a3d62ff86 Mon Sep 17 00:00:00 2001
From: Nathan Kinkade <nath@nkinka.de>
Date: Sun, 3 Feb 2008 23:23:24 +0000
Subject: Initial checkin of nutridb.org and basic subversion directory
 structure

---
 list_meals.php | 37 +++++++++++++++++++++++++++++++++++++
 1 file changed, 37 insertions(+)
 create mode 100644 list_meals.php

(limited to 'list_meals.php')

diff --git a/list_meals.php b/list_meals.php
new file mode 100644
index 0000000..a066e5a
--- /dev/null
+++ b/list_meals.php
@@ -0,0 +1,37 @@
+<?php
+
+# include the main site config where various global variables
+# and libraries are included
+require("config.php");
+
+# the user must be logged in to access this script. if they are
+# not then this function will send them back to the index page
+loginRequired();
+
+# grab all of the users saved meals
+$sql = sprintf ("
+	SELECT userMeals.*
+	FROM userMeals INNER JOIN users
+		ON userMeals.user = users.id
+	WHERE users.id = '%s'
+	ORDER BY userMeals.description
+	",
+	$_SESSION['user']['id']
+);
+$db->Select($sql);
+if ( $db->_rowCount > 0 ) {
+	$smarty->assign("mealCount", $db->_rowCount);
+	$smarty->assign("userMeals", $db->_rows);
+}
+
+# grab the various parts.  these sections are not printed to the screen
+# but rather dumped into smarty variables that will simply be printed
+# in the template, so the order doesn't matter here at the moment
+require("header.php");
+require("sidebar_left.php");
+require("sidebar_right.php");
+require("footer.php");
+
+$smarty->display("list_meals.tpl");
+
+?>
-- 
cgit v1.2.3