<?php
$stmt=$conn->prepare("SELECT * FROM news WHERE del=0");
$stmt->execute();
$news=$stmt->fetchAll(PDO::FETCH_ASSOC);
$stt=1;
?>
<div id="listNews">
	<div id="list">
		<table>
			<thead>
				<th>Stt</th>
				<th>Tin tức</th>
				<th>...</th>
			</thead>
			<?php foreach ($news as $news) { ?>
			<tr title="Nhấp vào để chỉnh sửa">
				<td align="center" onclick="document.location = 'editNews.php?id=<?php echo $news['id']; ?>';"><?php echo $stt;$stt++; ?></td>
				<td onclick="document.location = 'editNews.php?id=<?php echo $news['id']; ?>';"><?php echo $news['title']; ?></td>
				<td align="center"><a id="lastCheck" href="deleteAdmin.php?table=news&id=<?php echo $news['id']; ?>"><button><img align="center" src="lib/icons/delete.png"></button></a></td>
			</tr>
			<?php } ?>
		</table>
	</div>
</div>