PHP Code:
<?php
$serverName = "(local)";
$connectionInfo = array( "Database"=>"account", "UID"=>"tiaguim", "PWD"=>"1234" );
$connectionInfo2 = array( "Database"=>"cash", "UID"=>"tiaguim", "PWD"=>"1234" );
$conn = sqlsrv_connect( $serverName, $connectionInfo);
$conn2 = sqlsrv_connect( $serverName, $connectionInfo2);
if( $conn === false ) {
die( print_r( sqlsrv_errors(), true));
}
//Random numero do ID de utilizador
$dk_time=strftime("%y%m%d%H%M%S");
list($usec1, $sec1) = explode(" ",microtime());
$dk_user_no=$dk_time.substr($usec1,2,2);
//Pegar valores do index
$UsuarioID = $_POST['input1'];
$Password = md5($_POST['input2']);
$Mail = $_POST['input3'];
$Pergunt = $_POST['input4'];
$Respost = $_POST['input5'];
//Botão Pressionado
if(isset($_POST['register'])){
$Loginsql = "select user_id from Tbl_user where user_id='$UsuarioID'";
$params2 = array();
$options = array( "Scrollable" => "buffered" );
$qLogin = sqlsrv_query($conn, $Loginsql, $params2, $options);
$rLogin = sqlsrv_num_rows($qLogin);
$Mailsql = "select user_mail from Tbl_user where user_mail='$Mail'";
$qEmail = sqlsrv_query($conn, $Mailsql, $params2, $options);
$rEmail = sqlsrv_num_rows($qEmail);
if(empty($UsuarioID) || empty($Password) || empty($Mail) || empty($Pergunt) || empty($Respost)) {
echo "Preencha todos os campos corretamente, volte para a página <a href='http://25.81.112.243/Ryudekaron.html'> inicial <a/>";
}
elseif($rLogin >= 1){
die("Esse usuario já existe, volte para a página <a href='http://25.81.112.243/Ryudekaron.html'> inicial <a/>");
}
elseif($rEmail >= 1){
die("Esse email já existe, volte para a página <a href='http://25.81.112.243/Ryudekaron.html'> inicial <a/>");
}
else{
//Dia hora data
$dia = (strftime("%x %X"));
//Tbl_user
$sql = "INSERT INTO Tbl_user (user_no, user_id, user_pwd, user_mail, user_answer, user_question, IP) VALUES (?,?,?,?,?,?,?)";
$params = array($dk_user_no, $UsuarioID, $Password, $Mail, $Respost, $Pergunt, null);
$stmt = sqlsrv_query( $conn, $sql, $params);
if( $stmt === false ) {
die( print_r( sqlsrv_errors(), true));
}
//USER_PROFILE
$sql2 = "INSERT INTO USER_PROFILE (user_no, user_id, user_pwd, resident_no, user_type, login_flag, login_tag, ipt_time, login_time, logout_time, user_ip_addr, server_id) VALUES (?,?,?,?,?,?,?,?,?,?,CAST('?' AS VARBINARY(4)),?)";
$params2 = array($dk_user_no, $UsuarioID, $Password, "801011000000", "1", "0", "Y", $dia, null, null, null, "000");
$stmt2 = sqlsrv_query( $conn, $sql2, $params2);
if( $stmt2 === false) {
die( print_r( sqlsrv_errors(), true));
}
//user_cash
$sql3 = "INSERT INTO user_cash (id, user_no, group_id, amount, free_amount) VALUES (?,?,?,?,?)";
$params3 = array($dk_user_no, $dk_user_no,"01","10000","0" );
$stmt3 = sqlsrv_query( $conn2, $sql3, $params3);
if ($stmt3 === false) {
die( print_r( sqlsrv_errors(), true));
}
Echo "Sua conta foi registada com sucesso!";
}
}
?>
