getsoscial.php

<?php
// Kang HL
    require_once("config.php");
	$postdata = array('api_key' => '',//api key lo
                      'action'  => 'layanan'// aksi
                       );

	$ch = curl_init();
	curl_setopt($ch, CURLOPT_URL, "https://nespedia-panel.com/api/sosial-media");
    curl_setopt($ch, CURLOPT_POST, 1);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $postdata);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
    curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
    $chresult = curl_exec($ch);
    curl_close($ch);
    $json_result = json_decode($chresult, true);
    print_r($json_result);
	$no = 1;
	$indeks=0;
	while($indeks < count($json_result['data'])){
		$id_provider = $json_result['data'][$indeks]['sid'];
		$kategori = $json_result['data'][$indeks]['kategori'];
		$layanan = $json_result['data'][$indeks]['layanan'];
		$harga = $json_result['data'][$indeks]['harga'] + 10000;
		$min = $json_result['data'][$indeks]['min'];
		$max = $json_result['data'][$indeks]['max'];
		$catatan = $json_result['data'][$indeks]['catatan'];
		$provider = "NES-SOSMED";
        $indeks++;
		//INSERT KATEGORI
		$cek_kategori = $conn->query("SELECT * FROM kategori_layanan WHERE nama = '$kategori'");
		if(mysqli_num_rows($cek_kategori) > 0){

		}else{
			$input_kategori = $conn->query("INSERT INTO kategori_layanan VALUES ('','$kategori','$kategori','Sosial Media')");
		}

        $cek_layanan = $conn->query("SELECT * FROM layanan_sosmed WHERE provider_id = '$id_provider' AND provider = 'NES-SOSMED'");
        $data_layanan = $cek_layanan->fetch_assoc();
        if(mysqli_num_rows($cek_layanan) > 0) {
            echo "Layanan Sudah Ada Di database => $layanan | $id_provider \n <br />";
        } else {
		//INSERT LAYANAN
		$layanan2 = strtr($layanan, array(
			' IRVANKEDE' => ' Arifah',
			' IRVAN KEDE' => ' Arifah',
			' Irvankede' => ' ArifahPedia',
			' IRV' => ' DM',
			' [ ORDER VIA API 35K ]' => ' DM',
			' [ORDER VIA API RP 35K]' => ' DM',
			' [ORDER VIA API 35K]' => ' DM',
			' IKP' => ' DM IKP Server',
			' IK' => ' DM IK Server',
		));
		$sid = $no++;
		$insert_layanan = $conn->query("INSERT INTO layanan_sosmed VALUES ('','$sid' ,'$kategori' ,'$layanan2' ,'$catatan' ,'$min' ,'$max' ,'$harga', '9000', 'Aktif' ,'$id_provider' ,'NES-SOSMED' ,'Sosial Media')");
		if($insert_layanan == TRUE){
			echo "===============================
			Input Layanan Sukses  <br/>
			Kategori : $kategori <br/>
			SID : $sid <br />
			Layanan : $layanan2 <br />
			Min :$min <br />
			Max : $max  <br />
			Harga : $harga  <br />
			Note : $catatan <br />
			===================================<br/>";
		}else{
		    echo "Gagal";
		}
		// echo $no++." ";
	}