-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathpostExpense.php
More file actions
28 lines (24 loc) · 795 Bytes
/
postExpense.php
File metadata and controls
28 lines (24 loc) · 795 Bytes
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
<?php
session_start();
require('includes/config.php');
date_default_timezone_set('Asia/Kolkata');
$current_date_time = date("Y-m-d H:i:s");
$cat_id = $_POST['cat_id'];
$amount = $_POST['amount'];
$date = "";
$date = $_POST['expense_date'];
$user = $_POST['created_by'];
$cid = $_SESSION['cid'];
if( $user != ""){
$user= $user;
}else{
$user = $_SESSION['userid'];
}
$query = "insert into expenses( cat_id,amount,expense_date,created_by,created_at,cid ) values('".$cat_id."', ".$amount.",'". $date ."' ,".$user.", '".$current_date_time."', ".$cid.")" ;
$exe = mysqli_query($con,$query);
if( $exe ) {
echo json_encode( ['code' => 200,'data' => 'Expense added successfully', 'url' => 'expensesList' ] );
}else{
echo json_encode( ['code' => 405 , 'data' => 'Error Occured' ] );
}
?>