PHP MySQL Delete record only if it exist

Question

Having a bit of trouble, I have created a form to deleted a record from a linked MySQL database using PHP that works, but I am having an problem with how to make an error display if a uadnumber value for example already exists.

<form name="deleterecord" action="indexdelete.php" method="post">
  UAD Username: <br/><input type="text" name="uadnumber" /><br/>
  <input type="submit" onclick="return deletedatabase();" value="Delete" />
</form>

<?php
  // find the values from the form
  $uadnumber = $_POST['uadnumber'] ;
?>

<?php
    $con=mysqli_connect($db_hostname,$db_username,$db_password,$db_database);
    // Check connection
    if (mysqli_connect_errno())
      {
      echo "Failed to connect to MySQL: " . mysqli_connect_error();
      }
    $retval = mysqli_query($con,"DELETE FROM users WHERE uadnumber='$uadnumber'");
    if(!$retval<0)
    {
      die('Could not delete data: ' . mysql_error());
    }
    echo "Deleted all linked data from user $uadnumber successfully"."<br><br>";
    echo "<hr>";
    echo "Below is the remaining users within the database";

    mysqli_close($con);

    ?>

Unless you have globals on (which I hope you don't) you aren't retrieving the POST data. Add this line $uadnumber = $_POST['uadnumber']; above $retval. Also read this - stackoverflow.com/questions/60174/… — SamV
– SamV, Commented Mar 15, 2014 at 10:36
Sorry I forgot to add this in, I already had it in the webpage because linked back to the webpage that uses the form — magi4000
– magi4000, Commented Mar 15, 2014 at 10:37

Sates · Accepted Answer · 2014-03-15 11:25:10Z

3

if (isset($_POST["uadnumber"])) {
    $uadnumber = (int)$_POST["uadnumber"];
    $db = new mysqli($db_hostname,$db_username,$db_password,$db_database);

    if ($db->query("SELECT uadnumber FROM users WHERE uadnumber='".$uadnumber."'")->num_rows > 0) {
        if ($db->query("DELETE FROM users WHERE uadnumber='".$uadnumber."'")->affected_rows > 0) {
            echo 'Desired rows have been removed.';
        } else {
            echo 'No rows have been removed.';
        }
    } else {
        echo 'There are no rows identified by given value.';
    }
}

edited Mar 15, 2014 at 11:25

answered Mar 15, 2014 at 10:41

Sates

4081 gold badge5 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

magi4000 Over a year ago

Thank you this worked for me, after a little edit but worked and thanks again ^_^

Collectives™ on Stack Overflow

PHP MySQL Delete record only if it exist

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related