AllSyntax.com: » Tutorials » PHP » 37 » Accept Coupon Codes For Downloads


	You have to THINK anyway, so why not think BIG? - Donald Trump

[login] | [Register]

Accept Coupon Codes for Downloads

by: sm0ke

Page: 2 of 3
(View All)

Using a form to enter the coupon code

Right, lets pretend the user has selected a file to download, they click to pay with a coupon for a free download - we need to present the user with a form to enter the coupon code to enable the download of the correct file.

In the following file we need to call in the information from the database on the download file requested. so a good link to use to get to enter the code from your products page might be http://www.somesite.com/coupon.php?id={id} Lets take a look at the form

Now we have a way for the user to enter a coupon code to download the selected product, save the file as coupon.php under the root of your site.

Verify code and direct to download

Now the above file will use a form action pointing to "verify.php" sending the hidden download id and coupon code along with it. The following file needs to be saved as "verify.php" under your root directory, this file will grab both the download id field and coupon code from the database, verify that the code and file exist and if either is false (doesnt exist) it will exit, if both download and code are ok the user will be directed to the download script to grab the file and the code will be deleted from the database so it cant be reused.

<?     include("site/site.inc.php");

db_login();   //login to the DB with the function called from the site.inc.php file

//generate and execute the query to match against the download id and a valid coupon code
   $sql = "SELECT * FROM coupon, downloads WHERE coupon.code = '$code' AND downloads.id = '$id'";
   $provide = mysql_query($sql) or die ("Error in query: $sql" . mysql_error());

// get resultset as object
$row = mysql_fetch_object($provide);

// if the id and coupon code both exist then direct them to the download
if ($row)
{

$domain="http://www.somesite.com/download.php?file=";  //the location of the download.php file
$querystring="$row->file.zip";                          //the database field name (file) followed by the file extension
$redirectstr= $domain.$querystring;                     //adds the filename and ext to the download file query
header('Location:'. $redirectstr);                      //redirects the user to the download

db_login(); //the login isnt persistent so lets login again
 
//query to delete the coupon code from the database after succesful download request
   $sql = "DELETE FROM coupon WHERE code = '$code'";
   $provide = mysql_query($sql) or die ("Error in query: $sql" . mysql_error());
}
else //the code entered or file requested doesnt exist
  {

echo" Invalid Coupon Code or Download ID, please try again";

}

in the above file the variable $querystring points to the field called "file" on the downloads table and adds the .zip extension to said filename, remember, we said not to store the file extension in the database, thats why.

« Prev.

1 | 2 | 3 |

Next »

No Comments for this page.

You Must be logged in or a member to comment.