数据泄露统计：最常使用的方法和泄露记录最多的实体 - 数据安全分析 - 常规

<?php
//including the Mysql connect parameters.
$link = mysqli_connect('localhost', 'root', 'root', 'data breach');
if (!$link) {
    die('连接失败: ' . mysqli_connect_error());
}
$query_method = 'select method,count(method) from Method group by(method) order by count(method) desc limit 10';
$query_num = 'select Entity,Records from amount_of_data_leaked order by Records desc limit 10';
// 关闭自动提交 
mysqli_autocommit($link, FALSE);

$result_method = mysqli_query($link, $query_method);
$result_num = mysqli_query($link, $query_num);
while ($row = $result_method->fetch_assoc()) {
    $data_method[] = array(
        'method' => $row['method'],
        'method_sum' => $row['count(method)']
    );
}
$num2 = -1;
for ($n = 0; $n < 10; $n = $n + 1) {
    $num2 = $num2 + 1;
    $x = $data_method[$num2];
    ${'string_method_' . ($num2)} = $x['method'];
    ${'string_method_sum_' . ($num2)} = $x['method_sum'];
    //$x = json_encode($x);
    //${'string_method_'.($num)}= strval($x);没必要转字符串，array可以直接提
}
while ($row = $result_num->fetch_assoc()) {
    $data_num[] = array(
        'entity' => $row['Entity'],
        'records' => $row['Records']
    );
}
$num1 = -1;
for ($n = 0; $n < 10; $n = $n + 1) {
    $num1 = $num1 + 1;
    $x = $data_num[$num1];
    ${'string_entity_' . ($num1)} = $x['entity'];
    ${'string_records_sum_' . ($num1)} = $x['records'];
    echo ${'string_entity_' . ($num1)} . ${'string_records_sum_' . ($num1)};
    //$x = json_encode($x);
    //${'string_method_'.($num)}= strval($x);没必要转字符串，array可以直接提
}
mysqli_commit($link);
mysqli_close($link);
?>
<html>
<meta http-equiv='Content-Type' content='text/html; charset=utf-8'/>
<link rel='stylesheet' href='index.css'>
<body>
<div class='list-link'>
    <ul id='menu'>
        <li><a href='../welcome/welcome.html' style='color:white'>首页</a></li>
        <li style='color:white'>预览</li>
        <li><a href='../query/index.php' style='color:white'>录入</a></li>
        <li><a href='../homepage/homepage.html' style='color:white'>关于我们</a></li>
    </ul>
</div>
<div class='bg'>
    <iframe class='frameBg' src='../resource/bg1/index.html'></iframe>
</div>
<div class='keshihua'>
    <div class='top10-company'>
        <h3>top10-records</h3>
        <span><?php echo $string_entity_0 . $string_records_sum_0; ?></span>
        <span><?php echo $string_entity_1 . $string_records_sum_1; ?></span>
        <span><?php echo $string_entity_2 . $string_records_sum_2; ?></span>
        <span><?php echo $string_entity_3 . $string_records_sum_3; ?></span>
        <span><?php echo $string_entity_4 . $string_records_sum_4; ?></span>
        <span><?php echo $string_entity_5 . $string_records_sum_5; ?></span>
        <span><?php echo $string_entity_6 . $string_records_sum_6; ?></span>
        <span><?php echo $string_entity_7 . $string_records_sum_7; ?></span>
        <span><?php echo $string_entity_8 . $string_records_sum_8; ?></span>
        <span><?php echo $string_entity_9 . $string_records_sum_9; ?></span>
    </div>
    <div class='tu'></div>
    <div class='top10-method'>
        <h3>top10-method</h3>
        <span><?php echo $string_method_0 . $string_method_sum_0; ?></span>
        <span><?php echo $string_method_1 . $string_method_sum_1; ?></span>
        <span><?php echo $string_method_2 . $string_method_sum_2; ?></span>
        <span><?php echo $string_method_3 . $string_method_sum_3; ?></span>
        <span><?php echo $string_method_4 . $string_method_sum_4; ?></span>
        <span><?php echo $string_method_5 . $string_method_sum_5; ?></span>
        <span><?php echo $string_method_6 . $string_method_sum_6; ?></span>
        <span><?php echo $string_method_7 . $string_method_sum_7; ?></span>
        <span><?php echo $string_method_8 . $string_method_sum_8; ?></span>
        <span><?php echo $string_method_9 . $string_method_sum_9; ?></span>
    </div>
</div>
<div>
    <audio autoplay='autoplay' controls='controls' loop='loop' preload='auto' src='../music/风居住的街道.mp3'></audio>
</div>
</html>