From 6cc4334a83ee0926c54eb1c1e390ac951dd71365 Mon Sep 17 00:00:00 2001
From: Anthony Talarico <talarico@gaslightmedia.com>
Date: Tue, 1 Mar 2016 11:51:26 -0500
Subject: [PATCH] test adding categories to database withouth dataAbstract
 currently. added some layout to categories

---
 models/admin/events/categories.php | 54 +++++++++++++++++++++++++-----
 views/admin/member/categories.html |  3 ++
 2 files changed, 49 insertions(+), 8 deletions(-)

diff --git a/models/admin/events/categories.php b/models/admin/events/categories.php
index b099cbf..a59b775 100644
--- a/models/admin/events/categories.php
+++ b/models/admin/events/categories.php
@@ -14,9 +14,9 @@
  */
 
 // Load Contacts data abstract
-//require_once(GLM_MEMBERS_CONTACTS_PLUGIN_CLASS_PATH.'/data/dataContacts.php');
+require_once(GLM_MEMBERS_EVENTS_PLUGIN_CLASS_PATH.'/data/dataCategories.php');
 
-class GlmMembersAdmin_events_categories // extends GlmDataContacts
+class GlmMembersAdmin_events_categories  extends GlmDataEventsCategories
 {
 
     /**
@@ -106,11 +106,52 @@ class GlmMembersAdmin_events_categories // extends GlmDataContacts
 
         $displayData = 'Welcome to more information!<br>This is the Events Add-On "events" model with action "more" talking to you from inside WordPress.';
 
-        // Compile template data
+        $id = 1;
+        if($_REQUEST['Action'] == 'Add Topic'){
+            if(isset($_REQUEST['topic'])){
+                $title = $_REQUEST['topic'];
+                
+              // sql query
+               $sql = "
+                INSERT INTO ". GLM_MEMBERS_EVENTS_PLUGIN_DB_PREFIX . "categories
+                   (name)
+                 VALUES ("."'$title'".")
+            ;";
+               $this->wpdb->query($sql);
+            } 
+        }
+        // Get field names for each column
+//        $catName = "   
+//           SELECT column_name
+//            FROM information_schema.columns
+//            WHERE  table_name = '" .GLM_MEMBERS_EVENTS_PLUGIN_DB_PREFIX . "categories'
+//            AND table_schema = 'worddb'
+//                    ;";
+//        $categories = $this->wpdb->get_results($catName, ARRAY_A);
+//        foreach($categories as $key=>$value){
+//            $name[] = $value['column_name'];
+//        }
+//        echo '<pre>', print_r($name, true), '</pre>';
+//        echo $name[1];
+//       
+        
+        $catName = "
+          SELECT name 
+          FROM " . GLM_MEMBERS_EVENTS_PLUGIN_DB_PREFIX . "categories
+        ;";
+         $categories = $this->wpdb->get_results($catName, ARRAY_A);
+         foreach($categories as $key=>$value){
+              $name[] = $value['name'];
+         }
+         foreach($name as $cat){
+             echo $cat . "<br>";
+         }
+         
+         // Compile template data
         $templateData = array(
-            'displayData' => $displayData
+            'displayData' => $displayData,
+            'categoryNames' => $name
         );
-
         // Return status, any suggested view, and any data to controller
         return array(
                 'status' => true,
@@ -118,8 +159,5 @@ class GlmMembersAdmin_events_categories // extends GlmDataContacts
                 'view' => 'admin/events/categories.html',
                 'data' => $templateData
         );
-
     }
-
-
 }
diff --git a/views/admin/member/categories.html b/views/admin/member/categories.html
index 82d9067..aaab5e5 100644
--- a/views/admin/member/categories.html
+++ b/views/admin/member/categories.html
@@ -2,6 +2,9 @@
 <div class="wrap">
     <div id="glm-admin-content-container">
         <div class="topic-row">
+            {foreach from=$categoryNames item=category}
+            <div> {$category} </div>
+            {/foreach}
 	<form action="" method="post">
 	<table>
 		<tbody><tr>
-- 
2.17.1