sample/coa_create_php.php at master · Developmenteam30/sample · 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
<?php
include('db.php');


/*********************************************************************************************/
/*********************************************************************************************
										CREATE CHART OF ACCOUNT
*********************************************************************************************/
/*********************************************************************************************/
$code = $_POST['code'];
$accounts_name = $_POST['accounts_name'];
$group = $_POST['group'];

if($_POST['group'] == 'Income'){
$group2 = 'idiscount';
}elseif($_POST['group'] == 'Expenses'){
$group2 = 'ediscount';
}


if($_POST['group'] == 'Income' || $_POST['group'] == 'Expenses'){
$sqli="INSERT INTO `coa_list` (`code`, `accounts_name`, `group`, `group2`, `company_email`) VALUES ('$code', '$accounts_name', '$group', '$group2', '$company_email')";
$cccc = mysqli_query($conn, $sqli);
echo "Error: " . $sqli . "<br>" . mysqli_error($cccc);
}else{
$sql="INSERT INTO `coa_list` (`code`, `accounts_name`, `group`, `company_email`) VALUES ('$code', '$accounts_name', '$group','$company_email')";
$cccc = mysqli_query($conn, $sql);
    echo "Error: " . $sql . "<br>" . mysqli_error($cccc);
}