OXIESEC PANEL
- Current Dir:
/
/
var
/
www
/
accjournal
/
accjournal
Server IP: 10.0.0.4
Upload:
Create Dir:
Name
Size
Modified
Perms
📁
..
-
07/15/2022 06:28:55 AM
rwxr-xr-x
📄
about.php
2.42 KB
12/25/2021 07:18:07 AM
rw-r--r--
📁
cms
-
12/18/2021 02:05:57 PM
rwxr-xr-x
📄
contact.php
1.6 KB
12/25/2021 07:17:57 AM
rw-r--r--
📄
contributors.php
3.21 KB
12/28/2021 08:54:05 AM
rw-r--r--
📁
data
-
12/28/2021 08:55:40 AM
rwxr-xr-x
📄
editor.desk.php
4.17 KB
12/25/2021 07:17:50 AM
rw-r--r--
📄
editorial.php
4.01 KB
12/25/2021 07:17:45 AM
rw-r--r--
📁
grfx
-
12/25/2021 07:13:55 AM
rwxr-xr-x
📁
inc
-
12/26/2021 07:19:43 AM
rwxr-xr-x
📄
index.php
1.19 KB
12/29/2021 04:32:04 AM
rw-r--r--
📄
list.articles.php
4.28 KB
12/28/2021 06:58:37 AM
rw-r--r--
📄
list.authors.php
2.94 KB
12/28/2021 08:06:38 AM
rw-r--r--
📄
list.categories.php
2.45 KB
12/28/2021 04:23:50 AM
rw-r--r--
📄
list.volumes.php
3.6 KB
12/28/2021 04:15:40 AM
rw-r--r--
📄
puzzle.corner.php
987 bytes
12/25/2021 07:17:37 AM
rw-r--r--
📄
show.article.php
3.32 KB
12/29/2021 07:48:06 AM
rw-r--r--
📄
show.author.php
3.38 KB
12/28/2021 08:02:39 AM
rw-r--r--
📄
show.category.php
2.89 KB
12/28/2021 04:25:03 AM
rw-r--r--
📄
show.issue.php
3.85 KB
12/28/2021 08:05:47 AM
rw-r--r--
📄
show.volume.php
2.65 KB
12/28/2021 04:25:34 AM
rw-r--r--
Editing: list.articles.php
Close
<!DOCTYPE html> <html> <head> <title>A Quarterly Publication of ACCS</title> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <script src="inc/jquery-3.6.0.min.js"></script> <script src="inc/bootstrap.min.js"></script> <script src="inc/moment.min.js"></script> <script src="inc/common.js"></script> <link rel="stylesheet" type="text/css" href="inc/bootstrap.min.css" /> <link rel="stylesheet" type="text/css" href="inc/fontawesome/css/all.min.css" /> <link rel="stylesheet" type="text/css" href="inc/style.css" /> </head> <body> <? include 'inc/config.php' ?> <? include 'inc/header.php' ?> <div class="container"> <div class="row"> <div class="col-12 col-md-2 pt-2"> <i class="fas fa-angle-right"></i> <a href="list.volumes.php" style="font-size:15px">Volumes</a><br> <div class="lineDotted"></div> <i class="fas fa-angle-right"></i> <b style="font-size:15px">Articles</b><br> <div class="lineDotted"></div> <i class="fas fa-angle-right"></i> <a href="list.authors.php" style="font-size:15px">Authors</a><br> <div class="lineDotted"></div> <i class="fas fa-angle-right"></i> <a href="list.categories.php" style="font-size:15px">Categories</a><br> </div> <div class="col-12 col-md-6"> <div class="txtMedium txtBlue mb-2 py-2">Articles</div> <div class="row mt-3"> <div class="col-12"> <ul class="list-inline"> <? for ($column='A';$column!='AA';$column++) { ?> <li class="list-inline-item"><a href="#jump-<?=$column?>"><?=$column?></a></li> <? } ?> </ul> </div> <? for ($column='A';$column!='AA';$column++) { ?> <div class="col-12"> <div class="pt40 pb20 mt-3" id="jump-<?=$column?>"> <div class="row"> <div class="col-md-1 col-xs-1 col-sm-1 col-xl-1 col-lg-1"> <div class="txtMedium p-2"><?=$column?></div> </div> <div class="col-md-11 col-xs-11 col-sm-11 col-xl-11 col-lg-11"> <ul style="padding-left:20px"> <? $sql = "SELECT A.volume_num,A.issue_num,A.article_id,A.article_title,B.category_id,B.category_name,C.issue_date FROM ((articles A INNER JOIN categories B ON A.category_id=B.category_id) INNER JOIN issues C ON A.volume_num=C.volume_num AND A.issue_num=C.issue_num) WHERE A.article_title LIKE '$column%' AND A.is_active=1 ORDER BY A.article_title"; $query = mysqli_query($dbpro,$sql); while ($row = $query->fetch_assoc()) { $articleId = $row['article_id']; $articleTitle = $row['article_title']; $articleCategoryId = $row['category_id']; $articleCategoryName = $row['category_name']; $articleVolumeNum = $row['volume_num']; $articleIssueNum = $row['issue_num']; $articleIssueNum = subStr('00' . $articleIssueNum, -2); $articleIssueDate = date("d F, Y", strtotime($row['issue_date'])); ?> <li class="mt-3"> <a href="show.article.php?id=<?=$articleId?>"><b><?=$articleTitle?></b></a><br> <a href="show.category.php?id=<?=$articleCategoryId?>"><span class="txtBlue"><?=$articleCategoryName?></span></a> | <a href="show.issue.php?volume=<?=$articleVolumeNum?>&issue=<?=$articleIssueNum?>">Volume <?=$articleVolumeNum?>, Issue <?=$articleIssueNum?></a> | <?=$articleIssueDate?><br> <? $txtAuthor = ''; $sql = "SELECT B.author_id,B.first_name,B.last_name FROM article_authors A INNER JOIN authors B ON A.author_id=B.author_id WHERE A.article_id=$articleId ORDER BY A.id"; $resultAuthor = mysqli_query($dbpro,$sql); while ($rowAuthor = $resultAuthor->fetch_assoc()) { if (trim($rowAuthor['last_name'] == '')) { $txtAuthor .= '<a href="show.author.php?id=' . $rowAuthor['author_id'] . '">' . trim($rowAuthor['first_name']) . '</a>; '; } else { $txtAuthor .= '<a href="show.author.php?id=' . $rowAuthor['author_id'] . '">' . trim($rowAuthor['first_name']) . ' ' . trim($rowAuthor['last_name']) . '</a>, '; } } if ($txtAuthor <> '') { $txtAuthor = rtrim($txtAuthor, ', '); echo $txtAuthor; } echo "<br>"; ?> </li> <? } ?> </ul> </div> </div> </div> <div class="lineDotted"></div> </div> <? } ?> </div> </div> <div class="col-12 col-md-4"> <? include 'inc/side.php' ?> </div> </div> </div> <? include 'inc/footer.php' ?> </body> </html>