Ekhel

Import Data dari API ke DB

Aug 2nd, 2020
175
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.91 KB | None | 0 0
  1. public function import_from_backend()
  2.   {
  3.     $url = "http://endpoint.api/";
  4.  
  5.     $ch = curl_init();
  6.     curl_setopt($ch, CURLOPT_URL, $url);
  7.     curl_setopt($ch, CURLOPT_HEADER, 0);
  8.     curl_setopt($ch, CURLOPT_POST, 1);
  9.  
  10.     $readjson = curl_exec($ch);
  11.     $data = json_decode($readjson,true);
  12.     $hasil = $data['result'];
  13.     foreach ($hasil as $item)
  14.     {
  15.       $sql = "INSERT INTO tb_test(
  16.        nama,
  17.        umur,
  18.        jekel
  19.      )
  20.      VALUES(
  21.        '".$item['nama_lengkap']."',
  22.        '".$item['umur']."',
  23.        '".$item['gender']."'
  24.      )";
  25.  
  26.       $this->db->query($sql);
  27.     }
  28.     $this->session->set_flashdata("simpan_sumber","
  29.            <div class='alert alert-success fade in'>
  30.              <a href='#' class='close' data-dismiss='alert'>&times;</a>
  31.              <strong>Success !</strong> Berhasil Import Data!
  32.            </div>");
  33.     redirect('Import');
  34.   }
Add Comment
Please, Sign In to add comment