Untitled

<?php include "../inc/dbinfo.inc"; ?>
<html>
<body>
<h1>Sample page</h1>

<?php
	/* Connect to MySQL and select the database. */
	$connection = mysqli_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD);
	if (mysqli_connect_errno())
		echo "Failed to connect to MySQL: " . mysqli_connect_error();

	$database = mysqli_select_db($connection, DB_DATABASE);
	/* Ensure that the Employees table exists. */
	VerifyEmployeesTable($connection, DB_DATABASE);
	/* If input fields are populated, add a row to the Employees table. */
	$employee_name = htmlentities($_POST['Name']);
	$employee_address = htmlentities($_POST['Address']);
	if (strlen($employee_name) || strlen($employee_address)) {
		AddEmployee($connection, $employee_name, $employee_address);
	}
?>


<!-- Input form -->
	<form action="<?PHP echo $_SERVER['SCRIPT_NAME'] ?>" method="POST">
		<table border="0">
			<tr>
				<td>Name</td>
				<td>Address</td>
			</tr>
			<tr>
				<td>
					<input type="text" name="Name" maxlength="45" size="30" />
				</td>
				<td>
					<input type="text" name="Address" maxlength="90" size="60" />
				</td>
				<td>
					<input type="submit" value="Add Data" />
				</td>
			</tr>
		</table>
	</form>
	<!-- Display table data. -->
	<table border="1" cellpadding="2" cellspacing="2">
		<tr>
			<td>ID</td>
			<td>Name</td>
			<td>Address</td>
		</tr>
<?php
	$result = mysqli_query($connection, "SELECT * FROM Employees");
	while($query_data = mysqli_fetch_row($result)) {
		echo "<tr>";
		echo "<td>" . $query_data[0] . "</td>" .
		"<td>" . $query_data[1] . "</td>" .
		"<td>" . $query_data[2] . "</td>";
		echo "</tr>";
	}
?>
</table>
<!-- Clean up. -->
<?php
	mysqli_free_result($result);
	mysqli_close($connection);
?>
</body>
</html>


<?php
/* Add an employee to the table. */
function AddEmployee($connection, $name, $address) {
	$n = mysqli_real_escape_string($connection, $name);
	$a = mysqli_real_escape_string($connection, $address);
	$query = "INSERT INTO `Employees` (`Name`, `Address`) VALUES ('$n', '$a');";
	if(!mysqli_query($connection, $query)) echo("<p>Error adding employee data.</p>");
}

/* Check whether the table exists and, if not, create it. */
function VerifyEmployeesTable($connection, $dbName) {
	if(!TableExists("Employees", $connection, $dbName))
	{
$query = "CREATE TABLE `Employees` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`Name` varchar(45) DEFAULT NULL,
`Address` varchar(90) DEFAULT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `ID_UNIQUE` (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1";

	if(!mysqli_query($connection, $query)) echo("<p>Error creating table.</p>");
	}
}

/* Check for the existence of a table. */
function TableExists($tableName, $connection, $dbName) {
	$t = mysqli_real_escape_string($connection, $tableName);
	$d = mysqli_real_escape_string($connection, $dbName);
	$checktable = mysqli_query($connection, "SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_NAME ='$t' AND TABLE_SCHEMA = '$d'");
	if(mysqli_num_rows($checktable) > 0) return true;
	return false;
}
?>