How to add delete function using in php

Community support
#1
<?php include('db_connection.php'); if(isset($_POST['search_keyword'])) { $search_keyword = $dbConnection->real_escape_string($_POST['search_keyword']); $sqlCountries="SELECT countries_id,countries_name FROM tbl_countries WHERE countries_name LIKE '%$search_keyword%'"; $resCountries=$dbConnection->query($sqlCountries); if($resCountries === false) { trigger_error('Error: ' . $dbConnection->error, E_USER_ERROR); }else{ $rows_returned = $resCountries->num_rows; } $bold_search_keyword = ''.$search_keyword.''; if($rows_returned > 0){ while($rowCountries = $resCountries->fetch_assoc()) { echo '
'.str_ireplace($search_keyword,$bold_search_keyword,$rowCountries['countries_name']).'
'; echo "Delete"; } }else{ echo '
No matching records.
'; } } ?>
#2

It’s exactly the same thing, only using delete commands.

$sql_delete = "SELECT countries_id, countries_name DELETE FROM tbl_countries WHERE countries_name LIKE '%$search_keyword'" ;

$resDelete = $dbConnection -> query($sql_delete) ;

if($resDelete == false){
     trigger_error('Error: ' . $dbConnection->error, E_USER_ERROR);
}

For more information, visit: https://www.bitdegree.org/learn/mysql-delete-row

#3