PHP get XML from URL with credentials

Question

I have a URL that prompts for a username/password to get its data. The data is in XML format. At first I tried to retrieve the data like this:

$url = "http://username:password@[ip-address]:8086/connectioncounts?flat";
$xml = simplexml_load_file($url);
print_r($xml);

After searching for an answer I've come up with this code:

$url = "http://[ip-address]:8086/connectioncounts?flat"; 
$ch = curl_init();     
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);  
curl_setopt($ch, CURLOPT_URL, $url);  
curl_setopt($ch, CURLOPT_USERPWD, "username:password");
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
$result = curl_exec($ch);  
curl_close($ch);  
echo $result;

I'm not getting any data returned on either of these attempts. Could someone tell me what I'm doing wrong?

Also use the following option: curl_setopt($ch, CURLOPT_HTTPAUTH, CURLAUTH_BASIC); — Andreas
– Andreas, Commented Jun 7, 2016 at 13:15

Gerwin · Accepted Answer · 2016-06-07 13:28:21Z

1

You need to change seperate the port from the URL by filling the CURL options in an array like so -

$ch = curl_init(); 

$options = array(CURLOPT_URL => "http://[ip-address]/connectionscounts?flat/<URI>", 
CURLOPT_PORT => "8086", 
CURLOPT_HEADER => "Content-Type:application/xml", 
CURLOPT_USERPWD => "username:password", 
CURLOPT_HTTPAUTH => CURLAUTH_BASIC, 
CURLOPT_RETURNTRANSFER => TRUE 
); 

curl_setopt_array($ch, $options); 
$data = curl_exec($ch); 

$xml = new SimpleXMLElement($data); 
print_r($xml);

answered Jun 7, 2016 at 13:28

Gerwin

1,6145 gold badges25 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ram Sharma · Accepted Answer · 2016-06-07 13:10:55Z

1

I feel URL is redirect, you can try by adding. This will follow URL to return response.

curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true);

answered Jun 7, 2016 at 13:10

Ram Sharma

8,8157 gold badges48 silver badges59 bronze badges

2 Comments

MSU_Bulldog Over a year ago

Thanks for your response, I still am not getting any results when I add this line.

Ram Sharma Over a year ago

try to test by adding curl_setopt($ch, CURLOPT_HTTPAUTH, CURLAUTH_BASIC) as well

Collectives™ on Stack Overflow

PHP get XML from URL with credentials

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related