Algaza

File upload CSV

Apr 18th, 2022
2,070
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 3.41 KB | None | 0 0
  1. <div class="card card-primary">
  2.               <div class="card-header">
  3.                 <h3 class="card-title"><?=$judul?></h3>
  4.               </div>
  5.               <!-- /.card-header -->
  6.               <!-- form start -->
  7.               <form action="?update=true" method="POST" enctype="multipart/form-data">
  8.                 <div class="card-body">
  9.                   <div class="form-group">
  10.                     <label for="exampleInputFile">File input</label>
  11.                     <div class="input-group">
  12.                         <label class="" for="exampleInputFile">Choose file</label><br/><br/>
  13.                           <input name="csv" type="file" id="csv"><br/>
  14. <?php
  15. if ($_GET['update'] == true) {
  16. if ($_FILES['csv']['size'] > 0) {
  17.     //get the csv file
  18.     $file = $_FILES['csv']['tmp_name'];
  19.     $handle = fopen($file, "r");
  20.     $i = 0;
  21.     while (($dat = fgetcsv($handle, 1000, ",")) !== FALSE) { if ($i > 0) {
  22.  
  23.     $value = array( "kode" => $dat[4], "nama" => $dat[5], "type" => $dat[6], "sektoral" => $dat[7], "ip" => $dat[3], "j_down" => $dat[1], "durasi" => $dat[2], "tanggal" => $dat[0]);
  24.     $db->insert("koneksi_down", $value);
  25.  } $i++;
  26.     }
  27.     fclose($handle);
  28. ?>
  29. <script type="text/javascript">alert("SUKSES MENGIMPORT CSV ke DATABASE")</script>
  30. <?php
  31. }else{
  32. ?>
  33. <script type="text/javascript">alert("GAGAL MENGIMPORT CSV ke DATABASE")</script>
  34. <?php
  35. }
  36. }
  37. ?>
  38.  
  39.  
  40.  
  41.                     </div>
  42.                   </div>
  43.                 </div>
  44.                 <!-- /.card-body -->
  45.                 <div class="card-footer">
  46.                   <button type="submit" value="kirim" class="btn btn-primary">Submit</button>
  47.                 </div>
  48.               </form>
  49.             </div>
  50. <div class="card card-primary">
  51.               <div class="card-header">
  52.                 <h3 class="card-title"><?=$judul?></h3>
  53.               </div>
  54.               <!-- /.card-header -->
  55.               <!-- form start -->
  56.               <form action="?update=true" method="POST" enctype="multipart/form-data">
  57.                 <div class="card-body">
  58.                   <div class="form-group">
  59.                     <label for="exampleInputFile">File input</label>
  60.                     <div class="input-group">
  61.                         <label class="" for="exampleInputFile">Choose file</label><br/><br/>
  62.                           <input name="csv" type="file" id="csv"><br/>
  63. <?php
  64. if ($_GET['update'] == true) {
  65. if ($_FILES['csv']['size'] > 0) {
  66.     //get the csv file
  67.     $file = $_FILES['csv']['tmp_name'];
  68.     $handle = fopen($file, "r");
  69.     $i = 0;
  70.     while (($dat = fgetcsv($handle, 1000, ",")) !== FALSE) { if ($i > 0) {
  71.  
  72.     $value = array( "kode" => $dat[4], "nama" => $dat[5], "type" => $dat[6], "sektoral" => $dat[7], "ip" => $dat[3], "j_down" => $dat[1], "durasi" => $dat[2], "tanggal" => $dat[0]);
  73.     $db->insert("koneksi_down", $value);
  74.  } $i++;
  75.     }
  76.     fclose($handle);
  77. ?>
  78. <script type="text/javascript">alert("SUKSES MENGIMPORT CSV ke DATABASE")</script>
  79. <?php
  80. }else{
  81. ?>
  82. <script type="text/javascript">alert("GAGAL MENGIMPORT CSV ke DATABASE")</script>
  83. <?php
  84. }
  85. }
  86. ?>
  87.  
  88.  
  89.  
  90.                     </div>
  91.                   </div>
  92.                 </div>
  93.                 <!-- /.card-body -->
  94.                 <div class="card-footer">
  95.                   <button type="submit" value="kirim" class="btn btn-primary">Submit</button>
  96.                 </div>
  97.               </form>
  98.             </div>
  99.  
Advertisement
Add Comment
Please, Sign In to add comment