Tag Archive for xml

Hibernate XML Mapping

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping package="eg">

<class
name="Blog"
table="BLOGS">

<id
name="id"
column="BLOG_ID">

<generator class="native"/>

</id>

<property
name="name"
column="NAME"
not-null="true"
unique="true"/>

<bag
name="items"
inverse="true"
order-by="DATE_TIME"
cascade="all">

<key column="BLOG_ID"/>
<one-to-many class="BlogItem"/>

</bag>

</class>

</hibernate-mapping>

source

read XML with PHP

//xml.xml :

<?xml version="1.0" encoding="utf-8" ?>
<Kategorien>
<Kategorie>
<ID>1</ID>
<Name>PHP</Name>
<link>http://www.tsql.de/php.php</link>
</Kategorie>
<Kategorie>
<ID>2</ID>
<Name>SQL</Name>
<link>http://www.tsql.de/transact-sql/howto.htm</link>
</Kategorie>
<Kategorie>
<ID>3</ID>
<Name>CSharp</Name>
<link>http://tsql.de/csharp.htm</link>
</Kategorie>
</Kategorien>

//xmlread.php :

$Kategorien = simplexml_load_file('php-xml-lesen.xml');

echo $Kategorien->Kategorie[0]->Name.'<br />';
echo $Kategorien->Kategorie[0]->ID.'<br />';
echo $Kategorien->Kategorie[0]->link.'<br />';

source

Flex XMLListCollection

var xmlResult:XML = XML(event.result);

trace(xmlResult.toXMLString());  //So you know how to write the xmllist expression

var xlJobs:XMLList = xmlResult.job;

trace(xlJobs.length());  //is this number what you expect?

datagrid.dataProvider = xlJobs;

source

Make jsp an xhtml

<?xml version="1.0" encoding="utf-8"?>
<% response.setContentType("application/xhtml+xml"); %>

source

saxon XQuery for searching whole direcotry

<fileList>
{
for $doc in collection('/dir/to/your/xml/files/')
return $doc/text/body/div/head
}
</fileList>

source

Twitter Cache

$cache_file = dirname(__FILE__).'/cache/twitter_cache';

/* Start with the cache */

if(file_exists($cache_file))

{

$mtime = time_diff(filemtime($cache_file), time());

if($mtime['minutes'] > 9)

{

$cache_rss = file_get_contents('http://twitter.com/statuses/user_timeline/'.$usuario_id.'.rss');

$cache_static = fopen($cache_file, 'wb');

fwrite($cache_static, serialize($cache_rss));

fclose($cache_static);

}

echo "<!-- cache de twitter generado el ".date('Y-m-d h:i:s', filemtime($cache_file))." -->";

}

else

{

$cache_rss = file_get_contents('http://twitter.com/statuses/user_timeline/'.$usuario_id.'.rss');

$cache_static = fopen($cache_file, 'wb');

fwrite($cache_static, serialize($cache_rss));

fclose($cache_static);

$rss = $cache_rss;

}

/* End of caching */

$rss = @unserialize(file_get_contents($cache_file)); // Now parse it as you'd like

source

.NET Connection String

<connectionStrings>
<clear/>
<add name="NorthwindConnectionString"
connectionString="Data Source=SERVERNAME;Initial Catalog=Northwind;Persist Security Info=True;User ID=username;Password=password"
providerName="System.Data.SqlClient"/>
</connectionStrings>

source

Escape Illegal XML Characters

string safeXmlString = System.Security.SecurityElement.Escape(string str);

source

XML HTTP request Weather

<%
Dim StrUrl, strCorpo, strTemperatura, StrSensacao, StrImagem, StrClima, StrCidade
Dim arr, arrTemperatura, ArrClima, ArrImagem, ArrSensacao, ArrCidade
Dim objXMLHTTP, strXmlHttp
StrUrl = "http://br.weather.com/weather/local/BRXX0109" 'url da cidade desejada
Set objXMLHTTP = CreateObject("Microsoft.XMLHTTP")
objXMLHTTP.open "get", StrUrl,false
objXMLHTTP.send
strXmlHttp = objXMLHTTP.responseText
set objXMLHTTP = nothing

function limpa(str)
Dim var
var = replace(trim(str),"""","")
var = replace(var,">","")
var = replace(var,"xt","")
var = replace(var,"TeT","T")
var = replace(var,"Text","")
var = replace(var,"OP","")
var = replace(var,"Sensa&ccedil;&atilde;o de&nbsp;","")
limpa=var
end function

'Array global para pegar apenas a tabela que contem as informações desejadas
arr=split(strXmlHttp,"<!-- insert reported by and last updated info -->")
strCorpo = mid(arr(1),1,6300)

source

XML select node bassed on attribute

// select node based on attribute id
xml.photos.photo.(@id=="school").name // display node or attribute .@name

source