invisio v2.0

<?php
	include('config.php');
	
	date_default_timezone_set('Asia/Muscat');
 	$de = date('d-m-Y  H:i:s');
?>
<!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> Registration Details as on <?php echo $de?> for the BREATHTAKING OMAN EVENT</title>

</head>
<body>
<div align="center" style="background-color:#FFF">
	<img src="images/dmc logo.png" width="200" height="60"><HR  style="border-color:#5053FD" />
	<h3><b> Registration Details as on <?php echo $de?> for the BREATHTAKING OMAN EVENT </b></h3>
	<table
		style="border-collapse: collapse; "
		border="1" cellpadding="5" width="100%">
	<thead>
		<tr style="background-color:#030303; color:#fff;">
			<th>SL No</th>
			<th>Registration_Date</th> 
			<th>Participant ID</th>
            <th>Participant Name</th>
            <th>Mobile</th>
            <th>Email</th>
            <th>Agency Name</th>
            <th>Agency Address</th>
			<th>Location</th>
			<th>Remarks</th> 
		</tr>
	</thead>
	<?php
	
	$i = 1;
	
	$resultrr = $js->prepare('SELECT * FROM `businessmeet` ORDER BY `id` ');
			$resultrr->execute();
									 
	while($rowrr = $resultrr->fetch(PDO::FETCH_ASSOC))
		{
			$id = $rowrr['id'];
			$personid = $rowrr['personid'];
			$rdate = date('d-m-Y', strtotime($rowrr['registerdate']));
			$pname = strtoupper($rowrr['personname']);
			$mobile = $rowrr['mobile'];
			$email = $rowrr['emailid'];
			$loc = strtoupper($rowrr['location']);
			$agency = strtoupper($rowrr['agencyname']);
			$addr = $rowrr['address'];
			$remarks = $rowrr['comments'];
			
			echo "<tr>";
				echo "<td align='center'>$i</td>";
				echo "<td align='center'>$rdate</td>";
				echo "<td>$personid</td>";
				echo "<td style='padding-left:10px; padding-right:10px;'>$pname</td>";
				echo "<td style='padding-left:10px; padding-right:10px;'>$mobile</td>";
				echo "<td style='padding-left:10px; padding-right:10px;'>$email</td>";
				echo "<td style='padding-left:10px; padding-right:10px;'>$agency</td>";
				echo "<td style='padding-left:10px; padding-right:10px;'>$addr</td>";
				echo "<td align='center'>$loc</td>";
				echo "<td style='padding-left:10px; padding-right:10px;'>$remarks</td>"; 
			echo "</tr>";
			$i++;
		}