-
Notifications
You must be signed in to change notification settings - Fork 0
/
add_student_info.php
55 lines (46 loc) · 1.85 KB
/
add_student_info.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
<?php
require_once ("db_conn.php");
// Check if form is submitted
if ($_SERVER["REQUEST_METHOD"] == "POST") {
// Fetch form data
$first_name = $_POST["first_name"];
$last_name = $_POST["last_name"];
$department = $_POST["department"];
$school_id = $_POST["school_id"];
// Check for duplicates
$conn = connect_db();
$sql_check_duplicate = "SELECT COUNT(*) FROM tbl_cwts WHERE first_name = ? AND last_name = ? AND department = ? AND school_id = ?";
$stmt_check_duplicate = $conn->prepare($sql_check_duplicate);
$stmt_check_duplicate->bind_param("ssss", $first_name, $last_name, $department, $school_id);
$stmt_check_duplicate->execute();
$stmt_check_duplicate->bind_result($count);
$stmt_check_duplicate->fetch();
$stmt_check_duplicate->close();
if ($count > 0) {
// If duplicate found, return error
http_response_code(400);
echo "Error: Student with the same first name, last name, department and School ID already exists";
exit(); // Terminate script
}
// If no duplicate found, proceed with insertion
$gender = $_POST["gender"];
$nstp = $_POST["nstp"];
$course = $_POST["course"];
// Insert into database
$sql_insert = "INSERT INTO tbl_cwts (school_id, first_name, last_name, gender, nstp, department, course) VALUES (?, ?, ?, ?, ?, ?, ?)";
$stmt_insert = $conn->prepare($sql_insert);
$stmt_insert->bind_param("sssssss", $school_id, $first_name, $last_name, $gender, $nstp, $department, $course);
if ($stmt_insert->execute()) {
// If insertion is successful
http_response_code(200);
echo "Success: Data added successfully";
} else {
// If insertion fails
http_response_code(500);
echo "Error: " . $conn->error;
}
$stmt_insert->close();
$conn->close();
} else {
echo "Invalid request";
}