Can anyone help with this please?
I just get a response:
The following error occured:
With no error. I have replaced the sensitive parts for obvious reasons.
<?php
// error_reporting(E_ALL);
// ini_set('display_errors', 1);
$url = "http://mywhmcsurl/includes/api.php"; # URL to WHMCS API file
$username = "myadminuser"; # Admin username goes here
$password = "myadminpassword"; # Admin password goes here
$db = mysqli_connect("localhost", "dbname", "dbpass", "dbtable");
$strSQL = "select * from tbl_contract";
$query = mysqli_query($db, $strSQL);
while($row = mysqli_fetch_array($query)) {
$postfields["username"] = $username;
$postfields["password"] = md5($password);
$postfields["action"] = "createinvoice";
$postfields["userid"] = $row["bcid"];
$postfields["date"] = "20110901";
$postfields["duedate"] = "20110901";
$postfields["paymentmethod"] = "banktransfer";
$postfields["sendinvoice"] = false;
$postfields["itemdescription1"] = $row["contract_type"];
$postfields["itemamount1"] = $row["amount"];
$postfields["itemtaxed1"] = 1;
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_TIMEOUT, 100);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS, $postfields);
$data = curl_exec($ch);
curl_close($ch);
$data = explode(";",$data);
foreach ($data AS $temp) {
$temp = explode("=",$temp);
$results[$temp[0]] = $temp[1];
}
if ($results["result"]=="success") {
# Result was OK!
} else {
# An error occured
echo "The following error occured: ".$results["message"];
}
}
// CLOSE CONNECTION
mysqli_close($db);
?>