API tools faq
paste
Advertisement
GWibisono

perbaikan no 1

GWibisono
Aug 14th, 2012
50
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 7.44 KB | None | 0 0
raw download clone embed print report diff
  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'><?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);// 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>
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!