prepare($sql1);
$query1->execute();
$results1=$query1->fetchAll(PDO::FETCH_OBJ);
$sql2 = "SELECT COUNT(id) as ids from posts where pstatus = 0 AND status NOT IN (3,4)";
$query2 = $dbh -> prepare($sql2);
$query2->execute();
$results2=$query2->fetchAll(PDO::FETCH_OBJ);
$sql3 = "SELECT COUNT(id) as ids from posts where pstatus = 1 AND status NOT IN (3,4)";
$query3 = $dbh -> prepare($sql3);
$query3->execute();
$results3=$query3->fetchAll(PDO::FETCH_OBJ);
$sql4 = "SELECT COUNT(id) as ids from posts where status = 3";
$query4 = $dbh -> prepare($sql4);
$query4->execute();
$results4=$query4->fetchAll(PDO::FETCH_OBJ);
?>
| #id |
Title |
Status |
Action |
prepare($sql);
$query->execute();
$results=$query->fetchAll(PDO::FETCH_OBJ);
if($query->rowCount() > 0)
{
foreach($results as $result)
{
?>
| id;?> |
title;?> |
TRASH
|
Restore
Delete
|