| Server IP : 92.204.40.98 / Your IP : 216.73.216.201 Web Server : LiteSpeed System : Linux amster.dnsfors.com 4.18.0-553.111.1.el8_10.x86_64 #1 SMP Sun Mar 8 20:06:07 EDT 2026 x86_64 User : tmksyste ( 2190) PHP Version : 8.3.31 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/tmksyste/public_html/applications/ |
Upload File : |
<!DOCTYPE HTML>
<html>
<head>
<title>TMK Systems | Tables</title>
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="keywords" content="" />
<script type="application/x-javascript"> addEventListener("load", function() { setTimeout(hideURLbar, 0); }, false); function hideURLbar(){ window.scrollTo(0,1); } </script>
<!-- Bootstrap Core CSS -->
<link href="css/bootstrap.css" rel='stylesheet' type='text/css' />
<!-- Custom CSS -->
<link href="css/style.css" rel='stylesheet' type='text/css' />
<!-- font-awesome icons CSS -->
<link href="css/font-awesome.css" rel="stylesheet">
<!-- //font-awesome icons CSS -->
<!-- side nav css file -->
<link href='css/SidebarNav.min.css' media='all' rel='stylesheet' type='text/css'/>
<!-- side nav css file -->
<!-- js-->
<script src="js/jquery-1.11.1.min.js"></script>
<script src="js/modernizr.custom.js"></script>
<!--webfonts-->
<link href="//fonts.googleapis.com/css?family=PT+Sans:400,400i,700,700i&subset=cyrillic,cyrillic-ext,latin-ext" rel="stylesheet">
<!--//webfonts-->
<!-- Metis Menu -->
<script src="js/metisMenu.min.js"></script>
<script src="js/custom.js"></script>
<link href="css/custom.css" rel="stylesheet">
<!--//Metis Menu -->
</head>
<body class="cbp-spmenu-push">
<div class="main-content">
<?php include('sidemenu.php');?>
<?php include('connection.php');error_reporting(0);?>
<!-- main content start-->
<div id="page-wrapper">
<div class="main-page">
<div class="tables">
<h2 class="title1">Upcoming Services</h2>
<div class="bs-example widget-shadow" data-example-id="bordered-table">
<h4>Services List: </h4>
<table class="table table-bordered"> <thead>
<tr><th>#</th>
<th>Added Date</th>
<th>Next Service</th>
<th>Customer Name</th>
<th>Service Note</th>
<th>Interval</th>
</tr>
</thead><tbody>
<?php
$date=date('Y-m-d');
$todate=date("Y-m-d",strtotime("+15 days"));
$sql="SELECT * FROM `service` WHERE `nextdate`>'$date' and `nextdate`<='$todate' order by nextdate asc";
$result=mysql_query($sql) or die(mysql_error());
$i=1;
while($row=mysql_fetch_array($result))
{
$id=$row['cid'];
$sqls1="select * from leads where lid='$id'";
$results1=mysql_query($sqls1)or die(mysql_error());
$rows1=mysql_fetch_array($results1);
?>
<tr><th scope="row"><?php echo $i;?></th>
<td><?php echo date("d-m-Y",strtotime($row['date']));?></td>
<td><?php echo date("d-m-Y",strtotime($row['nextdate']));?></td>
<td><?php echo $rows1['name_firm'];?></td>
<td><?php echo $row['snotes'];?></td>
<td><?php echo $row['sinterval'];?></td>
</tr>
<?php $i=$i+1;}?>
</tbody> </table>
</div>
</div>
</div>
</div>
<?php include('footer.php');?>
</div>
<!-- side nav js -->
<script src='js/SidebarNav.min.js' type='text/javascript'></script>
<script>
$('.sidebar-menu').SidebarNav()
</script>
<!-- //side nav js -->
<!-- Classie --><!-- for toggle left push menu script -->
<script src="js/classie.js"></script>
<script>
var menuLeft = document.getElementById( 'cbp-spmenu-s1' ),
showLeftPush = document.getElementById( 'showLeftPush' ),
body = document.body;
showLeftPush.onclick = function() {
classie.toggle( this, 'active' );
classie.toggle( body, 'cbp-spmenu-push-toright' );
classie.toggle( menuLeft, 'cbp-spmenu-open' );
disableOther( 'showLeftPush' );
};
function disableOther( button ) {
if( button !== 'showLeftPush' ) {
classie.toggle( showLeftPush, 'disabled' );
}
}
</script>
<!-- //Classie --><!-- //for toggle left push menu script -->
<!--scrolling js-->
<script src="js/jquery.nicescroll.js"></script>
<script src="js/scripts.js"></script>
<!--//scrolling js-->
<!-- Bootstrap Core JavaScript -->
<script src="js/bootstrap.js"> </script>
</body>
</html>