 |
|
พอดีทำระบบ สมาชิกครับ แล้ว เวลา ทำบน serve บนเครื่องแล้วสามารถ insert ได้ตามปกติ แต่พอขึ้น serve จิงๆๆ แล้วบางที่ได้ บางทีก็ไม่ได้ เป็นเพราะอะไรครับ งงง มากๆๆ หรือจะเป็นที่ serve ครับ ช่วยบอกหน่อยครับ
<?
function addmember(){
$email=$_REQUEST["email"];
$status=$_REQUEST["status"];
$total = $_REQUEST["total"];
$statcost = $_REQUEST["stat"];
$numpageId1=$_REQUEST["numpageId1"];
$numpage1=$_REQUEST["numpage1"];
$Tonumpage1=$_REQUEST["Tonumpage1"];
$numpageId2=$_REQUEST["numpageId2"];
$numpage2=$_REQUEST["numpage2"];
$Tonumpage2=$_REQUEST["Tonumpage2"];
$numpageId3=$_REQUEST["numpageId3"];
$numpage3=$_REQUEST["numpage3"];
$Tonumpage3=$_REQUEST["Tonumpage3"];
$numpageId4=$_REQUEST["numpageId4"];
$numpage4=$_REQUEST["numpage4"];
$Tonumpage4=$_REQUEST["Tonumpage4"];
$numpageId5=$_REQUEST["numpageId5"];
$numpage5=$_REQUEST["numpage5"];
$Tonumpage5=$_REQUEST["Tonumpage5"];
$statcost = $_REQUEST["stat"];
$pselect2 = $_REQUEST["pselect2"];
$pselectcost = $_REQUEST["pselect"];
$link=mysql_connect("localhost","","");
if (!$link)
{
echo "Error MySQL";
}
else
{
mysql_select_db("cemdata",$link);
$sql="select * from member where email='$email'";
$result = mysql_query($sql,$link);
$num =mysql_num_rows($result);
$query="INSERT INTO `member` (`email`,`status`,`price`,`numpaper`,`costpaper`,`pid1`,`pnum1`,`pcost1`,`pid2`,`pnum2`,`pcost2`,`pid3`,`pnum3`,`pcost3`,`pid4`,`pnum4`,`pcost4`,`pid5`,`pnum5`,`pcost5`,`totalcost`) VALUES ('$email','$status','$statcost','$pselect2','$pselectcost','$numpageId1','$numpage1','$Tonumpage1','$numpageId2','$numpage2','$Tonumpage2','$numpageId3','$numpage3','$Tonumpage3','$numpageId4','$numpage4','$Tonumpage4','$numpageId5','$numpage5','$Tonumpage5','$total')";
mysql_query( $query , $link );
mysql_close($link);
}
}//end add Member
$email=$_REQUEST["email"];
$email2=$_REQUEST["email2"];
$password=$_REQUEST["password1"];
$password2=$_REQUEST["password2"];
$status=$_REQUEST["status"];
$title=$_REQUEST["title"];
$firstname=$_REQUEST["firstname"];
$lastname=$_REQUEST["lastname"];
$affiliation=$_REQUEST["affiliation"];
$address=$_REQUEST["address"];
$phone1=$_REQUEST["phone1"];
$phone2=$_REQUEST["phone2"];
$country=$_REQUEST["country"];
$city=$_REQUEST["city"];
$idcard=$_REQUEST["idcard"];
$idcardANDPAssport=$_REQUEST["idcardANDPAssport"];
$flightno=$_REQUEST["flightno"];
$arivalTime=$_REQUEST["arivalTime"];
$hotel=$_REQUEST["hotel"];
$special=$_REQUEST["special"];
$totalcost=$_REQUEST["total"];
$link=mysql_connect("localhost","sccem","cemmath");
if (!$link)
{
echo "Error MySQL";
}
else
{
mysql_select_db("cemdata",$link);
$sql="select * from registeredit where email='$email'";
$result = mysql_query($sql,$link);
$num =mysql_num_rows($result);
if($num>0)
{
print("<br>");
print(" "." "." "." "." "." "." "." "." "." "." "." "." "." "." "." "." "." "." "." "." "." "." "." "." "." "." "." "."email นี้มีคนใช้แล้ว");
}
else
{
addmember();
$link=mysql_connect("localhost","sccem","cemmath");
mysql_select_db("cemdata",$link);
$query="INSERT INTO `registeredit` (`email`,`password`,`status`,`title`,`firstname`,`lastname`,`affiliation`,`address`,`phone1`,`phone2`,`country`,`city`,`idcard`,`idcardANDPAssport`,`flightno`,`arivalTime`,`hotel`,`special`,`totalcost`) VALUES ('$email','$password','$status','$title','$firstname','$lastname','$affiliation','$address','$phone1','$phone2','$country','$city','$idcard','$idcardANDPAssport','$flightno','$arivalTime','$hotel','$special','$totalcost')";
mysql_query( $query , $link );
mysql_close($link);
print(" "." "." "." "." "." "." "." "." "." "." "." "." "." "." "." "." "." "." "." "." "." "." "." "." "." "." "." "."Data has been recorded.");
print("<br>");
print "EMAIL ADDRESS :"." ".$email;
print("<br>");
//print "PASSWORD :"." ".$password;
//print("<br>");
print "Totalcost :"." ".$totalcost;
print("<br>");
print "Please wait,detail of your registration will be sent to you address.";
print("<br>");
// ส่งเมลล์
$email_from='http://www.sc.mahidol.ac.th/cem';
$subject='User & Password (http://www.sc.mahidol.ac.th/cem)?';
$header="from: $email_from";
$messages.= "Hello \n";
$messages.= "This email is for user and password \n\n";
$messages.= "---------------------------------------------------------------------\n";
$messages.= "user = $email \n";
$messages.= "password = $password \n";
$messages.= "Totalcost = $totalcost \n";
$messages.= "---------------------------------------------------------------------\n";
$messages.= "e-mail address and password are needed every time you sign in.\n";
$messages.= "please keep this e-mail. \n\n";
$messages.= "Thank you \n\n";
mail($email,$subject,$messages,$header);
print(" "." "." "."The password has been sent to $email");
print("<br>");
print(" "." "." "."Please check your Email. if you cannot find the message in your mailbox, please check your junk mails");
}
}
?>
Tag : - - - -
|
|
|
 |
 |
 |
 |
| Date :
2009-06-24 10:14:23 |
By :
pjax |
View :
1006 |
Reply :
1 |
|
 |
 |
 |
 |
|
|
|
|
 |
