Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

Apache

System:

Linux 4.18.0-553.100.1.el8_10.x86_64

PHP Version:

7.2.34

User:

jaindirectory

Directory:

/home/jaindirectory/public_html/jainsociety

Free Space:

32.43 GB

🔧 Quick Actions

✏️ Editing: csv_demo.php

<?php

use PHPMailer\PHPMailer\PHPMailer;

use PHPMailer\PHPMailer\Exception;

// Load Composer's autoloader

//require 'vendor/autoload.php';

require 'PHPMailer/src/Exception.php';

require 'PHPMailer/src/PHPMailer.php';

require 'PHPMailer/src/SMTP.php';

include "Database.php";

//header('Content-Type: application/csv');

//header('Content-Disposition: attachment; filename=jaindirectory_Mf.csv;');

$crud= new Database();

function my_ucfirst($string, $e ='utf-8') {

if (function_exists('mb_strtoupper') && function_exists('mb_substr') && !empty($string)) {

$string = mb_strtolower($string, $e);

$upper = mb_strtoupper($string, $e);

preg_match('#(.)#us', $upper, $matches);

$string = $matches[1] . mb_substr($string, 1, mb_strlen($string, $e), $e);

} else {

$string = ucfirst($string);

}

return $string;

}

$query = "select * from member where family_id in (232100100921,232100101029) order by id  ";

$result = $crud->getAllData($query);

$f = fopen("pdf_card/abc.csv", "w");

//echo "hello"; die;

$head=array("S.No","Name","Address","Family ID","Mobile No","Sign");

fputcsv($f, $head);

$ii=1;

foreach($result as $row) {

$query_info = "select * from member_info where member_id='".$row['id']."' and relation='self' and name!='' order by id limit 1 ";

$result_info = $crud->getAllData($query_info);

foreach($result_info as $row1){

$from = new DateTime($row1['dob']);

$to   = new DateTime('today');

$age=$from->diff($to)->y;

$name=my_ucfirst($row1['name']);

if($age=='0' || $age>'150') {

$age='-';

}

$address= my_ucfirst($row["address"]);

$array=array(

$ii,$address,$name,$row['family_id'],$row['family_mo'],'');

fputcsv($f, $array);

$ii++;	}

}

fclose($f);

$file1 = fopen('pdf_card/abc.csv', 'r');

while(!feof($file1)) {

echo fgets($file1);

}

fclose($file1);

$mail = new PHPMailer(true);

try {

//Server settings

$mail->SMTPDebug = 2;                                       // Enable verbose debug output

$mail->isSMTP();                                            // Set mailer to use SMTP

$mail->Host       = 'jaindirectory.in';  // Specify main and backup SMTP servers

$mail->SMTPAuth   = true;                                   // Enable SMTP authentication

$mail->Username   = 'test@jaindirectory.in';                     // SMTP username

$mail->Password   = 'jaindir@123';                               // SMTP password

$mail->SMTPSecure = 'tls';                                  // Enable TLS encryption, `ssl` also accepted

$mail->Port       = 587;                                    // TCP port to connect to

//Recipients

$mail->setFrom('test@jaindirectory.in', 'jain directory');

//$mail->addAddress('b2b@jaindirectory.in');     // Add a recipient

//$mail->addAddress('deepakjain0734@gmail.com');     // Add a recipient

$mail->addAddress('eway.dev1@gmail.com');     // Add a recipient

// Attachments

//$mail->addAttachment('.csv');         // Add attachments

$mail->addAttachment('pdf_card/abc.csv');

// Content

$mail->isHTML(true);                                  // Set email format to HTML

$mail->Subject = 'Temple Pdf';

$mail->Body    = 'jain card attached';

$mail->AltBody = 'card';

$mail->send();

echo 'Message has been sent';

} catch (Exception $e) {

echo "Message could not be sent";

//echo "Message could not be sent. Mailer Error: {$mail->ErrorInfo}";

}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: csv_demo.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation