OXIESEC PANEL
- Current Dir:
/
/
var
/
www
/
html
/
process
Server IP: 10.0.0.4
Upload:
Create Dir:
Name
Size
Modified
Perms
📁
..
-
03/15/2024 04:24:02 PM
rwxr-xr-x
📄
add.edit.paper.php
7.04 KB
03/15/2024 04:24:02 PM
rw-r--r--
📄
article.php
1.14 KB
03/15/2024 04:24:02 PM
rw-r--r--
📄
featured.articles.php
535 bytes
03/15/2024 04:24:02 PM
rw-r--r--
📄
login.php
1.19 KB
03/15/2024 04:24:02 PM
rw-r--r--
📄
register.php
2.59 KB
03/15/2024 04:24:02 PM
rw-r--r--
📄
search.php
3.18 KB
03/15/2024 04:24:02 PM
rw-r--r--
📄
user.articles.php
1.03 KB
03/15/2024 04:24:02 PM
rw-r--r--
📄
verify.php
856 bytes
03/15/2024 04:24:02 PM
rw-r--r--
Editing: featured.articles.php
Close
<? // Opal API: Get Featured Articles require_once '../inc/config.php'; $sql = "SELECT articleId AS id,articleTitle AS title,articleSummary AS summary,fileImg FROM articles WHERE isPublished=1 AND isFeatured=1"; $result = mysqli_query($db, $sql); $numRows = mysqli_num_rows($result); if ($numRows > 0) { $data = mysqli_fetch_all($result, MYSQLI_ASSOC); $dataJSON = ['status' => 200, 'data' => $data]; } else { $dataJSON = ['status' => 500, 'response' => 'No Featured Articles found!']; } echo json_encode($dataJSON);