Untitled

<!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="UTF-8">
	<title></title>
	<style>
		form{
			width: 400px;
			height: 600px;
			border: 1px solid black;
			display: block;
			margin: 0 auto;
		}
		span{
			display: block;
		}

	</style>
</head>
<body>

<?php
    // A simple PHP script demonstrating how to connect to MySQL.
    // Provides a form for adding, and deleting a student record to the database

    $servername = getenv('IP');
    $username = getenv('JSMITH');
    $password = "1234";
    $database = "JSMITH";
    $dbport = 3306;

    // Create connection
    $db = new mysqli($servername, $username, $password, $database, $dbport);

    // Check connection
    if ($db->connect_error) {
        die("Connection failed: " . $db->connect_error);
    }
    echo "Connected successfully (".$db->host_info.")";

    $thisPHP = $_SERVER['PHP_SELF'];
    echo <<<EOE
    <form action="$thisPHP" method="POST">
		Name:</span>
		<input type="text" name="Name"><br>

		<span>Address:</span>
		<input type="text" name="Address"><br>

		<span>Phone:</span>
		<input type="number" name="Phone_number"><br>

		<span>Email:</span>
		<input type="text" name="Email">

		<span>Avaliability:</span>
    	<input type="radio" name="Avaliable" value="Now">Now: (&lt; 1 Month) <br>
  		<input type="radio" name="Avaliable" value="Soon" >Soon: (1-3 months)<br>
 		<input type="radio" name="Avaliable" value="Exploring">Upcoming: (3+ months)<br>


        <span>Company:</span>
        <input type="text" name="Company"><br>

		<span>Job:</span>
		<input type="text" name="Job"><br>

		<span>Description:</span>
		<input type="text" name="Description"><br>

		<span>Skills</span>
		<select name="Skill">
			<option value="SQL">SQL</option>
			<option value="Java">Java</option>
			<option value="HTML">HTML</option>
			<option value="Javascript">Javascript</option>
			<option value="C++">C++</option>
			<option value="C#">C#</option>
			<option value="XML">XML</option>
			<option value="C">C</option>
			<option value="Perl">Perl</option>
			<option value="Python">Python</option>
			<option value="PHP">PHP</option>

		</select>

		<span>Experience:</span>
		<select name="Period">
		<option value="0" >0</option>
		<option value="1-3">1-3</option>
		<option value="3-5">3-5</option>
		<option value="5-10">5-10</option>
		<option value="10+">10+</option>
		</select>
		<br>

		<span>Position:</span>
		<input type="radio" name="Position" value="Team-Member" >Team-Member<br>
		<input type="radio" name="Position" value="Team Leader">Team Leader<br>
		<input type="radio" name="Position" value="Executive">Executive<br>
		<input type="submit" name="Add" value="Add"><br>

    </form>
EOT;

    // Start executing the script
    {
    $Name = $_POST["Name"];
    $Address = $_POST["Address"];
    $Phone = $_POST["Phone"];
    $Email = $_POST["Email"];
    $Availability = $_POST['Availability'];
    $Company = $_POST["Company Name"];
	$Job = $_POST['Job Title'];
	$description = $_POST['Description'];
	$Skill = $_POST['Skill'];
	$Period = $_POST['Period'];
	$Position = $_POST['Position'];
    $Update=$_POST["Update"];

 if(!empty($Name)){
	$sql="INSERT INTO employee(Name, Address, Phone, Email, Availability, Company Name, Job Title, Description, Skill, Period, Position)
	VALUES ('$Name','$Address','$Phone','$Email','$Avaliabilty','$Company','$Job','$Description','$Period','$Skill','$Position')";
	if($db->query($sql) == TRUE){
		echo ("Record added");
	}


}
 if (isset($Update)){
	$sql="UPDATE employee SET Address='$Address',Phone='$Phone',Email='$Email',Availability='$Availability',Company='$Company',Job='$Job',Description='$Description',Skill = '$Skill',Period='$Period',Position='$Position' WHERE Name='$Name' ";
	$db->query($sql);

  }
    $db->close();
?>