php - PHPMailer password-protected attachment -

-

i'm making php script, import data mysql database , send via email in attachment. there 1 issue - in future there possibility, data sensitive. need set password attachment.

i'm using phpmailer method addstringattachment.

some code:

<?php require 'phpmailerautoload.php'; $con = new mysqli("x", "x", "x", "x");   $utf1 = "set names utf8"; $utf2 = "set character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'";  $con->query($utf1); $con->query($utf2);   $output =''; $result = $con->query("select * xxx date( entry_date ) between ( date( curdate( ) - interval 3 day )) , ( date( curdate( ) - interval 1 day ) )"); $columns_total = $con->field_count;   // field name ($i = 0; $i < $columns_total; $i++) {     $heading = mysqli_fetch_field_direct($result, $i)->name;     $output .= '"'.$heading.'";'; }  $output .="\n";  // records table while ($row = $result->fetch_array()) {     ($i = 0; $i < $columns_total; $i++) {         $output .='"'.$row["$i"].'";';     }     $output .="\n"; }  $filename = "myfile.xls"; header('content-encoding: utf-8');           $bomoutput = "\xef\xbb\xbf" . $output;  $con->close();

phpmailer:

$mail = new phpmailer;  [...]  $mail->from = 'xx'; $mail->fromname = 'xx'; $mail->addaddress('xx');     // add recipient  $mail->addstringattachment($bomoutput, $filename);     $mail->subject = 'here subject'; $mail->body    = 'this html message body <b>in bold!</b>'; $mail->altbody = 'this body in plain text non-html mail clients';  if(!$mail->send()) {     echo 'message not sent.';     echo 'mailer error: ' . $mail->errorinfo; } else {     echo 'message has been sent'; }

i hade issues utf-8 chars, have use utf8 bom. can give me advice/tip, how set attachment secuirty level @ minimum? does'nt metter how encrypted - has be. give me rod, please.

this doesn't have phpmailer or mysql - store or send whatever like, , if want encrypt it, that's you.

php has several functions allow encrypt strings - making usable bit more involved if want sure recipient able decrypt - zip files easiest solution.

this question has suggestions.


Comments

Post a Comment

Popular posts from this blog

mysql - FireDac error 314 - but DLLs are in program directory -

-
i getting when trying access mysql database : [firedac][phys][mysql]-314. cannot load vendor library [libmysql.dll or libmysqlld.dll] this did not happen (unchanged) code, however, have upgraded windows 10 , had reinstall delphi xe8, system configuration matter. in order try solve problem, copied both of files c:\windows\sysytem32. when did not seem work, copied them \win32\debug, generated .exe resides. i imagine doing rather stupid, can't see what. the proper solution place driver file (eg., libmysql.dll ) in application's folder, or place installation location in fddrivers.ini file: [mysql] vendor=<folder>\libmysql.dll (recent versions of documentation seem use vendorlib instead of vendor in ini file.) see rad studio documentation topics configuring drivers (firedac) , connect mysql server (firedac) more information.
Read more

git - How to list all releases of public repository with GitHub API V3 -

-
so per documentation https://developer.github.com/v3/repos/releases/#list-releases-for-a-repository get /repos/:owner/:repo/releases should list relases , https://api.github.com/repos/jquery/jquery/releases should list releases in jquery project , not , why ? because repository doesn't have releases. has tags github presenting in releases page. for more clear example, see: https://github.com/hashicorp/terraform/releases which has both releases , tags showing on page, api shows releases: https://api.github.com/repos/hashicorp/terraform/releases
Read more

c++ - Getting C2512 "no default constructor" for `ClassA` error on the first parentheses of constructor for `ClassB`? -

-
my situation follows. let there header file classdeclarations.h , have following classes declared: class classa; class classb; class classa { public: classa(int x); classa(double y); int returninteger(void) { return m_x; } double returndouble(void) { return m_y; } private: int m_x; double m_y; } class classb { public: classb(int x); int returninteger(void) { return m_x; } private: int m_x; classa m_instancea_1; } let there *.cpp file called classdefns.cpp , define methods of classes declared in classdeclarations.h : #include classdeclarations.h classa::classa(int x) : m_x(x) { } classa::classa(double y) : m_y(y) { } classb::classb(int x) : m_x(x) { // line build error occurs m_instancea_1 = classa(0); } note have commented line compiler says there error: error c2512: 'classa' : no appropriate default constructor avai...
Read more