API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 22nd, 2018
153
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 18.99 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. $koneksi = mysqli_connect("localhost","root","","bioskop");
  3.  
  4. if (! $koneksi) {die("Gagal Terhubung Ke Database");}
  5.  
  6. session_start();
  7. $username = $_SESSION['username'];
  8. $password = $_SESSION['password'];
  9. $hasil = "SELECT * FROM customer WHERE username LIKE '%$username%' OR email LIKE '%$username%'";
  10. $hasil_query = mysqli_query($koneksi,$hasil);
  11. if ($_SESSION['username'] == " ") {
  12. echo '
  13. <script>
  14. window.alert("Anda Harus Login Terlebih Dahulu");
  15. window.location = "login.php";
  16. </script>
  17. ';
  18. }
  19. ?>
  20. <!DOCTYPE HTML>
  21. <html>
  22. <head>
  23. <link href="bootstrap/bootstrap/css/bootstrap.min.css" rel="stylesheet">
  24. <link href="home.css" rel="stylesheet">
  25. <script src="jquery.js"></script>
  26. <script src="bootstrap/bootstrap/js/bootstrap.min.js"></script>
  27. <script src="fontawesome-free/svg-with-js/js/fontawesome-all.js"></script>
  28. <meta name="viewport" content="width=device-width, initial-scale=1">
  29. <meta charset="utf-8">
  30. <title>Home</title>
  31.  
  32. </head>
  33. <body>
  34. <nav class="navbar navbar-default navbar-fixed-top">
  35. <div class="navbar-header">
  36. <a class="navbar-brand" href="index.php">Cinema 69</a>
  37. </div>
  38. <div class="collapse navbar-collapse" id="menu">
  39. <ul class="nav navbar-nav">
  40. <li><a href="kategori.php">kategori</a></li>
  41. <li class="search">
  42. <form action="result.php" method="get">
  43. <div class="col-md-10">
  44. <input type="text" class="input-form" name="id" placeholder="Cari Film..." required>
  45. </div>
  46. <div class="col-md-2">
  47. <button type="submit" class="btn btn-search"><i class="fas fa-search"></i></button>
  48. </div>
  49. </form>
  50. </li>
  51. </ul>
  52. <ul class="nav navbar-nav navbar-right">
  53. <?php
  54. if (isset($_SESSION['username'])) {
  55. $name = $_SESSION['username'];
  56. $user = "SELECT username,saldo FROM customer WHERE username = '$name'";
  57. $user_query = mysqli_query($koneksi,$user);
  58.  
  59. $karyawan = "SELECT CONCAT(fname,' ',lname) AS name, id_dpt FROM karyawan WHERE email = '$name'";
  60. $karyawan_query = mysqli_query($koneksi,$karyawan);
  61.  
  62. if (mysqli_num_rows($user_query) == 1) {
  63. $row = mysqli_fetch_assoc($user_query);
  64. echo '
  65. <li class="dropdown">
  66. <a class="dropdown-toggle" data-toggle="dropdown" href="#"><i class="fas fa-user fa-lg"></i> '.$row['username'].'</a>
  67. <ul class="dropdown-menu">
  68. <li><a href="logout.php"><i class="fas fa-sign-out-alt"></i> logout</a></li>
  69. </ul>
  70. </li>
  71. <li><p class="saldo"><i class="fas fa-ticket-alt fa-lg"></i> '.$row['saldo'].'</p></li>
  72. ';
  73. }
  74. } else {
  75. echo '
  76. <script>
  77. window.alert("Anda Harus Login Terlebih Dahulu");
  78. window.location = "login.php";
  79. </script>
  80. ';
  81. }
  82. ?>
  83. </ul>
  84. </div>
  85. <button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#menu"><i class="fas fa-bars fa-lg"></i></button>
  86. </nav>
  87.  
  88. <div class="container-fluid">
  89. <ul class="nav nav-pills nav-justified">
  90. <li class="active"><a data-toggle="pill" href="#transaction"><i class="fas fa-ticket-alt fa-lg"></i> tiket berlaku</a></li>
  91. <li><a data-toggle="pill" href="#expire"><i class="fas fa-sync fa-lg"></i> histori tiket</a></li>
  92. <li><a data-toggle="pill" href="#promosi"><i class="fas fa-cut fa-lg"></i> promosi</a></li>
  93. <li><a data-toggle="pill" href="#topup"><i class="fas fa-dollar-sign fa-lg"></i> topup</a></li>
  94. <li><a data-toggle="pill" href='#setting'><i class="fas fa-cog fa-lg"></i> Settings</a></li>
  95. </ul>
  96. <div class="tab-content">
  97. <div id="transaction" class="tab-pane fade in active">
  98. <?php
  99. $username = $_SESSION['username'];
  100. $transaksi = "SELECT * FROM tiket where (tanggal_tonton >= CURDATE()) AND username = '$username'";
  101. $transaksi_query = mysqli_query($koneksi,$transaksi);
  102.  
  103. if (mysqli_num_rows($transaksi_query) < 1) {
  104. echo "
  105. <h3 style='text-align:center;'>Tidak Ada Data</h3>
  106. <p style='text-align:center;'>ayo mulai pesan tiket</p>
  107. <a href='index.php' class='btn-primary'>Pesan tiket</a>
  108. ";
  109. } else {
  110. echo "
  111. <div class='row'>
  112. ";
  113. while ($row = mysqli_fetch_assoc($transaksi_query)) {
  114. echo '
  115. <div class="col-md-6 col-xs-12 col-sm-12 col-lg-6">
  116. <div class="transaction-content">
  117. <h3>'.$row['judul'].'</h3>
  118. <hr>
  119. <div class="row info">
  120. <div class="col-md-2 col-xs-6 col-sm-6 col-lg-2">
  121. <p><b>Tanggal</b></p>
  122. <p>'.$row['tanggal_tonton'].'</p>
  123. </div>
  124. <div class="col-md-2 col-xs-6 col-sm-6 col-lg-2">
  125. <p><b>Studio</b></p>
  126. <p>'.$row['nama_studio'].'</p>
  127. </div>
  128. <div class="col-md-2 col-xs-6 col-sm-6 col-lg-2">
  129. <p><b>kursi</b></p>
  130. <p>'.$row['seat'].'</p>
  131. </div>
  132. <div class="col-md-2 col-xs-6 col-sm-6 col-lg-2">
  133. <p><b>jam</b></p>
  134. <p>'.$row['jam_tonton'].'</p>
  135. </div>
  136. <div class="col-md-2 col-xs-6 col-sm-6 col-lg-2">
  137. <p><b>Jumlah orang</b></p>
  138. <p>'.$row['jumlah_orang'].'</p>
  139. </div>
  140. <div class="col-md-2 col-xs-6 col-sm-6 col-lg-2">
  141. <p><b>Harga</b></p>
  142. <p>'.$row['total_harga'].'</p>
  143. </div>
  144. </div>
  145. </div>
  146. </div>
  147. ';
  148. }
  149. echo "</div>";
  150. }
  151. ?>
  152. </div>
  153. <div id="expire" class="tab-pane fade">
  154. <?php
  155. $expire = "SELECT * FROM tiket WHERE tanggal_tonton < CURDATE() AND username = '$username'";
  156. $expire_query = mysqli_query($koneksi,$expire);
  157. if (mysqli_num_rows($expire_query) < 1) {
  158. echo '<h3 style="text-align:center;">Tidak Ada Data</h3>';
  159. } else {
  160. echo '<div class="row">';
  161. while ($row = mysqli_fetch_assoc($expire_query)) {
  162. echo '
  163. <div class="expire-content col-md-6 col-xs-12 col-sm-12 col-lg-6">
  164. <div class="row">
  165. <div class="col-md-6 col-lg-6 col-xs-6 col-sm-6">
  166. <p class="title">'.$row['judul'].'</p>
  167. </div>
  168. <div class="col-md-6 col-lg-6 col-xs-6 col-sm-6">
  169. <p class="price">Rp. '.$row['total_harga'].'</p>
  170. </div>
  171. </div>
  172. <hr>
  173. <div class="row" style="text-align:center;">
  174. <div class="col-md-3 col-lg-3 col-xs-6 col-sm-6">
  175. <p><b>Tanggal</b></p>
  176. <p>'.$row['tanggal_tonton'].'</p>
  177. </div>
  178. <div class="col-md-3 col-lg-3 col-xs-6 col-sm-6">
  179. <p><b>studio</b></p>
  180. <p>'.$row['nama_studio'].'</p>
  181. </div>
  182. <div class="col-md-3 col-lg-3 col-xs-6 col-sm-6">
  183. <p><b>kursi</b></p>
  184. <p>'.$row['seat'].'</p>
  185. </div>
  186. <div class="col-md-3 col-lg-3 col-xs-6 col-sm-6">
  187. <p><b>jam</b></p>
  188. <p>'.$row['jam_tonton'].'</p>
  189. </div>
  190. </div>
  191. </div>
  192. ';
  193. }
  194. echo '</div>';
  195. }
  196. ?>
  197. </div>
  198. <div id="promosi" class="tab-pane fade">
  199. <?php
  200. $promosi = "SELECT * FROM promo WHERE CURDATE() BETWEEN tanggal_awal AND tanggal_akhir";
  201. $promosi_query = mysqli_query($koneksi,$promosi);
  202. if(mysqli_num_rows($promosi_query) < 1) {
  203. echo '<h3 style="text-align:center;">Tidak Ada Promosi :(</h3>';
  204. } else {
  205. echo '<div class="row">';
  206. while($row = mysqli_fetch_assoc($promosi_query)) {
  207. echo '
  208. <div class="col-md-3 col-lg-3 col-xs-12 col-sm-12">
  209. <div class="panel panel-default">
  210. <div class="panel-heading"><h3>'.$row['kode'].'</h3></div>
  211. <div class="panel-body">
  212. <h4>Rp. '.$row['nominal'].'</h4>
  213. <p>'.$row['tanggal_awal'].' s/d '.$row['tanggal_akhir'].'</p>
  214. <p>'.$row['deskripsi'].'</p>
  215. </div>
  216. </div>
  217. </div>
  218. ';
  219. }
  220. echo '</div>';
  221. }
  222. ?>
  223. </div>
  224. <div id="topup" class="tab-pane fade">
  225. <?php
  226. $topup = "SELECT * FROM topup WHERE username = '$username'";
  227. $topup_query = mysqli_query($koneksi,$topup);
  228. if (mysqli_num_rows($topup_query) < 1) {
  229. echo "
  230. <h3>Tidak ada transaksi topup tiket</h3>
  231. <p style='text-align:center;'>Silahkan lakukan topup tiket di bioskop</p>
  232. ";
  233. } else {
  234. echo '
  235. <div class="table-responsive">
  236. <table class="table table-striped">
  237. <tr>
  238. <th>Tanggal Transaksi</th>
  239. <th>Nominal</th>
  240. </tr>
  241. ';
  242. while ($row = mysqli_fetch_assoc($topup_query)) {
  243. echo '
  244. <tr>
  245. <td>'.$row['tanggal'].'</td>
  246. <td>'.$row['uang'].'</td>
  247. </tr>
  248. ';
  249. }
  250.  
  251. echo '</table></div>';
  252. }
  253. ?>
  254. </div>
  255. <div id="setting" class="tab-pane fade">
  256. <form method="post">
  257. <label>Ubah Password :</label>
  258. <input type="password" name="password" class="form-control" placeholder="Ubah Password...">
  259. <label>Retype Password :</label>
  260. <input type="password" name="retype" class="form-control" placeholder="Retype...">
  261. <button type="submit" name="submit" class="btn btn-primary">Ubah</button>
  262. </form>
  263.  
  264. <?php
  265. if(isset($_POST['submit'])) {
  266. if(isset($_POST['password']) && isset($_POST['retype'])) {
  267. $username = $_SESSION['username'];
  268. $password = $_POST['password'];
  269. $retype = $_POST['retype'];
  270. $hash = password_hash($password,PASSWORD_DEFAULT);
  271.  
  272. if ($password == $retype) {
  273. $update_password = "UPDATE customer SET password = '$hash' WHERE username = '$username'";
  274. $password_query = mysqli_query($koneksi,$update_password);
  275. if ($password_query) {
  276. echo '
  277. <script>
  278. window.alert("Password Berhasil Diupdate");
  279. window.location = "home.php";
  280. </script>
  281. ';
  282. } else {
  283. echo '
  284. <script>
  285. window.alert("Password Gagal Diupdate");
  286. window.location = "home.php";
  287. </script>
  288. ';
  289. }
  290. } else {
  291. echo '
  292. <script>
  293. window.alert("Password Harus Sama");
  294. window.location = "home.php";
  295. </script>
  296. ';
  297. }
  298. }
  299. }
  300. ?>
  301. </div>
  302. </div>
  303. </div>
  304. <div class="container-fluid footer">
  305. <div class="row">
  306. <div class="col-md-6 col-xs-12 col-sm-6">
  307. <div class="row sitemap">
  308. <div class="col-md-4 col-xs-12 col-sm-4">
  309. <p class="title">cinema 69s</p>
  310. <a href="#">about us</a>
  311. <a href="#">contact</a>
  312. <a href="#">jobs</a>
  313. </div>
  314. <div class="col-md-4 col-xs-12 col-sm-4">
  315. <p class="title">customers</p>
  316. <a href="#">Customer Service</a>
  317. <a href="#">FAQ</a>
  318. </div>
  319. <div class="col-md-4 col-xs-12 col-sm-4">
  320. <p class="title">legal</p>
  321. <a href="#">terms of service</a>
  322. <a href="#">privacy policy</a>
  323. </div>
  324. </div>
  325. </div>
  326. <div class="col-md-6 col-xs-12 col-sm-6">
  327. <div class=" col-md-6 col-xs-12 address">
  328. <p><i class="fas fa-map-marker-alt fa-lg"></i> fakultas teknologi informasi gedung r universitas tarumanagara. Jl. s parman jakarta barat</p>
  329. </div>
  330. <div class="col-md-6 col-xs-12 socmed">
  331. <a href="#"><i class="fab fa-facebook-square fa-2x"></i></a>
  332. <a href="#"><i class="fab fa-instagram fa-2x"></i></a>
  333. <a href="#"><i class="fab fa-twitter fa-2x"></i></a>
  334. <a href="#"><i class="fab fa-youtube fa-2x"></i></a>
  335. </div>
  336. </div>
  337. </div>
  338. </footer>
  339. </body>
  340. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!