1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / pattklvg / public_html / admin / pages / announcement / php /
Filename : newdata2.php
back
<?php
ob_start();
session_start();
include "../../../dist/resources/config.php";
require 'PHPMailer/PHPMailerAutoload.php';
$tt = $_POST['tt'];
$tg = $_POST['tg'];
$at = $_POST['at'];
$atg = $_POST['atg'];
$cv = $_FILES['cv']['name'];
$dc = $_FILES['annpdf']['name'];
$vl = $_POST['vl'];
$ins = $_POST['ins'];
$typ = $_POST['typ'];
$history_archives = $_POST['history_archives'];

$length=8;
$unique_id = substr(str_shuffle("abcdefghijklmnopqrstuvwxyz0123456789"), 0, $length);

date_default_timezone_set("Africa/Nairobi");
$now = date("Y-m-d h:i:sa");
if($cv !=''){
list($txt, $ext) = explode(".", $cv);
	$length=8;
	$ran = substr(str_shuffle("abcdefghijklmnopqrstuvwxyz"), 0, $length);
	$ph = $ran.".".$ext;
	$tmp = $_FILES['cv']['tmp_name'];
	$imn = "http://localhost/files/".$ran.".".$ext;
}
	
	if($dc !=''){
list($txt, $ext) = explode(".", $dc);
	$length=8;
	$ran = substr(str_shuffle("abcdefghijklmnopqrstuvwxyz"), 0, $length);
	$doc = $ran.".".$ext;
	$tmp2 = $_FILES['annpdf']['tmp_name'];
	$imn2 = "http://localhost/files/".$ran.".".$ext;
}

