PHP - Delete From Not Working

I'm working on an existing project, it's a mess but for the moment I just have to get the delete function working, but keep getting an error and I'm not sure what I'm missing.

The query string is a mess, but that's a headache for another day. The target shouldn't ge part of the query string, but that's how someone else had set it up so for now I'm stuck trying to work with it as it is currently and just have to get some basic CRUD functionality going. The other minor snag is inconsistencies with the name of the primary key between tables. It's not consistently called 'ID" so I need to get both the key and value for the where part of the DELETE statement. The query that I currently have is not working. Error 500, can't even get a simple var_dump to work.

 

Query string as it is in its present state:

Quote

somewbsite.com/endpoints/delete.php?target=TABLENAME&primaryKey=7

<?php

include('includes/config.php');
$table = $_GET['target'];

    parse_str($_SERVER['QUERY_STRING'], $data);
    array_shift($data);

    $cols = array_keys($data);
    $vals =  array_values($data);
    $idType = $cols[0];
    $id = $vals[0];

    $stmt = $pdo->prepare("DELETE FROM SOME_DATABASE.$table WHERE $idType = '$id';");
    $status = $stmt->execute();
    if($status)
    {
		echo "Success";
    }
    else
    {
        echo "Fail";
    }
?>

 

Hi
I am struggling with my last page for a project it is a delete page that retrieves data from a list, asks the user if he wants to delete that record if 'yes' delete it otherwise redirect to another page. My page looks like it should, but the function is not working. my code is:
Code: [Select]

<?php

  //check to see if user is logged on
  session_start();
  if (!(isset($_SESSION['login']) && $_SESSION['login'] != "")) {
  header ("Location:login.php");
  }
  
  include('connect.php'); //connection details to database in a connect.php page 

  //if form was submitted
  if (isset($_REQUEST['yes'])){
  
  $product_id = $_GET['product_id'];
  $productname = $_POST['pname'];
  $range = $_POST['prange'];
  $price1 = $_POST['pprice'];
  $price = (int)$price1;
  
  $query = "DELETE FROM products WHERE product_id = '$product_id'";
  $result = mysql_query($query);
 print "<br> $productname from range $range with a price of R$price has been deleted!</br>";
  } 
  }
  
  if (isset($_GET['product_id'])){   
    $product_id = $_GET['product_id'];
    $query = "SELECT * FROM products WHERE product_id = '$product_id'";
    $result = mysql_query($query);
  
  echo "<form method = \"post\" action = \"delete.php\">";
    
  while($row = mysql_fetch_array($result)){
  echo "<table>";
  echo "<tr>";
  echo "<td><input name = 'product_id' type = 'hidden' value ='{$row['product_id']}'></td>";
  echo "</tr>";
  echo "<tr>";
  echo "<td>Do you really want to delete {$row['product_name']} from range {$row['product_range']} with a price of R{$row['product_price']} from the database?</td>";
  echo "</tr>";
  echo "<tr>";
  echo "<td<input type = 'submit' name = 'yes' value = 'Yes'><input type = 'submit' name = 'no' value = 'NO'></td>";
  echo "</tr>";
  echo "</table>";
  }
  echo "</form>";
  }   
  ?>
Any help please?

<?php
$db = new PDO('mysql:host=localhost;dbname=wordpress', 'root','');
//---------prepare
$delete3 = $db->prepare("DELETE FROM wp_term_relationships WHERE object_id=:id");
$delete2 = $db->prepare("DELETE FROM wp_posts WHERE ID=:id");
$delete = $db->prepare("DELETE FROM wp_postmeta WHERE post_id=:id");
$select = $db->prepare("SELECT post_id FROM reference WHERE x_id=?");
$delete->bindValue(':id', $id, PDO::PARAM_STR);
$delete2->bindValue(':id', $id, PDO::PARAM_STR);
$delete3->bindValue(':id', $id, PDO::PARAM_STR);
//----------
echo 'conected-----';
{
$delfeed = '';}
$array = explode(',',$delfeed);
foreach($array as $deadman){
$select->execute(array($deadman));
$row = $select->Fetch(PDO::FETCH_ASSOC);
$id = $row['post_id'];
if ($id == null){}
else {
echo "$id"."\n";
$delete->execute();
$delete2->execute();
$delete3->execute();
}
$id++;
}
echo 'done!';
?>

