current community

your communities

more stack exchange communities

Stack Exchange Inbox Reputation and Badges
tour help
stack overflow careers
Sign up ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free.
up vote 1 down vote favorite
1

I hope comeone could help me out with my problem.

I have mysql table where is are columns ID and XMLLink, there is only one row which is UPDATED via html/php/mysql form..

My problem is I need to get data from XMLLink to some variable and this variable echo out in simplexml_load_file('$variable') I don't know if is this even possible but I try it..

I have this code:

$xmllink_query = mysql_query("SELECT xmllink FROM {$cfg[tbl_xmllink]} WHERE id='1'") or die(mysql_error());

while ($xmllink_array = mysql_fetch_row($xmllink_query)){
    $xmllink    =$xmllink_array['0'];

}
echo $xmllink;
//simplexml load xml feed file
   $vmdily =  simplexml_load_file('$xmllink');

When I echo out only $xmllink it works fine but I'm getting error like Warning: simplexml_load_file(): I/O warning : failed to load external entity "$xmllink"

How is possible to resolve this?

Thank you for your suggestions. :)

share|improve this question
    
get rid of the quotation: simplexml_load_file($xmllink); –  axel.michel May 31 '13 at 12:05
2  
I agree with @axel.michel but I have another question.. why would you use an iteration if you are just getting the last element? –  mishu May 31 '13 at 12:06
    
Just don't loop and get the value directly from the DB. Don't use an array –  user2426701 May 31 '13 at 12:12
    
Thank you all! I don't know why I didnt try it.. Thanks again! :) –  6fix May 31 '13 at 12:38

2 Answers 2

up vote 1 down vote accepted

You can also try to replace $vmdily = simplexml_load_file('$xmllink'); with $vmdily = simplexml_load_file($xmllink);

just remove '' from ('$xmllink')

share|improve this answer
up vote 0 down vote

Use double quotes or remove them completely

$vmdily =  simplexml_load_file("$xmllink");
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.