php - How to Include amount of entries Deleted -
so i'm looking have following code return amount of entries has deleted within echo.
$sql6 = "delete already_selected lastupdated < now() - interval 5 day7"; if ($conn->query($sql6) === true) { echo "records older 5 days have been deleted!"; } else { echo "<br> 0 records delete"; } } so outputs
records older 5 days have been deleted
where i'd return
5 amount of rows have been deleted
for example
it stored in database object's affected_rows property. then, this, example:
$deleted_qty = $conn->affected_rows; otherwise (procedural style):
$deleted_qty = mysqli_affected_rows($conn);
Comments
Post a Comment