its a simple delete script but it doesnt delete, it does print the right $id's witch means is working till there but delete goes bananas,double checked table names ,colums... tryied working with question mark place holders insted of bind parameter but nothing

I am trying to delete records across 3 tables but my code does not work.

Code: [Select]


$query = ("SELECT `propertyref` FROM `feed_property` WHERE `status` = 'Sold' ")or die(mysql_error());
   $result = mysql_query($query);
   
 if (isset($result)) {   
     while ($row = mysql_fetch_array($result)):
     $ref1 = mysql_real_escape_string($row['propertyref']);
 
   
$query1 = ("DELETE FROM `feed_property`, `feed_images`, `feed_characteristics`\n"
    . "USING `feed_property` INNER JOIN `feed_images` INNER JOIN `feed_characteristics`\n"
    . "WHERE feed_property.propertyref = '$ref1'\n"
    . " AND feed_images.propertyref = feed_property.propertyref\n"
    . " AND feed_characteristics.propertyref = feed_property.propertyref; ")or die(mysql_error());
   
   
   
   

echo $query1;
endwhile;


   
if(!mysql_query($query1)){
  echo '<h1 style="color: red;">Error</h1><p>', mysql_error(), '</p>';
}


else
{

  echo '<h1 style="color: red;">Properties have been removed from the database</h1>';
}
}


Query1 echos as:

Code: [Select]
DELETE FROM `feed_property`, `feed_images`, `feed_characteristics` USING `feed_property` INNER JOIN `feed_images` INNER JOIN `feed_characteristics` WHERE feed_property.propertyref = 'abc1' AND feed_images.propertyref = feed_property.propertyref AND feed_characteristics.propertyref = feed_property.propertyref;
DELETE FROM `feed_property`, `feed_images`, `feed_characteristics` USING `feed_property` INNER JOIN `feed_images` INNER JOIN `feed_characteristics` WHERE feed_property.propertyref = 'abc2' AND feed_images.propertyref = feed_property.propertyref AND feed_characteristics.propertyref = feed_property.propertyref;
The query completes without errors but does not delete the entries in the DB. If I run the query singly in PHP My Admin it functions correctly.

thanks for your help

connection is fine .. can  read records .. but can't delete ... any ideas..

Code: [Select]
<?php
$host="localhost"; // Host name 
$username="root"; // Mysql username 
$password="root"; // Mysql password 
$db_name="test"; // Database name 
$tbl_name="test_mysql"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);

$count=mysql_num_rows($result);

?>
<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td><form name="form1" method="post" action="">
<table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td bgcolor="#FFFFFF">&nbsp;</td>
<td colspan="4" bgcolor="#FFFFFF"><strong>Delete multiple rows in mysql</strong> </td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF">#</td>
<td align="center" bgcolor="#FFFFFF"><strong>Id</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Name</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Lastname</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Email</strong></td>
</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $rows['id']; ?>"></td>
<td bgcolor="#FFFFFF"><? echo $rows['id']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['name']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['lastname']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['email']; ?></td>
</tr>
<?php
}
?>
<tr>
<td colspan="5" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td>
</tr>
<?
// Check if delete button active, start this
if($delete){
for($i=0;$i<$count;$i++){
$del_id = $checkbox[$i];
$sql = "DELETE FROM $tbl_name WHERE id='$del_id'";

$result = mysql_query($sql);
}

// if successful redirect to delete_multiple.php
if($result){
echo "<meta http-equiv=\"refresh\" content=\"0;URL=delete_multiple.php\">";
}
}
mysql_close();
?>
</table>
</form>
</td>
</tr>
</table>

Mod edit: [code] . . . [/code] tags added.