// LOAD DATABASE CONNECTION FIRST include("../meta/mysql/mysqli_connect_wigglefish2016.php"); // DEFINE MYSQLI CONNECTION $mysqli = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); $message = ""; if(isset($_POST['but_submit'])) { $uname = strtolower(mysqli_real_escape_string($mysqli,$_POST['txt_uname'])); // look up password $query = " select ua3.value from person_attribute ua1, person_attribute ua2, person u, person_attribute ua3 where ua1.type='Email' AND ua1.app_id = '2020' and ua1.value='$uname' and ua1.id=ua2.id and ua2.type='Role' AND ua2.app_id = '2020' and ua2.name='Suturo Curator' and ua2.value='Yes' and ua2.id = u.id and u.type='Person' and u.id = ua3.id and ua3.type='Password' AND ua3.app_id = '2020' "; $mysqli = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); $rows=mysqli_query($mysqli,$query); $result=mysqli_num_rows($rows); if ($result) { while ($row = mysqli_fetch_array($rows,MYSQLI_NUM)) { $password = $row[0]; //mail here $messageSubject = "[ Suturo ] - Login help"; $messageBody ="
Here is a reminder how to log in to the Suturo curatorial portal:
Click here to visit the portal.
Suturo
Curatorial Site | Exhibition Site.
";
// PREPARE HTML MAIL HEADER
$header = "MIME-Version: 1.0" . "\r\n";
$header .= "Content-type: text/html; charset=iso-8859-1" . "\r\n";
// $header .= "To: <".$uname.">" . "\r\n";
$header .= "Bcc: $message
Need help with your website login?