TJdNxhqJ

1<?php //rfid.php 
2
3//setting up the twitter
4
5// twitter keys/tokens
6$consumerKey = 'secret';
7$consumerSecret = 'secret';
8$oAuthToken = 'secret';
9$oAuthSecret = 'secret';
10
11// Full path to twitteroauth.php (change oauth to your own path)
12require_once($_SERVER['DOCUMENT_ROOT'].'/oauth/twitteroauth.php');
13
14// create new twitter instance
15$tweet = new TwitterOAuth($consumerKey, $consumerSecret, $oAuthToken, $oAuthSecret);
16$name = 'Fake Name';
17$tweetdate = date("F j, Y, g:i a");
18
19mysql_connect("localhost", "root", "secret") or die(mysql_error());
20
21mysql_select_db("rfiddatabase");
22
23 
24$card=$_REQUEST['card']; 
25
26$door=$_REQUEST['door']; 
27
28$query = "SELECT * FROM cards WHERE cardID='$card' ";
29
30$result = mysql_query($query) or die(mysql_error());
31
32if (mysql_num_rows($result) )
33{
34    print 'success';
35
36 mysql_query("
37Insert Into log 
38
39VALUES ($card, 'Test Person2', NOW(), $sqldoor)
40
41");
42
43
44
45// create tweet message
46$message =  "$name (Card#  $card) entered $door on $tweetdate";
47
48// Send tweet 
49$tweet->post('statuses/update', array('status' => "$message"));
50	
51}
52else
53{
54        print 'fail';
55 mysql_query("
56Insert Into log (card, Name, timestamp, door)
57
58VALUES ($card, 'UNAUTHORIZED CARD', NOW(), $door)
59
60");
61
62// create tweet message
63$message =  "UNAUTHORIZED CARD (Card#  $card) scanned at $door on $tweetdate";
64
65// Send tweet 
66$tweet->post('statuses/update', array('status' => "$message"));
67
68}
69
70
71
72?>