-
Notifications
You must be signed in to change notification settings - Fork 0
/
department.php
128 lines (121 loc) · 3.49 KB
/
department.php
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
<?php
include("adheader.php");
include("dbconnection.php");
if(isset($_POST['submit']))
{
if(isset($_GET['editid']))
{
$sql ="UPDATE department SET departmentname='$_POST[departmentname]',description='$_POST[textarea]',status='$_POST[select]' WHERE departmentid='$_GET[editid]'";
if($qsql = mysqli_query($con,$sql))
{
echo "<script>alert('department record updated successfully...');</script>";
}
else
{
echo mysqli_error($con);
}
}
else
{
$sql ="INSERT INTO department(departmentname,description,status) values('$_POST[departmentname]','$_POST[textarea]','$_POST[select]')";
if($qsql = mysqli_query($con,$sql))
{
echo "<script>alert('Department record inserted successfully...');</script>";
}
else
{
echo mysqli_error($con);
}
}
}
if(isset($_GET['editid']))
{
$sql="SELECT * FROM department WHERE departmentid='$_GET[editid]' ";
$qsql = mysqli_query($con,$sql);
$rsedit = mysqli_fetch_array($qsql);
}
?>
<div class="container-fluid">
<div class="block-header">
<h2 class="text-center">Add New Department </h2>
</div>
<div class="card">
<form method="post" action="" name="frmdept" onSubmit="return validateform()">
<table class="table table-hover">
<tbody>
<tr>
<td width="34%">Department Name</td>
<td width="66%"><input placeholder=" Enter Here " class="form-control" type="text" name="departmentname" id="departmentname" value="<?php echo $rsedit['departmentname']; ?>" /></td>
</tr>
<tr>
<td>Description</td>
<td><textarea placeholder=" Enter Here " class="form-control no-resize" name="textarea" id="textarea" cols="45" rows="5"><?php echo $rsedit['description'] ; ?></textarea></td>
</tr>
<tr>
<td>Status</td>
<td> <select name="select" id="select" class="form-control show-tick">
<option value="">Select</option>
<?php
$arr = array("Active","Inactive");
foreach($arr as $val)
{
if($val == $rsedit['status'])
{
echo "<option value='$val' selected>$val</option>";
}
else
{
echo "<option value='$val'>$val</option>";
}
}
?>
</select></td>
</tr>
<tr>
<td colspan="2" align="center"><input class="btn btn-default" type="submit" name="submit" id="submit" value="Submit" /></td>
</tr>
</tbody>
</table>
</form>
<p> </p>
</div>
</div>
</div>
<div class="clear"></div>
</div>
</div>
<?php
include("adfooter.php");
?>
<script type="application/javascript">
var alphaExp = /^[a-zA-Z]+$/; //Variable to validate only alphabets
var alphaspaceExp = /^[a-zA-Z\s]+$/; //Variable to validate only alphabets and space
var numericExpression = /^[0-9]+$/; //Variable to validate only numbers
var alphanumericExp = /^[0-9a-zA-Z]+$/; //Variable to validate numbers and alphabets
var emailExp = /^[\w\-\.\+]+\@[a-zA-Z0-9\.\-]+\.[a-zA-z0-9]{2,4}$/; //Variable to validate Email ID
function validateform()
{
if(document.frmdept.departmentname.value == "")
{
alert("Department name should not be empty..");
document.frmdept.departmentname.focus();
return false;
}
else if(!document.frmdept.departmentname.value.match(alphaspaceExp))
{
alert("Department name not valid..");
document.frmdept.departmentname.focus();
return false;
}
else if(document.frmdept.select.value == "" )
{
alert("Kindly select the status..");
document.frmdept.select.focus();
return false;
}
else
{
return true;
}
}
</script>