API tools faq
paste
Guest User

PDO

a guest
Aug 8th, 2016
106
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.56 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. session_start();
  3. ?>
  4. <?php
  5. include('ceklogin.php');
  6. date_default_timezone_set("Asia/Jakarta");
  7. ?>
  8. <?php
  9. require 'database.php';
  10. error_reporting(E_ALL ^ (E_NOTICE | E_WARNING));
  11. // validasi error
  12. $Kd_barangError = null;
  13. $barangError = null;
  14. $hargaError = null;
  15.  
  16. // posting nilai variabel
  17. $Kd_barang = $_POST['Kd_barang'];
  18. $barang = $_POST['barang'];
  19. $harga = $_POST['harga'];
  20.  
  21. // validasi input
  22. $valid = true;
  23. if (empty($Kd_barang)) {
  24. $Kd_barangError = 'Masukkan Kode';
  25. $valid = false;
  26. }
  27.  
  28. if (empty($barang)) {
  29. $barangError = 'Masukkan Nama Barang';
  30. $valid = false;
  31. }
  32.  
  33. if (empty($harga)) {
  34. $hargaError = 'Masukkan harga barang';
  35. $valid = false;
  36. }
  37.  
  38. // proses insert data
  39. if ($valid) {
  40. $pdo = Database::connect();
  41. $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  42. $sql = "INSERT INTO barang (Kd_barang, barang, harga) values(?, ?, ?)" and mysql_query("ALTER TABLE tabeltransaksi ADD $barang INT(4) NULL default");
  43. $q = $pdo->prepare($sql);
  44. $q->execute(array($Kd_barang,$barang,$harga));
  45. if ($q == true) {
  46. echo "Proses memasukkan data berhasil";
  47. } else {
  48. echo "Proses memasukkan data gagal";
  49. }
  50. Database::disconnect();
  51. header("Location: tampilbarang.php");
  52. }
  53.  
  54.  
  55. ?>
  56.  
  57.  
  58. <!DOCTYPE html>
  59. <html lang="en">
  60.  
  61. <head>
  62.  
  63. <meta charset="utf-8">
  64. <meta http-equiv="X-UA-Compatible" content="IE=edge">
  65. <meta name="viewport" content="width=device-width, initial-scale=1">
  66. <meta name="description" content="">
  67. <meta name="author" content="">
  68.  
  69. <title>Tambah barang</title>
  70.  
  71. <!-- Bootstrap Core CSS -->
  72. <link href="vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet">
  73.  
  74. <!-- Theme CSS -->
  75. <link href="css/clean-blog.min.css" rel="stylesheet">
  76.  
  77. <!-- Custom Fonts -->
  78. <link href="vendor/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css">
  79. <link href='http://fonts.googleapis.com/css?family=Lora:400,700,400italic,700italic' rel='stylesheet' type='text/css'>
  80. <link href='http://fonts.googleapis.com/css?family=Open+Sans:300italic,400italic,600italic,700italic,800italic,400,300,600,700,800' rel='stylesheet' type='text/css'>
  81.  
  82. <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
  83. <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
  84. <!--[if lt IE 9]>
  85. <script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
  86. <script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script>
  87. <![endif]-->
  88.  
  89. </head>
  90.  
  91. <body>
  92.  
  93. <!-- Navigation -->
  94. <nav class="navbar navbar-default navbar-custom navbar-fixed-top">
  95. <div class="container-fluid">
  96. <!-- Brand and toggle get grouped for better mobile display -->
  97. <div class="navbar-header page-scroll">
  98. <button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
  99. <span class="sr-only">Toggle navigation</span>
  100. Menu <i class="fa fa-bars"></i>
  101. </button>
  102. <a class="navbar-brand" href="index.php">SND Photography</a>
  103. </div>
  104.  
  105. <!-- Collect the nav links, forms, and other content for toggling -->
  106. <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
  107. <ul class="nav navbar-nav navbar-right">
  108. <li>
  109. <a href="index.php">Beranda</a>
  110. </li>
  111. <li class="dropdown">
  112. <a href="#" class="dropdown-toggle" data-toggle="dropdown">Barang</a>
  113. <ul class="dropdown-menu">
  114. <li><a href="tambahbarang.php"><font color="#000000">Tambah Barang</font></a></li>
  115. <li><a href="tampilbarang.php"><font color="#000000">Tampil Barang </font></a></li>
  116. </ul>
  117. </li>
  118. <li>
  119. <a href="#" class="dropdown-toggle" data-toggle="dropdown">Transaksi</a>
  120. <ul class="dropdown-menu">
  121. <li><a href="tambahtransaksi.php"><font color="#000000">Tambah Transaksi</font></a></li>
  122. <li><a href="tampiltransaksi.php"><font color="#000000">Tampil Transaksi </font></a></li>
  123. </ul>
  124. </li>
  125. <li>
  126. <a href="#" class="dropdown-toggle" data-toggle="dropdown">User</a>
  127. <ul class="dropdown-menu">
  128. <li><a href="tambahadmin.php"><font color="#000000">Tambah User</font></a></li>
  129. <li><a href="tampiladmin.php"><font color="#000000">Tampil User</font></a></li>
  130. </ul>
  131. </li>
  132. <li>
  133. <a href="#" class="dropdown-toggle" data-toggle="dropdown">Laporan</a>
  134. <ul class="dropdown-menu">
  135. <li><a href="laporanbarang.php" target="_blank"><font color="#000000">Laporan Barang</font></a></li>
  136. <li><a href="laporantransaksi.php" target="_blank"><font color="#000000">Laporan Transaksi</font></a></li>
  137. <li><a href="laporanadmin.php" target="_blank"><font color="#000000">Laporan user</font></a></li>
  138. </ul>
  139. </li>
  140. <li>
  141. <a href="datamining/index.php" target="_blank">Analisa Apriori</a>
  142. </li>
  143.  
  144. </ul>
  145. </div>
  146. <!-- /.navbar-collapse -->
  147. </div>
  148. <!-- /.container -->
  149. </nav>
  150.  
  151. <!-- Page Header -->
  152. <!-- Set your background image for this header on the line below. -->
  153. <header class="intro-header" style="background-image: url('img/home-bg.jpg')">
  154. <div class="container">
  155. <div class="row">
  156. <div class="col-lg-8 col-lg-offset-2 col-md-10 col-md-offset-1">
  157. <div class="site-heading">
  158. <h1>Input Barang</h1>
  159. <hr class="small">
  160. <h4><?php echo "Tanggal " . date("d/m/Y") . "<br>"; ?> </h4>
  161. <h4><?php echo "Jam " . date("h:i a"); ?> </h4>
  162. </div>
  163. </div>
  164. </div>
  165. </div>
  166. </header>
  167.  
  168. <div class="container">
  169. <form class="form-horizontal" action="tambahbarang.php" method="post">
  170. <div class="control-group <?php echo !empty($Kd_barangError)?'error':'';?>">
  171. <label class="control-label">Kode Barang</label>
  172. <div class="controls">
  173. <input name="Kd_barang" id="Kd_barang" type="text" placeholder="Kode" value="<?php echo !empty($Kd_barang)?$Kd_barang:'';?>">
  174. <?php if(!empty($Kd_barangError)):?>
  175. <span class="help-inline"><?php echo $Kd_barangError;?></span>
  176. <?php endif; ?>
  177. </div>
  178. </div>
  179. <div class="control-group <?php echo !empty($barangError)?'error':'';?>">
  180. <label class="control-label">Nama Barang</label>
  181. <div class="controls">
  182. <input name="barang" id="barang" type="text" placeholder="Barang" value="<?php echo !empty($barang)?$barang:'';?>">
  183. <?php if(!empty($barangError)):?>
  184. <span class="help-inline"><?php echo $barangError;?></span>
  185. <?php endif; ?>
  186. </div>
  187. </div>
  188. <div class="control-group <?php echo !empty($hargaError)?'error':'';?>">
  189. <label class="control-label">Harga Barang</label>
  190. <div class="controls">
  191. <input name="harga" id="harga" type="number" placeholder="Harga" value="<?php echo !empty($harga)?$harga:'';?>">
  192. <?php if(!empty($hargaError)):?>
  193. <span class="help-inline"><?php echo $hargaError;?></span>
  194. <?php endif; ?>
  195. </div>
  196. </div>
  197. <br />
  198. <div class="form-actions">
  199. <button type="submit" class="btn btn-success">Buat</button>
  200. <a class="btn" href="tampilbarang.php">Kembali</a>
  201. </div>
  202. </form>
  203.  
  204. </div>
  205. <!-- Footer -->
  206. <footer>
  207. <div class="container">
  208. <div class="row">
  209. <div class="col-lg-8 col-lg-offset-2 col-md-10 col-md-offset-1">
  210. <ul class="list-inline text-center">
  211. <li>
  212. <a href="https://www.facebook.com/SND-Photography-188259054557713/">
  213. <span class="fa-stack fa-lg">
  214. <i class="fa fa-circle fa-stack-2x"></i>
  215. <i class="fa fa-facebook fa-stack-1x fa-inverse"></i>
  216. </span>
  217. </a>
  218. </li>
  219. </ul>
  220. <p class="copyright text-muted">Copyright &copy; SND Photography 2016</p>
  221. </div>
  222. </div>
  223. </div>
  224. </footer>
  225.  
  226. <!-- jQuery -->
  227. <script src="vendor/jquery/jquery.min.js"></script>
  228.  
  229. <!-- Bootstrap Core JavaScript -->
  230. <script src="vendor/bootstrap/js/bootstrap.min.js"></script>
  231.  
  232. <!-- Contact Form JavaScript -->
  233. <script src="js/jqBootstrapValidation.js"></script>
  234. <script src="js/contact_me.js"></script>
  235.  
  236. <!-- Theme JavaScript -->
  237. <script src="js/clean-blog.min.js"></script>
  238.  
  239. </body>
  240.  
  241. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
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!