\n"; }
// turn off strict mysql error checking for: STRICT_ALL_TABLES
$mysqlVersion = preg_replace("/[^0-9\.]/", "", mysql_get_server_info());
$isMySql5 = version_compare($mysqlVersion, '5.0.0', '>=');
if ($isMySql5) {
mysql_query("SET SESSION sql_mode = 'NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER'") or die("MySQL Error: " .mysql_error(). "\n");
}
// add record
if (!@$alertsAndErrors) {
mysql_query("INSERT INTO `{$TABLE_PREFIX}application_form` SET
company = '".mysql_real_escape_string( $_REQUEST['company'] )."',
abn = '".mysql_real_escape_string( $_REQUEST['abn'] )."',
established = '".mysql_real_escape_string( $_REQUEST['established'] )."',
company_type = '".mysql_real_escape_string( $_REQUEST['company_type'] )."',
if_other = '".mysql_real_escape_string( $_REQUEST['if_other'] )."',
email = '".mysql_real_escape_string( $_REQUEST['email'] )."',
telephone = '".mysql_real_escape_string( $_REQUEST['telephone'] )."',
fax = '".mysql_real_escape_string( $_REQUEST['fax'] )."',
mobile = '".mysql_real_escape_string( $_REQUEST['mobile'] )."',
period_from = '".mysql_real_escape_string( $_REQUEST['period_from'] )."',
period_to = '".mysql_real_escape_string( $_REQUEST['period_to'] )."',
public_liability = '".mysql_real_escape_string( $_REQUEST['public_liability'] )."',
product = '".mysql_real_escape_string( $_REQUEST['product'] )."',
professional = '".mysql_real_escape_string( $_REQUEST['professional'] )."',
description = '".mysql_real_escape_string( $_REQUEST['description'] )."',
powerline_clearing = '".mysql_real_escape_string( $_REQUEST['powerline_clearing'] )."',
powerline_clearing_yes = '".mysql_real_escape_string( $_REQUEST['powerline_clearing_yes'] )."',
no_type_unregistered_vehicles = '".mysql_real_escape_string( $_REQUEST['no_type_unregistered_vehicles'] )."',
lifting_equipment = '".mysql_real_escape_string( $_REQUEST['lifting_equipment'] )."',
actual = '".mysql_real_escape_string( $_REQUEST['actual'] )."',
estimate = '".mysql_real_escape_string( $_REQUEST['estimate'] )."',
years_in_business = '".mysql_real_escape_string( $_REQUEST['years_in_business'] )."',
no_employees = '".mysql_real_escape_string( $_REQUEST['no_employees'] )."',
estimated_total_annual_wages = '".mysql_real_escape_string( $_REQUEST['estimated_total_annual_wages'] )."',
sub_contractors = '".mysql_real_escape_string( $_REQUEST['sub_contractors'] )."',
subcontactor_wages = '".mysql_real_escape_string( $_REQUEST['subcontactor_wages'] )."',
previous_experience = '".mysql_real_escape_string( $_REQUEST['previous_experience'] )."',
additional_services = '".mysql_real_escape_string( $_REQUEST['additional_services'] )."',
additional_services_details = '".mysql_real_escape_string( $_REQUEST['additional_services_details'] )."',
accepted_liability = '".mysql_real_escape_string( $_REQUEST['accepted_liability'] )."',
given_away_rights = '".mysql_real_escape_string( $_REQUEST['given_away_rights'] )."',
claims_against = '".mysql_real_escape_string( $_REQUEST['claims_against'] )."',
a_loss_date = '".mysql_real_escape_string( $_REQUEST['a_loss_date'] )."',
a_loss_description = '".mysql_real_escape_string( $_REQUEST['a_loss_description'] )."',
a_loss_paid = '".mysql_real_escape_string( $_REQUEST['a_loss_paid'] )."',
a_loss_reserve = '".mysql_real_escape_string( $_REQUEST['a_loss_reserve'] )."',
b_loss_date = '".mysql_real_escape_string( $_REQUEST['b_loss_date'] )."',
b_loss_description = '".mysql_real_escape_string( $_REQUEST['b_loss_description'] )."',
b_loss_paid = '".mysql_real_escape_string( $_REQUEST['b_loss_paid'] )."',
b_loss_reserve = '".mysql_real_escape_string( $_REQUEST['b_loss_reserve'] )."',
c_loss_date = '".mysql_real_escape_string( $_REQUEST['c_loss_date'] )."',
c_loss_description = '".mysql_real_escape_string( $_REQUEST['c_loss_description'] )."',
c_loss_paid = '".mysql_real_escape_string( $_REQUEST['c_loss_paid'] )."',
c_loss_reserve = '".mysql_real_escape_string( $_REQUEST['c_loss_reserve'] )."',
addition_claims_against = '".mysql_real_escape_string( $_REQUEST['addition_claims_against'] )."',
additional_claims_detail = '".mysql_real_escape_string( $_REQUEST['additional_claims_detail'] )."',
a_previous_insurer_name = '".mysql_real_escape_string( $_REQUEST['a_previous_insurer_name'] )."',
a_previous_from = '".mysql_real_escape_string( $_REQUEST['a_previous_from'] )."',
a_previous_to = '".mysql_real_escape_string( $_REQUEST['a_previous_to'] )."',
b_previous_insurer_name = '".mysql_real_escape_string( $_REQUEST['b_previous_insurer_name'] )."',
b_previous_from = '".mysql_real_escape_string( $_REQUEST['b_previous_from'] )."',
b_previous_to = '".mysql_real_escape_string( $_REQUEST['b_previous_to'] )."',
previous_cancellations_etc = '".mysql_real_escape_string( $_REQUEST['previous_cancellations_etc'] )."',
previous_cancellations_detail = '".mysql_real_escape_string( $_REQUEST['previous_cancellations_detail'] )."',
createdDate = NOW(),
updatedDate = NOW(),
createdByUserNum = '0',
updatedByUserNum = '0'")
or die("MySQL Error Creating Record:
\n". htmlspecialchars(mysql_error()) . "\n");
$recordNum = mysql_insert_id();
// display thanks message and clear form
$alertsAndErrors = "Thanks, we've added that record!";
$_REQUEST = array();
}
}
$csv = '';
$csv .= implode(', ', array_map('_csvExport_escapeAsCSV', array_keys($_REQUEST))) . "\n";
$csv .= implode(', ', array_map('_csvExport_escapeAsCSV', array_values($_REQUEST))) . "\n";
sendMessage(array(
'from' => "tim@forrest.id.au",
'to' => "tim@toledoh.com.au",
'subject' => "Application Form",
'text' => "Text message content",
'attachments' => array(
'form.csv' => $csv
)
));
?>