Domains prices sync php cron job

[sskafandri]

Hello,

I am trying to develop a PHP script to fetch data from json and update domains prices by using cron job but I didn't succeed can you please help me.

this is the json data that i want to use:

{
   "transactid":"fe6s8f486ew84re68t4jg6bc8",
   "status":"SUCCESS",
   "product":[
      {
         "name":".com registration",
         "price":"10.99",
         "currency":"USD"
      },
      {
         "name":".com renewal",
         "price":"9.99",
         "currency":"USD"
      },
      {
         "name":".com transfer",
         "price":"8.99",
         "currency":"USD"
      },
      {
         "name":".com restore",
         "price":"70.00",
         "currency":"USD"
      },
      {
         "name":".net registration",
         "price":"9.99",
         "currency":"USD"
      },
      {
         "name":".net renewal",
         "price":"9.99",
         "currency":"USD"
      },
      {
         "name":".net transfer",
         "price":"9.99",
         "currency":"USD"
      },
      {
         "name":".net restore",
         "price":"70.00",
         "currency":"USD"
      },
      {
         "name":".org registration",
         "price":"12.30",
         "currency":"USD"
      },
      {
         "name":".org renewal",
         "price":"10.30",
         "currency":"USD"
      },
      {
         "name":".org transfer",
         "price":"10.30",
         "currency":"USD"
      },
      {
         "name":".org restore",
         "price":"70.00",
         "currency":"USD"
      },
      {
         "name":".fr registration",
         "price":"6.89",
         "currency":"USD"
      },
      {
         "name":".com.fr registration",
         "price":"6.89",
         "currency":"USD"
      },
      {
         "name":".fr renewal",
         "price":"4.89",
         "currency":"USD"
      },
      {
         "name":".com.fr renewal",
         "price":"6.89",
         "currency":"USD"
      },
      {
         "name":".fr trade",
         "price":"6.89",
         "currency":"USD"
      }
   ]
}

 

and this is my php script its only get the registration prices but not the renewal and the transfer prices :

 

<?php

$servername = "";
$dbname     = "";
$username   = "";
$password   = "";

$conn = mysqli_connect($servername, $username, $password, $dbname);

if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
} else {
    
    $commandUrl = "https://api.example.com/data.json";
    $ch = curl_init();
    curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
    curl_setopt($ch, CURLOPT_URL, $commandUrl);
    $result = curl_exec($ch);
    curl_close($ch);
    
    $products_json = json_decode($result, true);
    
    mysqli_query($conn, "TRUNCATE TABLE `tbldomainpricing`");
    echo "EMPTIED tbldomainpricing \n";
    mysqli_query($conn, "DELETE FROM `tblpricing` WHERE type='domainregister'");
    echo "REMOVED domainregister \n";
    mysqli_query($conn, "DELETE FROM `tblpricing` WHERE type='domaintransfer'");
    echo "REMOVED domaintransfer \n";
    mysqli_query($conn, "DELETE FROM `tblpricing` WHERE type='domainrenew'");
    echo "REMOVED domainrenew \n";
    
    $i = 1;
    foreach ($products_json['product'] as $product) {
        $extensions = $product['name'];
      
      if (substr($extensions, 0, 1) === '.') {
        if (strpos($extensions, "registration") !== FALSE) {
            $price     = $product['price'];
            $exts      = $product['name'];
            $extension = str_replace(' registration', '', $exts);
        
            $query = "INSERT INTO `tbldomainpricing` (`id` ,`extension` ,`dnsmanagement` ,`emailforwarding` ,`idprotection` ,`eppcode` ,`autoreg` ,`order`)
        VALUES (NULL , '" . $extension . "', '', '', '', '1', '', '$i');";
            mysqli_query($conn, $query);
            
            $relid = mysqli_insert_id($conn);
            
            $query = "INSERT INTO `tblpricing` (`id` ,`type` ,`currency` ,`relid` ,`msetupfee` ,`qsetupfee` ,`ssetupfee` ,`asetupfee` ,`bsetupfee` ,`tsetupfee` ,`monthly` ,`quarterly` ,`semiannually` ,`annually` ,`biennially` ,`triennially` )
        VALUES (NULL , 'domainregister', '1', '$relid', '" . $price . "', '-1.00', '-1.00', '-1.00', '-1.00', '0.00', '-1.00', '-1.00', '-1.00', '-1.00', '-1.00', '0.00')";
            mysqli_query($conn, $query);
            
            $i++;
        }
		
		if (strpos($extensions, "transfer") !== FALSE) {
            $price     = $product['price'];
            $exts      = $product['name'];
            $extension = str_replace(' transfer', '', $exts);
        
            $relid = mysqli_insert_id($conn);
            
            $query = "INSERT INTO `tblpricing` (`id` ,`type` ,`currency` ,`relid` ,`msetupfee` ,`qsetupfee` ,`ssetupfee` ,`asetupfee` ,`bsetupfee` ,`tsetupfee` ,`monthly` ,`quarterly` ,`semiannually` ,`annually` ,`biennially` ,`triennially` )
        VALUES (NULL , 'domaintransfer', '1', '$relid', '" . $price . "', '-1.00', '-1.00', '-1.00', '-1.00', '0.00', '-1.00', '-1.00', '-1.00', '-1.00', '-1.00', '0.00')";
            mysqli_query($conn, $query);
            
            
            $i++;
        }
		
		if (strpos($extensions, "renewal") !== FALSE) {
            $price     = $product['price'];
            $exts      = $product['name'];
            $extension = str_replace(' renewal', '', $exts);
        
		 $relid = mysqli_insert_id($conn);
		 
            $query = "INSERT INTO `tblpricing` (`id` ,`type` ,`currency` ,`relid` ,`msetupfee` ,`qsetupfee` ,`ssetupfee` ,`asetupfee` ,`bsetupfee` ,`tsetupfee` ,`monthly` ,`quarterly` ,`semiannually` ,`annually` ,`biennially` ,`triennially` )
        VALUES (NULL , 'domainrenew', '1', '$relid', '" . $price . "', '-1.00', '-1.00', '-1.00', '-1.00', '0.00', '-1.00', '-1.00', '-1.00', '-1.00', '-1.00', '0.00')";
            mysqli_query($conn, $query);
            
            $i++;
        }
      }
    }
    exit;
    
}

?>