Date din XML in Html

Cu PHP se poate rezolva, in mai multe feluri.
Problema este ca el are serverul ce suporta PHP diferit de cel ce genereaza XML-ul. Serverul de PHP ii blocheaza orice fel de accesare a resurselor externe (fie ea prin socket, file sau file_get_contents).
Cu XSL ar trebui sa modifice fisierul XML ca sa ii adauge modul de randare, dar nu poate pentru ca XML-ul este de fapt generat (cum am mai spus). Stiu ca XSL-ul se poate pune separat, dar pentru asta iti trebuie un parser pe server, si serverul de shoutcast nu stie sa ruleze asa ceva.

Și atunci instalezi un mic server care face asta...
Nu văd altă soluție, decât dacă obți o copie locală a XML-ului prin alte mijloace. Există n limbaje de scripting pe care le poți folosi și n-au nevoie de server, chiar și dacă nu folosești Linux.

sergiu_spooky, on 25th August 2009, 20:05, said:

El vrea ca valoarea respectiva sa apara pe situl sau (gazduit pe host-ul cu PHP). Scripturile care pot face asta local si pot fi incluse in HTML (Javascript, Java, ActiveX) nu sunt lasate sa descarce un fisier aflat pe alt host, nici macar sa acceseze un iframe cu url-ul pe alt host. Cred ca lucrurile stau la fel si la Flash sau Silverlight.

S-ar putea sa existe vreun hack, de ex. daca serverul PHP suporta si perl si au uitat sa blocheze accesul si pe acesta. Ori daca poate sa puna un html pe serverul shoucast ce contine un javascript care sa extraga valoarea, iar acesta sa fie inclus ca iframe pe situl sau.

Edited by senoctar, 25 August 2009 - 20:04.

A spus initiatorul topicului ca nu poate accesa fisierul prin file_get_contents/file ?

Daca intr-adevar asta e situatia, cred ca ar fi mai bine sa-si caute alt host ...

Salutare va multumesc pentru raspunsuri si va rog sa ma ajutati in continuarea.
Deci ca sa nu mai fie neintelegeri va explic mai bine:
Am un server de radio, adresa lui este terezian.hostradio.info:8000/listen.pls
Daca vreau sa vad cine asculta, sau ce melodie este acum la radio trebuie sa intru pe http://terezian.hostradio.info:8000 (vedeti ca nu merge cu opera)
Daca intru la Admin Login si ma loghez, acolo pe pagina am un xml la adresa http://terezian.host...gi?mode=viewxml

Un xml care este de forma:

Quote

Eu din xml-ul acesta vreau sa iau doar informatiile care sunt la
<CURRENTLISTENERS>0</CURRENTLISTENERS>  deci aici doar 0
<SONGTITLE>Geo Giovanni - Osenii si morosenii...By DJ Ovi & www.####.net</SONGTITLE> aici numele la melodie

Aceste informatii sa imi apara intrun html sau un php.

Intre timp am facut rost de un host platit de la hostgator.Deci spuneti-mi ce scripturi sa pun pe server sa testez conexiunea.

Va multumesc!

P.S.scuza-ti numele de manele dar am cumparat serverul de la cineva si nu am schimbat melodiile

Am incercat urmatorul script:

<?php

// Fill in your own server information here:
$customer_server = "213.48.102.229";
$customer_port = "9052";
$variable = "stream_status";

// variable can be one of the following

// version
// server_status
// stream_status
// listener_peak
// average_listen_time
// stream_title
// content_type
// stream_genre
// stream_url
// stream_aim
// stream_irc
// current_song
// server_bitrate
// server_current_listeners
// server_listen_link

// do not change anything below here.

$host = "statistics.streamsolutions.co.uk";
$port = "80";
$stats_get_line="GET http://$host/shoutcast/text/index.php?";
$stats_get_line.="server=$customer_server&port=$customer_port&variable=$variable HTTP/1.0\r\n";
$stats_get_line.="User-Agent: StreamSolutions  (Mozilla Compatible)\r\n\r\n";
$fp = fsockopen("$host", $port, &$errno, &$errstr, 30); //open connection
fputs($fp,$stats_get_line);
while(!feof($fp)) {
$page .= fgets($fp, 1000);
}
fclose($fp);
$lines=split("\n",$page);
print $lines[8];
?>


despre care se vorbeste aici http://forums.stream...read.php?t=2607

L-am pus pe serverul de la hostgator si pur si simplu nu imi arata nimic, doar pagina alba.



am testat si http://webscripts.so...load-12506.html
si mi-a aparut urmatoare eroare:

Warning: fsockopen() [function.fsockopen]: unable to connect to 86.106.120.76:8000 (Connection refused) in /home/server/public_html/rony/radio/shoutcast.class.php on line 38
Connection refused (111)

Am testat si scriptul pus de cineva in topic:

<?php header ("Content-Type: text/xml"); ?>
<?php
// get a web page into a string
$fcontents = join ('', file ('http://p.moreover.co...oper news&o=xml'));
echo $fcontents;
?>


