How to delete data for each row?

[mark103]

Hi guys,

I am working on the php page and I would like to add delete button for each row that the data have been print out in the php page.

Here it is the code:

<?php
session_start();
    define('DB_HOST', 'localhost');
    define('DB_USER', 'username');
    define('DB_PASSWORD', 'password');
    define('DB_DATABASE', 'databasename');

$errmsg_arr = array();
$errflag = false;

$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
if(!$link) {
  die('Failed to connect to server: ' . mysql_error());
    }

$db = mysql_select_db(DB_DATABASE);
if(!$db) {
  die("Unable to select database");
    }

   function clean($var){

return mysql_real_escape_string(strip_tags($var));
    }

$username = clean($_GET['user']);
$password = clean($_GET['pass']);
if($username == '') {
  $errmsg_arr[] = 'username ID missing';
  $errflag = true;
    }
    if($password == '') {
  $errmsg_arr[] = 'PASSWORD ID missing';
  $errflag = true;
    }

if($errflag) {
  $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
  echo implode('<br />',$errmsg_arr);
   }
   else {
  $qry="SELECT * FROM members WHERE username='$username' AND passwd='$password'";
  $result=mysql_query($qry) or die('Error:<br />' . $qry . '<br />' . mysql_error());


if(mysql_num_rows($result) > 0) {
  $qrytable1="SELECT strings1, strings2, strings3 FROM table1 WHERE username='$username'";
  $result1=mysql_query($qrytable1) or die('Error:<br />' . $qry . '<br />' . mysql_error());

while ($row = mysql_fetch_array($result1)) {
  echo "<p id='strings1'>";
  echo $row['strings1'] . "</p>";
  echo "<p id='strings2'>";
  echo $row['strings2'] . "</p>";
  echo "<p id='strings3'>";
  echo $row['strings3'] . "</p>";
  }
 }
}
?> 

As I find it easy to add the rows in the database, but I find it difficult to delete the rows that each data have been print out with the same id.

How to add the delete button on php page for each data that have been print out from mysql database?

Any info would be much appreciate.

[cretaceous]

you can do this in your table of items:

echo "<a href='$self_pg&amp;item=$item&amp;delete=1' >";

where $self_pg is the page name url
item is the id of the row you want to remove
delete is a marker to say what you want to do

at top of page do a $_GET on those values
and something like:

 if($delete==1 && $item){
$sql = "DELETE FROM itemtable WHERE itemid='$item'";
// then do mysql query stuff...
}

that's not secure for a public site!

you may want to add a javascript confirmation check
e.g. onClick=\"return confirmDelete()\"

[Nulled]

add column named id which will increase++ when ever a row is added ..so that each row would have a unique id. that way while you loop your info through the array , you implant the $row['id'] inside the loop and create a remove button..

[mark103]

Thanks, I have fixed the problem. However, I am getting an parse error with unexpected T_VARIABLE in /home/username/public_html/mysite.com/delete.php on line 19

Here it the line 19:

$deleted = mysql_affected_rows();

Any idea?

[cretaceous]

the error can be triggered from other lines near 19
check to see your curly braces are matched and that all lines end with a semicolon ;

[Pikachu2000]

You can read about it here: clicky.