<?
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";
				   
			   }
	 
header("Content-Disposition: attachment; filename=$row[puniqueno].ris");
print "TY  - JOUR
TI  - $row[title]
$authors
JO  - International Journal of Scientific Research in Computer Science, Engineering and Information Technology
PB  - Technoscience Academy
DA  - $dt
PY  - $y
DO  - $doi
UR  - https://ijsrcseit.com/$row[puniqueno]
VL  - $row[volumename]
IS  - $row[issuename]
SP  - $Start_Page	
EP  - $End_Page
AB  - $row[abstract]";
print $content;
}
?>