Question

How to delete all the records (rows) with one condition from a table with PDO in PHP

Answer 1

try 
{
    $con = new PDO("mysql:host=".$db_host.";dbname=...");
    
    $count = $con->exec("DELETE FROM table_name WHERE user_name = 'dan'");

    echo "Delete $count rows <br />";
}
catch (PDOException $e) 
{
    echo $e->getFile() . " : " . $e->getLine() . " : " . $e->getMessage();
}

/*
run: 

Delete 1 rows 

*/

 

70+ SQL courses for beginners and professionals