· 8 years ago · Aug 11, 2018, 02:16 AM
1script won't even build the two tables. error thrown: array(3) { [0]=> string(5) "3D000" [1]=> int(1046) [2]=> string(20) "No database selected" }
2
3<?php
4
5// Include global configs
6require_once( 'config.php' );
7
8// Page variables
9$page = 'Cvent Markets Form Upload';
10$admin = 'true';
11$sidebarright = 'true';
12
13
14
15// Include the header
16include( 'header.php' );
17
18if ($_FILES["file"]["error"] > 0){
19
20print "Error: " . $_FILES["file"]["error"] . "<br />";
21
22} else {
23
24 print "<p>";
25 print "Uploaded filename: " . $_FILES["file"]["name"] . "<br />";
26 print "Stored in: " . $_FILES["file"]["tmp_name"];
27 print "</p>";
28
29 $tmp = $_FILES["file"]["tmp_name"];
30
31}
32
33$file = @fopen( $tmp , "r" );
34
35if( $file ) {
36
37 //for determining when rows were uploaded, for backup purposes.
38 $stamp = time();
39
40
41 $cnxn = new PDO("mysql:host=" . MYSQL_LOCATION . ";database=" . MYSQL_DATABASE ,
42 MYSQL_USERNAME , MYSQL_PASSWORD );
43
44
45 $cnxn->beginTransaction();
46
47
48 //create tables if they do not already exist
49
50 $cnxn->exec(
51 "
52 CREATE TABLE IF NOT EXISTS `markets_info`
53 (
54 `id` int(11) NOT NULL AUTO_INCREMENT,
55 `eventtitle` varchar(128) NOT NULL,
56 `location` varchar(128) NOT NULL,
57 `address` varchar(128) NOT NULL,
58 `city` varchar(128) NOT NULL,
59 `state` varchar(128) NOT NULL,
60 `event_desc` varchar(128) NOT NULL,
61 `start_date` varchar(128) NOT NULL,
62 `end_date` varchar(128) NOT NULL,
63 `stakeholder_company` varchar(128) NOT NULL,
64 `full_name` varchar(128) NOT NULL,
65 `email` varchar(128) NOT NULL,
66 `registration_type` varchar(128) NOT NULL,
67 `website` varchar(128) NOT NULL,
68 `work_city` varchar(128) NOT NULL,
69 `work_state` varchar(128) NOT NULL,
70 `order_date` varchar(128) NOT NULL,
71 `product_name` varchar(128) NOT NULL,
72 `quantity` varchar(128) NOT NULL,
73 `timestamp` int(11) NOT NULL,
74 PRIMARY KEY (`id`)
75 )
76 ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1
77 "
78 ) or die ( var_dump($cnxn->errorInfo() ) );
79
80 $cnxn->exec(
81 "
82 CREATE TABLE IF NOT EXISTS `markets_info_backup`
83 (
84 `id` int(11) NOT NULL AUTO_INCREMENT,
85 `eventtitle` varchar(128) NOT NULL,
86 `location` varchar(128) NOT NULL,
87 `address` varchar(128) NOT NULL,
88 `city` varchar(128) NOT NULL,
89 `state` varchar(128) NOT NULL,
90 `event_desc` varchar(128) NOT NULL,
91 `start_date` varchar(128) NOT NULL,
92 `end_date` varchar(128) NOT NULL,
93 `stakeholder_company` varchar(128) NOT NULL,
94 `full_name` varchar(128) NOT NULL,
95 `email` varchar(128) NOT NULL,
96 `registration_type` varchar(128) NOT NULL,
97 `website` varchar(128) NOT NULL,
98 `work_city` varchar(128) NOT NULL,
99 `work_state` varchar(128) NOT NULL,
100 `order_date` varchar(128) NOT NULL,
101 `product_name` varchar(128) NOT NULL,
102 `quantity` varchar(128) NOT NULL,
103 `timestamp` int(11) NOT NULL,
104 PRIMARY KEY (`id`)
105 )
106 ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1
107 "
108 );
109
110 //insert into backup database
111 $result = $cnxn->query( "SELECT `eventtitle` ,
112 `location` ,
113 `address` ,
114 `city` ,
115 `state` ,
116 `event_desc` ,
117 `start_date` ,
118 `end_date` ,
119 `stakeholder_company`,
120 `full_name`,
121 `email` ,
122 `registration_type` ,
123 `website` ,
124 `work_city` ,
125 `work_state` ,
126 `order_date` ,
127 `product_name`,
128 `quantity` ,
129 `timestamp`
130
131 FROM markets_info
132
133 " );
134
135
136 while( $row = $result->fetch(PDO::FETCH_ASSOC) ) {
137 $cnxn->exec( "INSERT INTO markets_info_backup (
138 `eventtitle` ,
139 `location` ,
140 `address` ,
141 `city` ,
142 `state` ,
143 `event_desc` ,
144 `start_date` ,
145 `end_date` ,
146 `stakeholder_company` ,
147 `full_name` ,
148 `email` ,
149 `registration_type` ,
150 `website` ,
151 `work_city` ,
152 `work_state` ,
153 `order_date` ,
154 `product_name` ,
155 `quantity` ,
156 `timestamp`
157 )
158 VALUES
159 (
160
161 '".$row['eventtitle']."',
162 '".$row['location']."',
163 '".$row['address']."',
164 '".$row['city']."',
165 '".$row['state']."',
166 '".$row['event_desc']."',
167 '".$row['start_date']."',
168 '".$row['end_date']."',
169 '".$row['stakeholder_company']."',
170 '".$row['full_name']."',
171 '".$row['email']."',
172 '".$row['registration_type']."',
173 '".$row['website']."',
174 '".$row['work_city']."',
175 '".$row['work_state']."',
176 '".$row['order_date']."',
177 '".$row['product_name']."',
178 '".$row['quantity']."',
179 '".$row['timestamp']."'
180
181 )");
182 }
183
184
185
186 while (( $data = fgetcsv( $file )) !== false ) {
187
188 // splits string to create a way to order events by timestamp
189
190 $time = substr( strstr( $data[16] , ': ' ) , 2 );
191
192 $timestamp = strtotime($time);
193
194 //insert cvent file to database
195
196 $cnxn->exec( "INSERT INTO markets_info (
197 `eventtitle` ,
198 `location` ,
199 `address` ,
200 `city` ,
201 `state` ,
202 `event_desc` ,
203 `start_date` ,
204 `end_date` ,
205 `stakeholder_company` ,
206 `full_name` ,
207 `email` ,
208 `registration_type` ,
209 `website` ,
210 `work_city` ,
211 `work_state` ,
212 `order_date` ,
213 `product_name` ,
214 `quantity` ,
215 `timestamp`
216 )
217 VALUES
218 (
219
220 '".$data[0]."',
221 '".$data[1]."',
222 '".$data[2]."',
223 '".$data[3]."',
224 '".$data[4]."',
225 '".$data[5]."',
226 '".$data[6]."',
227 '".$data[7]."',
228 '".$data[8]."',
229 '".$data[9]."',
230 '".$data[10]."',
231 '".$data[11]."',
232 '".$data[12]."',
233 '".$data[13]."',
234 '".$data[14]."',
235 '".$data[15]."',
236 '".$data[16]."',
237 '".$data[17]."',
238 '".$timestamp."'
239
240 )");
241 }
242
243 fclose( $file );
244
245}
246
247$result = $cnxn->query( "SELECT `eventtitle` ,
248 `location` ,
249 `address` ,
250 `city` ,
251 `state` ,
252 `website` ,
253 `product_name`,
254 `timestamp`
255
256 FROM markets_info
257 WHERE `timestamp` > 0
258 ORDER BY `timestamp`
259
260 " );
261
262 while( $row = $result->fetch(PDO::FETCH_ASSOC) ) {
263
264 print '<p>';
265 print 'Date: '.$row['product_name'];
266 print '<br/>';
267 print 'Market: '.$row['eventtitle'];
268 print '<br/>';
269 print 'Website: '.$row['website'];
270 print '<br/>';
271 print 'Address: '.$row['address'].' ';
272 print $row['city'].', ';
273 print $row['state'];
274 print '<br/>';
275 print 'Location: '.$row['location'];
276 print '</p>';
277
278 }
279
280
281// Include the footer
282include 'footer.php';
283
284?>