tidal-students

byRuturaj kumbhar

<?php include 'db.php'; session_start(); $stream = $_GET['stream'] ?? ""; $message = ""; // Fetch students $students = []; if($stream != ""){ $stmt = $conn->prepare("SELECT * FROM students WHERE stream=? ORDER BY name ASC"); if($stmt){ $stmt->bind_param("s", $stream); $stmt->execute(); $result = $stmt->get_result(); $students = $result->fetch_all(MYSQLI_ASSOC); } } // SAVE MARKS if(isset($_POST['submit'])){ $student_id = $_POST['student_id']; $stream = $_POST['stream']; // Save function function saveMark($conn, $student_id, $subject, $marks){ $stmt = $conn->prepare("SELECT id FROM marks WHERE student_id=? AND subject=?"); $stmt->bind_param("is", $student_id, $subject); $stmt->execute(); $res = $stmt->get_result(); if($res->num_rows > 0){ $stmt2 = $conn->prepare("UPDATE marks SET marks=? WHERE student_id=? AND subject=?"); $stmt2->bind_param("sis", $marks, $student_id, $subject); $stmt2->execute(); } else { $stmt2 = $conn->prepare("INSERT INTO marks (student_id, subject, marks) VALUES (?, ?, ?)"); $stmt2->bind_param("iss", $student_id, $subject, $marks); $stmt2->execute(); } } // 🔬 SCIENCE if($stream == "Science"){ saveMark($conn, $student_id, "English", $_POST['english']); saveMark($conn, $student_id, "Physics", $_POST['physics']); saveMark($conn, $student_id, "Chemistry", $_POST['chemistry']); saveMark($conn, $student_id, $_POST['language_science'], $_POST['lang_marks_science']); saveMark($conn, $student_id, $_POST['optional1'], $_POST['opt1_marks']); saveMark($conn, $student_id, $_POST['optional2'], $_POST['opt2_marks']); } // 🎨 ARTS if($stream == "Arts"){ saveMark($conn, $student_id, "English", $_POST['english']); saveMark($conn, $student_id, $_POST['language'], $_POST['language_marks']); saveMark($conn, $student_id, $_POST['sub1'], $_POST['m1']); saveMark($conn, $student_id, $_POST['sub2'], $_POST['m2']); saveMark($conn, $student_id, $_POST['sub3'], $_POST['m3']); saveMark($conn, $student_id, $_POST['sub4'], $_POST['m4']); } // 💼 COMMERCE if($stream == "Commerce"){ saveMark($conn, $student_id, "English", $_POST['english']); saveMark($conn, $student_id, $_POST['language'], $_POST['language_marks']); saveMark($conn, $student_id, "Economics", $_POST['economics']); saveMark($conn, $student_id, "Co-operation", $_POST['cooperation']); saveMark($conn, $student_id, "Book Keeping & Account", $_POST['bk']); saveMark($conn, $student_id, "Org. of Commerce", $_POST['org']); } // 🌱 EVS + PE (FIXED) $evs = $_POST['evs'] ?? null; $pe = $_POST['pe'] ?? null; if($evs !== null){ saveMark($conn, $student_id, "EVS", $evs); } if($pe !== null){ saveMark($conn, $student_id, "PE", $pe); } $message = "✅ Marks Saved Successfully!"; } ?> <!DOCTYPE html> <html> <head> <title>Add Marks</title> <style> body { font-family: Arial; background: linear-gradient(135deg, #667eea, #764ba2); margin: 0; } .container { width: 500px; margin: 40px auto; background: #fff; padding: 25px; border-radius: 10px; box-shadow: 0 10px 25px rgba(0,0,0,0.3); } h2 { text-align: center; } .tabs { text-align: center; margin-bottom: 20px; } .tabs a { padding: 8px 15px; margin: 5px; border: 1px solid #333; text-decoration: none; border-radius: 5px; color: #333; } .tabs a.active { background: #333; color: white; } input, select { width: 100%; padding: 8px; margin: 6px 0 15px; border-radius: 5px; border: 1px solid #ccc; } button { width: 100%; padding: 10px; background: green; color: white; border: none; border-radius: 5px; } .message { background: #d4edda; padding: 10px; text-align: center; margin-bottom: 10px; } </style> </head> <body> <div class="container"> <h2>Add Marks</h2> <div class="tabs"> <a href="?stream=Science" class="<?= ($stream=="Science")?'active':'' ?>">Science</a> <a href="?stream=Arts" class="<?= ($stream=="Arts")?'active':'' ?>">Arts</a> <a href="?stream=Commerce" class="<?= ($stream=="Commerce")?'active':'' ?>">Commerce</a> </div> <?php if($message): ?> <div class="message"><?= $message ?></div> <?php endif; ?> <?php if($stream && !empty($students)): ?> <form method="POST"> <input type="hidden" name="stream" value="<?= $stream ?>"> <label>Select Student</label> <select name="student_id" required> <?php foreach($students as $s): ?> <option value="<?= $s['id'] ?>"> <?= $s['name'] ?> (<?= $s['roll_no'] ?>) </option> <?php endforeach; ?> </select> <!-- SCIENCE --> <?php if($stream=="Science"): ?> <input type="number" name="english" placeholder="English" required> <input type="number" name="physics" placeholder="Physics" required> <input type="number" name="chemistry" placeholder="Chemistry" required> <select name="language_science"> <option value="Marathi">Marathi</option> <option value="IT">IT</option> </select> <input type="number" name="lang_marks_science" placeholder="Marks" required> <select name="optional1"> <option value="Biology">Biology</option> <option value="Computer Science">Computer Science</option> </select> <input type="number" name="opt1_marks" placeholder="Marks" required> <select name="optional2"> <option value="Mathematics">Mathematics</option> <option value="Geography">Geography</option> </select> <input type="number" name="opt2_marks" placeholder="Marks" required> <?php endif; ?> <!-- ARTS --> <?php if($stream=="Arts"): ?> <input type="number" name="english" placeholder="English" required> <select name="language"> <option value="Marathi">Marathi</option> <option value="Hindi">Hindi</option> </select> <input type="number" name="language_marks" required> <input type="text" name="sub1" placeholder="Subject 1" required> <input type="number" name="m1" required> <input type="text" name="sub2" required> <input type="number" name="m2" required> <input type="text" name="sub3" required> <input type="number" name="m3" required> <input type="text" name="sub4" required> <input type="number" name="m4" required> <?php endif; ?> <!-- COMMERCE --> <?php if($stream=="Commerce"): ?> <input type="number" name="english" placeholder="English" required> <select name="language"> <option value="Marathi">Marathi</option> <option value="IT">IT</option> </select> <input type="number" name="language_marks" required> <input type="number" name="economics" placeholder="Economics" required> <input type="number" name="cooperation" placeholder="Co-operation" required> <input type="number" name="bk" placeholder="Book Keeping" required> <input type="number" name="org" placeholder="Org. of Commerce" required> <?php endif; ?> <!-- EVS + PE (FIXED) --> <label>Environmental Education</label> <select name="evs" required> <option value="A">A</option> <option value="B">B</option> <option value="C">C</option> </select> <label>Physical Education</label> <select name="pe" required> <option value="A">A</option> <option value="B">B</option> <option value="C">C</option> </select> <button type="submit" name="submit">Save Marks</button> </form> <?php else: ?> <p style="text-align:center;">Select stream</p> <?php endif; ?> </div> </body> </html>as pr provide code give view result php code