Posted By

drifterz28 on 01/21/11

Tagged

mysql
php

Versions (?)

Last Edited at 01/21/11 06:53am

Statistics

Viewed 1135 times

Favorited by 0 user(s)

Related snippets

Real Time Tax rates

/ Published in: PHP

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

<?
// the 2 post items that we need for tax.
$zip = $_POST['Ship-Zip'];
$total = $_POST['Taxable-Total'];
// connect to your mysql db, with yahoo your localhost is mysql
mysql_connect("mysql", "username", "password") or die(mysql_error());
mysql_select_db("tax_rates") or die(mysql_error());
$result = mysql_query("SELECT * FROM `zip_codes` WHERE `zipcode` LIKE CONVERT( _utf8 '$zip' USING latin1 )")
or die(mysql_error());  
$num_rows = mysql_num_rows($result);
// this checks if a zip code is returned, if no then no tax is charged
if($num_rows != "0"){
while($row = mysql_fetch_array( $result )) {
$percent = $row['taxrate']; 
} 
$to = ($percent/100)*$total;
}else {
$to = "0";
}
//needs the 200 ok header for the cart to see it.
header("HTTP/1.0 200 OK");
header("Tax-Charge: $to");
?>