FacultyFeedbackSystem/submit.php at master · professorlevi/FacultyFeedbackSystem · GitHub

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
56
57
58
59
60
61
62
63
64
<html>
   <head>
      <title>Creating MySQLi Tables</title>
   </head>

   <body>
      <?php
         require_once("connect.php");
        $facultyname="";
        $facultyname=$_POST['facultyNameAndSubject'];
         echo $facultyname;


         $facultyname= str_replace("(","1",$facultyname);
         $facultyname= str_replace(")","1",$facultyname);
         $facultyname= str_replace("-","1",$facultyname);
         $facultyname= str_replace(" ","1",$facultyname);
         $facultyname= str_replace(".","1",$facultyname);
         echo $facultyname;
         $CheckTable = mysqli_query($conn,"SHOW TABLES LIKE '".$facultyname."'");


         $sql = "create table $facultyname(srollno BIGINT,param1 TINYINT,param2 TINYINT,
         param3 TINYINT,param4 TINYINT,param5 TINYINT,param6 TINYINT,param7 TINYINT,param8 TINYINT,param9 TINYINT,
         primary key (srollno))";


         if( mysqli_num_rows($CheckTable) > 0 ) echo 'Table exists';
        else{
            echo 'table does not exist';
            if(mysqli_query($conn, $sql))
            {
         echo "Table created successfully";
         }
         else {
            echo "Table is not created successfully ";
         }
        }
        $insertquery = "INSERT INTO $facultyname(srollno,param1,param2,param3,param4,param5,
        param6,param7,param8,param9)VALUES ('".$_POST["rollno"]."','".$_POST["subk"]."','".$_POST["pap"]."','".$_POST["uoc"]."',
        '".$_POST["ps"]."','".$_POST["reg"]."','".$_POST["sp"]."','".$_POST["dc"]."','".$_POST["tc"]."',
        '".$_POST["ep"]."')";

        $query = "SELECT COUNT(*) FROM $facultyname";
        $result = mysqli_query($conn,$query);
        $rows = mysqli_fetch_row($result);
        echo $rows[0];
        if($rows[0]>120)
                {
                    echo "All the students have given feedback, no more feedback can be added";
                }
                else {
                if (mysqli_query($conn, $insertquery))
                    header('location:facultyfeedback1.html');
                else
               echo "Error: " . $insertquery . "" . mysqli_error($conn);
                }

         mysqli_close($conn);
      ?>
   </body>
</html>