-
Notifications
You must be signed in to change notification settings - Fork 3
/
designation_add.php
27 lines (23 loc) · 918 Bytes
/
designation_add.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
<?php
include_once 'config/config.php';
// var_dump($_POST);
$designationid = $_POST['designationid'];
$designationname = $_POST['designationname'];
$departmentname = $_POST['departmentname'];
$createddate = $_POST['createddate'];
$modifieddate = $_POST['modifieddate'];
$status = $_POST['status'];
$q = "INSERT INTO designation (`Designation_id`,`Designation_name`,`Department_name`,`Created_date`, `Modified_date`, `Status`) values('" . $designationid . "','" . $designationname . "','" . $departmentname . "','" . $createddate . "','" . $modifieddate . "','" . $status . "')";
if (mysqli_affected_rows($connection_obj) > 0) {
$data = mysqli_fetch_assoc($q);
header("location:./designation_count.php");
} else {
header("location:./500.php");
}
$status = mysqli_query($connection_obj, $q);
if ($status) {
header("location:./designation_count.php");
} else {
header("location:./500.php");
}
?>