OXIESEC PANEL
- Current Dir:
/
/
var
/
www
/
opalv1
/
api
Server IP: 10.0.0.4
Upload:
Create Dir:
Name
Size
Modified
Perms
📁
..
-
02/25/2024 03:43:29 AM
rwxr-xr-x
📄
add.edit.paper.php
7.04 KB
02/18/2024 05:41:10 AM
rw-rw-r--
📄
article.php
1.13 KB
02/18/2024 05:42:18 AM
rw-rw-r--
📄
featured.articles.php
517 bytes
02/18/2024 05:04:20 AM
rw-rw-r--
📄
login.php
1.19 KB
02/17/2024 03:38:38 PM
rw-rw-r--
📄
register.php
1.73 KB
02/17/2024 03:38:38 PM
rw-rw-r--
📄
search.php
3.13 KB
02/18/2024 05:01:46 AM
rw-rw-r--
📄
user.articles.php
1.03 KB
02/18/2024 05:49:34 AM
rw-rw-r--
📄
verify.php
869 bytes
02/18/2024 06:01:26 AM
rw-rw-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 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);