require('conn.php');
$id = $_POST["id"];
$pw = $_POST["pw"];
$name = $_POST["name"];
$jumin = $_POST["jumin"];
$email = $_POST["email"];
$tel = $_POST["tel"];
$sql="insert into id (id, pw, name, jumin, email, tel)
values (:v_id, DBMS_CRYPTO.Hash(to_clob(to_char(:v_id||:v_pw)),2), :v_name, DBMS_CRYPTO.Hash(to_clob(to_char(:v_jumin)),2), :v_email, :v_tel)";
// echo("$sql");
$result=oci_parse($conn,$sql);
oci_bind_by_name($result, ":v_id", $id);
oci_bind_by_name($result, ":v_pw", $pw);
oci_bind_by_name($result, ":v_name", $name);
oci_bind_by_name($result, ":v_jumin", $jumin);
oci_bind_by_name($result, ":v_email", $email);
oci_bind_by_name($result, ":v_tel", $tel);
$re=oci_execute($result);
oci_free_statement($result);
oci_close($conn);
if(!$re)
{ echo("
");
exit;
}
else
echo(" ");
?>