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) {