Delete user";
$verified = "No";
if($row['is_verified']){
$verified = "Yes";
$delete_btn = "";
}
$status = "";
if(!$row['status']){
$status = "";
}
$data.="
| $i |
$row[firstname] |
$row[lastname] |
$row[email] |
$row[phone] |
$row[address] |
$row[birth] |
$verified |
$status |
$date |
$delete_btn |
";
$i++;
}
echo $data;
}
if(isset($_POST['toggleStatus'])){
$frm_data = filteration($_POST);
$q = "UPDATE `user_creds` SET `status`=? WHERE `id`=?";
$values = [$frm_data['value'], $frm_data['toggleStatus']];
if(update($q, $values, 'ii')){
echo 1;
} else{
echo 0;
}
}
if(isset($_POST['remove_user'])){
$frm_data = filteration($_POST);
$res = delete("DELETE FROM `user_creds` WHERE `id`=? AND `is_verified`=?", [1, $frm_data['user_id'], 0], 'ii');
if($res){
echo 1;
} else{
echo 0;
}
}
if(isset($_POST['search_users'])){
$frm_data = filteration($_POST);
$query = "SELECT * FROM `user_creds` WHERE `firstname` LIKE ?";
$res = select($query, ["%$frm_data[firstname]%"], 's');
$i = 1;
$data = "";
while($row = mysqli_fetch_assoc($res)){
$date = date("M-d-Y", strtotime($row['datentime']));
$delete_btn = "";
$verified = "No";
if($row['is_verified']){
$verified = "Yes";
$delete_btn = "";
}
$status = "";
if(!$row['status']){
$status = "";
}
$data.="
| $i |
$row[firstname] |
$row[lastname] |
$row[email] |
$row[phone] |
$row[address] |
$row[birth] |
$verified |
$status |
$date |
$delete_btn |
";
$i++;
}
echo $data;
}
?>