session_start(); $host = "localhost"; //$user = "root"; //$pass = "1"; $user = "logisticsn_db"; $pass = "3ttLRXDs"; $con = mysql_connect($host,$user,$pass); if (!$con) { die(': ' . mysql_error()); }else{ mysql_select_db("logisticsn_db", $con); mysql_query("SET NAMES utf8"); } ?>
|
|
|
|
|||||||||||||||||
|
|
|
||||||||||||||||||
|
|
|||||||||||||||||||
|
|
|||||||||||||||||||
|
|
|||||||||||||||||||
|
if($_GET["name"] && $_GET["lname"] && $_GET["telephone"] && $_GET["email"] && $_GET["pass"]){
$memberid = "ln".time();
$_SESSION['mail'] = $_GET["email"];
$sql = "INSERT INTO member(id, name, lname, email, pass, position, company,
homeno, road, district1, district2, province, postcode, telephone, fax, taxid, companytype, companyother, subscribe, membertype, bookstart, registerdate, startdate, enddate)
VALUES('".$memberid."','".$_GET['name']."','".$_GET['lname']."','".$_GET['email']."','".sha1($_GET['pass'])."','".$_GET["position"]."','".$_GET['company']."','".$_GET['homeno']."','".$_GET['road']."','".$_GET['district1']."','".$_GET['district2']."','".$_GET['province']."','".$_GET['postcode']."','".$_GET["telephone"]."','".$_GET["fax"]."','".$_GET["taxid"]."','".$_GET["companytype"]."','".$_GET["companyother"]."','".$_GET["subscribe"]."','".$_GET["membertype"]."','".$_GET["bookstart"]."',now(),now()";
if($_GET["membertype"]=="3") $sql .= ",DATE_ADD(NOW(),INTERVAL 6 DAY ))"; else $sql .= ",now())";
if(mysql_query($sql)){
?>
}else{
?>
}
}
?>
|
|
||||||||||||||||||
|
|
|||||||||||||||||||
|
|
|
|
|
||||||||||||||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|||