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
|
<?php
require_once('check_login.php');
$messgae = "";
if(empty($_POST["code"])){
$messgae .= "Please enter RA code.\\n\\n";
}else{
//check if ra code duplicate
$sql = "select * from ra_code where code = ? and deleted = ?";
$parameters = array($_POST["code"], 0);
$result = bind_pdo($sql, $parameters, "selectall");
if(!empty($result)){
$messgae .= "The RA code you enter already exists";
}
}
if(empty($_POST["company_name_en"])){
$messgae .= "Please enter company name.\\n\\n";
}
/*if(empty($_POST["company_address_en"])){
$messgae .= "Please enter company address.\\n\\n";
}*/
if(!empty($messgae)){
echo "<script>alert('".$messgae."'); history.back();</script>";
exit;
}
$sql = "insert into ra_code set code =?, createdate=?, createby=?, lastupdate=?, lastupby=?, ";
$parameters = array($_POST["code"], $nowdate, $_SESSION['cmsloginid'], $nowdate, $_SESSION['cmsloginid']);
foreach ($arraylangcode as $langcode => $langname) {
//$sql .= "company_name_" . $langcode . "=?, company_address_" . $langcode . "=?, ";
$sql .= "company_name_" . $langcode . "=?, ";
$parameters[] = $_POST["company_name_" . $langcode];
//$parameters[] = $_POST["company_address_" . $langcode];
}
$sql = substr_replace($sql, "", -2);
bind_pdo($sql, $parameters);
$dbh = null;
header("Location: ra_code_index.php?msg=1");
|