Untitled



<!DOCTYPE html>
<?php

require_once("config.php");

$namaserver = "localhost";
$username = "root";
$password = "";
$namadb = "pelumas";
$koneksi_db = mysqli_connect($namaserver, $username, $password, $namadb);

if(isset($_POST['login'])){

    $nim = filter_input(INPUT_POST, 'nim', FILTER_SANITIZE_STRING);
    $password = filter_input(INPUT_POST, 'password', FILTER_SANITIZE_STRING);

    if (empty($nim) || empty($password)){
       echo "<script>alert(' NIM dan Password harus diisi');history.go(-1);</script>";
    }

    else{
     $sql = "SELECT * FROM akun WHERE nim=:nim OR emailmhs=:emailmhs";
    $stmt = $db->prepare($sql);

    // bind parameter ke query
    $params = array(
        ":nim" => $nim,
        ":emailmhs" => $nim
    );

    $stmt->execute($params);

    $user = $stmt->fetch(PDO::FETCH_ASSOC);

    // jika user terdaftar
    if($user){
        // verifikasi password
        if(password_verify($password, $user["password"])){
            // buat Session
            session_start();
            $_SESSION["user"] = $user;
            // login sukses, alihkan ke halaman timeline
            header("Location: loged.php");
        }
    }
}
}

?>


<!--
To change this license header, choose License Headers in Project Properties.
To change this template file, choose Tools | Templates
and open the template in the editor.
-->
<html>
    <head>
        <title>Selamat Datang di Website Pelumas</title>
        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <link rel="stylesheet" href="css/style-login.css" />
        <link href="https://fonts.googleapis.com/css?family=Roboto" rel="stylesheet">
        <link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.6.1/css/all.css" integrity="sha384-gfdkjb5BdAXd+lj+gudLWI+BXq4IuLW5IT+brZEZsLFm++aCMlF1V92rMkPaX4PP" crossorigin="anonymous">
    </head>
    <body>
        <div class="container">
            <!-- Start Header -->
            <div class="header">

                <a href="index.php"><img src="image/logo.png" alt="" />  </a>
              <!-- start Login -->
                    <?php session_start();
if(!isset($_SESSION["user"])){ ?>
     <form class="login" method="POST">
  <div class="sa">
                   <h5>NIM:</h5>
                 <input type="text" placeholder="Masukkan NIM" name="nim">
                 <div class="button">
                     <input type="submit" value="Login" name="login" class="ro" style="border:none">
                      <a href='register.php'" class="rg">Register</a>
                 </div>
                  </div>
                  <div class="du">
                      <h5>PASSWORD:</h5>
                 <input type="password" placeholder="Masukkan Password" name="password">
                 </div>


              </form>
<?php }

else{ ?>

       <div class="loged">
                  <div class="sa">
                       <h2><i class="far fa-user"></i>  Hy, <?php echo  $_SESSION["user"]["nama"] ?></h2>
                   <a href="logout.php" class="lo">Logout</a>
                  </div>


              </div>
 <?php }

  ?>


              <!-- End Login -->
              <div class="clear"></div>

              <div class="batas"></div>
            </div>
            <!-- End Header -->
            <!-- Start Isi -->
            <div class="isi">
                <div class="banner">
                    <p>
                      Punya Keluhan dikampus? Barang kesayangan mu hilang? atau kamu menemukan sesuatu?
Laporkan saja disini.
                    </p>

                   <button class="mklapor" onclick="<?php

                    if(!isset($_SESSION["user"])){ ?>alert('Anda harus Login dulu!');


                     <?php }
                     else{ ?>
                        window.location.href='formlapor.php'

                     <?php }
                   ?>";>Buat Laporan</button>
                </div>

                <div class="laporan">

                    <div class="title">

                        <h4>Data Laporan Terkini!</h4>
                    </div>
                    <div class="tab1">
                        <div class="tabkehilangan">
                         <h2> Kehilangan </h2>

                        </div>

<div class="over">


                          <?php

//buat skrip querry sql
$strSQL = "SELECT idlaporan, pelapor, isi, tanggal FROM datalapor WHERE kategori='kehilangan' ORDER BY idlaporan DESC";

 //echo $strSQL;

//Eksekusi skrip
$hasil = mysqli_query($koneksi_db, $strSQL);
//cek data ada atau tidak
$jmlRows = mysqli_num_rows($hasil); //menghitung jumlah rows


