From 11d088452a178ebdef7e280d335d055d8048dbcf Mon Sep 17 00:00:00 2001
From: Steve Sutton <steve@gaslightmedia.com>
Date: Wed, 5 Jul 2017 14:12:47 -0400
Subject: [PATCH] adding export for contacts

---
 exportContacts.php | 34 ++++++++++++++++++++++++++++++++++
 1 file changed, 34 insertions(+)
 create mode 100644 exportContacts.php

diff --git a/exportContacts.php b/exportContacts.php
new file mode 100644
index 0000000..27d3b72
--- /dev/null
+++ b/exportContacts.php
@@ -0,0 +1,34 @@
+<?php
+require_once '../setup.phtml';
+$contactsFileName = './contacts-export.csv';
+
+// DB connection
+$dbh = Toolkit_Database::getInstance();
+
+// pull the member data
+$sql = "
+  SELECT member_id, member_name, member_login, member_passwd, process_email as member_email
+    FROM members.member
+ORDER BY member_id";
+$stmt = $dbh->query( $sql );
+$memberData = $stmt->fetchAll( PDO::FETCH_ASSOC );
+echo '<pre>$memberData: ' . print_r( $memberData, true ) . '</pre>';
+
+$fileHeader = array( 'member_id',
+    'member_name',
+    'member_login',
+    'member_passwd',
+    'member_email',
+);
+
+// create file
+$fp = fopen( $contactsFileName, 'w' );
+if ( $fp ) {
+    // create file header
+    fputcsv( $fp, $fileHeader );
+    foreach ( $memberData as $member ) {
+        fputcsv( $fp, $member );
+    }
+    fclose( $fp );
+}
+
-- 
2.17.1