callfi_api/get_approved_users.php
2024-06-20 23:34:56 +08:00

18 lines
289 B
PHP

<?php
include('connection.php');
$conn =OpenCon();
$selectSql = "SELECT * FROM TwitterTags WHERE approved = 1";
$selectQuery = mysqli_query($conn, $selectSql);
$arr = [];
while($row = mysqli_fetch_assoc($selectQuery)){
array_push($arr, $row['tag']);
}
echo json_encode($arr);
?>