if($jmlRows > 0){
    $nomor = 0;
    while($row = mysqli_fetch_assoc($hasil)){
        $nomor = $nomor + 1;
        $idlaporan = $row["idlaporan"];
        $pelapor = $row["pelapor"];
        $isi = $row["isi"];
        $tanggal = $row["tanggal"];

?>
<div class="berita">
                            <div class="pembuka">

                            </div>

                            <p> <?php echo substr($isi, 0,65); ?> ...</p>
                            <a href="detail.php?page=detail&idlaporan=<?php echo $idlaporan; ?>" style="">Selengkapnya</a>

                            <div class="penutup">

                            </div>

                            <li><?php $pelapor = ucwords($pelapor);
                            echo $pelapor."&nbsp &nbsp <strong> | </strong>"; ?> </li>
                            <li><?php echo "", date('d F Y', strtotime($tanggal)); ?></li>

                        </div>
                        <?php }
} ?> </div>
                    </div>

                    <div class="tab2">
                        <div class="tabpenemuan">
                        <h2> Penemuan </h2>

                        </div>

                           <div class="over">
                          <?php

//buat skrip querry sql
$strSQL = "SELECT idlaporan, pelapor, isi, tanggal FROM datalapor WHERE kategori='penemuan' ORDER BY idlaporan DESC";

 //echo $strSQL;

//Eksekusi skrip
$hasil = mysqli_query($koneksi_db, $strSQL);
//cek data ada atau tidak
$jmlRows = mysqli_num_rows($hasil); //menghitung jumlah rows


if($jmlRows > 0){
    $nomor = 0;
    while($row = mysqli_fetch_assoc($hasil)){
        $nomor = $nomor + 1;
        $idlaporan = $row["idlaporan"];
        $pelapor = $row["pelapor"];
        $isi = $row["isi"];
        $tanggal = $row["tanggal"];

?>
<div class="berita">
                            <div class="pembuka">

                            </div>

                            <p> <?php echo substr($isi, 0,65); ?> ...</p>
                            <a href="detail.php?page=detail&idlaporan=<?php echo $idlaporan; ?>" style="">Selengkapnya</a>

                            <div class="penutup">

                            </div>

                            <li><?php echo ucwords($pelapor),"&nbsp &nbsp <strong> | </strong>"; ?> </li>
                            <li><?php echo "", date('d F Y', strtotime($tanggal)); ?></li>

                        </div>
                        <?php }
} ?>
</div>
</div>

                    <div class="tab3">
                        <div class="tabkeluhan">
                            <h2> Keluhan Mahasiswa</h2>
                        </div>
                        <div class="over">
                           <?php

//buat skrip querry sql
$strSQL = "SELECT idlaporan, pelapor, isi, tanggal FROM datalapor WHERE kategori='keluhan' ORDER BY idlaporan DESC";

 //echo $strSQL;

//Eksekusi skrip
$hasil = mysqli_query($koneksi_db, $strSQL);
//cek data ada atau tidak
$jmlRows = mysqli_num_rows($hasil); //menghitung jumlah rows


if($jmlRows > 0){
    $nomor = 0;
    while($row = mysqli_fetch_assoc($hasil)){
        $nomor = $nomor + 1;
         $idlaporan = $row["idlaporan"];
        $pelapor = $row["pelapor"];
        $isi = $row["isi"];
        $tanggal = $row["tanggal"];

?>
<div class="berita">
                            <div class="pembuka">

                            </div>

                            <p> <?php echo substr($isi, 0,65); ?> ...</p>
                            <a href="detail.php?page=detail&idlaporan=<?php echo $idlaporan; ?>" style="">Selengkapnya</a>

                            <div class="penutup">

                            </div>

                           <li><?php $pelapor = ucwords($pelapor);
                            echo $pelapor."&nbsp &nbsp <strong> | </strong>"; ?> </li>
                            <li><?php echo "", date('d F Y', strtotime($tanggal)); ?></li>

                        </div>
                        <?php }
} ?>
</div>

                        </div>

                    </div>

                </div>

            </div>
            <!-- End Isi -->

            <h3 style="margin-top: 100px;margin-bottom: 5px;font-size: 15px">@COPYRIGHT By</h3>
            <h3 style="margin: 0;padding: 0">INFORMATIKA 2016</h3>
            <div class="footer">

            </div>
        </div>
    </body>
</html>