API tools faq
paste
View difference between Paste ID: pp69mRQa and h4vqu5EV
SHOW: | | - or go back to the newest paste.
1
<html>
2
<head>
3
<link rel="stylesheet" href="assets/css/reqformtransaksi.css" type="text/css">
4
<style>
5
	#wrapper{
6
		margin: 150px 0px 50px 0px;
7
	}
8
	table{border-collapse:collapse; margin: 0 auto;}
9
	td, th{border-right:1px solid black;border-top:1px solid black;border-bottom:1px solid black;text-align:center;}
10
11
	.content{font-family:verdana; font-size:12px; color: #2E506E;}
12
	.content:hover{background-color: #9DC7ED;}
13
14
	td{padding: 5px 10px 5px 10px;}
15
	a{color: #2E506E;text-decoration:none;}
16
17
	#topleft{-moz-border-radius-topleft:10px;-webkit-border-radius-topleft:10px;-khtml-border-radius-topleft:10px;border-radius-topleft:10px;

18
19
		border-top: none;border-left:none;background-color: #37556E;color: white;font-family:verdana;font-weight:bold;font-size:13px;}

20
	

21
	#topright{-moz-border-radius-topright:10px;-webkit-border-radius-topright:10px;-khtml-border-radius-topright:10px;border-radius-topright:10px;

22
23
		border-top: none;border-right:none;background-color: #37556E;color: white;font-family:verdana;font-weight:bold;font-size:13px;}

24
25
	.top{border-top:none;background-color: #37556E;color: white;font-family:verdana;font-weight:bold;font-size:13px;}

26
27
	.mid_left_content{border-left:none;}

28
29
	.mid_right_content{border-right:none;}

30
31
	.foot_content{border-left:none;border-right:none;font-size:12px;text-align:right;font-family:verdana;}

32
	

33
	.foot_img{border-left:none;border-right:none;text-align:center;}

34
35
	.foot_content a{color: #2E506E;text-decoration:none;}	

36
37
	.foot_content1 a{font-family:verdana;font-size:12;color: #d5d5d5;text-decoration:none;}

38
39
	.foot_content1 a:hover{text-shadow:1px 1px 7px yellow;}

40
41
	.foot_content1{font-family:verdana;font-size:12;color: white;text-decoration:none;}

42
43
	#footer_tr{background-color: #024A68;color: white;font-weight:bold;height:30px;

44
45
		-moz-border-radius-bottomright:10px;-webkit-border-radius-bottomright:10px;-khtml-border-radius-bottomright:10px;border-radius-bottomright:10px;

46
		-moz-border-radius-bottomleft:10px;-webkit-border-radius-bottomleft:10px;-khtml-border-radius-bottomleft:10px;border-radius-bottomleft:10px;}

47
	

48
	input{text-align:center;padding: 5px 10px 5px 10px;}

49
</style>

50
</head>

51
<body>

52-
<div id='wrapper'>

52+
<div id='wrapper'><?php if($_POST){ print_r($_POST); die(); }?><form method="POST"><input type=hidden name=tes value=1> <input type='image' name='search' src='images/twitter.jpg' alt='beli' value='tes'></form>

53
<table>

54
<?

55
error_reporting(1);

56
include("../connect.php");

57
//Langkah 1: Tentukan batas,cek halaman & posisi data

58
		date_default_timezone_set('UTC');

59
		date_default_timezone_set('Asia/Jakarta');

60
61
		$date = date("Y-m-d H:i:s");

62
63
$batas=10;

64
$halaman=$_GET['halaman'];

65
if(empty($halaman)){

66
	$posisi=0;

67
	$halaman=1;

68
}

69
else{

70
	$posisi = ($halaman-1) * $batas;

71
}

72
73
echo "<tr>

74
		<td id='topleft' width='25px'>No</td>

75
		<td class='top' width='100px'>Id Accecoriss</td>

76
		<td class='top' width='110px'>Merk</td>

77
		<td class='top' width='65px'>Kategori</td>

78
		<td class='top' width='90px'>Harga Beli</td>

79
		<td class='top' width='90px'>Harga Jual</td>

80
		<td class='top' width='20px'>Stok</td>

81
		<td id='topright' width='145px'>Last Update</td>

82
	  </tr>";

83
84
//Langkah 2: Sesuaikan perintah SQL

85
$tampil="select * FROM db_accecoriss limit $posisi,$batas";

86-
$hasil=mysql_query($tampil);

86+
$hasil=mysql_query($tampil);// or die(mysql_error());

87
88
$no=$posisi+1;

89
$nomor = 0;

90
while ($data=mysql_fetch_array($hasil)){

91
92
	$id = $data[0];

93
	$merk = $data[1];

94
	$kategori = $data[2];

95
	$hargabeli=number_format($data[3],0,",",".");

96
	$hargajual=number_format($data[4],0,",",".");

97
	$stok = $data[5];

98
	$last_update = $data[6];

99
	$nomor++;

100
101
  echo "<tr bgcolor='#d5d5d5' class='content'>

102
  			<td class='mid_left_content'>$nomor</td>

103
  			<td>$id</td>

104
			<td>$merk</td>

105
			<td>$kategori</td>

106
			<td>Rp $hargabeli</td>

107
			<td>Rp $hargajual</td>

108
			<td>$stok</td>

109
			<td>$last_update</td>

110
  			<td class='mid_right_content'><Input type='checkbox' name='select[]' value='$id'></td>

111
		</tr>";

112
  $no++;

113
}

114
echo"<tr bgcolor='#d5d5d5'><td colspan='8' class='foot_content'><font color='#2E506E'>Input merk atau kategori accecoriss sebagai kata kunci <b>pencarian</b> 

115
		<input type='text' name='keyword_acc' placeholder='search'></font></td></tr>";

116
echo"<tr bgcolor='#d5d5d5'>

117
		<td colspan='8' class='foot_img'>

118
				<input type='image' name='search' src='../assets/image/b_search.png' alt='cari'>

119
				<input type='image' name='tambah_produk' src='../assets/image/b_tambah.png' alt='tambah produk'>

120
				<input type='image' name='search' src='../assets/image/b_delete.png' alt='hapus'>

121
				<input type='image' name='search' src='../assets/image/b_beli.png' alt='beli'>

122
			<a href='../interface/editstok/edit_stok_acc.php?select[]=$id'>

123
				<input type='image' name='search' src='../assets/image/b_edit.png' alt='edit'>

124
			</a>

125
		</td>

126
	</tr>";

127
echo"<tr bgcolor='#d5d5d5' class='list_tr'><td colspan='8' align='left' class='foot_content'>";

128
129
//Langkah 3: Hitung total data dan halaman 

130
$tampil2="select * FROM db_accecoriss";

131
$hasil2=mysql_query($tampil2);

132
$jmldata=mysql_num_rows($hasil2);

133
134
$jmlhalaman=ceil($jmldata/$batas);

135
136
// Link ke halaman sebelumnya (previous)

137
$file="index_cek_stok_acc.php";

138
if($halaman > 1){

139
	$sebelumnya=$halaman-1;

140
	echo "	<a href=$file?halaman=1>First</A> |

141
        	<a href=$file?halaman=$sebelumnya>Prev</a> | ";

142
}

143
else

144
{

145
	echo "First | Prev | ";

146
}

147
148
// Tampilkan link halaman

149
$file="index_cek_stok_acc.php";

150
for($i=1;$i<=$jmlhalaman;$i++)

151
if ($i != $halaman){

152
	echo " <a href=$file?halaman=$i>$i</a> | ";

153
}

154
else{

155
	echo " <b>$i</b> | ";

156
}

157
158
// Link kehalaman berikutnya (selanjutnya)

159
if($halaman < $jmlhalaman){

160
	$selanjutnya=$halaman+1;

161
	echo "<a href=$file?halaman=$selanjutnya> Next</A> |

162
		  <a href=$file?halaman=$jmlhalaman> Last</A> ";

163
}

164
else{ 

165
	echo " Next | Last</td></tr>";

166
}

167
echo "<tr bgcolor='#d5d5d5'><td colspan='8' class='foot_content'><p><font color='#2E506E'>Total Product : $jmldata Item</font></p></td></tr>";

168
echo "<tr bgcolor='#d5d5d5' id='footer_tr'><td colspan='8' class='foot_content'>$date</td></tr>";

169
echo "<tr bgcolor='#d5d5d5' id='footer_tr'><td colspan='8' class='foot_content1'>Jika data accecoriss belum terdaftar pada list stok silahkan input data accecoriss terbaru terlebih dahulu <a href='http://localhost/spscounter/template/index_input_hp.php'>disini</a></td></tr>";

170
?>

171
</div>

172
</table>

173
<!--

174
pada versi sebelumnya.. km jadi tumpang tindih formnya.. dilarang ada kejadian form seperti ini

175
	<form>

176
		<form></form>

177
	</form>

178
	ini memang tidak sama seperti 

179
	<a>

180
		<a>bla</a>

181
	</a>

182
183
<a><input type='image'></a>

184
	namanya input tidak bisa dikasi a href.. kecuali kl kamu kasi ke button.. tp cara ini tidak benar.. seharusnya pakai

185
	<a href='../interface/editstok/edit_stok_acc.php?select[]=$id'>

186
		<imgsrc='../assets/image/b_edit.png' alt='edit'>

187
	</a>

188
sebaiknya pake nama lain untuk variable seperti dtid[] dst

189
	

190
Tidak ada form untuk proses.. demikian juga tidak ada tombol untuk update/delete

191
192
line 86 harusnya dikasi mysql_error()

193
194
line 118-121. bila ingin melakukan edit untuk banyak sekaligus.. lebih baik tombolnya submit bukan gambar. Kalau ingin menjadi gambar, maka kamu harus memainkan css (disarankan). Tapi bila ingin gambar.. maka kamu harus mendeteksi aksinya dari nama input gambar bukan isi dari input gambar.. perhatikan bahwa input=image tidak seharusnya memiliki value , tapi tadi dicoba ternyata bisa ngasi value yang artinya kamu harus tangkap di file berikutnya

195
196
138-146 kalau kamu kasi ini.. nanti yg km klik barusan akan hilang..

197
198
-->

199
</body>

200
</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!