In opera mi-a aparut ceva de genul:
http://click.pulse36...p=developernews Mom Makes $77/Hr (Online) Ad - www.WallStreetGazetteNews.com text moreover... http://click.pulse36...p=developernews Aug 26 2009 3:30PM http://c.moreover.co....pl?x2167418072 Back to school quiz for techies ITworld.com text moreover... http://www.itworld.com Aug 26 2009 3:30PM http://c.moreover.co....pl?x2167357898 Novell's claim on Linux in jeopardy Boston Globe text moreover... http://www.boston.com Aug 26 2009 3:01PM http://c.moreover.co....pl?x2167355627 SUSE APPLIANCE PROGRAMME EMBRACED BY ISVS AND DEVELOPERS Computer Reseller News South Africa text moreover... http://www.crn.co.za Aug 26 2009 2:59PM http://c.moreover.co....pl?x2167351774 Sources: Nokia Moving to Maemo Linux OS PC Magazine text moreover... http://w

Iar in IE ceva de genul:

<?xml version="1.0" encoding="iso-8859-1" ?>
  <!DOCTYPE moreovernews (View Source for full doctype...)>
- <!--
by using this feed you have read and agree to our terms and conditions at
   http://w.moreover.co...utus/terms.html
   If the presence of this comment has caused an error in your parser you may use the older
   uncommented version by using &amp;o=xml_1 or +xml_1 in the URL. Using the xml_1 version
   still means that you have read and agree to our terms and conditions above

  -->
- <moreovernews>
- <article id="_0">
  <url>http://click.pulse36...etwork:(general)&clickfactor_impression=1&clickid=88033284&tz=618&UNQ=00000125130732574029243000000106051056&value=H52JQJU33EIKM&cgroup=developernews</url>
  <headline_text>Does your insurance cover the LAP-BAND?</headline_text>
  <source>Ad - www.trueresults.com</source>
  <media_type>text</media_type>
  <cluster>moreover...</cluster>
  <tagline />
  <document_url>http://click.pulse36...etwork:(general)&clickfactor_impression=1&clickid=88033284&tz=618&UNQ=00000125130732574029243000000106051056&value=H52JQJU33EIKM&cgroup=developernews</document_url>
  <harvest_time>Aug 26 2009 3:01PM</harvest_time>
  <access_registration />
  <access_status />
  </article>
- <article id="_2167357898">
  <url>http://c.moreover.co...167357898</url>
  <headline_text>Novell's claim on Linux in jeopardy</headline_text>
  <source>Boston Globe</source>
  <media_type>text</media_type>
  <cluster>moreover...</cluster>
  <tagline />
  <document_url>http://www.boston.co...</document_url>
  <harvest_time>Aug 26 2009 3:01PM</harvest_time>
  <access_registration />
  <access_status />
  </article>
- <article id="_2167355627">
  <url>http://c.moreover.co...167355627</url>
  <headline_text>SUSE APPLIANCE PROGRAMME EMBRACED BY ISVS AND DEVELOPERS</headline_text>
  <source>Computer Reseller News South Africa</source>
  <media_type>text</media_type>
  <cluster>moreover...</cluster>
  <tagline />
  <document_url>http://www.crn.co.za...</document_url>
  <harvest_time>Aug 26 2009 2:59PM</harvest_time>
  <access_registration />
  <access_status />
  </article>
- <article id="_2167351774">
  <url>http://c.moreover.co...167351774</url>
  <headline_text>Sources: Nokia Moving to Maemo Linux OS</headline_text>
  <source>PC Magazine</source>
  <media_type>text</media_type>
  <cluster>moreover...</cluster>
  <tagline />
  <document_url>http://www.pcmag.com...</document_url>
  <harvest_time>Aug 26 2009 2:57PM</harvest_time>
  <access_registration />
  <access_status />
  </article>
- <article id="_2167345612">
  <url>http://c.moreover.co...167345612</url>
  <headline_text>Nokia sides with Linux to take on iPhone</headline_text>
  <source>The Independent</source>
  <media_type>text</media_type>
  <cluster>moreover...</cluster>
  <tagline />
  <document_url>http://rss.feedsport...</document_url>
  <harvest_time>Aug 26 2009 2:54PM</harvest_time>
  <access_registration />
  <access_status />
  </article>
- <article id="_2167291179">
  <url>http://c.moreover.co...167291179</url>
  <headline_text>Nokia bets on Linux in iPhone battle - sources</headline_text>
  <source>Reuters India</source>
  <media_type>text</media_type>
  <cluster>moreover...</cluster>
  <tagline />
  <document_url>http://in.reuters.co...</document_url>
  <harvest_time>Aug 26 2009 2:27PM</harvest_time>
  <access_registration />
  <access_status />


Asta presupun ca inseamna ca serverul poate accesa un xml.

Edited by rony2006sb, 26 August 2009 - 18:49.

