< !DOCTYPE HTML> 

<html>

<head>

    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">

<style>

.error {color: #FF0000;}

</style>

</head>

<body> 


<?php

// define variables and set to empty values

$Name = $Email = $ID = $PassWord = "";


if ($_SERVER["REQUEST_METHOD"] == "POST") {

   if (empty($_POST["Name"])) {

     $nameErr = "Name is required";

   } else {

     $Name = test_input($_POST["Name"]);

//      check if name only contains letters and whitespace

//     if (!preg_match("/^[a-zA-Z ]*$/",$Name)) {

//      $nameErr = "Only letters and white space allowed"; 

//     }

   }

   

   if (empty($_POST["Email"])) {

     $emailErr = "Email is required";

   } else {

     $Email = test_input($_POST["Email"]);

     // check if e-mail address is well-formed

     if (!filter_var($Email, FILTER_VALIDATE_EMAIL)) {

       $emailErr = "Invalid email format"; 

     }

   }


   if (empty($_POST["ID"])) {

     $idErr = "ID is required";

   } else {

     $ID = test_input($_POST["ID"]);

   }

    

    if (empty($_POST["PassWord"])) {

     $passwordErr = "PassWord is required";

   } else {

     $PassWord = test_input($_POST["PassWord"]);

   }

}


function test_input($data) {

   $>

   $>

   $>

   return $data;

}

?>


<h2>PHP Form Validation Example</h2>

<p><span class="error">* required field.</span></p>

<form method="post" action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?>"> 

   이름: <input type="text" name="Name">

   <span class="error">* <?php echo $nameErr;?></span>

   <br><br>

   이메일: <input type="text" name="Email">

   <span class="error">* <?php echo $emailErr;?></span>

   <br><br>

   아이디: <input type="text" name="ID">

   <span class="error">* <?php echo $idErr;?></span>

   <br><br>

    비밀번호: <input type="text" name="PassWord">

   <span class="error">* <?php echo $passwordErr;?></span>

   <br><br>

   <input type="submit" name="submit" value="확인">

    


</form>

    

    <?php

    

    echo "$Name";

    echo "<br>";

    echo "$ID";

    echo "<br>";

    echo "$PassWord";

    echo "<br>";

    echo "$Email";

    echo "<br>";

        

    $connect = mysql_connect($mysql_hostname, $mysql_username, $mysql_password) 

    or die("MySQL connection error!");

if(!$connect) echo "[Fail]<br/>"; else echo "<br/>";

    $sql = "insert into member";

    $sql.= "values('$Name','$ID','$PassWord','$Email')";

    

    mysql_query($sql, $connect);

    mysql_close($connect);

    

    

    

    ?>




</body>

</html>



이렇게 했는데 mysql에 데이터 삽입이안됩니다 회원가입 폼인데


이름 이메일 아이디 비밀번호치고 확인누르면 데이터삽입이안되요mysql에 그런데 홈페이지에서 확인밑에는 입력한정보들에 나와요 


해결방법좀..ㅠㅠ