画面に入力した内容で、レコードの追加を行う
$inHospitalcd = $_POST['Hospitalcd']; $inHospitalnm = $_POST['Hospitalnm']; $inHospitaladd = $_POST['Hospitaladd']; $inHospitaltel = $_POST['Hospitaltel']; $sql = "INSERT INTO Hospitalmst (Hospitalcd, Hospitalnm, Hospitaladd, Hospitaltel) "; $sql .= "VALUES ($inHospitalcd, '$inHospitalnm', '$inHospitaladd', '$inHospitaltel')";
テーブル「StepsTB」からテーブル「NtStepsTB」にレコードを追加する
$sql = "INSERT INTO NtStepsTB "; $sql .= "( id, namae, steps, karori, exercise, distance, walktime, note, yy, yymm ) "; $sql .= "SELECT id, namae, sum(steps) as steps, round(sum(karori), 1) as karori, "; $sql .= " round(sum(exercise), 1) as exercise, round(sum(distance), 1) as distance, "; $sql .= " sum(walktime) as walktime, note, yy, yymm "; $sql .= "From StepsTB "; $sql .= "WHERE id = '" . $w_ID . "' AND yymm = '" . $w_yymm . "' GROUP BY yymm, note "; $sql .= "ORDER BY yymm";
・sum(steps)は「steps」を「yymm」と「note」で集計している。 ・round(sum(karori), 1)は、集計した「karori」を小数点二桁目を四捨五入している。