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: show.author.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' ?> <? $id = isset($_GET["id"]) ? $_GET["id"] : '0'; $sql = "SELECT first_name,last_name FROM authors WHERE author_id=$id"; $result = mysqli_query($dbpro, $sql); $hasResult = mysqli_num_rows($result); if ($hasResult > 0) { $row = mysqli_fetch_assoc($result); $authorName = $row['first_name']; if ($row['last_name'] <> '') $authorName .= ' ' . $row['last_name']; } mysqli_free_result($result); ?> <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> <a href="list.articles.php" style="font-size:15px">Articles</a><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 written by <?=$authorName?></div> <div style="border-right:1px dotted #6f6f6f;"> <ul style="padding-left:20px"> <? $sql = "SELECT A.volume_num,A.issue_num,A.article_id,A.article_title,C.category_id,C.category_name,D.issue_date FROM (((articles A INNER JOIN article_authors B ON A.article_id=B.article_id) INNER JOIN categories C ON A.category_id=C.category_id) INNER JOIN issues D ON A.volume_num=D.volume_num AND A.issue_num=D.issue_num) WHERE A.is_active=1 AND B.author_id=$id ORDER BY A.volume_num DESC,A.issue_num DESC,A.article_title ASC"; $result = mysqli_query($dbpro,$sql); while ($row = $result->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> </li> <? } mysqli_free_result($result); ?> </ul> </div> </div> <div class="col-12 col-md-4"> <? include 'inc/side.php' ?> </div> </div> </div> <? include 'inc/footer.php' ?> </body> </html>