<?php session_start(); //include("authenticate.php"); require_once "modules/Table.inc"; if (isset($_GET['id'])) { $id = $_GET['id']; $sql = "SELECT male.Name, users.username, users.password FROM male, users WHERE male.id = " . $id . " AND male.id = users.user_id"; $db = new Table('male'); $male_cred = $db->getArrayResult($sql); if (!is_null($male_cred)) { print_r($male_cred); } }
// Enable SMTP authentication $mail->Username = '******'; // SMTP username $mail->Password = '******'; // SMTP password $mail->Port = 25; $mail->From = '*****@*****.**'; $mail->FromName = 'RYA'; $mail->isHTML(false); $sent_count = 0; $fail_count = 0; $users = array('male', 'female'); foreach ($users as $key => $value) { $db = new Table($value); $sql = "SELECT " . $value . ".Name AS name, " . $value . ".Email AS email, users.username, users.password FROM " . $value . ",users WHERE " . $value . ".id = users.user_id"; $members = $db->getArrayResult($sql); if (isset($members)) { foreach ($members as $value) { if (is_null($value['email']) || $value['email'] == "") { continue; } else { $mail->addAddress($value['email']); $sub = $project_name . " app credentials"; $msg = "Dear Member,\n\n\t\t\t\t\t\tDownload " . $project_name . " app from Play Store or App store and stay connected with us.\n\n\t\t\t\t\t\t" . $value['name'] . " your " . $project_name . " app credentials are:\n\n\t\t\t\t\t\tUsername: "******"\n\t\t\t\t\t\tPassword: "******"\n\n\t\t\t\t\t\tPlease do not share your credentials.\n\n\t\t\t\t\t\tRegards\n" . $project_name; $mail->Subject = $sub; $mail->Body = $msg; if (!$mail->send()) { $fail_count++; } else { $sent_count++; }