Delete record from SQLite database using form button

Question

Created a form that successfully inserts a record from a form into a SQLite database. Trying to also add a delete button but i am unsure on how to execute the query properly. Here is my code:

index.php

<input id="submit" type="submit" name="input" value="Input">
<input id="submit" type="submit" name="delete" value="Delete">

post.php

if (!empty($_POST['input'])) {
  header("location:index.php");
  $stmt = $conn->prepare("INSERT INTO stock (name, gender, age) VALUES   (:name, :gender, :age)");
  $stmt->execute(array(':name' => $_POST['name'],
                                       ':gender' => $_POST['gender'],
                                       ':age' => $_POST['age']));
}

elseif (!empty($_POST['delete'])) {
  header("location:index.php");
  $stmt = $conn->prepare("DELETE FROM stock WHERE name = ':name' AND gender = ':gender' AND age = 'age'");

}

Plus, use isset() rather than !empty() and add exit; after each header. — Funk Forty Niner
– Funk Forty Niner, Commented Feb 7, 2015 at 17:42
You're welcome. When a certain button/input is "set", it will execute what's been called ;-) — Funk Forty Niner
– Funk Forty Niner, Commented Feb 7, 2015 at 17:43
Place/move your headers after each query and add exit;. Once one of them is successfully executed, it will then redirect to the specified URL and stop any further execution of the rest of the script. — Funk Forty Niner
– Funk Forty Niner, Commented Feb 7, 2015 at 17:47

Funk Forty Niner · Accepted Answer · 2015-02-07 17:59:47Z

1

Use isset() rather than !empty() When a certain button/input is "set", it will execute what's been called and add exit; after each header.

Using "exit;" will avoid further code execution.

Since you're getting a redirection loop, use echo "Success"; exit; instead, or use another file to redirect to.

You should remove the quotes around your binds also:

WHERE name = :name AND gender = :gender

answered Feb 7, 2015 at 17:59

Funk Forty Niner

74.2k14 gold badges71 silver badges146 bronze badges

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

Collectives™ on Stack Overflow

Delete record from SQLite database using form button

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related