PHP MySql delete query

Question

I have a delete script on my dashboard that WAS working before moving domains.

( not sure if that is relevant )

The code for my 'deletejob.php' is below.

<?php
error_reporting(0);

$host = 'localhost';
$port = 3306;
$database = 'database';
$username = 'username';
$password = 'password';

$UID = $_POST["ID"];


// Connect to the database    
$dsn = "mysql:host=$host;port=$port;dbname=$database";
$db = new PDO($dsn, $username, $password); // connect

$Query = "DELETE FROM joblist WHERE ID='$UID'";
// Do a query thingy whatever its called
$statement = $db->prepare($Query);
$statement->execute();
while ($result = $statement->fetchObject()) {}

?>

The script functions as if it is working and even gives me the alert
( ID has been successfully deleted. )

Does anyone have any idea as to why this script would return a false positive?

Not much use of using prepared statements if you just paste the value straight into your query... — Ivar
– Ivar, Commented Apr 25, 2016 at 9:08
where is your alert code?on which basis you shows the alert? — Dipanwita Kundu
– Dipanwita Kundu, Commented Apr 25, 2016 at 9:08
Can we see your form? Since there is no error checking in your code how should it alert you? — Hanky Panky
– Hanky Panky, Commented Apr 25, 2016 at 9:08
I`m not sure prepare->execute works with pasted variables.And why do you use fetchObject on DELETE? — Mihai
– Mihai, Commented Apr 25, 2016 at 9:09

Serjio · Accepted Answer · 2016-04-26 13:52:55Z

1

You must find the row you want to delete, using SELECT statement, like this:

$stmt= $conn->query("SELECT * FROM users WHERE id='".$_REQUEST['ids']."'");

Also You have to have the following sent when you click the delete button or it will not delete at all:

<input type="hidden" name="id" value="<?php echo $_REQUEST['ids'];?>">

After the above:

$stmt= $conn->query("DELETE FROM users Where id = '".$_REQUEST['id']."'");

answered Apr 26, 2016 at 13:52

Serjio

2192 silver badges10 bronze badges

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

Collectives™ on Stack Overflow

PHP MySql delete query

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