deleting records using button

[atomicc]

My client wanna delete undesired messages from his miniblog.
A repeating zone (code below) shows these posts and include a button to delete each of them. But it doesn't works out. Where is the error?

      <?php do { ?>
        <p class="style6">Em <?php echo $data = implode("/", array_reverse(explode("-", substr($row_myRdset['data'],0,10)))); ?>  &agrave;s <?php echo substr($row_myRdset['data'],11); ?>
        <?php echo $row_myRdset['nome']; ?>
        (mailto:<?php echo $row_myRdset['email']; ?>
        ) escreveu: <?php echo $row_myRdset['coment']; ?> e ID<?php echo $row_myRdset['id']; ?>: 

        <input name="submit" type="submit" id="id" value=<?php $id = $_GET["id"]?>;
	 mysql_query("delete from guestbook where id = $id")
	 ?>" />
        </p>
        <?php } while ($row_myRdset = mysql_fetch_assoc($myRdset)); ?>
</form>:confused:

PLease help me in this question!!

[kurby]

You have some major flaws in your practices and understanding of how PHP works. PHP routines can not be run solely by a button click, they require a server side request of some kind.

You have a few options to make the server side request.
1) Have your submit button part of a form that does a POST or GET to another php page ('deletePost.php'). That page will contain your query to delete the post.
2) Have your button run javascript that makes an asynchronous HTTP requests (AJAX) to another php page ('deletePost.php')

You also have a syntax error with this code:

<?php $id = $_GET["id"]?>;
     mysql_query("delete from guestbook where id = $id")
     ?>

You closed your PHP prematurely, it should be:

<?php $id = $_GET["id"];
     mysql_query("delete from guestbook where id = $id")
     ?>

While this fixes the syntax error, it won't function like you want it(as I mentioned earlier).

As for php practices, may I suggest altering your layout as readability suffers greatly. Personally I see no reason to jump in and out of php to print HTML when you are doing it so often and with such small blocks.

[atomicc]

you're right, kurby. I'm a newbie in PHP and I don't understand how it works out.
Please, can you post the server-side delete function and its calling on client-side (the button code)?

Thank you in advance.

Sincerely yours,
Atomicc

[kurby]

The your client would become MY client. I gave you some explanation, now its up to you to find out how to make it work.

Heres a starting point:

http://www.tizag.com/phpT/postget.php

[atomicc]

After studying some tutorials, I've reached to the following approach but it still is not working out. Let's see if you know where's the problem.

File: main.php (client-side)

<form name="form1" action="deletar.php" method="POST">

It takes the variable to another page (the server-side file).

<?php echo $row_myRdset['id']; ?>

the valuable variable ID to be transmitted

 <input name="submit" type="submit" id="id" value="submit" />

the button that submits the variable


File: deletar.php (server-side)
Built-in code from Dreamweaver from Server Behavior>Delete Record.

if ((isset($_GET['id'])) && ($_GET['id'] != "")) {
  $deleteSQL = sprintf("DELETE FROM miniblog WHERE id=%s",
                       GetSQLValueString($_GET['id'], "int"));

  mysql_select_db($database_conn, $conn);
  $Result1 = mysql_query($deleteSQL, $conn) or die(mysql_error());

  $deleteGoTo = "main.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $deleteGoTo .= (strpos($deleteGoTo, '?')) ? "&" : "?";
    $deleteGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $deleteGoTo));
}

A lot of guys use this dreamweaver's code but it's not working. Why?

[Mindzai]

A lot of guys use this dreamweaver's code but it's not working. Why?

Probably because it was generated by a crappy piece of software rather than a sentient programmer. I don't know how people have the nerve to click some buttons in Dreamweaver without having a clue about what is actually going on, then charge clients for this stuff! If you don't know what you're doing, read some books and learn before taking people's money in return for some insecure spaghetti code spat out by your editor. Sorry if that sounds harsh but this practice is something of an annoyance to me.