url;
$email = $row->email;
$xml = file_get_contents($url);
$newxml = str_replace('arxiv:','arxiv_',$xml);
//$xml = simplexml_load_file($url); //retrieve URL and parse XML content
//echo $xml->getName(); // output name of root element
$xmlparse = simplexml_load_string($newxml);
//$xmlparse = simplexml_load_string(html_entity_decode($xml), 'SimpleXMLElement', LIBXML_NOCDATA);
// $xml = file_get_contents('http://export.arxiv.org/api/query?search_query=au:Finazzi_F');
//$articoli = array('http://export.arxiv.org/api/query?search_query=au:Finazzi_F');
//foreach( $articoli as $articolo ) {
//$xml = simplexml_load_file($articoli);
foreach($xmlparse->entry as $item)
{
$date_format = "j-n-Y"; // 7-7-2008
// foreach($item->xpath('link') as $link)
// {
// echo $link->xpath('title');
// }
echo '';
echo $item->published;
echo '
'.$item->title.'
';
echo '
' . $item->summary . '
';
$autori = '';
foreach($item->author as $autore){
$autori = $autori.$autore->name. ', ';
}
echo $autori .'
';
$categorie = '';
foreach($item->category as $categoria){
$categorie = $categorie.$categoria['term']. ', ';
}
echo $categorie .'
';
//echo '' . $item->xpath('link')->title . '
';
//echo '' . $item->content . '
';
echo '';
$prova = mysqli_query($dbhandle,"SELECT * FROM wp_iscritti");
$item->published = '2018-07-04';
//echo $prova;
$query = "INSERT INTO wp_rawdata ( email, doi, published, title, summary, authors, ajournal, categories)
VALUES (
'$item->id',
'$email',
'$item->published',
'$item->title',
'$item->summary',
'$autori',
'$item->arxiv_journal_ref',
'$categorie'
)";
echo $query;
mysqli_query($dbhandle,$query);
// mysqli_query($dbhandle,"INSERT INTO wp_rawdata (idx, doi, email, published, title, summary, authors, ajournal, categories)
// VALUES (
// '',
// '".mysqli_real_escape_string($dbhandle,$item->id)."',
// '".mysqli_real_escape_string($dbhandle,$email)."',
// '".mysqli_real_escape_string($dbhandle,$item->published)."',
// '".mysqli_real_escape_string($dbhandle,$item->title)."',
// '".mysqli_real_escape_string($dbhandle,$item->summary)."',
// '".mysqli_real_escape_string($dbhandle,$autori)."',
// '".mysqli_real_escape_string($dbhandle,$item->arxiv_journal_ref)."',
// '".mysqli_real_escape_string($dbhandle,$categorie)."',
// ");
}
}
// }
?>