ACAD-an-ACademic-ADministration-application/Announcement1.php at master · ishmav16/ACAD-an-ACademic-ADministration-application · 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
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125


<?php
session_start();
include_once 'dbconnect.php';
 if (isset($_SESSION['usr_id'])) {
$usr_id=$_SESSION['usr_id'];
 }

$error = false;

//check if form is submitted
if (isset($_POST['signup'])) {

    $descp = mysqli_real_escape_string($con, $_POST['descp']);
    $select1 = mysqli_real_escape_string($con, $_POST['hello']);
    $c1=mysqli_query($con,"select * from courses where cid=$select1");
    while($num1=mysqli_fetch_array($c1))
    {
        $k1=$num1['cname'];
    }
    if(strlen($descp) ==0) {
        $error = true;
        $descp_error = "You should enter some description";
    }

    if (!$error)
{
	 if(mysqli_query($con, "INSERT INTO announcement(sub,des,dt,aid) VALUES('".$k1."','".$descp."',NOW() ,'".$usr_id."') ") ) {
            $successmsg = "NOTIFICATION SENT! <a href='facpage.php'>BACK</a>";
	}


}
         else {
            $errormsg = "Error in submitting please submit the form...Please try again later!";
      }

}
?>
<!DOCTYPE html>
<html>
<head>
    <title>ANNOUNCEMENT</title>
    <meta content="width=device-width, initial-scale=1.0" name="viewport" >
    <link rel="stylesheet" href="css/bootstrap.min.css" type="text/css" />
</head>
<body>

<nav class="navbar navbar-default" role="navigation">
    <div class="container-fluid">
        <!-- add header -->
        <div class="navbar-header">
            <button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#navbar1">
                <span class="sr-only">Toggle navigation</span>
                <span class="icon-bar"></span>
                <span class="icon-bar"></span>
                <span class="icon-bar"></span>
            </button>
            <a class="navbar-brand" >Academic Administration Application</a>
        </div>
        <!-- menu items -->
        </div>
</nav>

<div class="container">
    <div class="row">
        <div class="col-md-4 col-md-offset-4 well">
            <form role="form" action="<?php echo $_SERVER['PHP_SELF']; ?>" method="POST" name="signupform">
                <fieldset>


                    <div class="form-group">
                     <label for="name">SUBJECT</label>

           <select name="hello" Emp Name="NEW"  required class="form-control">
            <option value="" >--- Select ---</option>
            <?php
               mysqli_connect ("localhost","root","");
                mysqli_select_db ("testdb");
                $select="testdb";
                if (isset ($select)&&$select!=""){
                $select=$_POST ['NEW'];
            }
            ?>
            <?php
                $list=mysqli_query($con,"select * from courses where fid=$usr_id");

            while($row_list=mysqli_fetch_assoc($list)){
            ?>
                    <option value="<?php echo $row_list['cid']; ?> "<?php if($row_list['cid']==$select){ echo "selected"; } ?> >
                                         <?php echo $row_list['cname']; ?>
                    </option>

                <?php
            }

                ?>
                <span class="text-danger"><?php if (isset($d_error)) echo $d_error; ?></span>
            </select>
                    </div>


                    <div class="form-group">
                        <label for="name">TEXT</label>
                        <textarea  name="descp"  rows = "5" cols = "60" placeholder="Enter the subject" required class="form-control" /></textarea>
                        <span class="text-danger"><?php if (isset($descp_error)) echo $descp_error; ?></span>
                    </div>

                    <div class="form-group">
                        <input type="submit" name="signup" value="Add" class="btn btn-primary" />
                    </div>
                </fieldset>
            </form>
  <span class="text-success"><?php if (isset($successmsg)) { echo $successmsg; } ?></span>
            <span class="text-danger"><?php if (isset($errormsg)) { echo $errormsg; } ?></span>

            </div>
    </div>
    </div>
<script src="js/jquery-1.10.2.js"></script>
<script src="js/bootstrap.min.js"></script>
</body>
</html>