Untitled

<html>
<body>
<style>
table,th,td{
	border: 1px solid black;
}
</style>

<?php

 $username = "root";
 $password = "";
 $datab = "rentaltrax";

$con = new mysqli ('localhost', "$username","$password","$datab") or die ("unable to connect");

$sql="INSERT INTO rentaltrax (plateno,numdays,startdays,enddays,starttime,endtime) VALUES ('$_POST[platenumber]','$_POST[numberofdays]','$_POST[startingday]','$_POST[endingday]','$_POST[startingtime]','$_POST[endingtime]')";

if ($con->query($sql) ===  TRUE)
{
	$sql = "SELECT * FROM rentaltrax";
	$result = $con->query($sql);
	if ($result->num_rows > 0){
		echo "<table width=400><tr><th>Rental ID</th><th>Plate Number</th><th>Number of Days</th><th>Starting Day</th><th>Ending Day</th><th>Starting Time</th><th>Ending Time</th><th>Edit</th><th>Delete</th></tr>";
	while($row = $result->fetch_assoc()){
		echo "<tr><td>".$row["rentalID"]. "</td><td>".$row["plateno"]. "</td><td>".$row["numdays"]."</td><td>".$row["startdays"]."</td><td>".$row["enddays"]."</td><td>".$row["starttime"]."</td><td>".$row["endtime"]."</td> <td><a href='cn2.php?id=" . $row->id . "'>Edit</a></td></tr>";

	}
		echo "</table>";
	}
} else {
	echo "0 results";

}

$con->close();

?>
</body>
</html>