Direct Connect to MySQL using PHP

MySQL is a very popular open source database software.

You have a choice to retrieve the tax data aggregated for state-level reporting (Basic) or partitioned to local municipalities (Breakout).

Basic: Direct Connect to MySQL using PHP

Breakout: Direct Connect to MySQL using PHP

<?php

$strServer = "db.Zip2Tax.com";
$strDBUsername = "z2t_link";
$strDBPassword = "H^2p6~r";
$strDatabase = "zip2tax";

//Open the connection
$conn = mysql_connect($strServer, $strDBUsername, $strDBPassword, 0, 65536)
 or die("Failed to connect to MySQL server on $strServer");

//Open the Database
mysql_select_db($strDatabase, $conn)
 or die("Could not open database $strDatabase");

//Set-up query variables
$strZipCode = "90210"; //sample zip code must be between 90001 and 92999
$strUserName = "sample";
$strUserPassword = "password";

//Execute
$result = mysql_query( "CALL zip2tax.z2t_lookup_extended('" . $strZipCode . "','" . $strUserName . "', '" . $strUserPassword . "')" )
 or die( mysql_error() );

//Read the result
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
 {
 echo "Zip Code: " . $row['Zip_Code'] . " ";
 echo "Sales Tax Rate: " . $row['Sales_Tax_Rate'] . " ";
 echo "Post Office City: " . $row['Post_Office_City'] . " ";
 echo "County: " . $row['County'] . " ";
 echo "State: " . $row['State'] . " ";
 echo "Shipping Taxable: " . $row['Shipping_Taxable'] . " ";
 echo " Sales Tax Rate State: " . $row[' Sales_Tax_Rate_State '] . " ";
 echo " Sales Tax Rate County: " . $row[' Sales_Tax_Rate_County '] . " ";
 echo " Sales Tax Rate City: " . $row[' Sales_Tax_Rate_City '] . " ";
 echo " Sales Tax Rate Special: " . $row[' Sales_Tax_Rate_Special '] . " ";
 echo " Sales Tax Reporting Code Total: " . $row[' Sales_Tax_Reporting_Code_Total '] . " ";
 echo " Sales Tax Reporting Code State: " . $row[' Sales_Tax_Reporting_Code_State '] . " ";
 echo " Sales Tax Reporting Code County: " . $row[' Sales_Tax_Reporting_Code_County '] . " ";
 echo " Sales Tax Reporting Code City: " . $row[' Sales_Tax_Reporting_Code_City '] . " ";
 echo " Sales Tax Reporting Code Special: " . $row[' Sales_Tax_Reporting_Code_Special '] . " ";
 }

//Close the Database
mysql_close($conn);

?>


User Name:
Password:
	Submit
Do not log in if you wish to use the free trial lookups. Simply enter a ZIP code in the box below.
Having trouble? Call 1-866-492-8494 for help.

Direct Connect to MySQL using PHP

Login