Advertisement
Guest User

Untitled

a guest
Sep 23rd, 2018
212
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 7.02 KB | None | 0 0
  1. <?php
  2.   session_start();
  3.   require 'config/base.php';
  4.   require 'config/db_con.php';
  5.  
  6.   $conn = mysqli_connect($servername, $username, $password, $database);
  7.  
  8.   if (isset($_POST['username'])) {
  9.     $username = $_POST['username'];
  10.   }else{
  11.     $username = "";
  12.   }
  13.    if (isset($_POST['password'])) {
  14.     $password = $_POST['password'];
  15.   }else{
  16.     $password = "";
  17.   }
  18.   if (isset($_SESSION['nama_user'])) {
  19.     $nama_user = $_SESSION['nama_user'];
  20.   }else{
  21.     $nama_user = "";
  22.   }
  23.   if (isset($_SESSION['nim'])) {
  24.     $nim = $_SESSION['nim'];
  25.   }else{
  26.     $nim = "";
  27.   }
  28.   if (isset($_SESSION['nik'])) {
  29.     $nik = $_SESSION['nik'];
  30.   }else{
  31.     $nik = "";
  32.   }
  33.   if (isset($_SESSION['privillage'])) {
  34.     $prv = $_SESSION['privillage'];
  35.   }else{
  36.     $prv = "";
  37.   }
  38.   $status = "";
  39.   $keterangan = "";
  40. ?>
  41.  
  42. <!DOCTYPE html>
  43. <html>
  44. <head>
  45.   <meta charset="utf-8">
  46.   <meta http-equiv="X-UA-Compatible" content="IE=edge">
  47.   <title>AdminLTE 2 | Invoice</title>
  48.   <!-- Tell the browser to be responsive to screen width -->
  49.   <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
  50.   <!-- Bootstrap 3.3.7 -->
  51.   <link rel="stylesheet" href="stylesheet/print/bootstrap/dist/css/bootstrap.min.css">
  52.   <!-- Font Awesome -->
  53.   <link rel="stylesheet" href="stylesheet/print/font-awesome/css/font-awesome.min.css">
  54.   <!-- Ionicons -->
  55.   <link rel="stylesheet" href="stylesheet/print/Ionicons/css/ionicons.min.css">
  56.   <!-- Theme style -->
  57.   <!-- <link rel="stylesheet" href="stylesheets/print/AdminLTE.min.css"> -->
  58.   <link rel="stylesheet" href="stylesheets/print.css">
  59.  
  60.   <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
  61.   <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
  62.   <!--[if lt IE 9]>
  63.   <script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
  64.   <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
  65.   <![endif]-->
  66.  
  67.   <!-- Google Font -->
  68.   <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,600,700,300italic,400italic,600italic">
  69. </head>
  70. <page class="A4">
  71. <body onload="window.print();">
  72. <div class="wrapper">
  73.   <!-- Main content -->
  74.   <section class="invoice">
  75.     <!-- title row -->
  76.     <div class="row">
  77.     <table class="table table-striped">
  78.           <tbody>
  79.           <tr>
  80.             <td>        <img class="resize" src="images/yai-logos.png" alt="Universitas Persada Indonesia Y.A.I"></td>
  81.             <td>        <h2 class="page-header" style="font-family:cambria; text-align:center;">
  82.         UNIVERSITAS PERSADA INDONESIA Y.A.I <br>FAKULTAS TEKNIK
  83.         </h2>
  84.         <h4 style="font-family:cambria; text-align:center;">Kampus D : Jl. Salemba Raya 7/9 A Jakarta 10340, Indonesia
  85. Telp : (021) 3914075-76-81, Fax : (021) 3147910
  86. Website : www.yai.ac.id, E-mail : fti.upi@yai.ac.id
  87.   </h4></td>
  88.           </tr>
  89.           </tbody>
  90.         </table>
  91.         <!-- <div class="col-xs-3">
  92.         <img class="page-header" src="images/yai-logo.jpg" alt="Universitas Persada Indonesia Y.A.I">
  93.         </div> -->
  94.       <div class="col-xs-9">
  95.         <!-- <h2 class="page-header" style="font-family:cambria; text-align:center;">
  96.         UNIVERSITAS PERSADA INDONESIA Y.A.I <br>FAKULTAS TEKNIK
  97.         </h2>
  98.         <h4 style="font-family:cambria; text-align:center;">Kampus D : Jl. Salemba Raya 7/9 A Jakarta 10340, Indonesia
  99. Telp : (021) 3914075-76-81, Fax : (021) 3147910
  100. Website : www.yai.ac.id, E-mail : fti.upi@yai.ac.id
  101.   </h4> -->
  102.       </div>
  103.     </div>
  104.     <hr class="style2">
  105.     <!-- info row -->
  106.  
  107.                   <?php
  108.                    $query = "";
  109.                    $query = "SELECT * FROM tbl_pemilihan_judul A" ;
  110.                    $query .= " inner join tbl_usulan_judul B on A.id_usulan_judul=B.id_usulan_judul";
  111.                    $query .= " inner join tbl_mahasiswa C on B.nim=C.nim";
  112.                    $query .= " inner join tbl_dosen D on A.nik_dosen=D.nik_dosen";
  113.                    $query .= " inner join tbl_jurusan E on C.kode_jurusan=E.kode_jurusan";
  114.                    $query .= " inner join tbl_kajur F on E.kode_jurusan=F.kode_jurusan";
  115.                    $query .= " where B.nim='" . $nim . "'";
  116.                     $result = mysqli_query($conn,$query);
  117.                     while ($row = mysqli_fetch_array($result)) {
  118.                         $nim = $row[7];
  119.                         $nama_mahasiswa = $row[17];
  120.                         $jurusan = $row[30];
  121.                         $status = $row[15];
  122.                         $judul = $row[2];
  123.                         $keterangan = $row[5];
  124.                         $dosen = $row[24];
  125.                         $jenjang = $row[31];
  126.                         $nama_kajur = $row[34];
  127.                     }
  128.               ?>
  129.     <div class="row">
  130.       <div class="col-sm-12">
  131.  
  132.         <h3 class="page-header" style="font-family:cambria; text-align:center;">
  133.         LEMBAR PERSETUJUAN DAN PENGESAHAN
  134.         </h3>
  135.     <!-- Table row -->
  136.     <div class="row">
  137.       <div class="col-xs-12 table-responsive">
  138.         <table class="table table-striped">
  139.           <tbody>
  140.           <tr>
  141.             <td>Nama</td>
  142.             <td>: <?php echo($nama_mahasiswa)?></td>
  143.           </tr>
  144.           <tr>
  145.             <td>NIM</td>
  146.             <td>: <?php echo($nim)?></td>
  147.           </tr>
  148.           <tr>
  149.             <td>Program Studi</td>
  150.             <td>: <?php echo($jurusan)?></td>
  151.           </tr>
  152.           <tr>
  153.             <td>Jenjang Pendidikan</td>
  154.             <td>: <?php echo($jenjang)?></td>
  155.           </tr>          
  156.           <tr>
  157.             <td>Judul Tugas Akhir</td>
  158.             <td>: <?php echo($judul)?></td>
  159.           </tr>
  160.           <tr>
  161.             <td>Pembimbing</td>
  162.             <td>: <?php echo($dosen)?></td>
  163.           </tr>
  164.           </tbody>
  165.         </table>
  166.         <br> Naskah ini telah dibaca, diperiksa dan disetujui untuk dujikan pada sidang komprehensif.
  167.         <br>
  168.         <br>
  169.         <div class="col-xs-12 table-responsive">
  170.       </div>
  171.       <!-- /.col -->
  172.     </div>
  173.     <!-- /.row -->
  174.     <br><br>
  175. <div class = "row">
  176.   <div class = "col-xs-12">
  177.       <p style="text-align:right">
  178.             <b>Jakarta,  <?php echo date("d - F - Y"); ?></b>
  179.             <br>
  180.             <br>
  181.                         <td><p style="text-align:center"></tr>
  182.             <br> Disetujui Oleh :
  183.                   </p>
  184. <table width="100%">
  185.                         <tr></tr>
  186.                         <tr></tr>
  187.                         <tr></tr>
  188.                         <tr></tr>
  189.                         <tr></tr>
  190.                         <tr><td></td><td width="30%"></td><td  align="left">
  191.             <b>Pebimbing</b> </td>
  192.             <td><br><u>(<?php echo($dosen)?>)</u></p>
  193.                   </div>
  194.             <tr><td></td><td width="30%"></td><td  align="right">
  195.             <b>Ketua Program Studi</b></td>
  196.             <td><br><b><?php echo($jurusan)?></b></td>
  197.             <td><br><u> ( <?php echo($nama_kajur)?>)</u></td></div>
  198.   </section>
  199.   <!-- /.content -->
  200. </div>
  201. <!-- ./wrapper -->
  202. </body>
  203.                 </page>
  204. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement