include("../include/menu_webboard.php");?> |
 |
 |
|
 |
Home |
|
Member Register |
|
if($_REQUEST['action']=="register"){
//insert ข้อมูลลงไปเก็บแล้ว
$inputName=$_POST['inputName'];
$inputSurname=$_POST['inputSurname'];
$selectDate=$_POST['selectDate'];
$selectMonth=$_POST['selectMonth'];
$selectYear=$_POST['selectYear'];
$BirthDay = $selectYear."-".$selectMonth."-".$selectDate;
$inputSchool=$_POST['inputSchool'];
$inputClass=$_POST['inputClass'];
$inputIncome=$_POST['inputIncome']; //รายได้
$inputNumber=$_POST['inputNumber']; //บ้านเลขที่
$inputVillage=$_POST['inputVillage']; //หมู่บ้าน
$inputCondo=$_POST['inputCondo']; //COndo
$inputLane=$_POST['inputLane']; //ตรอก
$inputTombon=$_POST['inputTombon']; //ตำบล
$inputAmphur=$_POST['inputAmphur']; //อำเภอ
$inputProvince=$_POST['inputProvince']; //จังหวัด
$inputZipcode=$_POST['inputZipcode']; //Zipcode
$inputMobile=$_POST['inputMobile']; //เบอร์โทร
$inputAssume=$_POST['inputAssume'];
$inputEmail = str_replace('"',"",$_POST['inputEmail']);
$inputEmail = str_replace("'","",$_POST['inputEmail']);
$inputEmail = str_replace("#","",$_POST['inputEmail']);
$inputEmail=trim($_POST['inputEmail']); //Email
$inputPassword=$_POST['inputPassword']; //รหัสผ่าน
$file=$_FILES['inputImages']['tmp_name'];
$file_name=$_FILES['inputImages']['name'];
$file_size=$_FILES['inputImages']['size'];
$eNews = $_REQUEST['eNews'];
$insert = $table_member."_fname,".$table_member."_lname,".$table_member."_birthdate,".$table_member."_school,".$table_member."_class,".$table_member."_income,".$table_member."_number_house,".$table_member."_village,".$table_member."_condo,".$table_member."_lane,".$table_member."_district,".$table_member."_amphur,".$table_member."_province,".$table_member."_zipcode,".$table_member."_phone,".$table_member."_assume,".$table_member."_email,".$table_member."_password,".$table_member."_enews,".$table_member."_ip,".$table_member."_activate,".$table_member."_createdate,".$table_member."_lastupdate,".$table_member."_lastlogin,".$table_member."_language,".$table_member."_status";
$values = "'".$inputName."','".$inputSurname."','".$BirthDay."','".$inputSchool."','".$inputClass."','".$inputIncome."','".$inputNumber."','".$inputVillage."','".$inputCondo."','".$inputLane."','".$inputTombon."','".$inputAmphur."','".$inputProvince."','".$inputZipcode."','".$inputMobile."','".$inputAssume."','".$inputEmail."','".$inputPassword."','".$eNews."','".$ip."','yes',NOW(),NOW(),'','th','Member'";
$tmp = $obj_db->InsertRecord($table_member,$insert,$values);
$sql = "SELECT MAX(".$table_member."_ID) FROM ".$table_member;
$Query= $obj_db->SelectData($sql);
$Row=mysql_fetch_array($Query);
$MaxID = $Row[0];
// update images
$password = generatecode(2);
$now = date("Ymdgis");
$myrand=$now.$password;
if (!empty($_FILES['inputImages']['tmp_name'])) {
$rest = strrchr($_FILES['inputImages']['name'], ".");
$File_name = $MaxID."-".$myrand.$rest;
}else {
$File_name ="";
}
$where = $table_member."_id='$MaxID'";
$update =$table_member."_images='$File_name'";
$tmp = $obj_db->UpdateRecord($table_member,$update,$where);
if($tmp) {
if (!empty($_FILES['inputImages']['name'])) {
resizepicture($File_name,"../".$Path_Picture_Member,$file,$rest,100,100);
}
}
$Know = $_REQUEST['YouKnowWebsite'];
$source = $_REQUEST['inputSource'];
for($i =0;$i<=6;$i++){
//if(!empty($Know[$i])){
$insert = $table_member."_id,".$table_member_source."_name,".$table_member_source."_comment";
$values = "'".$MaxID."','".$Know[$i]."','".$source[$i]."'";
$tmp = $obj_db->InsertRecord($table_member_source,$insert,$values);
// }//end if
}//end for
?>
}else{?>
} ?>
|
|
|
|
|
 |
 |
|
$sql ="select * from ".$table_banner." where ".$table_banner."_status !='Offline' ORDER BY ".$table_banner."_id DESC";
$result=$obj_db->SelectData($sql);
if(mysql_num_rows($result)>0){
$row=mysql_fetch_array($result);
if($row[$table_banner."_images"]!=""){
$img = "../".$Path_Picture_Banner."/".$row[$table_banner."_images"];
}else{
$img = "../../images/home/default60.jpg";
}
?>
} ?>
|
|
 |
|