Email with attachment - PHP

$files = "logo.jpg";
// email fields: to, from, subject, and so on
$to = "example@example.com";
$from = "example@example.com";
$subject ="Test";
$message = "My message";
$headers = "From: $from";

// boundary
$semi_rand = md5(time());
$mime_boundary = "==Multipart_Boundary_x{$semi_rand}x";

// headers for attachment
$headers .= "\nMIME-Version: 1.0\n" . "Content-Type: multipart/mixed;\n" . " boundary=\"{$mime_boundary}\"";

// multipart boundary
$message = "This is a multi-part message in MIME format.\n\n" . "--{$mime_boundary}\n" . "Content-Type: text/html; charset=\"iso-8859-1\"\n" . "Content-Transfer-Encoding: 7bit\n\n" . $message . "\n\n";
$message .= "--{$mime_boundary}\n";

// preparing attachments
   
$file = fopen($files,"rb");
$data = fread($file,filesize($files));
fclose($file);
$data = chunk_split(base64_encode($data));
$message .= "Content-Type: {\"application/octet-stream\"};\n" . " name=\"$files\"\n" .
"Content-Disposition: attachment;\n" . " filename=\"$files\"\n" .
"Content-Transfer-Encoding: base64\n\n" . $data . "\n\n";
$message .= "--{$mime_boundary}-\n";

// send

$ok = @mail($to, $subject, $message, $headers);
if ($ok) {
    echo "<p>mail sent to $to!</p>";
} else {
    echo "<p>mail could not be sent!</p>";
}

Email Using - Wordpress

$headers= "MIME-Version: 1.0\n" .
        "From: Me <dale.hurley@example.com>\n" .
        "Content-Type: text/html; charset=\"" .
get_option('blog_charset') . "\"\n";
wp_mail($emailaddress, $subject, $content, $headers);

PHP Email - set the email text/html format

HTML email example

$email = "email@example.com";
$subject = "Test";
$message = "Html format message, e.g <div>message</div>";
$headers = "MIME-Version: 1.0\n" .
        "From: Me <me@example.com>\n" .
        "Content-Type: text/html; charset=\"UTF-8\"\n";
mail($email, $subject, $message , $headers);

Listing the category and subcategory from single table

You table structure

create table categories
( id       integer     not null  primary key
, name     varchar(37) not null
, parentid integer     null
, foreign key parentid_fk (parentid)
      references categories (id)
);

Your Sql

select root.name  as root_name
     , down1.name as down1_name
     , down2.name as down2_name
     , down3.name as down3_name
  from categories as root
left outer
  join categories as down1
    on down1.parentid = root.id
left outer
  join categories as down2
    on down2.parentid = down1.id
left outer
  join categories as down3
    on down3.parentid = down2.id
 where root.parentid is null
order
    by root_name
     , down1_name
     , down2_name
     , down3_name

Archive and extract files using command line

To create the  archive files use following command

tar -czf test.tar.gz test/

To extract the files use following command

tar -xzf test.tar.gz 

 

To repair Mysql Table

To repair Mysql Table use the following command.
 
$ myisamchk -r /usr/local/mysql/data/dbname/tablename.MYI

Thanks
Vishnu U