<?
header("Content-type: text/plain");
$puid = $_GET[ "param" ];
include( 'acessconns.php' );

$query = "SELECT i.issuename, v.volumename, i.datemonthissue, v.pyear, p.pid, p.puniqueno, p.title, p.abstract, p.keywords, p.reference, p.receiveddate, p.accepteddate, p.pageno, p.authors, p.accepted, p.seq, p.date_of_pub, p.detail, i.issueid, v.volumeid, p.doino, p.abstract FROM paper p, publishissue i, publishvolume v WHERE p.issueid = i.issueid and i.volumeid = v.volumeid and p.puniqueno = '$puid'";
$result1 = $conn->query( $query );
while ( ( $row = mysqli_fetch_assoc( $result1 ) ) != NULL ) {

$pageno = explode("-",$row[pageno]);
$Start_Page	= $pageno[0];
$End_Page = $pageno[1];
$d = $date=date_create($row[date_of_pub]);
$dt = date_format($d,"Y/m/d");
$y = date_format($d,"Y");
$au = "";
$auth = explode( ',', $row[authors] );
		$authorinst = explode( "|", $row[ 17 ] );
		$max = sizeof($auth);
		for ( $i = 0; $i < $max; $i++ ) {
		$last=$i+1;
		$au = $au."AU  - ".$auth[$i]."\n";
		}
$authors = chop ($au);
$doi=$row['doino'];
 if ($doi!="")
				{
					$doi="https://doi.org/$doi";
				}
               else
			   {
				 $doi = "https://doi.org/10.32628/IJSRCSEIT";
				   
			   }
$abstract = html_entity_decode(str_replace(',', '', $row["abstract"])); 
header("Content-Disposition: attachment; filename=$row[puniqueno].csv");
print "title,doi,url,abstract,journal,publication_year,pmid,arxiv
$row[title], $doi, https://ijsrcseit.com/$row[puniqueno], $abstract, International Journal of Scientific Research in Computer Science Engineering and Information Technology, $y, $row[puniqueno]";
print $content;
}
?>