<?php
            $host= "localhost";
            $user= getenv('C9_USER');
            $pass= "";
            $db= "c9";
            $port= "3306";

//create a connection
$db=mysqli_connect($host, $user, $pass, $db,$port);
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:<input type="text" name="Name" size="40" title="only underline allowed,the size must be 3 to 16 long numbers or characters " pattern="^[a-zA-Z0-9_-]{3,16}$" required ><br>
	Address:<input type="text" name="Address" title="validate address" required><br>
	Phone:<input type="number" name="Phone_number" size="10" title="xxx-yyy-zzzz, area code optional"   pattern="^(\d{3}-)?\d{3}-\d{4}$" required ><br>
	Email:<input type="text" name="Email" size="40" title="x@y.z, x and y can have . or -, z only 2 or 3 letters" pattern="^\w+([.-]?\w+)*(\.\w{2,3}})$" required>
	Avaliability:	<input type="radio" name="Avaliable" value="Now" checked required="required">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>
	Company:
		<input type="text" name="Company"><br>
	Job:
		<input type="text" name="Job"><br>
	Description:
		<input type="text" name="Description"><br>
	Skills:
		<select name="Skill" required>
			<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>

	Experience:
		<select name="period">
		<option value="0" checked required="required" >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>
	Position:
		<input type="radio" name="Position" value="Team-Member" checked required="required" >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>
		<input type="reset" name="reset" value="reset"><br>
		</form>

EOE;



//start executing the script
$name=$_POST['Name'];
$address=$_POST['Address'];
$phone_Number=$_POST['Phone_number'];
$email=$_POST['Email'];
$avaliable=$_POST['Avaliable'];
$company=$_POST['Company'];
$job=$_POST['Job'];
$description=$_POST['Description'];
$skill=$_POST['Skill'];
$period=$_POST['period'];
$pos=$_POST['Position'];

if(isset($_POST['Add'])){
	$sql="INSERT INTO employee(name, address, phone, email, availability, company_name, job_title, description, skill, period, position) VALUES ('$name','$address','$phone_Number','$email','$avaliable','$company','$job','$description','$skill','$period','$pos')";
	$db->query($sql);}

if(isset($_POST["Update"])){
	$sql="UPDATE employee SET address='$address',phone='$phone_Number',email='$email',availability='$avaliable',company_name='$company',job_title='$job',description='$description',skill='$skill',period='$period',position='$pos' WHERE name='$name' ";
	$db->query($sql);}

//check if delete is selected

if(isset($_POST['btnDelete'])){
	$name=$_POST['Name'];
	$sql="DELETE FROM employee WHERE name='$name'";
	$db->query($sql);}

$sql="SELECT * FROM employee";
$result=$db->query($sql);

if($result->num_rows >0){
	//output data of each row
	while($row =$result->fetch_assoc()){

			$name=$row["name"];
			$address=$row["address"];
			$phone_Number=$row["phone"];
			$email=$row["email"];
			$avaliable=$row["availability"];
			$company=$row["company_name"];
			$job=$row["job_title"];
			$description=$row["description"];
			$skill=$row["skill"];
			$period=$row["period"];
			$pos=$row["position"];

echo <<<EOE
	<form action="$thisPHP" method="post">
		Name:<input type="text" name="Name" value='$name' readonly><br>
		Address:<input type="text" name="Address" value='$address'><br>
		Phone:<input type="number" name="Phone_number" value='$phone_Number'><br>
		Email:<input type="text" name="Email" value='$email'>
		Avaliability:<input type="radio" name="Avaliable" value='$avaliable' checked>$avaliable<br>
		Company:<input type="text" name="Company" value='$company'><br>
		Job:<input type="text" name="Job" value='$job'><br>
		Description:<input type="text" name="Description" value='$description'><br>

		<span>Skills</span>
		<select name="Skill">
			<option value='$skill'>$skill</option>
		</select>

		<span>Experience:</span>
		<select name="period">
		<option value='$period'>$period</option>
		</select>
		<br>

		<span>Position:</span>
		<input type="radio" name="Position" value='$pos' checked >$pos<br>
		<input type="submit" value="update" name='Update'><br>
		<input type="submit" value="Delete" name="btnDelete"><br>
		</form>
EOE;
	}
}
 ?>
 </body>
</html>