cms/insert_social.php at master · rajakumar05032000/cms · 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
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
<?php

include 'db_conn.php';

error_reporting(0);

session_start();


if (!isset($_SESSION['empid']) && $_SESSION['designation']!='Faculty') {
    header("Location: new_login.php");
  }


// if (isset($_POST['submit'])) {


//     $sql = "create table if not exists social(date varchar(100),
//     title varchar(100),
//     resource varchar(100),
//     company varchar(500),
//     image varchar(100),
//     description varchar(500))";

//     $result = mysqli_query($conn, $sql);


//     $date = $_POST['date'];
//     $title = $_POST['title1'];
//     $resource = $_POST['person'];
//     $company = $_POST['title_name'];
//     $image = $_POST['image'];
//     $description = $_POST['description'];


//     $sql = "insert into social values('$date','$title','$resource','$company','$image','$description')";
//     $result = mysqli_query($conn, $sql);

//     if ($result) {
//       echo "<script>alert('Inserted Successfully')</script>";
//     } else {
//       echo "<script>alert('User already exists')</script>";
//     }
//   }
$sql = "create table if not exists social(id int not null auto_increment primary key, datee varchar(100),
titlee varchar(100),
resourcee varchar(20),
companyy varchar(300),
imagee varchar(300),
descriptionn varchar(100)
)";
$result = mysqli_query($conn, $sql);

// $sql= "insert into announcement values(0,'0','0','0','0','0','0');";

// mysqli_query($conn, $sql);

if (isset($_POST['submit'])) {

    $date = $_POST['date'];
    $title = $_POST['title1'];
    $resource = $_POST['person'];
    $company = $_POST['title_name'];
    $image = $_POST['image'];
    $description = $_POST['description'];
$sql ="insert into social(datee,titlee,resourcee,companyy,imagee,descriptionn) values('$date','$title','$resource','$company',' $image','$description')";

$result = mysqli_query($conn, $sql);
    if ($result) {
        try{
            $login_tym = $_SESSION["login_tym"] ;
            $emp_id =  $_SESSION["empid"] ;
            $sql = "select * from log_details where login_tym ='$login_tym' and emp_id ='$emp_id' ";
            $result = mysqli_query($conn, $sql);
            $row = mysqli_fetch_assoc($result);

            $action = $row['action'];
            $form = $row['form'];

            $t1 = $action.",inserted social";
            $t2 = $form.", social form";


            $sql = "update log_details set action = '$t1', form = '$t2' where login_tym ='$login_tym' and emp_id ='$emp_id'";
            $result = mysqli_query($conn,$sql);
            echo '<div class="alert alert-success alert-dismissable" id="flash-msg" style="margin-top:70px">
                <h4>award added successfully</h4>
            </div>';
        }
        catch(e)
        {
            echo e;
        }
    }
}

?>


<?php
include 'appsidebar.php'
?>
           <h1 class="ms-3">Social activities</h1>
           <div class="main-card m-3 card min-vh-50"style="min-height:60%">
                        <div class="card-body">
            <form method="POST" action="" enctype="multipart/form-data">

            <div class="row justify-content-evenly">
                <div class="col-md-3">
                    <label for="dojpsg" class="form-label mt-3">Date</label>
                    <input type="date" class="form-control" id="date" name="date">
                </div>
                <div class="col-md-3">
                    <label for="name" class="form-label mt-3" >title</label>
                      <input type="text" class="form-control" id="title1" name="title1">

                </div>
                <div class="col-md-3">
                    <label for="name" class="form-label mt-3" >resource person</label>
                      <input type="text" class="form-control" id="person" name="person">

                </div>
            </div>
            <div class="row justify-content-evenly">
                <div class="col-md-3">
                    <label for="name" class="form-label mt-4" >company title</label>
                      <input type="text" class="form-control" id="title_name" name="title_name">

                </div>
                <div class="col-md-3">
                    <label for="name"  class="form-label mt-4">image upload</label>
                    <input onclick="f2()" type="file" class="form-control" id="image" name="image">
                </div>
                <div class="col-md-3">
                    <label for="name" class="form-label mt-4" >description</label>
                      <input type="text" class="form-control" id="description" name="description">

                </div>
            </div>
            <div class="row mt-5 mb-3">
                <div class="col">
                    <button type="Submit" class="btn btn-primary mb-4 "  name="submit">Submit</button>
                </div>
        </div>

        <script>
        const alertBox = document.getElementById("flash-msg");
        setTimeout(() => {
            alertBox.style.display = "none";
        }, 3000);
    </script>

        </body>
        <?php
include 'endtags.php'
?>