function complete_order($orderid) {
    $consumer_key = 'xxx'; // Add your own Consumer Key here
    $consumer_secret = 'xxxx'; // Add your own Consumer Secret here
    $store_url = 'xxx'; // Add the home URL to the store you want to connect to here
    $options = array(
        'debug' => true,
        'return_as_array' => false,
        'validate_url' => false,
        'timeout' => 30,
        'ssl_verify' => false,
    );
    $servername = "xxx";
    $username = "xxx";
    $password = "xxx";
    $dbname = "xxx";
    $conn = new mysqli($servername, $username, $password, $dbname);
    $sql ="SELECT * FROM xxxxxx WHERE ID = '$orderid'";
    $result = $conn->query($sql);
    while($row = $result->fetch_assoc()) {
        $poststatus= '. $row["post_status"].';
        if ($poststatus = wc-manual-renewal-re){
            $client = new WC_API_Client($store_url, $consumer_key, $consumer_secret, $options);
            $client->orders->update_status($orderid, 'wc-manual-renewal-re');
        }else{$client = new WC_API_Client($store_url, $consumer_key, $consumer_secret, $options);
            $client->orders->update_status($orderid, 'wc-completed');
        }
    }
}

if ($poststatus = wc-manual-renewal-re){
  $client = new WC_API_Client($store_url, $consumer_key, $consumer_secret, $options);

  $client->orders->update_status($orderid, 'wc-manual-renewal-re');
}

if ($poststatus === 'wc-manual-renewal-re'){
  $client = new WC_API_Client($store_url, $consumer_key, $consumer_secret, $options);

  $client->orders->update_status($orderid, 'wc-manual-renewal-re');
}