· 6 years ago · Feb 01, 2020, 04:18 PM
1<?php
2 require_once("../mainconfig.php");
3
4$key = "383fa48c3847c92b27c6e084ec5c456f14daa0142f1589d2ff90d9797ce5a2b62495f166cfd93ee4cc"; // your api key
5$postdata = "key=$key&action=services";
6
7$ch = curl_init();
8curl_setopt($ch, CURLOPT_URL, "https://lucky-pedia.com/api/social-media");
9curl_setopt($ch, CURLOPT_POST, 1);
10curl_setopt($ch, CURLOPT_POSTFIELDS, $postdata);
11curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
12curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
13$chresult = curl_exec($ch);
14//echo $chresult;
15curl_close($ch);
16$json_result = json_decode($chresult, true);
17$indeks=0;
18$i = 1;
19// get data service
20while($indeks < count($json_result['data'])){
21
22$sid = $json_result['data'][$indeks]['id'];
23$category = $json_result['data'][$indeks]['category'];
24$service = $json_result['data'][$indeks]['service'];
25$note = $json_result['data'][$indeks]['note'];
26$min_order =$json_result['data'][$indeks]['min'];
27$max_order = $json_result['data'][$indeks]['max'];
28$price = $json_result['data'][$indeks]['price'];
29$status = $json_result['data'][$indeks]['status'];
30echo $category;
31$indeks++;
32$i++;
33// end get data service
34// setting price
35$k = 9000;
36$rate = $price;
37$rate_asli = $rate + $k; //setting penambahan harga
38// setting price
39
40 //INSERT KATEGORI
41 $cek_kategori = mysqli_query($db, "SELECT * FROM service_cat WHERE code = '$category'");
42 if(mysqli_num_rows($cek_kategori) == 0){
43 $input_kategori = mysqli_query($db, "INSERT INTO service_cat (name, code) VALUES ('$category','$category')");
44 echo "<br>Kategori Sudah Ada Di Database => $category \n <br>";
45 }else{
46
47 }
48
49 $check_services = mysqli_query($db, "SELECT * FROM services WHERE sid = '$sid' AND provider='LP-SOSMED'");
50 $data_services = mysqli_fetch_assoc($check_orders);
51 if(mysqli_num_rows($check_services) > 0) {
52 echo "Layanan Sudah Ada Di Database => $service | $sid \n <br />";
53 } else {
54
55$insert=mysqli_query($db, "INSERT INTO services (sid, category, service, note, min, max, price, status, pid, provider) VALUES ('$sid','$category','$service','$note','$min_order','$max_order','$rate_asli','Active','$sid','LP-SOSMED')");//Memasukan Kepada Database (OPTIONAL)
56if($insert == TRUE){
57echo"===============<br>Layanan Berhasil Di Tambahkan<br><br>ID Provider : $sid<br>Kategori : $category<br>Nama Layanan : $service<br>Minimal Pesan : $min_order<br>Maksimal Pesan : $max_order<br>Harga/1000 : $rate_asli<br>Note : $note<br>===============<br>";
58}else{
59 echo "Gagal Menampilkan Data Layanan Sosmed";
60
61}
62}
63}
64?>