Untitled

<html>

   <head>
      <title>Bartlomiej Daniel</title>
   </head>

   <body>


               <form method = "post" action = "home">
                  <table width = "400" border = "0" cellspacing = "1"
                     cellpadding = "2">

                     <tr>
                        <td width = "100">ImiÄ</td>
                        <td><input name = "name" type = "text"
                           id = "name"></td>
                     </tr>

                     <tr>
                        <td width = "100">Nazwisko</td>
                        <td><input name = "surname" type = "text"
                           id = "surname"></td>
                     </tr>

                     <tr>
                        <td width = "100">Wiek</td>
                        <td><input name = "age" type = "int"
                           id = "age"></td>
                     </tr>

                     <tr>
                        <td width = "100">Miejsce zamieszkania</td>
                        <td><input name = "hometown" type = "text"
                           id = "hometown"></td>
                     </tr>

                     <tr>
                        <td width = "100">Ulubiony kolor</td>
                        <td><input name = "color" type = "text"
                           id = "color"></td>
                     </tr>

                      <tr>
                        <td width = "100">PÅeÄ</td>
                        <td><input name = "gender" type = "text"
                           id = "gender"></td>
                     </tr>

                     <tr>
                        <td width = "100"> </td>
                        <td>
                           <input name = "add" type = "submit" id = "add"
                              value = "Dodaj">
                        </td>
                     </tr>

                  </table>
               </form>

<?php

         if(isset($_POST['add']))
			{
            $dbhost = 'localhost';
            $dbuser = 'pz78135';
            $dbpass = 'upiebah1Ie';
            $conn = mysql_connect($dbhost, $dbuser, $dbpass);

			if($conn)
			{
				die('BÅÄd poÅÄczenia z bazÄ danych: ' . mysql_error());
			}

            $name = mysqli_real_escape_string($conn, $_POST['name']);
            $surname = mysqli_real_escape_string($conn, $_POST['surname']);
            $age = mysqli_real_escape_string($conn, $_POST['age']);
			$hometown = mysqli_real_escape_string($conn, $_POST['hometown']);
			$color = mysqli_real_escape_string($conn, $_POST['color']);
			$gender = mysqli_real_escape_string($conn, $_POST['gender']);

            mysql_select_db('pz78135');
            $sql = "INSERT INTO Dane (name, surname, age, hometown, color, gender)
			VALUES('$name', '$surname', '$age', '$hometown', '$color', '$gender')";

            $a1 = mysql_query( $sql, $conn );

            if(! $a1 )
				{
					die('Nie moÅ¼na wpisaÄ danych: ' . mysql_error());
				}
					echo "Dodano jeden rekord\n";
            mysql_close($conn)
			} else
            {
				echo "Error";
			}
?>


   </body>
</html>