<?php if (isset($_REQUEST['fcid'])) { include "faculty_course.php"; $obj = new Faculty_course(); //$f_id=$_REQUEST['fid']; //$c_id=$_REQUEST['cid']; $obj->delete($f_id, $c_id); } ?>
<form method="GET" action="faculty_course_add.php"> Faculty ID :<input type="text" name="fid" size="30"> <p><br>Course ID :<input type="text" name="cid" size="30"> <br><input type="submit" value="Add"> </form> <?php if (isset($_REQUEST['fid'])) { include "faculty_course.php"; $obj = new Faculty_course(); $f_id = $_REQUEST['fid']; $c_id = $_REQUEST['cid']; if (!$obj->addFaculty_course($f_id, $c_id)) { echo "Error adding"; } else { echo "Added"; } } ?>
<?php if (!isset($_REQUEST["fcid"])) { echo "id is required"; exit; } include "faculty_course.php"; $obj = new Faculty_course(); $obj->viewFaculty_course(); $f_id = $row["faculty_id"]; $c_id = $row["course_id"]; ?> <form method="GET" action="faculty_course_update.php"> Faculty ID :<input type="text" name="fid" size="30" value="<?php echo $f_id; ?> " > Course ID :<input type="text" name="cid" size="30" value="<?php echo $c_id; ?> "> <input type="submit" value="Update"> </form> <?php include "faculty_course.php"; $f_id = $_REQUEST['fid']; $c_id = $_REQUEST['cid']; $obj = new Faculty_course(); $obj->updateFaculty_course($f_id, $c_id);
<?php echo "ALL FACULTIES"; include "faculty_course.php"; $obj = new Faculty_course(); $obj->viewFaculty_course(); echo "<table border='1'>"; echo "<tr style='text-align:center'><td>Faculty ID</td><td>Faculty Name</td><td>Course Name</td></tr>"; while ($row = $obj->fetch()) { echo "<tr><td>{$row['faculty_id']}</td>"; echo "<td>{$row['Faculty_Name']}</td>"; echo "<td>{$row['course_name']}</td></tr>"; } echo "</table>";