invisio v2.0

<?php
	include ('config.php');
	include('example.php');
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

$con = mysql_connect("50.62.209.50:3306","iseecrm","iseecrm123!@#");
	if (!$con)
	  {
	  die('Could not connect: ' . mysql_error());
	  }
	
	mysql_select_db("iseecrm", $con);
?>

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<style type="text/css">
@page {
    size: landscape;
}

@media print {
    table.paging thead td, table.paging tfoot td {
    }
	body {-webkit-print-color-adjust: exact;}
	
}

header, footer {
    width: 100%; height: .6in;
}

header {
    position: absolute;
    top: 0;
}

@media print {
    header, footer {
        position: fixed;
    }
    
    footer {
        bottom: 0;
    }
	.noprint {display:none;}
}
</style>
    <style type="text/css">
<!--

@media print
{
.noprint {display:none;}
}

@media screen
{
...
}

-->
</style><script>
function myFunction() {
    window.print();
}
</script>
<title>Things To Do Report</title>

</head>
<body>
<div align="center" style="background-color:#FFF">
	<img src="logo.png" ><HR  style="border-color:##1B75BB; color:#1B75BB" />
    		<h3 ><b>Things To Do Report</b></h3>

<table
		style="border-collapse: collapse; "
		border="1" cellpadding="5" width="100%">
	<thead>
		<tr style="background-color:#3753A4; color:#fff;">
			<th >Task Date</th>
            <th>Task By</th>
            <th>To Be Handle By</th>
            <th >Task Description</th>
            <th> Action Taken Description</th>
            <th >Action Taken</th>
		</tr>
	</thead>
    <tbody>
    		<?php
			
				$i =1;
				$stats = 'Paid';
				$taskstatus = 'Resolved';
				
				$resulttedo = $js->prepare('SELECT * FROM `task_reminders` WHERE taskstatus != :taskstatus ORDER BY `taskdate` ');
						  $resulttedo->execute(array(':taskstatus' => $taskstatus));

while($row = $resulttedo->fetch(PDO::FETCH_ASSOC)) 
			{
				$id = $row['id'];
				$subject = $row['tasksubj'];
				$taskdate = $row['taskdate'];
				$tasktime = $row['tasktime'];
				$taskdetails = $row['taskdetails'];
				$upremarks = $row['upremarks'];
				$taskby = $row['taskby'];
				$result1 = mysql_query("SELECT * FROM employees WHERE empid = '$taskby' ORDER BY empname");
              
              	while($row1 = mysql_fetch_array($result1))
                {
                      $taskname = strtoupper($row1['empname']);
                }
				$handled = $row['handled'];
				$result2 = mysql_query("SELECT * FROM employees WHERE empid = '$handled' ORDER BY empname"); 
              
              	while($row2 = mysql_fetch_array($result2))
                {
                      $handledname = strtoupper($row2['empname']);
                }
				
				$taskstatus = $row['taskstatus'];
				
				$updated = $row['taskupdatedtime'];
				
				
				$tdate = date('d-m-Y', strtotime($taskdate));
				echo "<tr>";
				echo "<td>$tdate</td>";
				echo "<td>$taskname</td>";
				echo "<td>$handledname</td>";
				echo "<td>$taskdetails</td>";
				echo "<td>$upremarks</td>";
					echo "<td><a href='update_thingstodostatus.php?task=$id'>$taskstatus</td>";
				/*echo "<td><a href='edit_reminders.php?task=$id' style='background-color:#47A3CF; border-color:#47A3CF;' class='btn btn-primary btn-circle' ><i  class='fas fa-edit'></i></a></td>";*/
				echo "</tr>";
			}
				
			?>
    </tbody>
    </table>
    
    </div>
    
<div class="noprint">
	<p align="center">
    	<a href="#" onClick="myFunction()" style="border:5px solid; background-color:#006; color:#FFF; padding:8px; text-decoration:none;">PRINT</a>
        
        <a href="search_pendinginvoices.php" style="border:5px solid; background-color:#F00; color:#FFF; padding:8px; text-decoration:none;">CLOSE</a>
    </p>
</div>