View difference between Paste ID: 6eSFkeeX and RE5nFa9W
SHOW: | | - or go back to the newest paste.
1
<?php
2-
	include'koneksi.php';
2+
/***
3
update koneksi dibawah!! 
4
5
***/
6
	if(is_file('koneksi.php')){
7
		include'koneksi.php';
8
	}
9
?> 
10-
				<th>Hasil</th
10+
11
<head></head>
12
<body>
13
	<table border="1">
14
		<thead align="center">
15
			<tr>
16
				<th>Hasil</th>
17
				<?php 
18
				for($j=0;$j<10;$j++){
19
					echo "<th>$j</th>";
20
				}
21
				?>
22
			</tr>
23
		</thead>
24
		<?php
25
		for($i=0;$i<10;$i++){
26
			echo '<tr>';
27
			$n=$i/100;
28-
		<?php }?>
28+
			echo '<td>'.$n.'</td>';
29
			for($j=0;$j<10;$j++){
30
				$n=($i*10+$j)/100;
31
				echo "<td>".get_num($n)."</td>";
32
			}
33
			echo '</tr>';
34-
</html>
34+
		}
35
/**
36
			stat($i);
37
			$N1=floor($i*10)/10;
38
			$N2=floor($i*100)%10;
39
			mysqli_select_db($koneksi,"tabelz");
40
			$query="SELECT z".$N1." as num from tabelZ where noZ='$N1'";
41
			$sql=mysqli_query($query);
42
			$total=mysqli_num_rows($sql);
43
			while($data=mysqli_fetch_array($sql))
44
			{
45
		?>
46
		<tbody>
47
			<tr> 
48
				<td><?php echo $data['num'];?></td
49
			</tr>
50
		<?php }
51
52
*/
53
?>
54
		</tbody>
55
	</table>
56
</body>
57
		
58
</body>
59
</html>
60
<?php
61
function get_num($i){
62
	$mysqli = koneksi();
63
	$N1=floor($i*10)/10;
64
	$N2=floor($i*100)%10;
65
			//mysqli_select_db($koneksi,"tabelz");
66
	$query="SELECT z".$N2." as num from tabelZ where noZ='$N1'";
67
	 
68
			//$sql=mysqli_query($query);
69
	if($result= $mysqli->query($query)){
70
			$row = $result->fetch_array();
71
	}else{
72
		$row=array('num'=>$query);
73
	}
74
	return $row['num'];
75
}
76
77
function koneksi(){
78
//update ini
79
$mysqli = new mysqli("localhost", "root3", "", "fb_statistik");
80
if(mysqli_connect_errno()){
81
    echo 'Gagal melakukan koneksi ke Database : '.mysqli_connect_error();
82
	exit;
83
}
84
return $mysqli;
85
86
}