1.
- Copy file assets drupal ke cpanel
- Install drupal melalui cpanel
- Customize dan test untuk mengisi post
2.
- sql_connect.php
- LOC: 9
- Status: Pass
1: <?php
2: $conn = mysql_connect("localhost", "ets", "ets");
3: mysql_select_db("ets");
4: if($conn){
5: }
6: else{
7: echo "gagal";
8: }
9: ?>
- index.php (login page)
- LOC: 21
- Status: Pass
1: <!doctype html>
2: <html>
3: <body>
4: <form method="POST" action="login.php">
5: <div class="form-group">
6: <label class="control-label"></label>
7: <div class="controls">
8: <input class="form-control" type="text" name="username" placeholder="Username">
9: </div>
10: <div class="form-group">
11: <label class="control-label"></label>
12: <div class="controls">
13: <input class="form-control" type="password" name="password" placeholder="Password">
14: </div>
15: </div>
16: <div class="pull-right">
17: <input class="btn btn-success" type="submit" value="Login" name="submit"/>
18: </div>
19: </form>
20: </body>
21: </html>
- login.php
- LOC: 33
- Status: Pass
1: <?php
2: require ('sql_connect.php');
3: if (isset($_POST['submit'])){
4: $username=mysql_escape_string($_POST['username']);
5: $password=mysql_escape_string($_POST['password']);
6: if (!$_POST['username'] | !$_POST['password'])
7: {
8: echo ("<SCRIPT LANGUAGE='JavaScript'>
9: window.alert('You did not complete all of the required fields')
10: window.location.href='/ets'
11: </SCRIPT>");
12: exit();
13: }
14: $sql= mysql_query("SELECT * FROM `user` WHERE `nama_user` = '$username' AND `password_user` = '$password'");
15: if(mysql_num_rows($sql) > 0)
16: {
17: echo ("<SCRIPT LANGUAGE='JavaScript'>
18: window.alert('Login Succesfully!.')
19: window.location.href='/ets/tampilkandata.php'
20: </SCRIPT>");
21: exit();
22: }
23: else{
24: echo ("<SCRIPT LANGUAGE='JavaScript'>
25: window.alert('Wrong username password combination.Please re-enter.')
26: window.location.href='/ets'
27: </SCRIPT>");
28: exit();
29: }
30: }
31: else{
32: }
33: ?>
- tampilkandata.php
- LOC: 30
- Status: Pass
1: <!doctype html>
2: <html>
3: <body>
4: <?php
5: $no = 1;
6: include "sql_connect.php";
7: mysql_select_db("ets");
8: $result = mysql_query("SELECT * FROM praktikum");
9: echo "<table border='1'>
10: <tr>
11: <th>No</th>
12: <th>Kode</th>
13: <th>Mata Praktikum</th>
14: <th>Jumlah Praktikan</th>
15: </tr>";
16: while($row = mysql_fetch_array($result))
17: {
18: echo "<tr>";
19: echo "<td>" . $no . "</td>";
20: echo "<td>" . $row['kode_mk'] . "</td>";
21: echo "<td>" . $row['nama_mk'] . "</td>";
22: echo "<td>" . $row['jumlah_praktikan'] . "</td>";
23: echo "</tr>";
24: $no = $no + 1;
25: }
26: echo "</table>";
27: mysql_close($conn)
28: ?>
29: </body>
30: </html>
Tidak ada komentar:
Posting Komentar