adminmanage.github.io/new_event.php at pages · ExperienceIsKey/adminmanage.github.io · 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
<head>

<link rel="stylesheet" href="projectstyle.css" type="text/css">
<script src = "ckeditor/ckeditor.js"></script>

</head>

<?php

session_start();

include('connection.php');
include('header.php');
include('navigation.php');


if(isset($_POST['Submit']))
{
	//$sno = $_POST['sno'];
	$name = $_POST['name'];
	$date = $_POST['date'];
	$sdesp = $_POST['sdesp'];
	$ldesp = $_POST['ldesp'];

	$sql = "INSERT INTO events (name, date, sdesp, ldesp) VALUES ('$name', '$date', '$sdesp', '$ldesp')";


if (mysqli_query($conn, $sql)) {
    echo "New event has been added successfully";
} else {
    echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}

}
?>

<form action = '' method = 'POST' class = 'new_event'>

<div>

<div class = "acform">
<h1><i>New Event</i></h1>
</div>

<div class = 'acform'>

<div class = 'leftac'>
<label>Name:</label>
</div>

<div class = 'rightac'>
<input type="text" name="name" >
</div>

</div>

<div class = 'acform'>

<div class = 'leftac'>
<label>Date:</label>
</div>

<div class = 'rightac'>
<input type="date" name="date" >
</div>

</div>

<div class = 'acform'>

<div class = 'leftac'>
<label>Short Description:</label>
</div>

<div class = 'rightac'>
<textarea rows="4" cols="50" name="sdesp" ></textarea>
</div>

</div>

<div class = 'acform'>

<div class = 'leftac'>
<label>Long Description:</label>
</div>

<div class = 'rightac'>
<textarea rows="10" cols="50" class = "ckeditor" name="ldesp" >&lt;h1&gt;Article Title&lt;/h1&gt;
        &lt;p&gt;Here's some sample text&lt;/p&gt;</textarea>

</div>

</div>

<div class = 'acform'>

<input type="submit" class = "button" name="Submit" value="Add">

</div>

</div>

</form>

<?php

include('footer.php');

?>