Please fill in the red field(s):
fullySanitize($_GET['key']);
$depth = 1; // 1 for country, 2 for state, 3 for city
$keys = explode("-", $key);
$cat = $keys[0]; // this is cat_path
$country = $keys[1]; // this is loc_path of country
$state = ""; // this is loc_path of state
$city = ""; // this is loc_path of city
if (count($keys) > 2) {
$state = $keys[2];
$toplocpath = $state;
$depth = 2;
}
if (count($keys) > 3) {
$city = $keys[3] . '_' . strtolower($state);
$toplocpath = $city;
$depth = 3;
}
$trans = TransManager::getInstance();
$trans->beginTrans();
$pdo = $trans->getPDO();
$stmt = $pdo->prepare('SELECT location_cat_id FROM location_cat WHERE cat_path = ? AND loc_path = ?');
$stmt->bindParam(1, $cat);
$stmt->bindParam(2, $toplocpath);
$stmt->execute();
$myrow = $stmt->fetch(PDO::FETCH_NUM);
$loccatid = $myrow[0];
if (!stristr($tip, 'a href') && !stristr($tip, '[url') && !stristr($tip, 'http://')) {
$stmt = $pdo->prepare('INSERT INTO tip (name, email, location, body, location_cat_id, admin_flag) VALUES (?, ?, ?, ?, ?, \'U\')');
if (strlen($name) != 0)
$stmt->bindParam(1, $name);
else
$stmt->bindValue(1, null);
if (strlen($email) != 0)
$stmt->bindParam(2, $email);
else
$stmt->bindValue(2, null);
if (strlen($location) != 0)
$stmt->bindParam(3, $location);
else
$stmt->bindValue(3, null);
if (strlen($tip) != 0)
$stmt->bindParam(4, $tip);
else
$stmt->bindValue(4, null);
$stmt->bindParam(5, $loccatid);
$stmt->execute();
}
$trans->commit();
$trans->disconnect();
?>
Thank You For Your Submission
Thank you , your submission has been recorded
All submissions are reviewed before they "go live" on DatingDiversions.com. Therefore your
tip or advice will not be displayed immediately.
Thank you again for contributing to DatingDiversions.com.