Medoo delete ID found in array

Question

I have scripts provided by another coder that use Medoo for database functions. I have a script to delete one item at a time but now I need to delete multiple rows according to a list submitted from checkboxes. For example:

$delete = "123, 124, 125, 126";

global $db;
$sql = db::query("DELETE FROM users, [id IN '$delete']");

Unfortunately the documentation and examples provided for Medoo are sparse and do not cover IN examples. So I am looking for suggestions.

While that may work with MySQL, Medoo uses different syntax. Your suggestion results in "Syntax error or access violation"... http://medoo.in/api/delete — WilliamK, Jan 19 '15 at 20:58

score 1 · Answer 1 · answered Jan 29 '15 at 09:03

1

Really simple. Just provide an array with ids.

$database->delete("users", [
    "id" => [123, 124, 125, 126]
]);

answered Jan 29 '15 at 09:03

Angolao

986
1
15
27

score 0 · Accepted Answer · answered Jan 20 '15 at 05:50

$delete = "123, 124, 125";        // original string

$delete = explode(',',$delete);   // convert to array

foreach($delete as $id) {         // walk wthrough array items

$database->delete("users", [      // run medoo query 
"AND" => [
    "id" => intval($id)          // if whitespaces, make an integer
    ]
]);
}

Deror · Answer 3 · 2015-02-09T19:16:18.103

see medoo delete method http://medoo.in/api/delete

$database->delete("account", array(
    "id" => array(123, 124, 125, 126)
));

or

$delete = "123, 124, 125";        

$ids_array= explode(',', $delete);  

foreach($ids_array as $id) {        
 $database->delete("users", array("id" => $id));
}

or

$ids_array= explode(',', '123, 124, 125'); 

function delete_by_id($value, $key){
  global $database;
  $database->delete("users", array("id" => $value));
}

array_walk($ids_array,"delete_by_id");

or ......

$ids_array= explode(',', '123, 124, 125'); 
array_walk($ids_array, function($value, $key) use (&$database){
   $database->delete("users", array("id" => $value));
});

You can check through the last query performed:

echo $database->last_query();

The best solution had already been submitted, tried and proven. Yes, there is a help page for "delete" which is useless for an array. — WilliamK, Feb 09 '15 at 20:45

Medoo delete ID found in array

3 Answers3