mastura

now i have succesfully stored the api data to my localhost database. but the data is duplicated once i refresh the page. Not sure what is happening. Can you please take a look on the code. // Decode response $jsonData = json_decode($response,true); //store client data in db $clients = $jsonData['clients']['client']; foreach ($clients as $client) { $firstname = $companyname = $email = ''; foreach($client as $key => $value){ switch($key){ case 'firstname': $firstname = $value; break; case 'companyname': $companyname = $value; break; case 'email': $email = $value; break; } } if($firstname && $companyname && $email){ $sql = "INSERT INTO members ( `firstname`, `companyname`, `email`) VALUES ('$firstname', '$companyname', '$email');"; $query = $connect->query($sql);} if ($connect->query($sql) === TRUE) { echo "New record created successfully"."<br>"; } else { echo "Error: " . $sql . "<br>" . $connect->error."<br>"; } }

Hi everyone.. need some guide here . is there anything wrong with my code to store getclient data into my localhost database. <?php $whmcsUrl = "https://domain.com/"; // For WHMCS 7.2 and later, we recommend using an API Authentication Credential pair. // Learn more at http://docs.whmcs.com/API_Authentication_Credentials // Prior to WHMCS 7.2, an admin username and md5 hash of the admin password may be used. $username = "xxxxxxxxxxxxxxxxxx"; $password = "yyyyyyyyyyyyyyyyy"; // Set post values $postfields = array( 'username' => $username, 'password' => $password, 'action' => 'GetClients', 'responsetype' => 'json', ); // Call the API $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $whmcsUrl . 'includes/api.php'); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_TIMEOUT, 30); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 1); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 2); curl_setopt($ch, CURLOPT_POSTFIELDS, http_build_query($postfields)); $response = curl_exec($ch); if (curl_error($ch)) { die('Unable to connect: ' . curl_errno($ch) . ' - ' . curl_error($ch)); } curl_close($ch); // Decode response $jsonData = json_decode($response,true); $clients = $jsonData['clients']['client']; foreach ($clients as $client) { foreach($client as $key => $value){ $firstname = $key => $value['firstname']; $companyname = $key => $value['companyname']; $sql = "INSERT INTO members ( `firstname`, `companyname`) VALUES ('$firstname', '$companyname')"; $query = $connect->query($sql); if ($connect->query($sql) === TRUE) { echo "New record created successfully"."<br>"; } else { echo "Error: " . $sql . "<br>" . $connect->error."<br>"; } } } Really need this to be done asap.. please help me.. thank you

heyy..thank you so much ..this works wonder.. but why there is an error/notices prompted at the top of the table? how do i assign the table variable?

Hi.. I have been working on this for 4 days now and still not able to find a right solution. i have the get client data using api to display it in other platform but it displays in array form. Since i am new to coding, I need it to display in table form . How am i able to do it ? please help me here the code applied: // API Connection Details $whmcsUrl = "https://domain.com/"; // For WHMCS 7.2 and later, we recommend using an API Authentication Credential pair. // Learn more at http://docs.whmcs.com/API_Authentication_Credentials // Prior to WHMCS 7.2, an admin username and md5 hash of the admin password may be used. $username = "xxxxxxxxxxxxxxxxxxxxxxx"; $password = "yyyyyyyyyyyyyyyyyyyyyyyyy"; // Set post values $postfields = array( 'username' => $username, 'password' => $password, 'action' => 'GetClients', 'responsetype' => 'json', ); // Call the API $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $whmcsUrl . 'includes/api.php'); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_TIMEOUT, 30); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 1); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 2); curl_setopt($ch, CURLOPT_POSTFIELDS, http_build_query($postfields)); $response = curl_exec($ch); if (curl_error($ch)) { die('Unable to connect: ' . curl_errno($ch) . ' - ' . curl_error($ch)); } curl_close($ch); // Decode response $jsonData = json_decode($response, true); // Dump array structure for inspection var_dump($jsonData);?> Here is the result: Please help me solve this..Thank you

awesome.. thanks for the reply..

Hello.. May I know which domain registrar supports .my ccTLD in WHMCS? I am getting this error: " There was a problem connecting to the domain registry. Please check port 43 is open in your servers firewall."

I have no idea why I am getting Failed to connect to 110.4.45.188 port 2087: Connection timed out (Code 7) - Check IP/Blocked Firewall Ports. I have read a community saying i have to unblock port 2087. How can I know to unblock the port in detail?

so, should I signup for enom to enable .my tld? does enom costs money?

Hello everyone.. Need some explanation here on the error:110. why do I getting this error.. I am very new to whmcs and i have idea how to figure it out.. Does this error is something to do with the enom domain registerar? Do I need to sign up and activate enom? Please help me..

Hi.. want to get some help here.. I wanted to import this cpanel account to whmcs.. first step: setup -> product/service -> add new server second step :utilities -> cpanel/WHM import -> get account list when click on get account list, an error showing up saying : "Connection ErrorFailed to connect to 192.185.95.19 port 2087: Connection timed out (Code 7) - Check IP/Blocked Firewall Ports" Why does this error showing up? And how do I import the cpanel account to whmcs?

meaning 300 customer account with domain..

its about 300 projects to import... can u share the script with me?

oh..now i undertand.. great explanation...thanksss a lottt!!!

ya.. its from WHM server.. my boss wanted to import all the client data and domains from whm to whmcs for keep track and billing. i was told that if from WHM server, only the domains detail will be imported but not client data and billing information... so, does that means we can only import domains from whm to whmcs and manually enter client data and billing information?