· 5 years ago · Sep 15, 2020, 07:12 PM
1<?php
2require_once("../config.php");
3
4$apikey = "API KEY ANDA";
5
6$postdata = "api_key=$apikey&action=layanan";
7
8$ch = curl_init();
9curl_setopt($ch, CURLOPT_URL, "https://warriors-media.xyz/api/sosial-media");
10curl_setopt($ch, CURLOPT_POST, 1);
11curl_setopt($ch, CURLOPT_POSTFIELDS, $postdata);
12curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
13curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
14$chresult = curl_exec($ch);
15//echo $chresult;
16curl_close($ch);
17$json_result = json_decode($chresult, true);
18//
19$no = 1;
20$indeks=0;
21while($indeks < count($json_result['data'])){
22$id_provider = $json_result['data'][$indeks]['sid'];
23$kategori = $json_result['data'][$indeks]['kategori'];
24$layanan = $json_result['data'][$indeks]['layanan'];
25$min = $json_result['data'][$indeks]['min'];
26$max = $json_result['data'][$indeks]['max'];
27$harga = $json_result['data'][$indeks]['harga'] + 2000;
28$catatan = $json_result['data'][$indeks]['catatan'];
29$provider = "WM";
30$indeks++;
31
32//INSERT KATEGORI KE DATABASE kategori_layanan
33$cek_kategori = $conn->query("SELECT * FROM kategori_layanan WHERE nama = '$kategori'");
34if(mysqli_num_rows($cek_kategori) > 0){
35}else{
36$input_kategori = $conn->query("INSERT INTO kategori_layanan VALUES ('','$kategori','$kategori','Sosial Media')");
37}
38
39$cek_layanan = $conn->query("SELECT * FROM layanan_sosmed WHERE provider_id = '$id_provider' AND provider = WM'");
40$data_layanan = $cek_layanan->fetch_assoc();
41if(mysqli_num_rows($cek_layanan) > 0) {
42echo "Layanan Sudah Ada Di database => $layanan | $id_provider \n <br />";
43} else {
44
45$sid = $no++;
46$insert_layanan = $conn->query("INSERT INTO layanan_sosmed VALUES ('','$sid' ,'$kategori' ,'$layanan' ,'$catatan' ,'$min' ,'$max' ,'$harga', '1000', 'Aktif' ,'$id_provider' ,'WM' ,'Sosial Media')");
47if($insert_layanan == TRUE){
48
49echo "===============================
50Input Layanan Sukses <br/>
51Kategori : $kategori <br/>
52SID : $sid <br />
53Layanan : $layanan <br />
54Min :$min <br />
55Max : $max <br />
56Harga : $harga <br />
57Note : $catatan <br />
58===================================<br/>";
59}else{
60echo "Gagal";
61}
62// echo $no++." ";
63}
64}
65?>