View difference between Paste ID: <a href="/87BT3YET">87BT3YET</a> and <a href="/gci0VTLS">gci0VTLS</a>

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