if($tt != null && $at != null && $ins && $typ){
            if($cv !=''){
	        move_uploaded_file($tmp, '../images/'.$ph);
            }
	        if($dc !=''){
	    	move_uploaded_file($tmp2, '../files/'.$doc);
	        }
		$stmt = $conn->prepare("INSERT INTO announcement VALUES ('',?,?,?,?,?,?,?,?,?,?,?,?)");
$stmt->bind_param('ssssssssssss', $tt,$history_archives,$tg, $at,$atg, $ph,$doc,$vl, $ins, $typ,$unique_id,$now);

if($stmt->execute()){
    
    
     $sqlll = "SELECT institute.name,announcement.id FROM announcement INNER JOIN institute ON institute.inst_id=announcement.institute WHERE unique_id='$unique_id' ORDER BY id DESC; ";
                    $resultttann = $conn->query($sqlll);
                    
                    if ($resultttann->num_rows > 0) {
                        // output data of each row
                        while($row = $resultttann->fetch_assoc()) {
                          $announcement_id = $row['id'];
                          $created_at = $row['created_at'];
                          $name = $row['name'];
                        }
                    }
                    
    // $sqlll->execute();
    
    // $sqlll = "SELECT members.email,members.f_name,members.l_name FROM members WHERE institute_id=$ins AND status='Active' AND member_id='3' ORDER BY member_id DESC; ";
    
    $sqlll = "SELECT members.email,members.f_name,members.l_name FROM members WHERE members.institute_id='$ins' AND status='Active' AND rec_mail='checked' AND rec_mail_all='' ORDER BY member_id DESC; ";
                    $resulttt = $conn->query($sqlll);
                    
                    if ($resulttt->num_rows > 0) {
                        // output data of each row
                        while($row = $resulttt->fetch_assoc()) {
                          $f_name = $row['f_name'];    
                          $l_name = $row['l_name'];
                          $email = $row['email'];
    
    $mail = new PHPMailer;
        //credentials
              // Set mailer to use SMTP
                    $mail->IsSMTP();
        			$mail->Host = 'pattniworld.com';  // Specify main and backup SMTP servers
        		    //$mail->SMTPDebug = 3;
        		    $mail->SMTPDebug = false;
        		    $mail->do_debug=0;
                    $mail->SMTPAuth = true;// Enable SMTP authentication
        			$mail->Username = 'announcements@pattniworld.com';                 // SMTP username
        			$mail->Password = 'jhE97ip(uFH)';                           // SMTP password
        			$mail->SMTPSecure = 'ssl';                            // Enable TLS encryption, `ssl` also accepted
        			$mail->Port = 465;                                    // TCP port to connect to
                    //$mail->IsHTML(true);
        //From email address and name
        $mail->From = "announcements@pattniworld.com";
        $mail->FromName = "Pattni World";
        $mail->addAddress($email); //Recipient name is optional
        //Address to which recipient will reply
        $mail->addReplyTo("app@lohananairobi.com", "Reply");
        $mail->Subject = "New announcement: $tt";
        $mail->Body = 'Dear '.$f_name.',<br/> Kindly note that a new announcement titled: '.$tt.' has been added to your institute. Use the link: https://pattniworld.com/detaill_announcement.php?id='.$announcement_id.' to view it.
        <br><br> Thank you.<br> '.$name.'<br> Pattni World Team.<br><img src="https://pattniworld.com/images/Logo%20edited.png" style="width:120px;height:57px;"/>';
        $mail->AltBody = "this mail concerns application approval";
        if(!$mail->send())
        {
            echo "Mailer Error:".$mail->ErrorInfo;
        }
        else
        {
            echo "Message has been sent successfully";
        }
    
    
                        }
                      }
                      
    
    $sqlll = "SELECT members.email,members.f_name,members.l_name FROM members WHERE  status='Active' AND rec_mail_all='checked' ORDER BY member_id DESC; ";
                    $resulttt = $conn->query($sqlll);
                    
                    if ($resulttt->num_rows > 0) {
                        // output data of each row
                        while($row = $resulttt->fetch_assoc()) {
                          $f_name = $row['f_name'];    
                          $l_name = $row['l_name'];
                          $email = $row['email'];
    
    $mail = new PHPMailer;
        //credentials
              // Set mailer to use SMTP
                    $mail->IsSMTP();
        			$mail->Host = 'pattniworld.com';  // Specify main and backup SMTP servers
        		    //$mail->SMTPDebug = 3;
        		    $mail->SMTPDebug = false;
        		    $mail->do_debug=0;
                    $mail->SMTPAuth = true;// Enable SMTP authentication
        			$mail->Username = 'announcements@pattniworld.com';                 // SMTP username
        			$mail->Password = 'jhE97ip(uFH)';                           // SMTP password
        			$mail->SMTPSecure = 'ssl';                            // Enable TLS encryption, `ssl` also accepted
        			$mail->Port = 465;                                    // TCP port to connect to
                    //$mail->IsHTML(true);
        //From email address and name
        $mail->From = "announcements@pattniworld.com";
        $mail->FromName = "Pattni World";
        $mail->addAddress($email); //Recipient name is optional
        //Address to which recipient will reply
        $mail->addReplyTo("app@lohananairobi.com", "Reply");
        $mail->Subject = "New announcement: $tt";
        $mail->Body = 'Dear '.$f_name.',<br/> Kindly note that a new announcement titled: '.$tt.' has been added to Pattni World. Use the link: https://pattniworld.com/detaill_announcement.php?id='.$announcement_id.' to view it.
        <br><br> Thank you.<br>'.$name.' <br/> Pattni World Team.<br><img src="https://pattniworld.com/images/Logo%20edited.png" style="width:120px;height:57px;"/>';
        $mail->AltBody = "this mail concerns application approval";
        if(!$mail->send())
        {
            echo "Mailer Error:".$mail->ErrorInfo;
        }
        else
        {
            echo "Message has been sent successfully";
        }
    
    
                        }
                      }

    
    
	$_SESSION['an_1']='<div class="alert alert-success alert-dismissible" role="alert">
  <button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">&times;</span></button>
  <strong>Announcement Added Successfully</strong>
</div>';
?>
<div class="alert alert-success alert-dismissible" role="alert">
  <button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">&times;</span></button>
  <strong>Success!</strong>
</div>
<?php
} else{
	$_SESSION['an_1']='<div class="alert alert-danger alert-dismissible" role="alert">
  <button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">&times;</span></button>
  <strong>Error! Publication Already Exists</strong>
</div>';
?>
<div class="alert alert-danger alert-dismissible" role="alert">
  <button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">&times;</span></button>
  <strong>Error!</strong>
</div>
<?php
}

	

} 
?> 

<?php


header('Location:../index.php');
?>