Translate # of Twitter Followers to Discount Coupon % on osCommerce

TWEET2COUPON

<?php

$tweet_data = json_decode(file_get_contents("http://api.twitter.com/1/users/show.json?screen_name=YOURTWITTERNAME"), true); 

// display tweet data array ( just to show you i know what i'm doing =] )

//print "<pre>";
//print_r($tweet_data);
//print "</pre>";

?>

<?php

// format likes percent
if($tweet_data["followers_count"] > 1) {
  $tweet_data["followers_count"] = $tweet_data["followers_count"] * floatval("." . str_repeat(0, strlen($tweet_data["followers_count"])) . 1 );
}

print $fb_data["likes"];

// connect to DB
$db = mysql_connect("localhost","DBADMIN","DBPASSWORD") or die("DB connection failed " . mysql_error());
mysql_select_db("DATABASENAME", $db) or die("DB connection: DB select failed " . mysql_error());

// set query (protected DB with secure mysql func)
$query = sprintf("UPDATE discount_coupons SET coupons_discount_amount = '%s' WHERE coupons_id = 'COUPONCODE';",
  mysql_real_escape_string($tweet_data["followers_count"]));
  
// execute query
$success = mysql_query($query) or die("DB connection: query failed " . mysql_error());

// check for successful update
if($success) {
  print "1 record updated";
} else {
  print "DB connection: update failed";
}

// finally, close connection
mysql_close($db);

?>