Advanced Search

Return to Snippet

Revision: 39808
at March 29, 2011 08:38 by drifterz28
Updated Code 
<?
// 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");
?>

Revision: 39807
at January 23, 2011 17:36 by drifterz28
Updated Code 
<?
// the 2 post items that we need for tax.
$zip = $_POST['Ship-Zip'];
$total = $_POST['Taxable-Total'];
// connect to you 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");
?>

Revision: 39806
at January 21, 2011 06:53 by drifterz28
Initial Code 
<?
// the 2 post items that we need for tax.
$zip = $_POST['Ship-Zip'];
$total = $_POST['Taxable-Total'];
// connect to you 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 = $total/$percent;
}else {
$to = "0";
}
//needs the 200 ok header for the cart to see it.
header("HTTP/1.0 200 OK");
header("Tax-Charge: $to");
?>
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Real Time Tax rates

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
mysql, php

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
PHP