· 6 years ago · Jan 21, 2020, 11:58 AM
1<?php
2// Kang HL
3 require_once("config.php");
4 $postdata = array('api_key' => '',//api key lo
5 'action' => 'layanan'// aksi
6 );
7
8 $ch = curl_init();
9 curl_setopt($ch, CURLOPT_URL, "https://nespedia-panel.com/api/sosial-media");
10 curl_setopt($ch, CURLOPT_POST, 1);
11 curl_setopt($ch, CURLOPT_POSTFIELDS, $postdata);
12 curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
13 curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
14 $chresult = curl_exec($ch);
15 curl_close($ch);
16 $json_result = json_decode($chresult, true);
17 print_r($json_result);
18 $no = 1;
19 $indeks=0;
20 while($indeks < count($json_result['data'])){
21 $id_provider = $json_result['data'][$indeks]['sid'];
22 $kategori = $json_result['data'][$indeks]['kategori'];
23 $layanan = $json_result['data'][$indeks]['layanan'];
24 $harga = $json_result['data'][$indeks]['harga'] + 10000;
25 $min = $json_result['data'][$indeks]['min'];
26 $max = $json_result['data'][$indeks]['max'];
27 $catatan = $json_result['data'][$indeks]['catatan'];
28 $provider = "NES-SOSMED";
29 $indeks++;
30 //INSERT KATEGORI
31 $cek_kategori = $conn->query("SELECT * FROM kategori_layanan WHERE nama = '$kategori'");
32 if(mysqli_num_rows($cek_kategori) > 0){
33
34 }else{
35 $input_kategori = $conn->query("INSERT INTO kategori_layanan VALUES ('','$kategori','$kategori','Sosial Media')");
36 }
37
38 $cek_layanan = $conn->query("SELECT * FROM layanan_sosmed WHERE provider_id = '$id_provider' AND provider = 'NES-SOSMED'");
39 $data_layanan = $cek_layanan->fetch_assoc();
40 if(mysqli_num_rows($cek_layanan) > 0) {
41 echo "Layanan Sudah Ada Di database => $layanan | $id_provider \n <br />";
42 } else {
43 //INSERT LAYANAN
44 $layanan2 = strtr($layanan, array(
45 ' IRVANKEDE' => ' Arifah',
46 ' IRVAN KEDE' => ' Arifah',
47 ' Irvankede' => ' ArifahPedia',
48 ' IRV' => ' DM',
49 ' [ ORDER VIA API 35K ]' => ' DM',
50 ' [ORDER VIA API RP 35K]' => ' DM',
51 ' [ORDER VIA API 35K]' => ' DM',
52 ' IKP' => ' DM IKP Server',
53 ' IK' => ' DM IK Server',
54 ));
55 $sid = $no++;
56 $insert_layanan = $conn->query("INSERT INTO layanan_sosmed VALUES ('','$sid' ,'$kategori' ,'$layanan2' ,'$catatan' ,'$min' ,'$max' ,'$harga', '9000', 'Aktif' ,'$id_provider' ,'NES-SOSMED' ,'Sosial Media')");
57 if($insert_layanan == TRUE){
58 echo "===============================
59 Input Layanan Sukses <br/>
60 Kategori : $kategori <br/>
61 SID : $sid <br />
62 Layanan : $layanan2 <br />
63 Min :$min <br />
64 Max : $max <br />
65 Harga : $harga <br />
66 Note : $catatan <br />
67 ===================================<br/>";
68 }else{
69 echo "Gagal";
70 }
71 // echo $no++." ";
72 }