<?php

 // Connects to your Database
 mysql_connect("localhost", "root", "secretpassword") or die(mysql_error());
 mysql_select_db("ispcp") or die(mysql_error());
 
 // Function to talk with SQL by ZBT :)
 function result($query)
     {
          $array = $result = array();

          $query = mysql_query($query) or die(mysql_error());

          while($re = mysql_fetch_array($query, MYSQL_ASSOC))
                    $array[] = $re;

          if(!sizeof($array)) return false;

          foreach($array as $no => $arr)
               foreach($arr as $key => $val)
                    $result[$no][$key] = stripslashes($val);

          return $result;
     }

 // query to database
 $query = result("SELECT * FROM `domain` WHERE `domain_created_id`= '3'");

  foreach($query as $row){

    if (($row['domain_expires'] != '') || ($row['domain_expires'] != '0')){
      $year = date('Y'); $month = date('n'); $day = date('d');
        $end = date("Y-m-d", $row['domain_expires']);
          $ile_dni = (strtotime("$end GMT")-strtotime("$year-$month-$day GMT"))/86400;

// 14 dni
    if ($ile_dni == '14'){
        $email = result("SELECT * FROM `admin` WHERE `admin_id` = '".$row['domain_admin_id']."'");
          foreach($email as $row1){
            $email=$row1['email'];
      }

      $naglowki = "From: contact@domain.tld".PHP_EOL."Content-type: text/plain; charset=utf-8";

      mail($email, 'Reminder', "\n\n\nWelcome ".$row['domain_name']." your account expire for 14 days", $naglowki);
      mail('myemail@domain.tld', 'Reminder', "\n\n\nAccount ".$row['domain_name']." for 14 days die", $naglowki);
    }

// 30 dni
    if ($ile_dni == '30'){
        $email = result("SELECT * FROM `admin` WHERE `admin_id` = '".$row['domain_admin_id']."'");
          foreach($email as $row1){
            $email=$row1['email'];
      }

      $naglowki = "From: contact@domain.tld".PHP_EOL."Content-type: text/plain; charset=utf-8";

      mail($email, 'Reminder', "\n\n\nWelcome ".$row['domain_name']." your account expire for 30 days", $naglowki);
      mail('myemail@domain.tld', 'Reminder', "\n\n\nAccount ".$row['domain_name']." expire for 30 days", $naglowki);

    }

  }

}

?>