<?
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 ) {


$d = $date=date_create($row[date_of_pub]);
$dt = "{".date_format($d,"Y/m/d")."}";
$y = "{".date_format($d,"Y")."}";
$m = "{".date_format($d,"M")."}";
$au = "";
$auth = explode( ',', $row[authors] );
		$authorinst = explode( "|", $row[ 17 ] );
		$max = sizeof($auth);
		for ( $i = 0; $i < $max; $i++ ) {
		$last=$i+1;
		if ($last !=$max)
		{
		$au = $au."{".$auth[$i]."} and ";
		}
		else
		{
		$au = $au."{".$auth[$i]."}";
		}
		
		}
		
$ab = "{".$row["abstract"]."}";
$v = "{".$row["volumename"]."}";
$i = "{".$row["issuename"]."}";
$title = "{".$row["title"]."}";
$authors = "{".$au."}";;
$doi=$row['doino'];
 if ($doi!="")
				{
					$doi="{https://doi.org/$doi}";
				}
               else
			   {
				 $doi = "{https://doi.org/10.32628/IJSRCSEIT}";
				   
			   }
$pg= "{".$row["pageno"]."}";
$PID = $row["puniqueno"];
header("Content-Disposition: attachment; filename=$row[puniqueno].bib");
print "@article{IJSRCSEIT,
  title=$title,
  author= $authors,
  journal={International Journal of Scientific Research in Computer Science, Engineering and Information Technology},
  volume=$v,
  url={https://ijsrcseit.com/$row[puniqueno]},
  year=$y,
  publisher={Technoscience Academy}
} ";
print $content;
}
?>