// tell the browser not to cache this page
header("Pragma: no-cache");
// really, don't cache it, I mean it this time
header("Expires: Monday 01-Jan-80 12:00:00 GMT");
$usr = "denton_ntn";
$pwd = "sQ2975";
$db = "denton_ntn";
$host = "localhost";
# connect to database
$cid = mysqli_connect($host,$usr,$pwd);
if (!$cid) { echo("ERROR: " . mysqli_error() . "\n"); }
?>
Alternative Reviews
Write-A-Review
Please rate this NTN site from 1 to 5 - 5 being best!
When commenting, please be specific. If there is something that could be improved,
PLEASE phrase those comments in a constructive manner.
Your E-mail address is not displayed with the review.
E-mail addresses will not be shared with anyone but may be used for verification or to follow-up.
Reviews that can NOT be verified may be deleted.
All fields are required.
$from_mail=$email;
//------------------------------------------------------------------------
# this is processed when the form is submitted
# back on to this page (POST METHOD)
if ($REQUEST_METHOD=="POST") {
/* Connecting, selecting database */
$link = mysqli_connect("localhost", "denton_ntn", "sQ2975", "denton_ntn") or die("Could not connect");
# double-up apostrophes
//$COMMENTS = str_replace("'","''",$COMMENTS);
//$NAME = str_replace("'","''",$NAME);
# check for bad words
$COMMENTS=censor($COMMENTS);
$review=$comments;
# setup SQL statement
$SQL = " INSERT INTO ntnreviews ";
$SQL = $SQL . " (ID, NAME, EMAIL, RATING, COMMENTS, DATE) VALUES ";
$SQL = $SQL . " ('$ID', '$NAME', '$EMAIL', '$RATING', '$COMMENTS', NOW()) ";
#execute SQL statement
$result = mysqli_query($SQL);
# check for error
if (!$result) {
echo("ERROR: " . mysqli_error() . "\n$SQL\n");
}
$to_email="Don@DonRDenton.com";
// send copy of review to Don
$BUSINESS=urldecode($BUSINESS);
$alt_comments=urldecode($alt_comments);
mail("$to_email","NTN: $BUSINESS","$ID: $alt_comments Rating:$RATING","From:$EMAIL") or die ("Could not send mail!");
// do a javascript go(-2) to get browser to a page prior to the form
echo "\n";
// head out without re-sending the form
exit;
}
mysqli_close($cid);
?>
Errors, omissions, suggestions, questions, comments? Please contact Don Denton
Read our privacy policy.
Copyright 2004 - , don.ntn.com. All Rights Reserved.