 |
|
หน้าบันทึกข้อมูลสมาชิก อันนี้แก้เฉพาะส่วน save
Code (PHP)
<?php
if ($action=='savenew'){
$member_name =$_POST[$txtmember_name] ;
$member_lastname=$_POST[$txtmember_lastname] ;
$member_sex = $_POST[$radiosex];
$member_brithday = $_POST[ThaiDateTcomSql($txtmember_brithday)];
$member_address = $_POST[$txtmember_address] ;
$member_aumphur = $_POST[$txtmember_aumphur];
$member_province = $_POST[$txtmember_province];
$member_zipcode = $_POST[$txtmember_zipcode];
$member_tel = $_POST[$txtmember_tel];
$member_mobile = $_POST[$txtmember_mobile];
$member_fax = $_POST[$txtmember_fax];
$member_email = $_POST[$txtmember_email];
$member_user = $_POST[$txtmember_user];
$member_pwd = $_POST[$txtmember_pwd];
$sqlmem="select * from members where member_user='$member_user' ";
//echo $sqlmem ;
$resulmem=mysql_query($sqlmem);
while($rowmem=mysql_fetch_array($resulmem)){
$temp = $rowmem[member_user];
}
//echo $temp ;
$sql="insert into members ";
$sql= $sql." (member_name, member_lastname ,member_sex,member_brithday ," ;
$sql= $sql." member_address,member_aumphur,member_province,member_zipcode,";
$sql= $sql." member_tel , member_mobile , member_fax , member_email , member_user , member_pwd ) ";
$sql= $sql." values('$member_name', '$member_lastname' ,'$member_sex',$member_brithday ," ; l." '$member_address','$member_aumphur','$member_province','$member_zipcode',";
$sql= $sql." '$member_tel' , '$member_mobile' , '$member_fax' , '$member_email' , '$member_user' , '$member_pwd' ) ";
//echo $sql ;
}
if ($action=='edit'){
$temp = "";
$member_idedit = $txtmember_id ;
$member_name =$txtmember_name ;
$member_lastname=$txtmember_lastname ;
$member_sex = $radiosex;
$member_brithday = ThaiDateTcomSql($txtmember_brithday);
$member_address = $txtmember_address ;
$member_aumphur = $txtmember_aumphur;
$member_province = $txtmember_province;
$member_zipcode = $txtmember_zipcode;
$member_tel = $txtmember_tel;
$member_mobile = $txtmember_mobile;
$member_fax = $txtmember_fax;
$member_email = $txtmember_email;
$member_user = $txtmember_user;
$member_pwd = $txtmember_pwd;
$sql="update members ";
$sql= $sql."Set member_name ='$member_name' , ";
$sql= $sql."member_lastname= '$member_lastname' ,";
$sql= $sql."member_sex = '$member_sex' ,";
$sql= $sql."member_brithday = $member_brithday ," ;
$sql= $sql." member_address = '$member_address' ,";
$sql= $sql."member_aumphur ='$member_aumphur',";
$sql= $sql."member_province = '$member_province',";
$sql= $sql."member_zipcode = '$member_zipcode',";
$sql= $sql." member_tel= '$member_tel',";
$sql= $sql." member_mobile='$member_mobile' ,";
$sql= $sql." member_fax='$member_fax' , ";
$sql= $sql."member_email='$member_email' ,";
$sql= $sql." member_pwd='$member_pwd' ";
$sql= $sql." Where member_id= $member_idedit " ;
}
//echo $sql ;
if ($temp =="") {
$result=mysql_query($sql);
}
if($result){
$mem_id=mysql_insert_id();
session_register("mem_id");
//echo $mem_id ;
?>
<table width="100%" height="100" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td align="center">บันทึกข้อมูลสมาชิกเรียบร้อยแล้ว <br>
กรุณารอสักครู่ Loding....</td>
</tr>
</table>
<?
}
else
{
?>
<table width="100%" height="100" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td align="center">ไม่สามารถบันทึกข้อมูลการสมัครสมาชิกได้ <br>
<? if ($temp !="") { echo "เนื่องจากมีชื่อผู้ใช้งานในระบบอยู่แล้ว" ;}?><br>กรุณารอสักครู่ Loding....</td>
</tr>
</table>
<?
}
mysql_close();
?>
|
 |
 |
 |
 |
| Date :
2009-07-11 13:36:40 |
By :
มือใหม่ |
|
 |
 |
 |
 |
|
|
 |
