testsys/tabletest.php at master · inity13/testsys · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
<?php
$db_host = 'localhost'; // Server Name
$db_user = 'root'; // Username
$db_pass = ''; // Password
$db_name = 'testsys2'; // Database Name

ini_set('default_charset', 'utf-8');


$conn = mysqli_connect($db_host, $db_user, $db_pass, $db_name);
if (!$conn) {
    die ('Failed to connect to MySQL: ' . mysqli_connect_error());
}

$sql = 'SELECT *
        FROM test_run_log';

$query = mysqli_query($conn, $sql);

if (!$query) {
    die ('SQL Error: ' . mysqli_error($conn));
}
?>

<html>

<head>
<title>TableTest</title>

	<meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <meta name="description" content="">
    <meta name="author" content="">

    <title>KE-Test-sidebar</title>

    <!-- Bootstrap core CSS -->
    <link href="css/bootstrap.min.css" rel="stylesheet">

	<script type="text/javascript" charset="utf-8" src="jquery/jquery.js"></script>
	<script type="text/javascript" charset="utf-8" src="jquery/jquery.min.js"></script>

	<script type="text/javascript" charset="utf-8" src="DataTables/datatables.min.js"></script>

	<script type="text/javascript" charset="utf-8" src="jquery/tablejquery.js"></script>
	<script type="text/javascript" charset="utf-8" src="jquery/tablejquery2.js"></script>
	<link rel="stylesheet" type="text/css" charset="utf-8" href="DataTables/datatables.min.css"/>

	<!-- Custom styles for this sidebar -->
    <link href="css/simple-sidebar.css" rel="stylesheet">

</head>


<body background="sidebar/hyvakiertaa.jpg">
	<div id="wrapper">

        <!-- Sidebar -->
        <div id="sidebar-wrapper">
            <ul class="sidebar-nav">
                <li class="sidebar-brand">
                    <a href="sidebar\index.html">
                        Etusivu
                    </a>
                </li>
                <li>
                    <a href="reportico\">Raportit</a>
                </li>
                <li>
                    <a href="tabletest.php">Kaikki tapaukset</a>
                </li>
                <li>
                    <a href="not_passed.php">Avoinna olevat bugit</a>
                </li>
                <li>
                    <a href="insert_sivu.php">Syötä uusi regressiotapaus</a>
                </li>
                <li>
                    <a href="#">Raportoi testauksesta</a>
                </li>
            </ul>
        </div>
        <!-- /#sidebar-wrapper -->

        <!-- Page Content -->
        <div id="page-content-wrapper">
        <a href="#menu-toggle" class="btn btn-secondary" id="menu-toggle">Menu</a>

	<script>$(document).ready(function() {
	    $('#test_run_log').DataTable();
	} );</script>

	<table id="test_run_log" class="display">
<caption class="title">Regressio Testit</caption>
		<thead>
			<tr>
				<th>LogID</th>
				<th>Testauksen syy</th>
				<th>Läpäisty</th>
				<th>Ei läpäisty</th>
				<th>Huomiot</th>
				<th>Aika</th>
				<th>TestID</th>
			</tr>
		</thead>
		<tbody>
		<?php
		while ($row = mysqli_fetch_array($query))
		{
			echo '<tr>
					<td>'.$row['LogID'].'</td>
					<td>'.$row['TestReason'].'</td>
					<td>'.$row['Passed'].'</td>
					<td>'.$row['NotPassed'].'</td>
					<td>'.$row['NotesFromTest'].'</td>
					<td>'.$row['Time'].'</td>
					<td>'.$row['TestID'].'</td>
				</tr>';
		}?>
<!-- Menu Toggle Script -->
<script>
    $("#menu-toggle").click(function(e) {
        e.preventDefault();
        $("#wrapper").toggleClass("toggled");
    });
    </script>
</body>
</html>