function not seeing variables
Posted: Mon Nov 26, 2007 7:53 am
Code: Select all
// BEGIN DISCOUNT COUPON CODE //
// Database information
$store_host = "localhost";
$store_user = "user";
$store_pass = "pass";
$store_db = "database";
$store_table = "xcart_discount_coupons";
$discount_value = "10.00";
$coupon_status = false;
// We're setting a value for $coupon_code //
if (isset($HTTP_POST_VARS['coupon']) && $HTTP_POST_VARS['coupon'] != "")
{
$coupon_code = $HTTP_POST_VARS['coupon'];
}
else if (isset($HTTP_GET_VARS['coupon']) && $HTTP_GET_VARS['coupon'] != "")
{
$coupon_code = $HTTP_GET_VARS['coupon'];
}
else
{
$coupon_code = "";
}
// Decide if we can display the coupon code in the registration page //
if ($_SERVER["HTTP_REFERER"] == "http://forums.plastikracing.net/discount_register.php" && isset($HTTP_GET_VARS['coupon']))
{
$discount_code = "<tr>
<td class=\"row1\"><span class=\"explaintitle\">Discount Coupon:</span><br />
<span class=\"gensmall\">Your discount coupon for the on-line store.</span></td>
<td class=\"row2\">
<input type=\"text\" name=\"coupon\" value=\"" . $coupon_code . "\" maxlength=\"14\" class=\"post\" />
</td>
</tr>";
}
// Add the coupon to the store //
function createCoupon ()
{
@mysql_connect("localhost","user","pass") or die(mysql_error());
@mysql_select_db("database") or die(mysql_error());
$coupon_sql = "INSERT INTO ".$store_table." VALUES ('".$coupon_code."', '".$discount_value."', 'absolute', '0', '0', '10.00', '1', 'N', '0', '1230699600', 'A', 'master', 'N', 'N', 'N')";
mysql_query($coupon_sql) or die('Query failed: ' . mysql_error());
mysql_close();
$coupon_status = true;
}
// END DISCOUNT COUPON CODE //