OXIESEC PANEL
- Current Dir:
/
/
var
/
www
/
reader
/
knaadu
Server IP: 139.59.38.164
Upload:
Create Dir:
Name
Size
Modified
Perms
📁
..
-
11/28/2024 11:03:35 AM
rwxrwxr-x
📄
about.php
22 bytes
01/14/2024 11:11:31 AM
rw-r--r--
📁
cms
-
01/14/2024 11:47:41 AM
rwxr-xr-x
📄
contact.php
1.61 KB
07/15/2023 04:15:21 PM
rwxr-xr-x
📄
contributors.php
3.19 KB
04/29/2023 03:34:18 AM
rwxr-xr-x
📁
data
-
01/14/2024 11:47:19 AM
rwxrwxrwx
📄
editor.desk.php
6.52 KB
01/14/2024 04:22:03 PM
rwxr-xr-x
📄
editorial.php
4.01 KB
12/25/2021 01:47:00 AM
rwxr-xr-x
📁
grfx
-
01/14/2024 04:38:30 PM
rwxr-xr-x
📁
inc
-
01/27/2024 08:56:19 AM
rwxr-xr-x
📄
index.php
984 bytes
01/27/2024 09:01:14 AM
rwxr-xr-x
📄
list.articles.php
4.28 KB
12/28/2021 01:28:00 AM
rwxr-xr-x
📄
list.authors.php
2.94 KB
12/28/2021 02:36:00 AM
rwxr-xr-x
📄
list.categories.php
2.45 KB
12/27/2021 10:53:00 PM
rwxr-xr-x
📄
list.volumes.php
3.6 KB
12/27/2021 10:45:00 PM
rwxr-xr-x
📄
puzzle.corner.php
987 bytes
12/25/2021 01:47:00 AM
rwxr-xr-x
📄
show.article.php
2.81 KB
02/21/2023 05:23:28 AM
rwxr-xr-x
📄
show.author.php
3.38 KB
12/28/2021 02:32:00 AM
rwxr-xr-x
📄
show.category.php
2.45 KB
04/29/2023 03:33:19 AM
rwxr-xr-x
📄
show.issue.php
3.85 KB
12/28/2021 02:35:00 AM
rwxr-xr-x
📄
show.volume.php
2.65 KB
12/27/2021 10:55:00 PM
rwxr-xr-x
📄
zeditor.desk.php
6.52 KB
01/14/2024 02:45:19 PM
rwxr-xr-x
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>