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

Popular posts from this blog

routing - AngularJS State management ->load multiple states in one page -

python - GRASS parser() error -

json - Gson().fromJson(jsonResult, Myobject.class) return values in 0's -