PHP Code:
<?php
$db_username = "alef";
$db_password = "password";
$db = "oci:dbname=account";
$conn = new PDO($db,$db_username,$db_password);
?><center>
<form id="reg" name="reg" method="post" action="">
<font color="white">Username</font><br />
<input name="user" type="text" class="txt" id="path" size="30"
<br /><br />
<font color="white">password</font><br />
<input name="pass" type="password" class="txt" id="author" size="30" />
<br />
<input name="submit" type="submit" class="btn" id="button" value="Register" /></center>
</form>
<?php
if($_POST['submit']){
$date = date("d.m.Y");
$user = isset($_POST['user']) ? $_POST['user'] : false;
$pass = isset($_POST['pass']) ? $_POST['pass'] : false;
if($user && $pass){
$stmt = $conn->exec("INSERT INTO AMT_ACCOUNT (ACCOUNTID,PASSWORD) VALUES ('$user','$pass')");
$stmt2 = $conn->exec("INSERT INTO AMT_MASTER (ACCOUNTID,EMAIL,SOCIALNO,CREATION_DATE,LAST_DATE,MODIFY_DATE,PHONE,MOBILE,ZIPCODE,ADDR1,ADDR2,SMS_YN,EMAIL_YN,PENALTY_GBN,PAUSE_DATE,IP,LOGINCNT,NOMINATOR,RPG_LEVEL,LONEY_AGREEYN,LONEY_CHARGEYN,SEX) VALUES ('$user', '
', '14124123', TO_DATE('20130512143514', 'YYYYMMDDHH24MISS'), TO_DATE('20130512143520', 'YYYYMMDDHH24MISS'), TO_DATE('20130512143523', 'YYYYMMDDHH24MISS'), '141231', '123124124', '123123', '123', '123', '1', '1', '12', TO_DATE('20130512143543', 'YYYYMMDDHH24MISS'), '12', '123', '12', '12', '1', '1', '1')");
if($stmt && $stmt2){//22
echo "<script type=\"text/javascript\">
alert('Registration successful! You can play now!');
</script>";
}else{
echo "<script type=\"text/javascript\">
alert('Error: ');
</script>";
print_r($conn->errorInfo());
}
}else{
echo "<script type=\"text/javascript\">
alert('Empty field!');
</script>";
}
}
?>