Incearca din nou scriptul acesta : http://webscripts.so...-php-12506.html
Deschide fisierul demo.php si editeaza liniile acestea (cu datele serverului tau):

$shoutcast->host = "localhost";
$shoutcast->port = 8000;
$shoutcast->passwd = "YOURPASSWORDGOESHERE";

Apoi pune ambele fisiere php pe server si acceseaza demo.php dintr-un browser.

LE:
Acum am vazut ca ai incercat.

LELE:)
incearca asa (ar trebui sa obtii xml-ul care iti trebuie):

<?php header ("Content-Type: text/xml"); ?>
<?php
// get a web page into a string
$fcontents = join ('', file ('http://USER@PAROLA:terezian.hostradio.info:8000/admin.cgi?mode=viewxml'));
echo $fcontents;
?>

Edited by senoctar, 26 August 2009 - 19:38.

Am incercat cu Opera si mi-a dat urmatoarea eroarea:

[ http://i29.tinypic.com/33dffv5.jpg - Pentru incarcare in pagina (embed) Click aici ]

IE imi spune:

The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.


--------------------------------------------------------------------------------

Only one top level element is allowed in an XML document. Error processing resource 'http://detectinvisib...rony/radio/t...

<b>Warning</b>:  file(http://...@parola mea:terezian.hostradio.info:8000/admin.cgi?mode=viewxml) [<a href='func...

incearca si varianta cu SimpleXML...

Altcineva, alte ideii?

rony2006sb, on 26th August 2009, 22:50, said:

<?php>
	$continut_fisier = join ('', file ('http://USER:[email protected]:8000/admin.cgi?mode=viewxml'));
	$xml = new SimpleXMLElement($continut_fisier);
	
	echo '<p>Ascultatori : ' . $xml->CURRENTLISTENERS . '</p>';
	echo '<p>Live acum : ' . $xml->SONGTITLE . '</p>';
?>

senoctar, on 26th August 2009, 23:12, said:

Opera si IE imi spun:

Warning: file(http://[email protected]?mode=viewxml) [function.file]: failed to open stream: Connection refused in /home/dforumro/public_html/rony/test/test.php on line 2

Warning: join() [function.join]: Invalid arguments passed in /home/dforumro/public_html/rony/test/test.php on line 2

Fatal error: Uncaught exception 'Exception' with message 'String could not be parsed as XML' in /home/dforumro/public_html/rony/test/test.php:3 Stack trace: #0 /home/dforumro/public_html/rony/test/test.php(3): SimpleXMLElement->__construct('') #1 {main} thrown in /home/dforumro/public_html/rony/test/test.php on line 3

rony2006sb, on 27th August 2009, 00:51, said:

Inlocuieste linia

$continut_fisier = join ('', file ('http://USER:[email protected]:8000/admin.cgi?mode=viewxml'));

cu

$continut_fisier = file_get_contents('http://terezian.hostradio.info:8000/admin.cgi?pass=PAROLA&mode=viewxml');

Eu am incercat pe un server shoutcast, si nu stiu din ce motiv imi da connection timeout. Pe alte URL-uri imi merge. Daca iti da si tie la fel s-ar putea ca serverele shoutcast sa nu accepte unele request-uri.

poate nu am dreptat, dar profa de tehnici web de la facultate ne-a spus sa facem legatura xml-html asa:

avind acest xml putin modificat

<?xml version="1.0"?> 

<SHOUTCASTSERVER>
<CURRENTLISTENERS>0</CURRENTLISTENERS> 
<PEAKLISTENERS>0</PEAKLISTENERS> 
<MAXLISTENERS>100</MAXLISTENERS> 
<REPORTEDLISTENERS>0</REPORTEDLISTENERS> 
<AVERAGETIME>123</AVERAGETIME> 
<SERVERGENRE>Muzica Ta Preferata</SERVERGENRE> 
<SERVERURL>http://www.test.ro</SERVERURL> 
<SERVERTITLE>Radio Terezian</SERVERTITLE> 
<SONGTITLE>test</SONGTITLE> 
<SONGURL>http://www.test.com</SONGURL> 
<IRC>N/A</IRC> 
<ICQ>N/A</ICQ> 
<AIM>N/A</AIM> 
<WEBHITS>2</WEBHITS> 
<STREAMHITS>0</STREAMHITS> 
<STREAMSTATUS>1</STREAMSTATUS> 
<BITRATE>32</BITRATE> 
<CONTENT>audio/mpeg</CONTENT> 
<VERSION>1.9.8</VERSION>
</SHOUTCASTSERVER>

in fisierul html, facem un tabel:
<body>
<xml id="NuConteazaC" src="fisier.xml"></xml>
......
<table datasrc="#NuConteazaCe">
   <thead>
    <th>Ascultatori la moment</th>
   </thead>
   <tr>
     <td><span datafld="CURRENTLISTENERS"></span></td>
   </tr>
   </table>
.....


Poate nu am dreptate, ca nu prea pricep xml, abia acum il trecel la ore