function adddata()
{
require '../include/config.php';
$name = $_POST['txtname'];
$detail = $_POST['txtdetail'];
$userid = $_POST['userid'];
$status = $_POST['status'];
$file = $_FILES['fle']['name'];
$file_tmp = $_FILES['fle']['tmp_name'];
$id = NewID('P', 'postid', 'post');
if ($file != "") {
//check_size($file_tmp);
$imgname = md5($file);
$dot = substr($file, -3, 3);
$pic_name = $imgname . "-" . time() . "." . $dot;
resize($file_tmp, $pic_name, 250, "../../images/post/tmp/");
copy($file_tmp, "../../images/post/{$pic_name}");
}
$insert = "INSERT INTO post(postid,postname,postdetail,postimg,user_id,status) \r\n \t\t\tVALUES('{$id}', '{$name}' , '{$detail}', '{$pic_name}' , '{$userid}', '{$status}')";
$dbCon->query($insert) or die($dbCon->error);
$dbCon->close();
//echo $insert;
header("Location: ../posts");
exit;
}
function adddata()
{
require '../include/config.php';
$name = $_POST['txtname'];
$code = $_POST['txtcode'];
$posision = $_POST['txtposision'];
$line = $_POST['txtline'];
$link = $_POST['txtlink'];
$datestart = $_POST['datestart'];
$dateend = $_POST['dateend'];
$status = $_POST['status'];
$file = $_FILES['fle']['name'];
$file_tmp = $_FILES['fle']['tmp_name'];
$id = NewID('BA', 'baid', 'banner_ads');
if ($file != "") {
//check_size($file_tmp);
$imgname = md5($file);
$dot = substr($file, -3, 3);
$pic_name = md5($id) . '_' . $imgname . "-" . time() . "." . $dot;
resize($file_tmp, $pic_name, 300, "../../images/banner/ads/tmp/");
copy($file_tmp, "../../images/banner/ads/{$pic_name}");
}
$insert = "INSERT INTO banner_ads(baid,baname,baimg,bacode,baline,baposition,balink,datestart,dateend,status) \r\n \t\t\tVALUES('{$id}', '{$name}','{$pic_name}', '{$code}' ,'{$line}','{$posision}','{$link}','{$datestart}','{$dateend}','{$status}')";
$dbCon->query($insert) or die($dbCon->error);
$dbCon->close();
//echo $insert;
header("Location: ../banner/bannerads");
exit;
}
function addData()
{
require '../include/config.php';
$fullname = $_POST['txtname'];
$email = $_POST['txtemail'];
$active_check = $_POST['status'];
$date_add = date("Y-m-d");
$id = NewID('N', 'member_id', 'member');
$insert = "INSERT INTO member(member_id,member_name,member_email,status) \r\n \t\t\tVALUES('{$id}', '{$fullname}' , '{$email}', '{$active_check}')";
$dbCon->query($insert) or die($dbCon->error);
$dbCon->close();
//echo $insert;
header("Location: ../member/newslater");
exit;
}
function addData()
{
require '../include/config.php';
$user_name = $_POST['txtusername'];
$user_pass = $_POST['txtuserpass'];
$idcard = $_POST['txtidcard'];
$name = $_POST['txtname'];
$surname = $_POST['txtsurname'];
$address = $_POST['txtaddress'];
$tel = $_POST['txttel'];
$email = $_POST['txtemail'];
$province = $_POST['txtprovince'];
$file = $_FILES['fle']['name'];
$file_tmp = $_FILES['fle']['tmp_name'];
$active_check = $_POST['status'];
$pageurl = $_POST['pageurl'];
$mtype = $_POST['mtype'];
$date_add = date("Y-m-d");
$id = NewID('M', 'member_id', 'member_register');
$mdpass = md5($user_pass);
$ckuser = checkuseradd($user_name);
if ($ckuser > 0) {
?>
<script type="text/javascript">
alert("Username มีผู้ใช้งานอยู่แล้ว กรุณาเปลี่ยน Username ใหม่!!!");
window.history.back();
</script>
<?php
exit;
} else {
if ($file != "") {
//check_size_user($file_tmp);
$imgname = md5($file);
$dot = substr($file, -3, 3);
$pic_name = $id . '_' . $imgname . "_" . $date_add . "." . $dot;
resize($file_tmp, $pic_name, 200, "../../images/member/tmp/");
copy($file_tmp, "../../images/member/{$pic_name}");
}
$insert = "INSERT INTO member_register(member_id,member_name,member_surname,member_address,provincecode,id_card,member_phone,member_email,member_username,member_pass,member_pass2,member_img,{$mtype},status_active) \r\n \t\t\tVALUES('{$id}', '{$name}' ,'{$surname}','{$address}','{$province}','{$idcard}','{$tel}','{$email}','{$user_name}', '{$mdpass}' ,'{$user_pass}' ,'{$pic_name}' , '1' , '{$active_check}')";
$dbCon->query($insert) or die($dbCon->error);
$dbCon->close();
//echo $insert;
header("Location: ../member/{$pageurl}");
exit;
}
}
