listposts.php (1.0)

<?PHP

require('../mysql.php');

if(isset($_GET['delete'])){

$id = intval($_GET['delete']);

$query = mysql_query("DELETE FROM `comments` WHERE `postid`='$id';");

$query2 = mysql_query("DELETE FROM `posts` WHERE `id`='$id';");

if(!$query || !$query2){

echo'<div class="post"><b>Ieraksta džēšanas kļūda:</b> '.mysql_error().' <a href="listposts.php">Atpakaļ</a></div>';

}else

{

header("Location: listposts.php");

}

exit;

}

require('../head.php');

$posts = mysql_query("SELECT * FROM `posts` ORDER BY `id`;",$link);

echo'<table>';

while($post = mysql_fetch_object($posts)){

echo'

<tr>

<td>'.$post->id.'</td>

<td>'.substr($post->text,0,100).'...</td>

<td><a href="edditpost.php?id='.$post->id.'">Labot</a></td>

<td><a href="listposts.php?delete='.$post->id.'">Dzēst</a></td>

</tr>';

}

echo'</table>

<p><a href="index.php">Sākums</a></p>

';

require('../end.php');

?>