DatabaSE:
CREATE TABLE IF NOT EXISTS `kontak` (
`id_kontak` int(11) NOT NULL,
`id_user` varchar(20) NOT NULL,
`nama` varchar(50) NOT NULL,
`tlp` varchar(12) NOT NULL,
`tgl` date NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=86506 DEFAULT CHARSET=latin1;
COPAS SKRIP INI
<?php
include "../config/koneksi.php";
$tgl=date('Y-m-d');
date_default_timezone_get('Asia/Jakarta');
$tanggal_now = date('Y-m-d');
$tambah_tanggal = mktime(0,0,0,date('m'),date('d')-1,date('Y'));
$tambah = date('Y-m-d',$tambah_tanggal);
date_default_timezone_get('Asia/Jakarta');
$tanggal_now2 = date('Y-m-d');
$tambah_tanggal2 = mktime(0,0,0,date('m'),date('d')-2,date('Y'));
$tambah2 = date('Y-m-d',$tambah_tanggal2);
date_default_timezone_get('Asia/Jakarta');
$tanggal_now3 = date('Y-m-d');
$tambah_tanggal3 = mktime(0,0,0,date('m'),date('d')-3,date('Y'));
$tambah3 = date('Y-m-d',$tambah_tanggal3);
date_default_timezone_get('Asia/Jakarta');
$tanggal_now4 = date('Y-m-d');
$tambah_tanggal4 = mktime(0,0,0,date('m'),date('d')-4,date('Y'));
$tambah4 = date('Y-m-d',$tambah_tanggal4);
date_default_timezone_get('Asia/Jakarta');
$tanggal_now5 = date('Y-m-d');
$tambah_tanggal5 = mktime(0,0,0,date('m'),date('d')-5,date('Y'));
$tambah5 = date('Y-m-d',$tambah_tanggal5);
date_default_timezone_get('Asia/Jakarta');
$tanggal_now6 = date('Y-m-d');
$tambah_tanggal6 = mktime(0,0,0,date('m'),date('d')-6,date('Y'));
$tambah6 = date('Y-m-d',$tambah_tanggal6);
date_default_timezone_get('Asia/Jakarta');
$tanggal_now7 = date('Y-m-d');
$tambah_tanggal7 = mktime(0,0,0,date('m'),date('d')-7,date('Y'));
$tambah7 = date('Y-m-d',$tambah_tanggal7);
?>
<!DOCTYPE HTML>
<html>
<head>
<title>The Fitness_Time for Iphone, Android & Smartphone Mobile Website Template | Home :: w3layouts</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="viewport" content="width=device-width; initial-scale=1.0; maximum-scale=1.0; user-scalable=0;" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="keywords" content="Fitness_Time Iphone web template, Andriod web template, Smartphone web template, free webdesigns for Nokia, Samsung, LG, SonyErricsson, Motorola web design" />
<script type="application/x-javascript"> addEventListener("load", function() { setTimeout(
hideURLbar, 0); }, false); function hideURLbar(){ window.scrollTo(0,1); } </script>
<link href="css/style.css" rel="stylesheet" type="text/css" media="all" />
<script src="js/jquery.min.js"></script>
<!---- start-smoth-scrolling---->
<script type="text/javascript" src="js/move-top.js"></script>
<script type="text/javascript" src="js/easing.js"></script>
<script type="text/javascript">
jQuery(document).ready(function($) {
$(".scroll").click(function(event){
event.preventDefault();
$('html,body').animate({scrollTop:$(this.hash).offset().top},1000);
});
});
</script>
<!---- start-smoth-scrolling---->
<meta name="viewport" content="width=device-width, initial-scale=1">
<script type="application/x-javascript"> addEventListener("load", function() { setTimeout(hideURLbar, 0); }, false); function hideURLbar(){ window.scrollTo(0,1); } </script>
</script>
<!----webfonts---->
<link href='http://fonts.googleapis.com/css?family=Oswald:300,400,700' rel='stylesheet' type='text/css'>
<link href='http://fonts.googleapis.com/css?family=Droid+Serif' rel='stylesheet' type='text/css'>
<link href='http://fonts.googleapis.com/css?family=Open+Sans' rel='stylesheet' type='text/css'>
<!----//webfonts---->
<!--nav-->
<script src="js/mobile.js"></script>
</script><script type="text/javascript">window.onload = function() { w3Init(); };</script>
</head>
<body>
<!-----start-container---->
<!----- start-header---->
<div id="home" class="header">
<div id="w3-masthead">
<div id="w3-universal-nav">
<ul id="header">
<div class="logo">
<a href="index.php"><img src="images/logo.png" alt=""/></a>
</div>
</ul>
<div id="w3-mobile-options">
<li id="w3-menu-trigger">
<a href="">Menu</a></li>
</div>
<ul id="w3-menu-links" style="display: none;">
<li class="active"><a href="#home" class="scroll">Home</a></li>
</ul>
</div>
</div>
</div>
<!----- //End-header---->
<!----start-slider-script---->
<script src="js/responsiveslides.min.js"></script>
<script>
// You can also use "$(window).load(function() {"
$(function () {
// Slideshow 4
$("#slider4").responsiveSlides({
auto: true,
pager: true,
nav: true,
speed: 500,
namespace: "callbacks",
before: function () {
$('.events').append("<li>before event fired.</li>");
},
after: function () {
$('.events').append("<li>after event fired.</li>");
}
});
});
</script>
<!----//End-slider-script---->
<!-- Slideshow 4 -->
<div id="top" class="callbacks_container">
<ul class="rslides" id="slider4">
<li>
<img src="http://danmogot.com/foto_banner/1.jpg" alt="">
<div class="caption">
<div class="slide-text-info">
</div>
</div>
</li>
<li>
<img src="http://danmogot.com/foto_banner/2.jpg" alt="">
<div class="caption">
<div class="slide-text-info">
</div>
</div>
</li>
<li>
<img src="http://danmogot.com/foto_banner/3.jpg" alt="">
<div class="caption">
<div class="slide-text-info">
</div>
</div>
</li>
<li>
<img src="http://danmogot.com/foto_banner/4.jpg" alt="">
<div class="caption">
<div class="slide-text-info">
</div>
</div>
</li>
<li>
<img src="http://danmogot.com/foto_banner/5.jpg" alt="">
<div class="caption">
<div class="slide-text-info">
</div>
</div>
</li>
<li>
<img src="http://danmogot.com/foto_banner/6.jpg" alt="">
<div class="caption">
<div class="slide-text-info">
</div>
</div>
</li>
<li>
<img src="http://danmogot.com/foto_banner/7.jpg" alt="">
<div class="caption">
<div class="slide-text-info">
</div>
</div>
</li>
</ul>
</div>
<div class="clear"> </div>
<!----- //End-slider---->
<!-----start-fearures---->
<div class="features" id="features">
<div class="container">
<div class="features-head text-center">
<h2>Doni</span></h2>
<?php
$waktu= 7;
$query = mysql_query("SELECT * FROM kontak WHERE id_user='doni' AND tgl='$tgl'");
$jumlah = mysql_num_rows($query);
$query2 = mysql_query("SELECT * FROM kontak WHERE id_user='doni' AND tgl='$tambah'");
$jumlah2 = mysql_num_rows($query2);
$query3 = mysql_query("SELECT * FROM kontak WHERE id_user='doni' AND tgl='$tambah2'");
$jumlah3 = mysql_num_rows($query3);
$query4 = mysql_query("SELECT * FROM kontak WHERE id_user='doni' AND tgl='$tambah3'");
$jumlah4 = mysql_num_rows($query4);
$query5 = mysql_query("SELECT * FROM kontak WHERE id_user='doni' AND tgl='$tambah4'");
$jumlah5 = mysql_num_rows($query5);
$query6 = mysql_query("SELECT * FROM kontak WHERE id_user='doni' AND tgl='$tambah5'");
$jumlah6 = mysql_num_rows($query6);
$query7 = mysql_query("SELECT * FROM kontak WHERE id_user='doni' AND tgl='$tambah6'");
$jumlah7 = mysql_num_rows($query7);
$query8 = mysql_query("SELECT * FROM kontak WHERE id_user='doni' AND tgl='$tambah7'");
$jumlah8 = mysql_num_rows($query8);
$query10 = mysql_query("SELECT * FROM kontak WHERE id_user='doni' AND DATEDIFF(CURDATE(),tgl) < $waktu");
$jumlah10 = mysql_num_rows($query10);
$query9 = mysql_query("SELECT * FROM kontak WHERE id_user='doni'");
$jumlah9 = mysql_num_rows($query9);
echo " <div align='center'>
<p><table>
<tr align='center' bgcolor='#FF8000'>
<td>1</td>
<td>2</td>
<td>3</td>
<td>4</td>
<td>5</td>
<td>6</td>
<td>7</td>
</tr>
<tr bgcolor='#FEDFBF'>
<td> $jumlah-</td>
<td> $jumlah2-</td>
<td> $jumlah3-</td>
<td> $jumlah4-</td>
<td> $jumlah5-</td>
<td> $jumlah6-</td>
<td> $jumlah7</td>
</tr>
<tr>
<td colspan='6'>Total Perminggu</td>
<td>$jumlah10</td>
</tr>
<tr>
<td colspan='6'>Total Keseluruhan</td>
<td>$jumlah9</td>
</tr>
</table></p>"; ?>
</div>
<div class="feature-grids">
<div class="col-md-3 feature-grid">
<h3></span>rendra</h3>
<?php
$waktu= 7;
$query = mysql_query("SELECT * FROM kontak WHERE id_user='rendra' AND tgl='$tgl'");
$jumlah = mysql_num_rows($query);
$query2 = mysql_query("SELECT * FROM kontak WHERE id_user='rendra' AND tgl='$tambah'");
$jumlah2 = mysql_num_rows($query2);
$query3 = mysql_query("SELECT * FROM kontak WHERE id_user='rendra' AND tgl='$tambah2'");
$jumlah3 = mysql_num_rows($query3);
$query4 = mysql_query("SELECT * FROM kontak WHERE id_user='rendra' AND tgl='$tambah3'");
$jumlah4 = mysql_num_rows($query4);
$query5 = mysql_query("SELECT * FROM kontak WHERE id_user='rendra' AND tgl='$tambah4'");
$jumlah5 = mysql_num_rows($query5);
$query6 = mysql_query("SELECT * FROM kontak WHERE id_user='rendra' AND tgl='$tambah5'");
$jumlah6 = mysql_num_rows($query6);
$query7 = mysql_query("SELECT * FROM kontak WHERE id_user='rendra' AND tgl='$tambah6'");
$jumlah7 = mysql_num_rows($query7);
$query8 = mysql_query("SELECT * FROM kontak WHERE id_user='rendra' AND tgl='$tambah7'");
$jumlah8 = mysql_num_rows($query8);
$query10 = mysql_query("SELECT * FROM kontak WHERE id_user='rendra' AND DATEDIFF(CURDATE(),tgl) < $waktu");
$jumlah10 = mysql_num_rows($query10);
$query9 = mysql_query("SELECT * FROM kontak WHERE id_user='rendra'");
$jumlah9 = mysql_num_rows($query9);
echo " <div align='center'>
<p><table>
<tr align='center' bgcolor='#008E00'>
<td>1</td>
<td>2</td>
<td>3</td>
<td>4</td>
<td>5</td>
<td>6</td>
<td>7</td>
</tr>
<tr bgcolor='#00CC00'>
<td> $jumlah-</td>
<td> $jumlah2-</td>
<td> $jumlah3-</td>
<td> $jumlah4-</td>
<td> $jumlah5-</td>
<td> $jumlah6-</td>
<td> $jumlah7</td>
</tr>
<tr>
<td colspan='6'>Total Perminggu</td>
<td>$jumlah10</td>
</tr>
<tr>
<td colspan='6'>Total Keseluruhan</td>
<td>$jumlah9</td>
</tr>
</table></p>"; ?>
</div>
<div class="feature-grids">
<div class="col-md-3 feature-grid">
<h3></span>pohan</h3>
<?php
$waktu= 7;
$query = mysql_query("SELECT * FROM kontak WHERE id_user='pohan' AND tgl='$tgl'");
$jumlah = mysql_num_rows($query);
$query2 = mysql_query("SELECT * FROM kontak WHERE id_user='pohan' AND tgl='$tambah'");
$jumlah2 = mysql_num_rows($query2);
$query3 = mysql_query("SELECT * FROM kontak WHERE id_user='pohan' AND tgl='$tambah2'");
$jumlah3 = mysql_num_rows($query3);
$query4 = mysql_query("SELECT * FROM kontak WHERE id_user='pohan' AND tgl='$tambah3'");
$jumlah4 = mysql_num_rows($query4);
$query5 = mysql_query("SELECT * FROM kontak WHERE id_user='pohan' AND tgl='$tambah4'");
$jumlah5 = mysql_num_rows($query5);
$query6 = mysql_query("SELECT * FROM kontak WHERE id_user='pohan' AND tgl='$tambah5'");
$jumlah6 = mysql_num_rows($query6);
$query7 = mysql_query("SELECT * FROM kontak WHERE id_user='pohan' AND tgl='$tambah6'");
$jumlah7 = mysql_num_rows($query7);
$query8 = mysql_query("SELECT * FROM kontak WHERE id_user='pohan' AND tgl='$tambah7'");
$jumlah8 = mysql_num_rows($query8);
$query10 = mysql_query("SELECT * FROM kontak WHERE id_user='pohan' AND DATEDIFF(CURDATE(),tgl) < $waktu");
$jumlah10 = mysql_num_rows($query10);
$query9 = mysql_query("SELECT * FROM kontak WHERE id_user='pohan'");
$jumlah9 = mysql_num_rows($query9);
echo " <div align='center'>
<p><table>
<tr align='center' bgcolor='#B2A100'>
<td>1</td>
<td>2</td>
<td>3</td>
<td>4</td>
<td>5</td>
<td>6</td>
<td>7</td>
</tr>
<tr bgcolor='#FFE500'>
<td> $jumlah-</td>
<td> $jumlah2-</td>
<td> $jumlah3-</td>
<td> $jumlah4-</td>
<td> $jumlah5-</td>
<td> $jumlah6-</td>
<td> $jumlah7</td>
</tr>
<tr>
<td colspan='6'>Total Perminggu</td>
<td>$jumlah10</td>
</tr>
<tr>
<td colspan='6'>Total Keseluruhan</td>
<td>$jumlah9</td>
</tr>
</table></p>"; ?>
</div>
<div class="feature-grids">
<div class="col-md-3 feature-grid">
<h3></span>odi</h3>
<?php
$waktu= 7;
$query = mysql_query("SELECT * FROM kontak WHERE id_user='odi' AND tgl='$tgl'");
$jumlah = mysql_num_rows($query);
$query2 = mysql_query("SELECT * FROM kontak WHERE id_user='odi' AND tgl='$tambah'");
$jumlah2 = mysql_num_rows($query2);
$query3 = mysql_query("SELECT * FROM kontak WHERE id_user='odi' AND tgl='$tambah2'");
$jumlah3 = mysql_num_rows($query3);
$query4 = mysql_query("SELECT * FROM kontak WHERE id_user='odi' AND tgl='$tambah3'");
$jumlah4 = mysql_num_rows($query4);
$query5 = mysql_query("SELECT * FROM kontak WHERE id_user='odi' AND tgl='$tambah4'");
$jumlah5 = mysql_num_rows($query5);
$query6 = mysql_query("SELECT * FROM kontak WHERE id_user='odi' AND tgl='$tambah5'");
$jumlah6 = mysql_num_rows($query6);
$query7 = mysql_query("SELECT * FROM kontak WHERE id_user='odi' AND tgl='$tambah6'");
$jumlah7 = mysql_num_rows($query7);
$query8 = mysql_query("SELECT * FROM kontak WHERE id_user='odi' AND tgl='$tambah7'");
$jumlah8 = mysql_num_rows($query8);
$query10 = mysql_query("SELECT * FROM kontak WHERE id_user='odi' AND DATEDIFF(CURDATE(),tgl) < $waktu");
$jumlah10 = mysql_num_rows($query10);
$query9 = mysql_query("SELECT * FROM kontak WHERE id_user='odi'");
$jumlah9 = mysql_num_rows($query9);
echo " <div align='center'>
<p><table>
<tr align='center' bgcolor='#FE80B9'>
<td>1</td>
<td>2</td>
<td>3</td>
<td>4</td>
<td>5</td>
<td>6</td>
<td>7</td>
</tr>
<tr>
<td> $jumlah-</td>
<td> $jumlah2-</td>
<td> $jumlah3-</td>
<td> $jumlah4-</td>
<td> $jumlah5-</td>
<td> $jumlah6-</td>
<td> $jumlah7</td>
</tr>
<tr bgcolor='#FEBFDC'>
<td colspan='6'>Total Perminggu</td>
<td>$jumlah10</td>
</tr>
<tr>
<td colspan='6'>Total Keseluruhan</td>
<td>$jumlah9</td>
</tr>
</table></p>"; ?>
</div>
<div class="feature-grids">
<div class="col-md-3 feature-grid">
<h3></span>hery</h3>
<?php
$waktu= 7;
$query = mysql_query("SELECT * FROM kontak WHERE id_user='hery' AND tgl='$tgl'");
$jumlah = mysql_num_rows($query);
$query2 = mysql_query("SELECT * FROM kontak WHERE id_user='hery' AND tgl='$tambah'");
$jumlah2 = mysql_num_rows($query2);
$query3 = mysql_query("SELECT * FROM kontak WHERE id_user='hery' AND tgl='$tambah2'");
$jumlah3 = mysql_num_rows($query3);
$query4 = mysql_query("SELECT * FROM kontak WHERE id_user='hery' AND tgl='$tambah3'");
$jumlah4 = mysql_num_rows($query4);
$query5 = mysql_query("SELECT * FROM kontak WHERE id_user='hery' AND tgl='$tambah4'");
$jumlah5 = mysql_num_rows($query5);
$query6 = mysql_query("SELECT * FROM kontak WHERE id_user='hery' AND tgl='$tambah5'");
$jumlah6 = mysql_num_rows($query6);
$query7 = mysql_query("SELECT * FROM kontak WHERE id_user='hery' AND tgl='$tambah6'");
$jumlah7 = mysql_num_rows($query7);
$query8 = mysql_query("SELECT * FROM kontak WHERE id_user='hery' AND tgl='$tambah7'");
$jumlah8 = mysql_num_rows($query8);
$query10 = mysql_query("SELECT * FROM kontak WHERE id_user='hery' AND DATEDIFF(CURDATE(),tgl) < $waktu");
$jumlah10 = mysql_num_rows($query10);
$query9 = mysql_query("SELECT * FROM kontak WHERE id_user='hery'");
$jumlah9 = mysql_num_rows($query9);
echo " <div align='center'>
<p><table>
<tr align='center' bgcolor='#007D47'>
<td>1</td>
<td>2</td>
<td>3</td>
<td>4</td>
<td>5</td>
<td>6</td>
<td>7</td>
</tr>
<tr bgcolor='#BFFEE3'>
<td> $jumlah-</td>
<td> $jumlah2-</td>
<td> $jumlah3-</td>
<td> $jumlah4-</td>
<td> $jumlah5-</td>
<td> $jumlah6-</td>
<td> $jumlah7</td>
</tr>
<tr>
<td colspan='6'>Total Perminggu</td>
<td>$jumlah10</td>
</tr>
<tr>
<td colspan='6'>Total Keseluruhan</td>
<td>$jumlah9</td>
</tr>
</table></p>"; ?>
</div>
<div class="clearfix"> </div>
</div>
</div>
</div>
</div>
<div class="feature-grids">
<div class="col-md-3 feature-grid">
<h3></span>juliet</h3>
<?php
$waktu= 7;
$query = mysql_query("SELECT * FROM kontak WHERE id_user='juliet' AND tgl='$tgl'");
$jumlah = mysql_num_rows($query);
$query2 = mysql_query("SELECT * FROM kontak WHERE id_user='juliet' AND tgl='$tambah'");
$jumlah2 = mysql_num_rows($query2);
$query3 = mysql_query("SELECT * FROM kontak WHERE id_user='juliet' AND tgl='$tambah2'");
$jumlah3 = mysql_num_rows($query3);
$query4 = mysql_query("SELECT * FROM kontak WHERE id_user='juliet' AND tgl='$tambah3'");
$jumlah4 = mysql_num_rows($query4);
$query5 = mysql_query("SELECT * FROM kontak WHERE id_user='juliet' AND tgl='$tambah4'");
$jumlah5 = mysql_num_rows($query5);
$query6 = mysql_query("SELECT * FROM kontak WHERE id_user='juliet' AND tgl='$tambah5'");
$jumlah6 = mysql_num_rows($query6);
$query7 = mysql_query("SELECT * FROM kontak WHERE id_user='juliet' AND tgl='$tambah6'");
$jumlah7 = mysql_num_rows($query7);
$query8 = mysql_query("SELECT * FROM kontak WHERE id_user='juliet' AND tgl='$tambah7'");
$jumlah8 = mysql_num_rows($query8);
$query10 = mysql_query("SELECT * FROM kontak WHERE id_user='juliet' AND DATEDIFF(CURDATE(),tgl) < $waktu");
$jumlah10 = mysql_num_rows($query10);
$query9 = mysql_query("SELECT * FROM kontak WHERE id_user='juliet'");
$jumlah9 = mysql_num_rows($query9);
echo " <div align='center'>
<p><table>
<tr align='center' bgcolor='#FF80FE'>
<td>1</td>
<td>2</td>
<td>3</td>
<td>4</td>
<td>5</td>
<td>6</td>
<td>7</td>
</tr>
<tr bgcolor='#FFBFFE'>
<td> $jumlah-</td>
<td> $jumlah2-</td>
<td> $jumlah3-</td>
<td> $jumlah4-</td>
<td> $jumlah5-</td>
<td> $jumlah6-</td>
<td> $jumlah7</td>
</tr>
<tr>
<td colspan='6'>Total Perminggu</td>
<td>$jumlah10</td>
</tr>
<tr>
<td colspan='6'>Total Keseluruhan</td>
<td>$jumlah9</td>
</tr>
</table></p>"; ?>
</div>
<div class="clearfix"> </div>
</div>
</div>
</div>
</div>
<div class="feature-grids">
<div class="col-md-3 feature-grid">
<h3 align="center"></span>ayub</h3>
<div align="center">
<?php
$waktu= 7;
$query = mysql_query("SELECT * FROM kontak WHERE id_user='ayub' AND tgl='$tgl'");
$jumlah = mysql_num_rows($query);
$query2 = mysql_query("SELECT * FROM kontak WHERE id_user='ayub' AND tgl='$tambah'");
$jumlah2 = mysql_num_rows($query2);
$query3 = mysql_query("SELECT * FROM kontak WHERE id_user='ayub' AND tgl='$tambah2'");
$jumlah3 = mysql_num_rows($query3);
$query4 = mysql_query("SELECT * FROM kontak WHERE id_user='ayub' AND tgl='$tambah3'");
$jumlah4 = mysql_num_rows($query4);
$query5 = mysql_query("SELECT * FROM kontak WHERE id_user='ayub' AND tgl='$tambah4'");
$jumlah5 = mysql_num_rows($query5);
$query6 = mysql_query("SELECT * FROM kontak WHERE id_user='ayub' AND tgl='$tambah5'");
$jumlah6 = mysql_num_rows($query6);
$query7 = mysql_query("SELECT * FROM kontak WHERE id_user='ayub' AND tgl='$tambah6'");
$jumlah7 = mysql_num_rows($query7);
$query8 = mysql_query("SELECT * FROM kontak WHERE id_user='ayub' AND tgl='$tambah7'");
$jumlah8 = mysql_num_rows($query8);
$query10 = mysql_query("SELECT * FROM kontak WHERE id_user='ayub' AND DATEDIFF(CURDATE(),tgl) < $waktu");
$jumlah10 = mysql_num_rows($query10);
$query9 = mysql_query("SELECT * FROM kontak WHERE id_user='ayub'");
$jumlah9 = mysql_num_rows($query9);
echo " <div align='center'>
<p><table>
<tr align='center' bgcolor='#B2A100'>
<td>1</td>
<td>2</td>
<td>3</td>
<td>4</td>
<td>5</td>
<td>6</td>
<td>7</td>
</tr>
<tr bgcolor='#FEF280'>
<td> $jumlah-</td>
<td> $jumlah2-</td>
<td> $jumlah3-</td>
<td> $jumlah4-</td>
<td> $jumlah5-</td>
<td> $jumlah6-</td>
<td> $jumlah7</td>
</tr>
<tr>
<td colspan='6'>Total Perminggu</td>
<td>$jumlah10</td>
</tr>
<tr>
<td colspan='6'>Total Keseluruhan</td>
<td>$jumlah9</td>
</tr>
</table></p>"; ?>
</div>
</div>
<div class="clearfix"> </div>
</div>
</div>
</div>
</div>
<div class="feature-grids">
<div class="col-md-3 feature-grid">
<h3 align="center"></span>adi</h3>
<div align="center">
<?php
$waktu= 7;
$query = mysql_query("SELECT * FROM kontak WHERE id_user='adi' AND tgl='$tgl'");
$jumlah = mysql_num_rows($query);
$query2 = mysql_query("SELECT * FROM kontak WHERE id_user='adi' AND tgl='$tambah'");
$jumlah2 = mysql_num_rows($query2);
$query3 = mysql_query("SELECT * FROM kontak WHERE id_user='adi' AND tgl='$tambah2'");
$jumlah3 = mysql_num_rows($query3);
$query4 = mysql_query("SELECT * FROM kontak WHERE id_user='adi' AND tgl='$tambah3'");
$jumlah4 = mysql_num_rows($query4);
$query5 = mysql_query("SELECT * FROM kontak WHERE id_user='adi' AND tgl='$tambah4'");
$jumlah5 = mysql_num_rows($query5);
$query6 = mysql_query("SELECT * FROM kontak WHERE id_user='adi' AND tgl='$tambah5'");
$jumlah6 = mysql_num_rows($query6);
$query7 = mysql_query("SELECT * FROM kontak WHERE id_user='adi' AND tgl='$tambah6'");
$jumlah7 = mysql_num_rows($query7);
$query8 = mysql_query("SELECT * FROM kontak WHERE id_user='adi' AND tgl='$tambah7'");
$jumlah8 = mysql_num_rows($query8);
$query10 = mysql_query("SELECT * FROM kontak WHERE id_user='adi' AND DATEDIFF(CURDATE(),tgl) < $waktu");
$jumlah10 = mysql_num_rows($query10);
$query9 = mysql_query("SELECT * FROM kontak WHERE id_user='adi'");
$jumlah9 = mysql_num_rows($query9);
echo " <div align='center'>
<p><table>
<tr align='center' bgcolor='#24B200'>
<td>1</td>
<td>2</td>
<td>3</td>
<td>4</td>
<td>5</td>
<td>6</td>
<td>7</td>
</tr>
<tr bgcolor='#33FF00'>
<td> $jumlah-</td>
<td> $jumlah2-</td>
<td> $jumlah3-</td>
<td> $jumlah4-</td>
<td> $jumlah5-</td>
<td> $jumlah6-</td>
<td> $jumlah7</td>
</tr>
<tr>
<td colspan='6'>Total Perminggu</td>
<td>$jumlah10</td>
</tr>
<tr>
<td colspan='6'>Total Keseluruhan</td>
<td>$jumlah9</td>
</tr>
</table></p>"; ?>
</div>
</div>
<div class="clearfix"> </div>
</div>
</div>
</div>
</div>
<div class="feature-grids">
<div class="col-md-3 feature-grid">
<h3 align="center"></span>bayu</h3>
<div align="center">
<?php
$waktu= 7;
$query = mysql_query("SELECT * FROM kontak WHERE id_user='bayu' AND tgl='$tgl'");
$jumlah = mysql_num_rows($query);
$query2 = mysql_query("SELECT * FROM kontak WHERE id_user='bayu' AND tgl='$tambah'");
$jumlah2 = mysql_num_rows($query2);
$query3 = mysql_query("SELECT * FROM kontak WHERE id_user='bayu' AND tgl='$tambah2'");
$jumlah3 = mysql_num_rows($query3);
$query4 = mysql_query("SELECT * FROM kontak WHERE id_user='bayu' AND tgl='$tambah3'");
$jumlah4 = mysql_num_rows($query4);
$query5 = mysql_query("SELECT * FROM kontak WHERE id_user='bayu' AND tgl='$tambah4'");
$jumlah5 = mysql_num_rows($query5);
$query6 = mysql_query("SELECT * FROM kontak WHERE id_user='bayu' AND tgl='$tambah5'");
$jumlah6 = mysql_num_rows($query6);
$query7 = mysql_query("SELECT * FROM kontak WHERE id_user='bayu' AND tgl='$tambah6'");
$jumlah7 = mysql_num_rows($query7);
$query8 = mysql_query("SELECT * FROM kontak WHERE id_user='bayu' AND tgl='$tambah7'");
$jumlah8 = mysql_num_rows($query8);
$query10 = mysql_query("SELECT * FROM kontak WHERE id_user='bayu' AND DATEDIFF(CURDATE(),tgl) < $waktu");
$jumlah10 = mysql_num_rows($query10);
$query9 = mysql_query("SELECT * FROM kontak WHERE id_user='bayu'");
$jumlah9 = mysql_num_rows($query9);
echo " <div align='center'>
<p><table>
<tr align='center' bgcolor='#00B366'>
<td>1</td>
<td>2</td>
<td>3</td>
<td>4</td>
<td>5</td>
<td>6</td>
<td>7</td>
</tr>
<tr bgcolor='#80FEC8'>
<td> $jumlah-</td>
<td> $jumlah2-</td>
<td> $jumlah3-</td>
<td> $jumlah4-</td>
<td> $jumlah5-</td>
<td> $jumlah6-</td>
<td> $jumlah7</td>
</tr>
<tr>
<td colspan='6'>Total Perminggu</td>
<td>$jumlah10</td>
</tr>
<tr>
<td colspan='6'>Total Keseluruhan</td>
<td>$jumlah9</td>
</tr>
</table></p>"; ?>
</div>
</div>
<div class="clearfix"> </div>
</div>
</div>
</div>
</div>
<div class="feature-grids">
<div class="col-md-3 feature-grid">
<h3 align="center"></span>Katamso</h3>
<div align="center">
<?php
$waktu= 7;
$query = mysql_query("SELECT * FROM kontak WHERE id_user='user_mogot' AND tgl='$tgl'");
$jumlah = mysql_num_rows($query);
$query2 = mysql_query("SELECT * FROM kontak WHERE id_user='user_mogot' AND tgl='$tambah'");
$jumlah2 = mysql_num_rows($query2);
$query3 = mysql_query("SELECT * FROM kontak WHERE id_user='user_mogot' AND tgl='$tambah2'");
$jumlah3 = mysql_num_rows($query3);
$query4 = mysql_query("SELECT * FROM kontak WHERE id_user='user_mogot' AND tgl='$tambah3'");
$jumlah4 = mysql_num_rows($query4);
$query5 = mysql_query("SELECT * FROM kontak WHERE id_user='user_mogot' AND tgl='$tambah4'");
$jumlah5 = mysql_num_rows($query5);
$query6 = mysql_query("SELECT * FROM kontak WHERE id_user='user_mogot' AND tgl='$tambah5'");
$jumlah6 = mysql_num_rows($query6);
$query7 = mysql_query("SELECT * FROM kontak WHERE id_user='user_mogot' AND tgl='$tambah6'");
$jumlah7 = mysql_num_rows($query7);
$query8 = mysql_query("SELECT * FROM kontak WHERE id_user='user_mogot' AND tgl='$tambah7'");
$jumlah8 = mysql_num_rows($query8);
$query10 = mysql_query("SELECT * FROM kontak WHERE id_user='user_mogot' AND DATEDIFF(CURDATE(),tgl) < $waktu");
$jumlah10 = mysql_num_rows($query10);
$query9 = mysql_query("SELECT * FROM kontak WHERE id_user='user_mogot'");
$jumlah9 = mysql_num_rows($query9);
echo " <div align='center'>
<p><table>
<tr align='center' bgcolor='#00FFFF'>
<td>1</td>
<td>2</td>
<td>3</td>
<td>4</td>
<td>5</td>
<td>6</td>
<td>7</td>
</tr>
<tr>
<td> $jumlah-</td>
<td> $jumlah2-</td>
<td> $jumlah3-</td>
<td> $jumlah4-</td>
<td> $jumlah5-</td>
<td> $jumlah6-</td>
<td> $jumlah7</td>
</tr>
<tr>
<td colspan='6'>Total Perminggu</td>
<td>$jumlah10</td>
</tr>
<tr>
<td colspan='6'>Total Keseluruhan</td>
<td>$jumlah9</td>
</tr>
</table></p>"; ?>
</div>
</div>
<div class="clearfix"> </div>
</div>
</div>
</div>
</div>
<div class="feature-grids">
<div class="col-md-3 feature-grid">
<h3 align="center"></span>ilham</h3>
<div align="center">
<?php
$waktu= 7;
$query = mysql_query("SELECT * FROM kontak WHERE id_user='ilham' AND tgl='$tgl'");
$jumlah = mysql_num_rows($query);
$query2 = mysql_query("SELECT * FROM kontak WHERE id_user='ilham' AND tgl='$tambah'");
$jumlah2 = mysql_num_rows($query2);
$query3 = mysql_query("SELECT * FROM kontak WHERE id_user='ilham' AND tgl='$tambah2'");
$jumlah3 = mysql_num_rows($query3);
$query4 = mysql_query("SELECT * FROM kontak WHERE id_user='ilham' AND tgl='$tambah3'");
$jumlah4 = mysql_num_rows($query4);
$query5 = mysql_query("SELECT * FROM kontak WHERE id_user='ilham' AND tgl='$tambah4'");
$jumlah5 = mysql_num_rows($query5);
$query6 = mysql_query("SELECT * FROM kontak WHERE id_user='ilham' AND tgl='$tambah5'");
$jumlah6 = mysql_num_rows($query6);
$query7 = mysql_query("SELECT * FROM kontak WHERE id_user='ilham' AND tgl='$tambah6'");
$jumlah7 = mysql_num_rows($query7);
$query8 = mysql_query("SELECT * FROM kontak WHERE id_user='ilham' AND tgl='$tambah7'");
$jumlah8 = mysql_num_rows($query8);
$query10 = mysql_query("SELECT * FROM kontak WHERE id_user='ilham' AND DATEDIFF(CURDATE(),tgl) < $waktu");
$jumlah10 = mysql_num_rows($query10);
$query9 = mysql_query("SELECT * FROM kontak WHERE id_user='ilham'");
$jumlah9 = mysql_num_rows($query9);
echo " <div align='center'>
<p><table>
<tr align='center' bgcolor='#00FFFF'>
<td>1</td>
<td>2</td>
<td>3</td>
<td>4</td>
<td>5</td>
<td>6</td>
<td>7</td>
</tr>
<tr>
<td> $jumlah-</td>
<td> $jumlah2-</td>
<td> $jumlah3-</td>
<td> $jumlah4-</td>
<td> $jumlah5-</td>
<td> $jumlah6-</td>
<td> $jumlah7</td>
</tr>
<tr>
<td colspan='6'>Total Perminggu</td>
<td>$jumlah10</td>
</tr>
<tr>
<td colspan='6'>Total Keseluruhan</td>
<td>$jumlah9</td>
</tr>
</table></p>"; ?>
</div>
</div>
<div class="clearfix"> </div>
</div>
</div>
</div>
<div class="gallery" id="gallery"></div>
<!-----//End-gallery---->
<!-----start-pricing-plans---->
<div class="pricing-plans" id="pricing"></div>
<!-----//End-pricing-plans---->
<!-----//End-container---->
<div class="footer">
<div class="container">
<div class="footer-bottom" id="contact">
<div class="copy">
<p>Danmogot.com</p>
</div>
</div>
<script type="text/javascript">
$(document).ready(function() {
$().UItoTop({ easingType: 'easeOutQuart' });
});
</script>
<a href="#" id="toTop" style="display: block;"> <span id="toTopHover" style="opacity: 1;">top </span></a>
</div>
</div>
<!----//End-footer---->
<!----//End-container---->
</body>
</html>
0 Comments