I want to change my delete that when i delete a record on my website it will not be permanently deleted on my database I already made an additional column(
status INTEGER NOT NULL DEFAULT 0
$id = $_POST['del_id'];
$stmt=$db_con->prepare("DELETE FROM tblsales WHERE id=:id");
Simply change your query to an update query:
$stmt=$db_con->prepare("UPDATE tblsales set status=0 WHERE id=:id"); $stmt->execute(array(':id'=>$id));
BTW: I think your Default should be 1 (active)?