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; } }