Search the Community
Showing results for tags 'php phpmyadmin table row'.
Found 1 result
-
Hello! I'm making a blog and I'm almost done with it. I'm at the point, where i have a page and I've created a while-loop, that shows every post on the page. I even asigned the delete-button, but for some reason it doesn't work. Could you take a look at my code and help me out? Thanks in advance. <?php session_start(); if(!isset($_SESSION['user_id'])){ header('location: index.php'); exit(); } if (isset($_POST['post_id'])) { $post_id = $_POST['post_id']; if (isset($_POST['delete_id'])) { mysql_query("DELETE FROM posts WHERE post_id = " . $post_id); } } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"/> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <style> #delete-post { width: 100%; margin: auto; background-color: #999; } </style> <script src="http://code.jquery.com/jquery-1.5.min.js"></script> </head> <body> <div> <table border cellpadding="3"> <?php mysql_connect("localhost", "root", "hejmeddig") or die(mysql_error()); mysql_select_db("pentakill_dk_db") or die(mysql_error()); $data = mysql_query("SELECT * FROM posts") or die(mysql_error()); while($info = mysql_fetch_array($data)){ ?> <tr> <th> <form method="post" action=""> <input type="hidden" name="post_id" value="<?php echo $info['post_id']; ?>" /> <input type="submit" name="delete_id" value="Delete" /> </form> </th> <th> Post-Title: </th> <td> <?php echo $info['title']; ?> </td> <th> Body: </th> <td> <?php echo $info['body']; ?> </td> </tr> <?php } ?> </table> </div> </body> </html>
