online feedback management system, Study Guides, Projects, Research of Computer science

Download online feedback management system and more Study Guides, Projects, Research Computer science in PDF only on Docsity! 1. INTRODUTION 1.1 Project overview Our document provides the design report for the web-based Student Review System. This helps in providing the insight to the whole design and implementation of the project. It deals with the following components: 1. Managing Staffs and Faculty. 2. Capturing the Faculty and Student details 3. Managing Review System 4. View Review System This document mainly consists of State Machine/ Activity Flow Diagrams, Class Design, Internal Data Structures, Architectural design, User Interface and Testing. The main purposes of this design document are listed below. 1. Precise understanding of the requirements and constraints related with the Programming language, and User Interface. 2. Abstraction of the system implementation with the help of classes. 3. Provide a basic outline of the User Interface of the Student Review System. This report is the result of the design phase. The class diagrams and activity provide a schematic representation of the various classes used and design flow respectively. Activity diagram provides a model to visualize the flow in the system as a whole. The class diagrams also hold the data structures that would be used and also their data types. They will be implemented using PHP as the programming language with HTML as front end design language and JavaScript as Scripting Language. MYSQL database will be used to store information’s related to Student Review System. 1.1.1 PURPOSE The purpose of developing student review system is to provide fast and quick feedback about the staffs in an organization by the student on time at anywhere from anyplace by just login from their valid account. 1.1.2 SCOPE The scope of Student Review System is as follows: 1. The faculty feedback portal provides an easier and quicker way to give rating to the organization staffs. 2. Student can review their faculty members according to their teaching style, knowledge, discipline and punctuality at any time from any place. 3. Though this site data of faculty members and student were managed in quite a simple manner. Five important characteristics make PHP's practical nature possible −  Simplicity  Efficiency  Security  Flexibility  Familiarity Web Development PHP is widely used in web development nowadays. PHP can develop dynamic websites easily. But you must have the basic the knowledge of following technologies for web development as well. o HTML o CSS o JavaScript o Ajax o XML and JSON o jQuery Prerequisite Before learning PHP, you must have the basic knowledge of HTML. Audience Our PHP tutorial is designed to help beginners and professionals. Problem We assure that you will not find any problem in this PHP tutorial. But if there is any mistake or error, please post the error in the contact form. PHP Function PHP functions are similar to other programming languages. A function is a piece of code which takes one more input in the form of parameter and does some processing and returns a value. You already have seen many functions like fopen() and fread() etc. They are built-in functions but PHP gives you option to create your own functions as well. There are two parts which should be clear to you −  Creating a PHP Function  Calling a PHP Function In fact you hardly need to create your own PHP function because there are already more than 1000 of built-in library functions created for different area and you just need to call them according to your requirement. PHP Functions with Parameters PHP gives you option to pass your parameters inside a function. You can pass as many as parameters your like. These parameters work like variables inside your function. Following example takes two integer parameters and add them together and then print them. HTML HTML stands for Hyper Text Markup Language. It is used to design web pages using markup language. HTML is the combination of Hypertext and Markup language. Hypertext defines the link between the web pages. Markup language is used to define the text document within tag which defines the structure of web pages. HTML is a markup language which is used by the browser to manipulate text, images and other content to display it in required format. HTML page structure: The Basic structure of HTML page is given below. It contain some elements like head, title, body, … etc. These elements are used to build the blocks of web pages. <html>: This is called HTML root element and used to wrap all the code. <head>: Head tag contains metadata, title, page CSS etc. All the HTML elements that can be used inside the <head> element are:  <style>  <title>  <base>  <no script>  <script>  <meta>  <title> <body>: Body tag is used to enclosed all the data which a web page has from texts to links. All of the content that you see rendered in the browser is contained within this element. Features of HTML:  It is platform independent.  Images, video and audio can be added to a web page.  Hypertext can be added to text.  It is a markup language. Why learn HTML?  It is a simple markup language. Its implementation is easy.  It is used to create a website.  Helps in developing fundamentals about web programming. Applications of CSS As mentioned before, CSS is one of the most widely used style language over the web. I'm going to list few of them here:  CSS saves time - You can write CSS once and then reuse same sheet in multiple HTML pages. You can define a style for each HTML element and apply it to as many Web pages as you want.  Pages load faster - If you are using CSS, you do not need to write HTML tag attributes every time. Just write one CSS rule of a tag and apply it to all the occurrences of that tag. So less code means faster download times.  Easy maintenance - To make a global change, simply change the style, and all elements in all the web pages will be updated automatically.  Superior styles to HTML - CSS has a much wider array of attributes than HTML, so you can give a far better look to your HTML page in comparison to HTML attributes.  Multiple Device Compatibility - Style sheets allow content to be optimized for more than one type of device. By using the same HTML document, different versions of a website can be presented for handheld devices such as PDAs and cell phones or for printing.  Global web standards - Now HTML attributes are being deprecated and it is being recommended to use CSS. So its a good idea to start using CSS in all the HTML pages to make them compatible to future browsers. JAVASCRIPT: JavaScript is an object-based scripting language which is lightweight and cross-platform. JavaScript is not a compiled language, but it is a translated language. The JavaScript Translator (embedded in the browser) is responsible for translating the JavaScript code for the web browser. What can in-browser JavaScript do? JavaScript's functionality depends on the environment it's running in. For example, Node.js supports functions which allows JavaScript to read and write arbitrary files, perform network requests, object-oriented, etc. The roles that JavaScript plays in both client-side (front end) and server-side (back end) development of applications can vary wildly. In-browser JavaScript also allows you to perform webpage manipulation, interaction with the user and with the web server. Javascript offer advantages like:  Show dynamic content based on the user profile.  React to user's operations, like mouse clicks events, key presses or pointer movements.  Support features like auto-validated form entries and interactive drop-down menus.  Send requests to remote servers, Upload and download files.  JavaScript code can also create movement and sound  Ask questions to the users, Get and set cookies, show messages, switch browser tabs.  Allows the data on to be stored in the local storage. What can't in-browser JavaScript do? JavaScript's capabilities in the browser are quite limited for the sake of the user's safety. It helps to prevent any unauthorized webpage from accessing private information. Examples of such limitations are:  JavaScript on a webpage may not allow you to copy, execute or read/write arbitrary files on the hard disk. It doesn't offer any access to Operating system functions.  Many browsers allow it to work with files, but the access is very limited and only provided if the user is performing a specific action like, dropping a file into a browser window or selecting using <input> tag.  JavaScript allows you to communicate over the net to the server where the current page came from. Although, it does not allow you to receive data from other sites/domains. Application of JavaScript JavaScript is used to create interactive websites. It is mainly used for:  Client-side validation,  Dynamic drop-down menus,  Displaying date and time,  Displaying pop-up windows and dialog boxes (like an alert dialog box, confirm dialog box and prompt dialog box),  Displaying clocks etc. What makes JavaScript unique? The most important features which make JavaScript unique  It offers full integration with HTML/CSS.  Simple things are done quickly without any complication or following strict rules.  Supported by all major browsers and JavaScript is enabled by default. Bootstrap Bootstrap is the popular HTML, CSS and JavaScript framework for developing a responsive and mobile friendly website. What is Bootstrap  Bootstrap is the most popular HTML, CSS and JavaScript framework for developing a responsive and mobile friendly website.  It is absolutely free to download and use.  It is a front-end framework used for easier and faster web development.  It includes HTML and CSS based design templates for typography, forms, buttons, tables, navigation, modals, image carousels and many others.  It can also use JavaScript plug-ins.  It facilitates you to create responsive designs. Advantages of Bootstrap:  It is very easy to use. Anybody having basic knowledge of HTML and CSS can use Bootstrap.  It facilitates users to develop a responsive website. MySQL Features o Relational Database Management System (RDBMS): MySQL is a relational database management system. o Easy to use: MySQL is easy to use. You have to get only the basic knowledge of SQL. You can build and interact with MySQL with only a few simple SQL statements. o It is secure: MySQL consist of a solid data security layer that protects sensitive data from intruders. Passwords are encrypted in MySQL. o Client/ Server Architecture: MySQL follows a client /server architecture. There is a database server (MySQL) and arbitrarily many clients (application programs), which communicate with the server; that is, they query data, save changes, etc. o Free to download: MySQL is free to use and you can download it from MySQL official website. o It is scalable: MySQL can handle almost any amount of data, up to as much as 50 million rows or more. The default file size limit is about 4 GB. However, you can increase this number to a theoretical limit of 8 TB of data. o Compatibale on many operating systems: MySQL is compatible to run on many operating systems, like Novell NetWare, Windows* Linux*, many varieties of UNIX* (such as Sun* Solaris*, AIX, and DEC* UNIX), OS/2, FreeBSD*, and others. MySQL also provides a facility that the clients can run on the same computer as the server or on another computer (communication via a local network or the Internet). o Allows roll-back: MySQL allows transactions to be rolled back, commit and crash recovery. o High Performance: MySQL is faster, more reliable and cheaper because of its unique storage engine architecture. o High Flexibility: MySQL supports a large number of embedded applications which makes MySQL very flexible. o High Productivity: MySQL uses Triggers, Stored procedures and views which allows the developer to give a higher productivity. Disadvantages / Drawback of MySQL: Following are the few disadvantages of MySQL: o MySQL version less than 5.0 doesn't support ROLE, COMMIT and stored procedure. o MySQL does not support a very large database size as efficiently. o MySQL doesn't handle transactions very efficiently and it is prone to data corruption. o MySQL is accused that it doesn't have a good developing and debugging tool compared to paid databases. o MySQL doesn't support SQL check constraints. 4. SYSTEM ANALYSIS 4.1 Existing System In the existing system students can give feedback about the lecturers by using paper and pen. The purpose of this project is to make the process of taking feedback from the students in online regarding the lecturer’s teaching. As of now this task was done manually with the use of papers and pens. This has many drawbacks and evaluating this hand written forms is a difficult process. But the restriction here is once the student submits the report then he cannot modify it later. With this the student can successfully submit feedback on lecturer’s teaching in a very efficient manner without any loss of data. The administrator and the faculty members can access these feedbacks from the students and take appropriate actions. By this process. Student can give feedback in online system without waste his time in writing. After giving feedback by every student. With this, the institutes can access the feedback reports in a faster way and without any loss of data. This Page May Contain What is student staff feedback system on Java And Latest Information/News About student staff feedback system on Java,If Not Use Search.Papers are collected by the Hod’s and calculate the overall grade for each subject and each lecturer. Student needs to logging into the website of online feedback system and giving his/her feedback and can perform modifications too. Online Student Feedback System Project Topics, One student is allowed to give only one feedback in one turn; however they are allowed to change it at any time After that those all grade report is viewed by the principal which is given by the Hod’s. for both staff and students in an institution. For Staff to provide student feedback collection form project in core me Feedback management system. Hence estimating the performance of lecturers and giving counseling to college staff. 4.2 PROPOSED SYSTEM: Feedback Module:  Admin can manage the feedback  Admin can edit/delete feedback  Admin can see the list of feedback  Admin can see his feedback Student Module:  Admin can add new students records  Admin can see the list of student details  Only admin can update the records of the students  Admin can be able to delete the student details  Student can be able to see his details  Student can be able to update his details 5.2 DATA FLOW DIAGRAM A data flow diagram (DFD) is a graphical representation of the "flow" of data through an information system, modelling its process aspects. A DFD is often used as a preliminary step to create an overview of the system without going into great detail. DFDs can also be used for the visualization of data processing (structured design). The Data Flow Diagrams (DFDs) are used for structure analysis and design. DFDs show the flow of data from external entities into the system. DFDs also show how the data moves and is transformed from one process to another, as well as its logical storage. The following symbols are used within DFDs. For clarity, a key has been provided at the bottom of this page. Data Flow Symbols and Meaning Entity: An entity is the source or destination of data. The source in a DFD represents these entities that are outside the context of the system. Entities either provide data to the system (referred to as a source) or receive data from it (referred to as a sink). Process: Represented by circles in the diagram. Processes are responsible for manipulating the data. They take data as input and output an altered version of the data. Data Store: Represented by a segmented rectangle with an open end on the right. Data Stores are both electronic and physical locations of data. Data Flow: Represented by a unidirectional arrow. Data Flows show how data is moved through the System. ADMIN ID USERNAME PASSWORD FACULTY ID FACULTY_ID FACULTY_NAME EMAIL MOBILE PASSWORD STATUS FEEDBACK STUDENT_ID FACULTY_NAME QNO ANSWER STATUS FACULTY_REGISTER ID INTAKE_LIST FACULTY_NAMEBRANCH STUDENT ID NAME INTAKE_CODE LEVEL BRANCH EMAIL STATUS 5.3 CLASSES The following classes are used to design an Pharmaceutical system. A class diagram is used to represent the relationship between the classes in a Unified Modeling Language (UML). 5.4 INPUT DESIGN HOME PAGE: Bi svete x |g Ye ew ae |G md-ee K |G MALI XW agscliest x |B facta XE amit | - 6 STUDENT REVIEW SYSTEM “FEEDBACK IS THE BREAKFAST OF CHAMPIONS.” eee TP eee ee LOGIN AS STUDENT Bloat x ak X |G moa-cess x | G wysoLTmer x YW nysoLFesnn x | FF FeectaceMe x () Prerteper x | + ” © lecatos AD Yeats to By: Gecgle Tense STUDENT REVIFW § Sign In As Student Pre cy STUDENT DASHBOARD: By estore: « [ESE 3 [6 maya) @ Ms lvee e W Matl enue | BP ieee eB hemttepen # | - a * ® ° “fee Gale M Gat DB halle EP taates My tyetiontie Kolbe. @ Whadios = be ETT nd ccd ci Pray Poca rord == usc Baca DETAILS 2 |G mat cs | @ Mose em oe Ways Femi oe | Pfr eB) Peper sepen oe | ot - a «x =p * MO: G come Mt Cont Yue BP Facer Dy cegle tener GP SeuTiberatea. @ Whanéo> G Cony elim STUDENT REVIEW SYSTEM FEEDBACK LOGIN AS FACULTY 5.5 OUTPUT DESIGN: LOGIN PAGE: Bink « S| Gms tase |S Ms ens dU Leet | Plata XB Poeeiipen oe | - 0 x € > SO kecaostie Wn log.ohp ~ + B1e: Gade M1 Goat MB Woslube OB Fewbooh Dp Guusie lias cD) Yule totes Sign In As Admin fee Rete ge eee BR Givers. Borat. Qs... Bpretasr Bower = Co aie STUDENT REGISTRTION FORM: Baan x € 2 FO teatosvie entregetes hp of B18: G Sale M Goat BB YaTobe (EP Feutook Bp Gale Xe ew a 2 |G mpgs x |G mse tote de WY erie oe | rewtacemte x B hes tepe x | - 6 @ Sastbe woth DE field crenerer ie) poral Bepertnrey email id BS Co carted Bea Te  med-tece |G MAUL Iutons XW) Lee MPL 9 | JP teeiteck a ERD Horetitepos | of - 0 x oP Goat BE la Be Oe ces 2) Welt tts vat CCE B Ih eta eT es esp U hE LOGOUT VIEW FACULTY DETAILS JAYARARATH) rina? COMPUTING GAYAIHE! Pitney ACCOUNTING Xe | msc eters 2 Learn is x | taestecce x Bl) Pres tps x | + - 0 x Intake List Branch DH iccobasctees gy saben ts € FSO kecathostites M4 cra X |G mag te x | & msc ters 2) Yuli tote X | FP tesstacke ERD Hore! STUDENT REVIEW SYSTEM DISPLAY STUDENT DETAIL TP108022 RAJADURA, TP108023 RAJACURA TP108024 RAJADURA. og SHAKTI BO Ginter. @ leraaeyfo M cra AYA, JAVA JAVA ave anya LAYABARAIHL JAVABARATH JAYADARATII Caen pe? SCLcCT 'NACT | COMPLETE SELECT AGIIVE AGLIVE ACTIVE oat Pee Paes PERSONALITY QUALILY MANAGING QUERY TEACHINC SPEED SAMPLE SAMPLC2 SAMP) FA SAMI He PERSONALIY QUALILY MANAGING QUERY TEACIIING SPCCD SELECI PROJECT STATU SCLECT PROIFCT STATU J THANRAJAS@.CMAIL.COM PD textes x | @ Msortuer: x FXCHIIFNT VERY UDB soon 00D VERY 8000 soon VERY G0 VERY GOOD s0on VERY GOOD JIT IANRAJAA6@ GMAIL J THANRAJAB@.CMAILCOM SUIAKTINI@GMAIL COM eov2aitas6 = TRTR e02g1918 | RRAR 9042911918 DURAL 0974551230 SIIAKTHNNI23 Soe Co CE ae x | Fesstsccwe x Ol) Prec: ero ae eee 5.TESTING AND IMPLEMENTATION INTRODUCTION Testing is a schedule process carried out by the software development team to capture all the possible errors, missing operations and also a complete verification to verify objective are met and user requirement are satisfied. The design of tests for software and other engineering products can be as challenging as the initial design to the product itself. The following description shows that the description of test results which are done in this project. 5.1 TYPES OF TESTING A software engineering product can be tested in one of two ways:  Black box testing  White box testing Black box testing - knowing the specified function that a product has been designed to perform, determine whether each function is fully operational. White box testing – knowing the internal workings of a software product determine whether the internal operation implementing the functions perform according to the specification, and all the internal components have been adequately exercised. TESTING STRATEGIES Four Testing Strategies that are often adopted by the software development team include:  Unit Testing  Integration Testing  Validation Testing  System Testing This system was tested using Unit Testing and Integration Testing Strategies to test the project because there were the most relevant approaches for this project. 5.2 UNIT TESTING We adopt white box testing when using this testing technique. This testing was carried out on individual components of the software that were designed. Each individual module was tested using this technique during the coding phase. Every component was checked to make sure that they adhere strictly to the specifications spelt out in the data flow diagram and ensure that they perform the purpose intended for them. All the names of the variables are scrutinized to make sure that they are truly reflected of the element they represent. All the looping mechanisms were verified to ensure that they were as decided. Beside these, we trace through the code manually to capture syntax errors and logical errors. 5.3 INTEGRATION TESTING: After finishing the Unit Testing process, next is the integration testing process. In this testing process we put our focus on identifying the interfaces between components and their functionality as dictated by the DFD diagram. The bottom up incremental approach was adopted during this testing. Low level modules are integrated and combined as a cluster before testing. 5.4VALIDATION TESTING: Software testing and validation is achieved through a series of black box tests that demonstrate tests that demonstrate conformity with requirements. A test procedure defines specific test cases that will be used to demonstrate conformity with requirements. Both ,the plan and the procedure are designed to ensure that all functional requirements are achieved, documentation is correct and other requirements are met. After each validation test case has been conducted, one of the two possible conditions exists, They are,  The function from performance characteristics conform to specification and are accepted.  A deviation from specification is uncovered and a deficiency list is created. The deviation or error discovered at this stage in project can rarely be corrected prior to scheduled completion. It is necessary to negotiate with the customer to establish a method for resolving deficiencies. 5.5 SYSTEM TESTING: System testing is a series of different tests whose primary purpose is to fully exercise the computer based system. Although each has a different purpose, all the work should verify that all system elements have been properly integrated and perform allocated functions. Recovery testing is done in such as way that failure is forced to a software system and checked whether the recovery is proper and accurate. The performance of the system is highly effective. Software testing is critical element of software quality assurance and represents ultimate review of specification, design and coding. Test case design focuses on a set of technique for the creation of test cases that meet overall testing objectives. Planning and testing of a programming system involve formulating a set of test cases, which are similar to the real data that the system is intended to manipulate. In principle, testing of a program must be extensive. Every statement in the program should be exercised and every possible path combination through the program should be executed at least once. Thus it is necessary to select a subset of the possible test cases and conjecture that this subset will adequately test the program. 5.6APPROACH TO TESTING  Testing a system’s capabilities is more important that testing its component. This means that test cases should be chosen to identity aspects of the system, which will stop them doing their job.  Testing old capabilities is more important than testing new capabilities. If program is a revision of an existing system, users existing feature to keep working.  Testing typical situation is more important that testing boundary value cases. It is more important that a system works under normal usage conditions than under occasional conditions, which only arise with extreme data values. 7. CONCLUSION AND FUTURE ENHANCEMENT CONCLUSION: The Project “Feedback management system” is designed in order reduce the burden of maintaining bulk of records of all the students feedback details of who study in an Educational Institution. Inserting, retrieving and updating the feedback details of a student are easy when it is compared to the manual feedback and storing. Maintaining the project is also easy which can is easily understandable. Maintaining the details in the database is manageable. FUTURE ENHANCEMENTS: Due to the lack of time, the design part is not done so attractive. Further enhancements can be made in designing the screens. Some more forms can also be added so as to better retrieve the feedback details. Various other options can also be added for the better usability of project. 8. BIBLIOGRAPHY 1. https://www.w3schools.com/html/html_styles.asp 2. https://www.studentstutorial.com/javascript/javascript-home 3. https://www.javatpoint.com/mysql-features 4. https://www.javatpoint.com/php-tutorial 9. APPENDIX A. DATABASE DESIGN ADMIN TABLE: S.No Field name Data type 1 Id Int 2 username Varchar 3 password varchar Faculty table: S.No Field name Data type 1 Id Int 2 Faculty_id Varchar 3 Faculty_name Varchar 4 Email Varchar 5 Phone_number Varchar 6 Password Varchar Faculty Register: S.No Field name Data type 1 Id Int 2 Inttake_list Varchar 3 Faculty_name Varchar 4 Branch Varchar Feedback : S.No Field name Data type 1 Id Int 2 Student_id Int 3 Faculty_name Varchar 4 Lecture Varchar text-decoration: none; text-decoration:bold; } .footer { width:100%; height:100px; background-image:url(".//images/back7.jpg"); } .w3-section { margin-top:0px !important; margin-bottom:0px !important; } </style> </head> <body> <div class="top-header"> <div class="header"> <p style="color:#fcb103;">STUDENT REVIEW SYSTEM</p> </div> <!-- Navigation Menu --> <nav> <ul> <li><a href="student_login.php">STUDENT LOGIN</a></li> <li><a href="faculty_login.php">FACULTY LOGIN</a></li> <li><a href="admin_login.php">ADMIN LOGIN</a></li> </ul> </nav> </div> <!-- Image menu in Header to contain an Image and a sample text over that image --> <div class="main"> <div class="w3-content w3-section" > <img class="mySlides" src=".//images/sl0.jpg" style="width:100%"> <img class="mySlides" src=".//images/sl1.jpg" style="width:100%"> <img class="mySlides" src=".//images/sl6.jpg" style="width:100%"> <img class="mySlides" src=".//images/sl2.jpg" style="width:100%"> <img class="mySlides" src=".//images/sl3.jpg" style="width:100%"> <img class="mySlides" src=".//images/sl7.jpg" style="width:100%"> <img class="mySlides" src=".//images/sl4.jpg" style="width:100%"> </div> </div> <div class="footer"> </div> <script> var myIndex = 0; carousel(); function carousel() { var i; var x = document.getElementsByClassName("mySlides"); for (i = 0; i < x.length; i++) { x[i].style.display = "none"; } myIndex++; if (myIndex > x.length) {myIndex = 1} x[myIndex-1].style.display = "block"; setTimeout(carousel, 2000); // Change image every 2 seconds } </script> </body> </html> Student_dashboard.php: <html> <head> <link rel="stylesheet" href="./css/dashboard.css"> <style> img { height: 100px; width: 100px; border-radius:50%; } .container { margin-top:0px; } .header { <a href="feedback_details.php" class="btn btn-success btn-lg" role="button"> <br/><img src="./images/fbk.jpg"/><h6 style="color:white;font-size:15px;">TAKE FEEDBACK</h6></a> </div> <div class="col-xs-6 col-md-6" id="two"> <a href="myfeedback.php" class="btn btn-success btn-lg" role="button"> <br/><img src="./images/vrpt.jpg"/><h6 style="color:white;font-size:15px;">ENTERED FEEDBACK DETAILS</h6></a> <a href="excel.php" class="btn btn- success btn-lg" role="button"> <br/><img src="./images/report.jpg"/><h6 style="color:white;font-size:15px;">EXPORT AS EXCEL</h6></a> </div> </div> </div> </div> </div> </div> </div> </div> <div class="footer"> <h6 style="color:white;margin-left:830px;">Copyright @ Student Review System 2019</h6> </div> </body> </html> Student_login: <!DOCTYPE html> <html> <head> <title>Login Page</title> <!--Made with love by Mutiullah Samim --> <!--Bootsrap 4 CDN--> <link rel="stylesheet" href="./css/bootstrap5.min.css" > <!--Fontawesome CDN--> <link rel="stylesheet" href="./css/all.css" > <!--Custom styles--> <link rel="stylesheet" type="text/css" href="./css/exstyle.css"> <style> .header { height:100px; background-image:url(".//images/back7.jpg"); margin-bottom:20px; font-family:serif; } .footer { background-image:url(".//images/back7.jpg"); } .container { background-image:url(".//images/back7.jpg"); } p { font-family:serif; margin-left:480px; padding:30px; font-size:30px; } body { background-image:url(".//images/back7.jpg"); } </style> </head> <body> <div class="header"> <p style="color:#fcb103;"> STUDENT REVIEW SYSTEM</p> </div> <div class="container"> <div class="d-flex justify-content-center h-100"> <div class="card"> <div class="card-header"> <h3>Sign In As Student</h3> <!--<div class="d-flex justify-content-end social_icon"> else { $msg="<script>alert('Invalid user. Please signup and try again');</script>"; } } ?> </body> </html> Studentregister.php: <html> <head> <link rel="stylesheet" href="./css/bootstrap.min2.css"> <link rel="stylesheet" href="./css/style.css"> <link rel="stylesheet" href="./css/header2.css"> <link rel="stylesheet" href="./css/grid.css"> <style> .header { background-image:url(".//images/back7.jpg"); font-family:serif; font-size:30px; } .footer { background-image:url(".//images/back7.jpg"); } a { background-color:transparent !important; padding:0px; border:none !important; color:#fcb103 !important; font-size:15px; } .form-horizontal { margin-left:50px !important; } p { margin-left:500px; } .content { background-image:url(".//images/back7.jpg"); } </style> </head> <body> <div class="header"> <p style="color:#fcb103;"> STUDENT REVIEW SYSTEM <a href="logout.php" style="margin-left:100px;" role="button"><img src="./images/logout3.png" style="width:100px;height:50px;margin-left:150px;"/></a> </p> <a href="admin_dashboard.php" style="padding:10px;" role="button">CONTINUE TO ADMIN DASHBOARD</a> </div> <div class="content"> <form method="post" class="form-horizontal" name="myform" onsubmit = "return(validate());"> <h3 style="margin-left:350px;color:white;font-size:20px;">STUDENT REGISTRATION FORM</h3> <div class="container"> <div class="form-group"> <label for="project_Name" class="control-label col-sm-2" style="width:160px;text- align:left;">Name</label> <div class="col-sm-5"> <input type="text" name="name" class="form-control" required> </div> </div> <div class="form-group"> <label for="project_Name" class="control-label col-sm-2" style="width:160px;text- align:left;">Intake</label> <div class="col-sm-5"> </select> </div> </div> <div class="form-group"> <label for="project_Name" class="control-label col-sm-2" style="width:160px;text- align:left;">email_id</label> <div class="col-sm-5"> <input type="text" name="email" class="form-control" required> </div> </div> <div class="form-group"> <label for="project_Name" class="control-label col-sm-2" style="width:160px;text- align:left;">Mobile no</label> <div class="col-sm-5"> <input type="text" name="mobile" class="form-control" required> </div> </div> <div class="form-group"> <label for="project_Name" class="control-label col-sm-2" style="width:160px;text- align:left;">Password</label> <div class="col-sm-5"> <input type="password" name="pwd" class="form-control" required> </div> </div> <div class="form-group"> <div class="col-sm-offset-2 col-sm-10"> <input type="submit" name="save" class="btn btn-default"> </div> </div> </div> </form> </div> <div class="footer"> <h6 style="color:white;margin-left:330px;">Copyright @ Student Feedback 2019</h6> </div> </body> </html> <?php include("config.php"); if(isset($_POST['save'])) { $sql="select * from student where Name='".$_POST['name']."' "; $res=mysql_query($sql) or die(mysql_error()); $row=mysql_num_rows($res); if($row) { echo "already exists"; } else { $sql= "insert into student (Name,intake,intake_code,level,branch,email,mobile,password)values('".$_POST['name']."','". $_POST['intake']."','".$_POST['icode']."','".$_POST['level']."','".$_POST['branch']."','". $_POST['email']."','".$_POST['mobile']."','".$_POST['pwd']."')"; $res=mysql_query($sql) or die(mysql_error()); if($res) { echo "inserted"; //$msg="<script>alert('inserted');</script>"; } else { echo "fill all the details correctly"; } } } ?> Admin_dashboard.php: <html> <head> <link rel="stylesheet" href="./css/dashboard.css"> <style> img { height: 150px; width: 150px; border-radius:50%; } <div class="panel-body"> <div class="row"> <div class="col-xs-6 col-md-6" style=""> <a href="studentregister.php" class="btn btn-danger btn-lg" role="button"> <br/><img src="./images/addstd.png"/>STUDENT REGISTRATION FORM</a> <a href="facultyregister.php" class="btn btn-warning btn-lg" role="button"> <br/><img src="./images/addstaff.jpg"/>ADD FACULTY DETAILS</a> <a href="viewfaculty.php" class="btn btn-primary btn-lg" role="button"> <br/><img src="./images/staff2.jpg"/>FIND STAFF DETAILS</a> </div> <div class="col-xs-6 col-md-6" style=""> <a href="adminreport.php" class="btn btn- success btn-lg" role="button"> <br/><img src="./images/report.jpg"/>EXPORT EXCEL REPORT</a> <a href="viewfeedback.php" class="btn btn-success btn-lg" role="button"> <br/><img src="./images/fbk.jpg"/>VIEW FEEDBACK DETAILS</a> <a href="dispstud.php" class="btn btn-primary btn-lg" role="button"> <br/><img src="./images/student.jpg" id="one"/>VIEW STUDENT DETAILS</a> </div> </div> </div> </div> </div> </div> <div class="footer"> <h6 style="color:white;margin-left:330px;">Copyright @ Student Feedback 2019</h6> </div> </body> </html> Admin_login.php: <!DOCTYPE html> <html> <head> <title>Login Page</title> <!--Made with love by Mutiullah Samim --> <!--Bootsrap 4 CDN--> <link rel="stylesheet" href="./css/bootstrap5.min.css" > <!--Fontawesome CDN--> <link rel="stylesheet" href="./css/all.css" > <!--Custom styles--> <link rel="stylesheet" type="text/css" href="./css/exstyle.css"> <style> .header { height:100px; background-image:url(".//images/back7.jpg"); font-family:serif; font-size:30px; } .footer { background-image:url(".//images/back7.jpg"); } a { background-color:transparent !important; padding:0px; border:none !important; color:white !important; } .form-horizontal { margin-left:250px !important; } p { margin-left:500px; } .container { background-image:url(".//images/back7.jpg"); } body { background-image:url(".//images/back7.jpg"); } if(isset($_POST['login'])) { $sql="select * from admin where username='".$_POST['uname']."' AND password='". $_POST['pwd']."' "; $res=mysql_query($sql) or die(mysql_error()); $row=mysql_fetch_array($res); if($row["username"]==$_POST['uname'] && $row["password"]==$_POST['pwd']) { $SESSION['username']=$_POST['uname']; $SESSION['id']=mysql_result($login,0); header("Location:admin_dashboard.php"); } else { $msg="<script>alert('Invalid user. Please signup and try again');</script>"; } } ?> </body> </html> Faculty_dashboard.php: <html> <head> <link rel="stylesheet" href="./css/dashboard.css"> <style> .container{ padding-left:600px; margin:0px; } img { height: 150px; width: 150px; border-radius:50%; } .header { height:100px; background-image:url(".//images/back7.jpg"); font-family:serif; font-size:30px; } .footer { background-image:url(".//images/back7.jpg"); } a { background-color:transparent !important; padding:0px; border:none !important; color:white !important; } .form-horizontal { margin-left:50px !important; margin-top:0px !important; margin-bottom:0px !important; } p { margin-left:500px; } .row { margin-top:0px; margin-bottom:0px; } .main1 { background-image:url(".//images/back7.jpg"); } </style </head> <body> <div class="header"> <p style="color:#fcb103;"> STUDENT REVIEW SYSTEM <a href="logout.php" style="margin-left:400px;" role="button"><img src="./images/logout3.png" style="width:100px;height:50px;margin-left:150px;"/></a> </p> </div> <div class="main1"> <div class="container"> { background-image:url(".//images/back7.jpg"); } .content { background-image:url(".//images/back7.jpg"); } p { margin-left:180px; } .form-horizontal { margin-left:200px !important; margin-top:0px !important; margin-bottom:0px !important; } td { text-transform:uppercase; background-color:#2eaba5; } th { background-color:#2eaba5; } .row { margin:0px !important; </style> </head> <body> <div class="header"> <p style="color:#fcb103;"> STUDENT REVIEW SYSTEM <a href="logout.php" style="margin-left:330px;padding:10px;" role="button">LOGOUT</a> </p> <a href="student_dashboard.php" style="padding:10px;" role="button">CONTINUE TO STUDENT DASHBOARD</a> </div> <div class="content"> <form method="post" class="form-horizontal" name="myform"> <h3 style="font-size:25px;margin-left:40px;color:white;">VIEW FACULTY DETAILS</h3> <div class="container"> <div class="form_group"> <div class="tbl"> <table> <tr> <th>FACULTY_ID</th> <th>FACULTY_NAME</th> <th>INTAKE LIST</th> <th>BRANCH</th> <th>TO EDIT</th> </tr> <?php include("config.php"); $sql = "select id,faculty_name,intake_list,branch from faculty_register"; $res=mysql_query($sql) or die(mysql_error()); while ($row = mysql_fetch_array($res)) { echo "<tr>"; echo "<td>".$row['id']."</td>"; echo "<td>".$row['faculty_name']."</td>"; echo "<td>".$row['intake_list']."</td>"; echo "<td>".$row['branch']."</td>"; echo "<td><a href='editfaculty.php?id=".$row['id']."'> Edit </td>"; echo "</tr>"; } ?> </table> </div> </div> <div class="form-group"> </div> </div> </form> </div> background-image:url(".//images/back7.jpg"); } a { background-color:transparent !important; padding:0px; border:none !important; color:#fcb103!important; font-size:15px !important; } .form-horizontal { margin-left:250px !important; } p { margin-left:500px; } .content { background-image:url(".//images/back7.jpg"); } </style> </head> <body> <div class="header"> <p style="color:#fcb103;"> STUDENT REVIEW SYSTEM <a href="logout.php" style="margin-left:700px;" role="button"><img src="./images/logout3.png" style="width:100px;height:50px;margin-left:150px;"/></a> </p> <a href="student_dashboard.php" style="padding:10px;" role="button">CONTINUE TO STUDENT DASHBOARD</a> </div> <div class="content"> <form method="post" class="form-horizontal" name="myform"> <h3 style="font-size:25px;margin-left:40px;">Edit or delete Faculty details</h3> <div class="container"> <div class="form-group"> <label for="project_Name" class="control-label col-sm-2" style="width:160px;text- align:left;">Faculty Name</label> <div class="col-sm-5"> <input type="text" name="name" class="form-control" value='<?php echo $name; ?>' id="fname" required> </div> </div> <div class="form-group"> <label for="project_Name" class="control-label col-sm-2" name="intakecode" style="width:160px;text-align:left;">Intake List</label> <div class="col-sm-3"> <select name="icode" class="form-control" value='<?php echo $intake_list; ?>' id="intcode" required> <option value="">select</option> <option value="PT1082">PT1082</option> <option value="PT1083">PT1083</option> <option value="PT1084">PT1084</option> <option value="PT1084">PT1085 </option> </select> </div> </div> <div class="form-group"> <label for="project_Name" class="control-label col-sm-2" name="Status" style="width:160px;text-align:left;">Branch</label> <div class="col-sm-3"> <select name="branch" class="form-control" value='<?php echo $branch; ?>' id="brnch" required> <option value="">select</option> <option value="computing">computing</option> <option value="accounting">accounting</option> <option value="management">management</option> <option value="research">research</option> </select> { echo "try again"; } } ?> C.SCREENSHOTS: HOME PAGE: STUDENT REVIEW SYSTEM “FEEDBACK IS THE BREAKFAST OF CHAMPIONS.” ee) eee ee LOGIN AS STUDENT % |G mpd Ging x |G MSOLTU oY MGCL Feats x | F Feclack Me x Bll Pies tye e MM Grat mB YouTube [EH Facebook By ceca) ‘evTubet 3 Sign In As Student STUDENT DASHBOARD:  By bcahorvtees » CRSA G mrd-tess | MAUL eters MY Mysttents o | BP ieectack Me Xf Hroetieper | + - 0 x € 2 GO tecathost seals M4 Grad BB tovlate Ep retook Bp Guayle amie oD Yeulubetantest vat JENT REVIEW SYSTEM ETT nd ccd ci Pray Poca rord ETB usc Baca DETAILS rere FEEDBACK FORM: ee ryan errc re | @ wySOE Taran 9 WE NSC Fotis 3C | JP Fevekaee on oe BRD reerzepens oe | of - a x a * a6 G seer ML Gent AB eutTine Bp trrnoar Bp er STUDENT REVIEW SYSTEM FEEDBACK TORM AYA, LOGIN AS FACULTY Admin student faculty Feedback id username password Add stud ent Email Id Name intake Intake code Level branch Mobile Password Faculty_name Stud_id Id idd Faculty_nameId Add fac ulty Give feed back View feedb ack D.ER DIAGRAM: consultation Cmt_question Id idd lecture tutorial Qus_answer Cmt_lecture Cmt_consultant Cmt_tutorial Branch Intake_list