'hide' ORDER BY id DESC";
$result7 = mysqli_query($conn, $query7) or die(mysqli_error($conn));
$info7 = mysqli_fetch_array($result7);
$id_of_current_volume=$info7['id'];
$volume_title=$info7['volume_title'];
$cover_design_img=$info7['cover_design_img'];
print 'Current Issue';
}else
*/
if((isset($_REQUEST['issue']))&&($_REQUEST['issue']=='archives')){
$volume_id = mysqli_escape_string($conn, $_REQUEST['volume_id']);
$query7 = "SELECT * FROM volume_tbl WHERE status <> 'hide' AND id='$volume_id'";
$result7 = mysqli_query($conn, $query7) or die(mysqli_error($conn));
$info7 = mysqli_fetch_array($result7);
$id_of_current_volume=$info7['id'];
$volume_title=$info7['volume_title'];
$cover_design_img=$info7['cover_design_img'];
print '
Archives Issue
';
//==============count articles
$sql_done1 = "SELECT * FROM submission_tbl WHERE status = 'published' AND volume_id ='$id_of_current_volume'";
$result1 = mysqli_query($conn, $sql_done1) or die(mysqli_error($conn));
$count_article = mysqli_num_rows($result1);
//=============================
}else{
$query7 = "SELECT * FROM volume_tbl WHERE status <> 'hide' ORDER BY id DESC";
$result7 = mysqli_query($conn, $query7) or die(mysqli_error($conn));
$info7 = mysqli_fetch_array($result7);
$id_of_current_volume=$info7['id'];
$volume_title=$info7['volume_title'];
$cover_design_img=$info7['cover_design_img'];
print '
Current Issue
';
//==============count articles
$sql_done1 = "SELECT * FROM submission_tbl WHERE status = 'published' AND volume_id ='$id_of_current_volume'";
$result1 = mysqli_query($conn, $sql_done1) or die(mysqli_error($conn));
$count_article = mysqli_num_rows($result1);
//=============================
}
print "
$volume_title
Table of Contents
";
if($cover_design_img != ""){
print "
Cover
![\"$volume_title\"](\"admin/piks/$cover_design_img\")
";
}
print "
";
$sql_done = "SELECT * FROM submission_tbl WHERE status = 'published' AND volume_id ='$id_of_current_volume' ORDER BY ABS(page_number)";
$result = mysqli_query($conn, $sql_done) or die(mysqli_error($conn));
//$num_report = mysqli_num_rows($result);
print "Articles
";
if (mysqli_num_rows($result) > 0) {
while($info = mysqli_fetch_array($result))
{
$submission_id=$info['id'];
$date_time=$info['date_time'];
$jounal_section=$info['jounal_section'];
$comments_for_the_editor=$info['comments_for_the_editor'];
$submission_file=$info['submission_file'];
$title=$info['title'];
$abstract=$info['abstract'];
$keywords_text =$info['keywords_text'];
$language_text =$info['language_text'];
$agencies =$info['agencies'];
$references_text =$info['references_text'];
$status =$info['status'];
$volume_id =$info['volume_id'];
$page_number =$info['page_number'];
if($page_number != ""){
$page_number = "Page $page_number";
}
if($status=="published"){
$vol_id = $volume_id;
include("admin/inc_volume.php");
$status_msg = "Published";
}
//get all authors....
$authors="";
$all_authors="";
$sql_done = "SELECT * FROM authors_record WHERE submission_id = '$submission_id' ORDER BY id DESC";
$result9 = mysqli_query($conn, $sql_done) or die(mysqli_error($conn));
if (mysqli_num_rows($result9) > 0) {
while($info9 = mysqli_fetch_array($result9))
{
$all_authors.=$info9['first_name'].", ";
}
$authors= rtrim($all_authors, ', ');
}
print "
$title
$authors
$page_number
Download
";
}
}else{
print "No article in this volume!";
}
?>
Archives
$volume_title
";
if($cover_design_img != ""){
print "";
}
print "";
print "
";
}
?>