Example #1
0
<?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++;
                 }