<?php

	$odbc_dsnname = "ini3_py_account";
	$odbc_dsnuser = "sa";
	$odbc_dsnpass = "123456";



        	$user_to_add = $_POST['login'];
        	$user_password = $_POST['senha'];
        	$sex = $_POST['select'];
			$dataniver = $_POST['aniversario'];
			$cep = $_POST['cep'];
			$email = $_POST['email'];
			$pergunta = $_POST['pergunta'];
			$resposta = $_POST['resposta'];
			$nome = $_POST['nome'];
		    $sobrenome = $_POST['sobrenome'];


        $connection = odbc_connect($odbc_dsnname, $odbc_dsnuser, $odbc_dsnpass) or die ( "Could Not Connect to ODBC Database!" );


	if(!($connection))
	{
		echo "Conectado com sucesso";
	}
	else
	{
		echo "error";
		if($resource = odbc_exec($connection, "exec SP_PANGYA_REGIST '10', '$sex', '$dataniver', '$cep', '$user_to_add', '$user_password', '$email', '$pergunta', '$resposta', '$nome', '$sobrenome'"))
		{
			print('');
			odbc_exec($connection, "exec SP_PANGYA_ACTIVATE '$user_to_add'");
		}
	}