function get_Query($query)
{
$conn = get_Connection();
//$result = "";
if (!empty($conn)) {
$result = mysql_query($query);
if (!$result) {
+die('Could not get data: ' . mysql_error());
}
}
mysql_close($conn);
return $result;
}
<?php
$Email = my_fix($_POST['inputEmail3']);
if ($Email === '') {
get_outa_here();
}
$_SESSION['Email'] = $Email;
$Connection = get_Connection();
$q1 = "SELECT PersonalId,NameLast,NameFirst,Email FROM framy_personal WHERE Email = :a";
$s1 = $Connection->prepare($q1);
$s1->bindValue(':a', $Email);
$s1->execute();
// Email is UNIQUE KEY. Either zero or one record returned.
// But just in case database fails, only take the first pass:
$UniquePass1 = TRUE;
foreach ($s1 as $row1) {
if ($UniquePass1) {
$UniquePass1 = FALSE;
$NameLast = $row1['namelast'];
$NameFirst = $row1['namefirst'];
$Password = random_str(8);
if (Config::read('dev.noemail')) {
$_SESSION['dev']['pw'] = $Password;
}
$TempBlowfish = encrypt_password($Password);
$q2 = "UPDATE framy_blowfish SET TempBlowfish = '{$TempBlowfish}',Expiry = NOW() + INTERVAL '15 MINUTES' WHERE PersonalId = :a";
$s2 = $Connection->prepare($q2);
$s2->bindValue(':a', $row1['personalid']);
$s2->execute();
$UniquePass2 = TRUE;
foreach ($s2 as $row2) {
