prefix . "amazon_setting";
$def_det = $wpdb->get_results('SELECT * FROM '.$tblname.' WHERE id = 1', OBJECT );
define('public_key', $def_det[0]->amazon_access_key);
define('private_key', $def_det[0]->amazon_secret_access_key);
define('associate_tag', $def_det[0]->amazon_associate_tag);
function amproductprice_install()
{
global $wpdb;
global $am_table_name;
$am_table_name = $wpdb->prefix . "amazon_setting";
$am_db_version = "1.0";
if($wpdb->get_var("show tables like '$am_table_name'") != $am_db_version) {
$sql = "CREATE TABLE " . $am_table_name . " (
id mediumint(9) NOT NULL AUTO_INCREMENT,
amazon_access_key VARCHAR(255) NOT NULL,
amazon_secret_access_key VARCHAR(255) NOT NULL,
amazon_associate_tag VARCHAR(255) NOT NULL,
amazon_region VARCHAR(255) NOT NULL,
UNIQUE KEY id (id)
);";
require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
dbDelta($sql);
add_option("am_db_version", $am_db_version);
}
}
register_activation_hook(__FILE__,'amproductprice_install');
add_action('admin_menu', 'add_settings_menu');
function add_settings_menu(){
add_options_page('Amazon Settings', 'Amazon Settings', 'manage_options', 'amazon-setting', 'amazon_setting');
}
function am_setting_url(){
return admin_url("options-general.php?page=amazon-setting");
}
function amazon_setting()
{
global $wpdb;
$tblname = $wpdb->prefix . "amazon_setting";
if(isset($_POST['submit']))
{
$amazon_access_key = trim($_POST['amazon_access_key']);
$amazon_secret_access_key = trim($_POST['amazon_secret_access_key']);
$amazon_associate_tag = trim($_POST['amazon_associate_tag']);
if(empty($_POST['up_id']))
{
$wpdb->insert($tblname,array('amazon_access_key' => $amazon_access_key, 'amazon_secret_access_key' => $amazon_secret_access_key, 'amazon_associate_tag' => $amazon_associate_tag),array('%s','%s','%s'));
}
else
{
$wpdb->update($tblname,array('amazon_access_key' => $amazon_access_key, 'amazon_secret_access_key' => $amazon_secret_access_key, 'amazon_associate_tag' => $amazon_associate_tag),array('id'=>$_POST['up_id']),array('%s','%s','%s'),array('%d'));
}
}
$update_det = $wpdb->get_results('SELECT * FROM '.$tblname.' WHERE id = 1', OBJECT );
?>
getItemByAsin($atts['asin']);
}
catch(Exception $e)
{
echo $e->getMessage();
}
// echo '';
// print_r($result->Items->Item);
$price = $result->Items->Item->OfferSummary->LowestNewPrice->Amount;
$MSRP = $result->Items->Item->ItemAttributes->ListPrice->Amount;
if(!empty($MSRP))
{
$Savings = $MSRP - $price;
$MSRP2 = number_format($MSRP /100,2);
}
$price = number_format($price /100,2);
echo '';
if(!empty($price) && !empty($MSRP))
{
echo 'Retail Price: '.$MSRP2.'
';
echo 'Lowest Price: '.$price.'
';
$MSRP2 = number_format($MSRP /100,2);
$percent = ($Savings/$MSRP2);
echo 'Saveing Percent: '.number_format($percent,2).'%
';
}
elseif(!empty($price) && empty($MSRP))
{
echo 'Price: '.$price.'
';
}
echo '
';
}
?>