\n"; } // NEED TO ADD FIELDS & MESSAGES FOR MANDITORY FIELDS
// 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}tell_a_friend` SET
a = '".mysql_real_escape_string( $_REQUEST['a'] )."',
b = '".mysql_real_escape_string( $_REQUEST['b'] )."',
c = '".mysql_real_escape_string( $_REQUEST['c'] )."',
d = '".mysql_real_escape_string( $_REQUEST['d'] )."',
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 = "We've sent that brochure!";
// PDF VIA EMAIL
$url = "[your data]?num=" . mysql_escape(@$_REQUEST['num']) . "";
$data = createPDF_fromUrl($url);
sendMessage(array(
'from' => @$_REQUEST['a'],
'to' => @$_REQUEST['b'],
'subject' => @$_REQUEST['c'],
'text' => @$_REQUEST['d'],
'attachments' => array(
'example.pdf' => $data
)
));
}
}
?>
'products',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));
$productsRecord = @$productsRecords[0]; // get first record
// show error message if no matching record is found
if (!$productsRecord) {
header("HTTP/1.0 404 Not Found");
print "Record not found!";
exit;
}
?>
[your data]
[your data]
[your data]