[ DEL ] prepare('delete from heart where id=?'); if ($sql->execute([$_REQUEST['id']])) { echo '刪除成功 ! ' . '
'; } else { echo '刪除失敗 !' . '
'; } ?> prepare('Select * from heart'); if($sql->execute()) echo 'Query Success!' . '
'; else echo 'Query Failed !' . '
'; ?>

Show

 

fetchAll() as $row) { echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; } ?>
id Sex Age Diastolic Systolic Anti-Hypertensives Smoker Diabetes HDL TDL Score Risk
' . $row['id'] . '' . $row['sex'] . '' . $row['age'] . '' . $row['diastolic'] . '' . $row['systolic'] . '' . $row['antih'] . '' . $row['smoker'] . '' . $row['diabete'] . '' . $row['tdl'] . '' . $row['hdl'] . '' . $row['score'] . '' . $row['risk'] . '' . ' [ EDIT ] ' . '' . ' [ DEL ] ' . '

 

Total : rowCount(); ?> Records.