Create submit_attendance.php

Abhijeetbyte · web-flow · commit f66e41c67664 · 2024-06-22T19:03:53.000+05:30
diff --git a/submit_attendance.php b/submit_attendance.php
@@ -0,0 +1,18 @@
+<?php
+try {
+    // Connect to SQLite database
+    $db = new PDO('sqlite:students.db');
+    $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
+
+    // Insert data into Attendance table
+    $stmt = $db->prepare("INSERT INTO Attendance (roll_no, student_name, date) VALUES (:roll_no, :student_name, :date)");
+    $stmt->bindParam(':roll_no', $_POST['roll_no']);
+    $stmt->bindParam(':student_name', $_POST['student_name']);
+    $stmt->bindParam(':date', date('Y-m-d'));
+    $stmt->execute();
+
+    echo "Attendance recorded successfully.";
+} catch (PDOException $e) {
+    echo "Error: " . $e->getMessage();
+}
+?>
