· 5 years ago · Aug 06, 2020, 02:26 PM
1<?php
2require_once("../config.php");
3
4$postdata = "api_key=iSiApiKey11-11&action=cat"; //isi api key anda
5
6$ch = curl_init();
7curl_setopt($ch, CURLOPT_URL, "https://grace-panel.id/api/category-pulsa");
8curl_setopt($ch, CURLOPT_POST, 1);
9curl_setopt($ch, CURLOPT_POSTFIELDS, $postdata);
10curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
11curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
12$chresult = curl_exec($ch);
13//echo $chresult;
14curl_close($ch);
15$json_result = json_decode($chresult, true);
16
17$indeks=0;
18while($indeks < count($json_result['data'])){
19$nama = $json_result['data'][$indeks]['nama'];
20$kode = $json_result['data'][$indeks]['kode'];
21$tipe = $json_result['data'][$indeks]['tipe'];
22$indeks++;
23
24 $check_services_pulsa = mysqli_query($conn, "SELECT * FROM kategori_layanan WHERE kode = '$kode'");
25 $data_services_pulsa = mysqli_fetch_assoc($check_services_pulsa);
26 if(mysqli_num_rows($check_services_pulsa) > 0) {
27 echo "Kode Sudah Ada Di database => $kode \n <br />";
28 } else {
29
30$insert=mysqli_query($conn, "INSERT INTO kategori_layanan (nama, kode, tipe) VALUES ('$nama', '$kode', '$tipe')");//Memasukan Kepada Database (OPTIONAL)
31if($insert == TRUE){
32echo"SUKSES INSERT -> Nama : $nama || Kode : $kode <br />";
33}else{
34 echo "GAGAL MEMASUKAN DATA";
35
36}
37}
38}
39?>
40
41