API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 10th, 2019
273
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.77 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2.  
  3. include'koneksi.php'; // koneksi database dalam bentuk class
  4. // memanggil dan medeklasrasikan class db ke function conn
  5. function conn($server="localhost", $user="root", $pass="",$db="db_puskesmas"){
  6. $dbcon= new dbcon();
  7. $conn=$dbcon ->conn($server,$user,$pass,$db);
  8. $koneksi= mysqli_connect($server, $user, $pass, $db);
  9. if ($koneksi){
  10. }else{
  11. echo "Koneksi Gagal";
  12. }
  13. $koneksi->select_db($db);
  14. return $conn;
  15. }
  16.  
  17.  
  18. // function cek login dengan memanggil dan validasi apakan user bersangkutan ada di tabel atau tidak
  19. function cek_login($user,$pass){
  20. $koneksi=conn();
  21. $sql =mysqli_query($koneksi,"SELECT username, hak_akses FROM tb_user WHERE username='$user' AND password='$pass'");
  22. $cek =mysqli_num_rows($sql);
  23. $data =mysqli_fetch_array($sql);
  24. if ($cek > 0 ) {
  25. //session_start ();
  26. $_SESSION['USERE']=$data[username];
  27. $_SESSION['AKSES']=$data[hak_akses];
  28. //echo"<script>alert('Login data berhasil !')</script>";
  29. echo "<meta http-equiv='refresh' content='0; url=index.php'>";
  30. }else {
  31. echo "<script> alert('Login Gagal !!!')</script>";
  32. }
  33. mysqli_close($koneksi);
  34. }
  35.  
  36. // function user time out , jika aplikasi tidak di gunakan dalam 600 detik maka akan logout
  37. function user_out(){
  38. $_SESSION['TIME']=time();
  39. $session=$_SESSION['TIME'];
  40. if (isset($session)&&(time() - $session>600)) {
  41. session_destroy();
  42. // logout();
  43. }
  44. }
  45.  
  46. function logout(){
  47. unset($_SESSION['USERE']);
  48. unset($_SESSION["AKSES"]);
  49. // exit();
  50. echo "<script>window.alert(Log Out Sukses);</script>";
  51. echo "<meta http-equiv='refresh' content='0;url=index.php'>";
  52.  
  53. }
  54.  
  55.  
  56. // fungsi original manual php untuk tampil data
  57. function tampil2(){
  58. $koneksi=conn();
  59. $query="select * from tb_user";
  60. $result=mysqli_query($koneksi,$query);
  61. $numfields = mysqli_num_fields($result);
  62.  
  63. echo "<table>\n<tr>";
  64.  
  65. for ($i=0; $i < $numfields; $i++) // Header
  66. { echo '<th>'.mysqli_fetch_field_direct($result, $i)->name.'</th>'; }
  67.  
  68. echo "</tr>\n";
  69.  
  70. while ($row = mysqli_fetch_row($result)) // Data
  71. { echo '<td>'.implode($row,'</td><td>')."</td></tr>\n"; }
  72.  
  73. echo "</table>\n";
  74. }
  75.  
  76. error_reporting(E_ALL);
  77. // function tampilkan data dengan tampilan tabel bootstrap
  78. function tampil($sql,$page,$kode){
  79. $koneksi=conn();
  80. $query=mysqli_query($koneksi,$sql);
  81. $ncols =mysqli_num_fields($query);
  82. echo '<table class="table table-striped table-bordered table-hover" id="dataTables-example">';
  83. echo '<thead>';
  84. echo '<tr >';
  85. for ($i = 0; $i < $ncols; $i++)// heder
  86. {
  87. $colname = mysqli_fetch_field_direct($query,$i)->name;
  88. echo " <th>".$colname."</th>";
  89. }
  90. echo '<th width=100> Aksi </th>';
  91. echo '</tr>';
  92. echo '</thead>';
  93. echo '<tbody>';
  94. while ($row = mysqli_fetch_row($query)) // Data
  95. { echo '<td>'.implode($row,'</td><td>').'</td>
  96. <td><a href="?page='.$page.'_edit&kode='.$row[$kode].'"> <i class="glyphicon glyphicon-edit"> Edit </i></a>
  97. <a href="?page='.$page.'_delete&kode='.$row[$kode].'"> <i class="glyphicon glyphicon-remove"> Delete</i></a>
  98. </td>
  99. </tr>'."\n";}
  100. echo '</tbody>';
  101. echo '</table>';
  102. mysqli_close($koneksi);
  103. }
  104.  
  105. // function tampilkan data dengan cetak dengan tampilan tabel bootstrap
  106. function tampil_cetak($sql,$page,$kode){
  107. $koneksi=conn();
  108. $query=mysqli_query($koneksi,$sql);
  109. $ncols =mysqli_num_fields($query);
  110. echo '<table class="table table-striped table-bordered table-hover" id="dataTables-example">';
  111. echo '<thead>';
  112. echo '<tr >';
  113. for ($i = 0; $i < $ncols; $i++)// heder
  114. {
  115. $colname = mysqli_fetch_field_direct($query,$i)->name;
  116. echo " <th>".$colname."</th>";
  117. }
  118. echo '<th width=100> Aksi </th>';
  119. echo '</tr>';
  120. echo '</thead>';
  121. echo '<tbody>';
  122. while ($row = mysqli_fetch_row($query)) // Data
  123. { echo '<td>'.implode($row,'</td><td>').'</td>
  124. <td><a href="?page='.$page.'_edit&kode='.$row[$kode].'"> <i class="glyphicon glyphicon-edit"> Edit </i></a>
  125. <a href="?page='.$page.'_delete&kode='.$row[$kode].'"> <i class="glyphicon glyphicon-remove"> Delete</i></a>
  126. <a href="'.$page.'_cetak.php?kode='.$row[$kode].'" target="_blank"> <i class="glyphicon glyphicon-print"> Cetak</i></a>
  127. </td>
  128. </tr>'."\n";}
  129. echo '</tbody>';
  130. echo '</table>';
  131. mysqli_close($koneksi);
  132. }
  133. function cetak_tampil($sql){
  134. $koneksi=conn();
  135. $query=mysqli_query($koneksi,$sql);
  136. $ncols = mysqli_num_fields($query);
  137. echo '<table class="table table-striped table-bordered table-hover" id="dataTables-example">';
  138. echo '<thead>';
  139. echo '<tr >';
  140. for ($i = 0; $i < $ncols; $i++)// heder
  141. {
  142. $colname = mysqli_fetch_field_direct($query,$i)->name;
  143. echo "<th>".$colname."</th>";
  144. }
  145. echo '</tr>';
  146. echo '</thead>';
  147. echo '<tbody>';
  148. while ($row = mysqli_fetch_row($query)) // Data
  149. { echo '<td>'.implode($row,'</td><td>').'</td>
  150. </tr>'."\n"; }
  151. echo '</tbody>';
  152. echo '</table>';
  153. mysqli_close($koneksi);
  154. }
  155. // funsi menyimpan lokasi
  156. function tampil_lokasi($sql,$page,$kode){
  157. $koneksi=conn();
  158. $query=mysqli_query($koneksi,$sql);
  159. $ncols = mysqli_num_fields($query);
  160. echo '<table class="table table-striped table-bordered table-hover" id="dataTables-example">';
  161. echo '<thead>';
  162. echo '<tr >';
  163. for ($i = 0; $i < $ncols; $i++)// heder
  164. {
  165. $colname = mysqli_fetch_field_direct($query,$i)->name;
  166. echo " <th>".$colname."</th>";
  167. }
  168. echo '<th> Aksi </th>';
  169. echo '</tr>';
  170. echo '</thead>';
  171. echo '<tbody>';
  172. while ($row = mysqli_fetch_row($query)) // Data
  173. { echo '<td>'.implode($row,'</td><td>').'</td>
  174. <td><a href="?page='.$page.'_pilih&kode='.$row[$kode].'"> <i class="glyphicon glyphicon-edit">_Pilih </i>
  175. </a> </td>
  176. </tr>'."\n"; }
  177.  
  178. echo '</tbody>';
  179. echo '</table>';
  180. mysqli_close($koneksi);
  181. }
  182.  
  183. function tampil_lokasi_edit($sql,$page,$kode){
  184. $koneksi=conn();
  185. $query=mysqli_query($koneksi,$sql);
  186. $ncols = mysqli_num_fields($query);
  187. echo '<table class="table table-striped table-bordered table-hover" id="dataTables-example">';
  188. echo '<thead>';
  189. echo '<tr >';
  190. for ($i = 0; $i < $ncols; $i++)// heder
  191. {
  192. $colname = mysqli_fetch_field_direct($query,$i)->name;
  193. echo " <th>".$colname."</th>";
  194. }
  195. echo '<th> Aksi </th>';
  196. echo '</tr>';
  197. echo '</thead>';
  198. echo '<tbody>';
  199. while ($row = mysqli_fetch_row($query)) // Data
  200. { echo '<td>'.implode($row,'</td><td>').'</td>
  201. <td><a href="?page='.$page.'_edit&kode='.$row[$kode].'"> <i class="glyphicon glyphicon-edit">_Edit </i>
  202. </a> </td>
  203. </tr>'."\n"; }
  204.  
  205. echo '</tbody>';
  206. echo '</table>';
  207. mysqli_close($koneksi);
  208. }
  209.  
  210.  
  211. // function untuk menyimpan data
  212. function simpan($sql,$page){
  213. $koneksi=conn();
  214. $query = mysqli_query($koneksi,$sql) or die (mysqli_error());
  215. if ($query)
  216. {
  217. echo"<script>alert('Simpan data berhasil !')</script>";
  218. echo"<meta http-equiv='refresh' content='0' url='?page=".$page."';>";
  219. }
  220. mysqli_close($koneksi);
  221. }
  222.  
  223. //fungsi menyimpan data tanpa massage
  224. function simpan2($sql){
  225. $koneksi=conn();
  226. $query = mysqli_query($koneksi,$sql) or die (mysqli_error());
  227.  
  228. mysqli_close($koneksi);
  229. }
  230.  
  231.  
  232. function edit($sql) {
  233. $koneksi= conn();
  234. $query = mysqli_query($koneksi,$sql) or die (mysqli_error());
  235. if ($query)
  236. {
  237. echo"<script>alert('Edit data berhasil !')</script>";
  238.  
  239. }
  240. mysqli_close($koneksi);
  241.  
  242.  
  243. }
  244.  
  245. function edit2($sql,$page) {
  246. $koneksi= conn();
  247. $query = mysqli_query($koneksi,$sql) or die (mysqli_error());
  248. if ($query)
  249. {
  250. echo"<meta http-equiv='refresh' content='0; url=?page=".$page."'>";
  251. }
  252. mysqli_close($koneksi);
  253.  
  254.  
  255. }
  256.  
  257.  
  258. function hapus($sql) {
  259. $koneksi= conn();
  260. $query = mysqli_query($koneksi,$sql) or die (mysqli_error());
  261. if ($query)
  262. {
  263. echo"<script>alert('Hapus data berhasil !')</script>";
  264.  
  265. }
  266. mysqli_close($koneksi);
  267.  
  268. }
  269.  
  270. //hapus tanpa massage
  271. function hapus2($sql,$page) {
  272. $koneksi= conn();
  273. $query = mysqli_query($koneksi,$sql) or die (mysqli_error());
  274. if ($query)
  275. {
  276. echo"<meta http-equiv='refresh' content='0; url=?page=".$page."'>";
  277. }
  278. mysqli_close($koneksi);
  279.  
  280. }
  281.  
  282. //fungsi cari hapus untuk IKM
  283. function cariKODE($sql,$kode) {
  284. $koneksi=conn();
  285. $query= mysqli_query($koneksi,$sql);
  286. $data= mysqli_fetch_array($query);
  287. $nilai=$data[$kode];
  288. return $nilai;
  289. mysqli_close($koneksi);
  290.  
  291. }
  292.  
  293. function cek_data($sql){
  294. $koneksi=conn();
  295. $query= mysqli_query($koneksi,$sql);
  296. $cek =mysqli_num_rows($query); //mencari jumlah record dalam tabel
  297. return $cek;
  298. mysqli_close($koneksi);
  299. }
  300.  
  301. function kode_otomatis($inis,$sql){
  302. $koneksi=conn();
  303. $nilai =$inis;// inisial kode contoh = KT-
  304. $sql= "SELECT MAX(RIGHT(id_pendaftaran,1)) as ID FROM tb_pendaftaran where id_pendaftaran LIKE '$nilai%'";
  305. $query = mysqli_query($koneksi,$sql);
  306. $data = mysqli_fetch_row($query);
  307. $kodeUSER =$data['ID'];
  308. $kodeUSER++;
  309. $char =$nilai;
  310. $kode= $char .sprintf("%04s", $kodeUSER);
  311. return $kode;
  312. mysqli_close($koneksi);
  313. }
  314.  
  315. function kode_ikm($inis,$sql,$karakter){
  316. $koneksi=conn();
  317. $nilai =$inis;
  318. $query = mysqli_query($koneksi,$sql);
  319. $data = mysqli_fetch_row($query);
  320. $kodeUSER =$data['ID'];
  321. $kodeUSER++;
  322. $char =$nilai;
  323. // $karakter=date("Y.m")."/";
  324. $kode= $char .$karakter.sprintf("%03s", $kodeUSER);
  325.  
  326. return $kode;
  327. mysqli_close($koneksi);
  328. }
  329. function cari_kode($sql){
  330. $koneksi=conn();
  331. $query = mysqli_query($koneksi,$sql);
  332. $data = mysqli_fetch_row($query);
  333. $kode =$data['ID'];
  334. return $kode;
  335. mysqli_close($koneksi);
  336. }
  337. function stock_barang($id_barang){
  338. $koneksi=conn();
  339. $sql_id_stock="SELECT max(id_persediaan) as ID from persediaan where id_barang='$id_barang'";
  340. $nilai_id=cari_kode($sql_id_stock);
  341. $sql= "SELECT jml_stock as jml from persediaan where id_persediaan='$nilai_id' and id_barang='$id_barang'";
  342. $query = mysqli_query($koneksi,$sql);
  343. $data = mysqli_fetch_row($query);
  344. $jml =$data['jml'];
  345. $values=array('id_stok' =>$nilai_id ,'jml'=>$jml);
  346. return $values;
  347. mysqli_close($koneksi);
  348. }
  349.  
  350.  
  351. function kode_ijin($inis,$sql,$karakter){
  352. $koneksi=conn();
  353. $nilai =$inis;
  354. $query = mysqli_query($koneksi,$sql);
  355. $data = mysqli_fetch_row($query);
  356. $kodeUSER =$data['ID'];
  357. $kodeUSER++;
  358. $char =$nilai;
  359. // $karakter=date("Y.m")."/";
  360. $kode= $char .sprintf("%03s", $kodeUSER).$karakter;
  361. return $kode;
  362. mysqli_close($koneksi);
  363. }
  364. function convert_tgl($tgl){
  365. $tanggal=$tgl;
  366. $ubahFormat=date("Y-m-d",strtotime($tanggal));
  367. return $ubahFormat;
  368. }
  369.  
  370. ?>
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!