Gecko [ eachadeal.com ]

Name	Size	Permission	Date
.well-known	[ DIR ]	drwxr-xr-x	2019-10-09 06:45
ajaxcall	[ DIR ]	drwxr-xr-x	2019-10-09 08:39
assets	[ DIR ]	drwxr-xr-x	2025-10-29 23:03
css	[ DIR ]	drwxr-xr-x	2019-10-25 02:53
js	[ DIR ]	drwxr-xr-x	2019-10-25 02:52
pdf	[ DIR ]	drwxr-xr-x	2019-10-15 12:31
phpMailer	[ DIR ]	drwxr-xr-x	2016-03-30 06:50
signatures	[ DIR ]	drwxr-xr-x	2016-03-20 05:27
.htaccess	279 B	-rw-r--r--	2020-12-01 10:37
calendar.php	12.63 KB	-rw-r--r--	2019-10-25 03:18
config.php	384 B	-rw-r--r--	2016-03-19 12:15
edit-customer.php	10.61 KB	-rw-r--r--	2019-10-25 03:52
email-reminder.php	1.88 KB	-rw-r--r--	2019-11-14 09:08
error_log	1.19 MB	-rw-r--r--	2024-05-14 22:57
footer.php	48 B	-rw-r--r--	2016-03-19 12:21
header.php	2.9 KB	-rw-r--r--	2020-12-01 10:45
index.php	62 B	-rw-r--r--	2019-10-09 06:47
maintenance-form-unique-key.php	12.55 KB	-rw-r--r--	2019-10-09 06:28
maintenance-form.php	11.19 KB	-rw-r--r--	2019-10-09 16:21
new-customer.php	1.3 KB	-rw-r--r--	2016-03-31 13:37
new-form.php	2.14 KB	-rw-r--r--	2019-10-09 09:32
phpinfo.php	69 B	-rw-r--r--	2019-10-08 09:21
post-maintenance.php	4.77 KB	-rw-r--r--	2019-10-25 09:33
uniquekey.php	964 B	-rw-r--r--	2019-10-09 06:49
wp.php	18 B	-rw-r--r--	2025-10-28 12:36

Rename

<?php
$base_url="http://eachadeal.com/maintenance/";
$servername = "localhost";
$username = "eachadea_mainten";
$password = "{o(5w6%[x}T0";
$database = "eachadea_maintenance";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $database);
// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

<?php
require('phpMailer/class.phpmailer.php');

$from = date("Y-m-d");
    $to = date('Y-m-d', strtotime($from. ' + 8 days'));
    $sql = "SELECT * FROM calendar INNER JOIN customer ON customer.id=calendar.customer_id WHERE calendar.date BETWEEN '".$from."' and '".$to."';";

$result = mysqli_query($conn, $sql); 
    if (mysqli_num_rows($result)==0)
        return;
    while($row = mysqli_fetch_assoc($result)) {
    
        $summary[] = Array($row['date'], $row['name'], $row['address'], $row['email'], $row['phone'], $row['contact_person']);
        
        $body .= '<h2>'.$row['date'].'</h2>';
        $body .= $row['name'] .'<br />'.
        $row['address'] .'<br />'.
        $row['email'] .'<br />'.
        $row['phone'] .'<br />'.
        $row['contact_person'];
        
        $body .= '<br /><br /><br />';
    }

$body .= '<a href="'.$_SESSION['base_url'].'calendar.php?month='.date("m",strtotime($summary[0][0])).'&year='.date("Y",strtotime($summary[0][0])).'">Click here to create maintenance form</a>';
    
    echo $body;
    
    $mail = new PHPMailer();

$mail->setFrom('contactus@homegym.sg', 'HOMEGYM.SG');
	$mail->addAddress('homegym.sg@gmail.com');
	$mail->addReplyTo('contactus@homegym.sg', 'HOMEGYM.SG');
	$mail->isHTML(true);

$mail->Subject = 'Maintenance Reminder';
	$mail->Body    = $body;
	$mail->AltBody = 'This is an email in plain text for non-HTML mail clients. Please see attachment for maintenance report.';
	
	
	$mail->Send();
	
?>

<?php mysqli_close($conn);?>