API tools faq
paste
View difference between Paste ID: vf6QLLaP and BXPjKDS5
SHOW: | | - or go back to the newest paste.
1
<?php
2
session_start();
3
?>
4
<?php
5
include('ceklogin.php');
6
date_default_timezone_set("Asia/Jakarta");
7
?>
8
9
<?php

10
$Kd_barang=isset($_GET['Kd_barang']) ? $_GET['Kd_barang'] :'';

11
Include('db_connection.php');

12
$querybarang=mysql_query("SELECT * FROM tabelbarang where Kd_barang='".$Kd_barang."'");

13
$databarang=mysql_fetch_array($querybarang);

14
?>

15
16
17
<?php

18
    require 'database.php';

19
    $Kd_barang = 0;

20
	$barang = 0;

21
22
    if ( !empty($_GET['Kd_barang'])) {

23
        $Kd_barang = $_REQUEST['Kd_barang'];

24
    }

25
     

26
	 

27
    if ( !empty($_POST)) {

28
        // post value

29
        $Kd_barang = $_POST['Kd_barang'];

30
		$barang = isset($_GET['barang']) ? $_GET['barang']:null;

31
         $barang = $_POST['barang'];

32-
		 

32+
		try { 

33
        // menghapus data

34
        $pdo = Database::connect();

35
        $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

36
        $sql = "DELETE FROM tabelbarang WHERE Kd_barang = ?";

37
		$sql2 ="ALTER TABLE tabeltransaksi 

38
		        DROP COLUMN '".$barang."'";

39
        

40
		

41
		$q = $pdo->prepare($sql);

42
		$q->execute(array($Kd_barang));

43
            if ($q == true) {

44-
                try {

44+
      //         try {

45
					

46
		  	    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

47
				$pdo->beginTransaction();	

48
				$pdo->exec("ALTER TABLE tabeltransaksi DROP '".$barang."'");        

49
		    	$pdo->commit(); 

50-
				echo "Data berhasil dihapus...";    

50+
				echo "Data berhasil dihapus...";

51
/*

52
     				}     

53
			    	catch(PDOException $e)     

54
					     {     

55
				      // roll back transaksi jika error sesuatu    

56
					      $pdo->rollback();     

57-
			      echo $sql . "<br>" . $e->getMessage(); 

57+
58
			      echo $sql . "<br>" . $e->getMessage();

59
60-
        }

60+
61
*/

62
		

63
            }

64
            else{

65-
        }

65+
				echo "<b>proses penghapusan berhasil ??{$sql} tetapi proses alter tidak dijalankan??";

66
die();

67
			}

68
						

69
		

70
            Database::disconnect();

71
            header("Location: tampilbarang.php");

72
        }     

73
		catch(PDOException $e){     

74
		// roll back transaksi jika error sesuatu    

75
		$pdo->rollback();     

76
		echo  "<br>Telah terjadi error:" . $e->getMessage();

77
		die();

78
		}

79
?>

80
 

81
<!DOCTYPE html>

82
<html lang="en">

83
84
<head>

85
86
    <meta charset="utf-8">

87
    <meta http-equiv="X-UA-Compatible" content="IE=edge">

88
    <meta name="viewport" content="width=device-width, initial-scale=1">

89
    <meta name="description" content="">

90
    <meta name="author" content="">

91
92
    <title>Hapus barang</title>

93
94
    <!-- Bootstrap Core CSS -->

95
    <link href="vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet">

96
97
    <!-- Theme CSS -->

98
    <link href="css/clean-blog.min.css" rel="stylesheet">

99
100
    <!-- Custom Fonts -->

101
    <link href="vendor/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css">

102
    <link href='http://fonts.googleapis.com/css?family=Lora:400,700,400italic,700italic' rel='stylesheet' type='text/css'>

103
    <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'>

104
105
    <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->

106
    <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->

107
    <!--[if lt IE 9]>

108
        <script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>

109
        <script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script>

110
    <![endif]-->

111
112
</head>

113
114
<body>

115
116
    <!-- Navigation -->

117
    <nav class="navbar navbar-default navbar-custom navbar-fixed-top">

118
        <div class="container-fluid">

119
            <!-- Brand and toggle get grouped for better mobile display -->

120
            <div class="navbar-header page-scroll">

121
                <button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">

122
                    <span class="sr-only">Toggle navigation</span>

123
                    Menu <i class="fa fa-bars"></i>

124
                </button>

125
                <a class="navbar-brand" href="index.php">SND Photography</a>

126
            </div>

127
128
            <!-- Collect the nav links, forms, and other content for toggling -->

129
            <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">

130
                <ul class="nav navbar-nav navbar-right">

131
                    <li>

132
                        <a href="index.php">Beranda</a>

133
                    </li>

134
                    <li class="dropdown">

135
                        <a href="#" class="dropdown-toggle" data-toggle="dropdown">Barang</a>

136
						<ul class="dropdown-menu">

137
                        <li><a href="tambahbarang.php"><font color="#000000">Tambah Barang</font></a></li>

138
                        <li><a href="tampilbarang.php"><font color="#000000">Tampil Barang </font></a></li>                                                                        

139
                        </ul>

140
                    </li>

141
                    <li>

142
                        <a href="#" class="dropdown-toggle" data-toggle="dropdown">Transaksi</a>

143
						<ul class="dropdown-menu">

144
                        <li><a href="tambahtransaksi.php"><font color="#000000">Tambah Transaksi</font></a></li>

145
                        <li><a href="tampiltransaksi.php"><font color="#000000">Tampil Transaksi </font></a></li>          

146
						</ul>

147
                    </li>

148
                    <li>

149
                        <a href="#" class="dropdown-toggle" data-toggle="dropdown">User</a>

150
						<ul class="dropdown-menu">

151
                        <li><a href="tambahadmin.php"><font color="#000000">Tambah User</font></a></li>

152
                        <li><a href="tampiladmin.php"><font color="#000000">Tampil User</font></a></li>    

153
						</ul>

154
                    </li>                  

155
                    <li>

156
                        <a href="#" class="dropdown-toggle" data-toggle="dropdown">Laporan</a>

157
						<ul class="dropdown-menu">

158
                        <li><a href="laporanbarang.php" target="_blank"><font color="#000000">Laporan Barang</font></a></li>

159
                        <li><a href="laporantransaksi.php" target="_blank"><font color="#000000">Laporan Transaksi</font></a></li>

160
                        <li><a href="laporanadmin.php" target="_blank"><font color="#000000">Laporan user</font></a></li>

161
						</ul>

162
                    </li>

163
                    <li>

164
                        <a href="datamining/index.php" target="_blank">Analisa Apriori</a>

165
                    </li>

166
                    

167
                </ul>

168
            </div>

169
            <!-- /.navbar-collapse -->

170
        </div>

171
        <!-- /.container -->

172
    </nav>

173
174
    <!-- Page Header -->

175
    <!-- Set your background image for this header on the line below. -->

176
    <header class="intro-header" style="background-image: url('img/home-bg.jpg')">

177
        <div class="container">

178
            <div class="row">

179
                <div class="col-lg-8 col-lg-offset-2 col-md-10 col-md-offset-1">

180
                    <div class="site-heading">

181
                        <h1>Hapus Barang</h1>

182
                        <hr class="small">

183
                        <h4><?php echo "Tanggal " . date("d/m/Y") . "<br>"; ?> </h4>

184
                        <h4><?php echo "Jam " . date("h:i a"); ?> </h4>                       

185
                    </div>

186
                </div>

187
            </div>

188
        </div>

189
    </header>

190
191
<div class="container">

192
<form class="form-horizontal" action="deletebarang.php" method="post">

193
<label class="control-label">Kode Barang</label>

194
<div class="controls">

195
<input name="Kd_barang" id="Kd_barang" type="number" placeholder="Kode Barang" readonly value="<?php echo $databarang['Kd_barang'];?>">

196
</div>

197
</div>

198
199
<label class="control-label">Barang</label>

200
<div class="controls">

201
<input name="barang" id="barang" type="text" placeholder="Barang" readonly value="<?php echo $databarang['barang'];?>">

202
</div>

203
</div>

204
205
<label class="control-label">Harga Barang</label>

206
<div class="controls">

207
<input name="harga" id="harga" type="number" placeholder="Harga" readonly value="<?php echo $databarang['harga'];?>">

208
</div>

209
</div>

210
211
<label class="control-label">Keterangan</label>

212
<div class="controls">

213
<input name="Keterangan" id="Keterangan" type="text" placeholder="Keterangan" readonly value="<?php echo $databarang['Keterangan'];?>">

214
215
</div>

216
</div>

217
<br />

218
<div class="form-actions">

219
<button type="submit" class="btn btn-success">hapus</button>

220
<a class="btn" href="tampilbarang.php">Kembali</a>

221
</div>

222
</form>

223
224
225
226
</div>

227
  <!-- Footer -->

228
    <footer>

229
        <div class="container">

230
            <div class="row">

231
                <div class="col-lg-8 col-lg-offset-2 col-md-10 col-md-offset-1">

232
                    <ul class="list-inline text-center">

233
                        <li>

234
                            <a href="https://www.facebook.com/SND-Photography-188259054557713/">

235
                                <span class="fa-stack fa-lg">

236
                                    <i class="fa fa-circle fa-stack-2x"></i>

237
                                    <i class="fa fa-facebook fa-stack-1x fa-inverse"></i>

238
                                </span>

239
                            </a>

240
                        </li>

241
                    </ul>

242
                    <p class="copyright text-muted">Copyright &copy; SND Photography 2016</p>

243
                </div>

244
            </div>

245
        </div>

246
    </footer>

247
248
    <!-- jQuery -->

249
    <script src="vendor/jquery/jquery.min.js"></script>

250
251
    <!-- Bootstrap Core JavaScript -->

252
    <script src="vendor/bootstrap/js/bootstrap.min.js"></script>

253
254
    <!-- Contact Form JavaScript -->

255
    <script src="js/jqBootstrapValidation.js"></script>

256
    <script src="js/contact_me.js"></script>

257
258
    <!-- Theme JavaScript -->

259
    <script src="js/clean-blog.min.js"></script>

260
261
</body>

262
263
</html>
        

    


            


                                


        

            



                
    

        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!