<?PHP

ini_set("display_errors","2");
ERROR_REPORTING(E_ALL);



	$dbhost = "127.0.0.1"; //The database server
	$dbuser = "root"; //Your HW account
	$dbpass = ""; //Your mysql password - your HW account by default
	$dbname = "farm"; //Database name is your HW account

	//Connect to database


	$conn = mysql_connect($dbhost, $dbuser, $dbpass);
	if (!$conn)
	{
		$description = "Database connection failed.";
	}
	else
	{
		//Get the database
		mysql_select_db($dbname);


		$query = "SELECT FarmName, FarmerName, Address, ClaimNo, RegionName, NoOfCows, NoOfBulls, NoOfSheep, Cereal, Oilseed, Linseed, Protein, PhoneNumber, CurrentSubsidyEntitlement FROM Farminfo;";

		$result = mysql_query($query);
		if (!$result)
		{
			die('Invalid query: ' . mysql_error());
		}
		else
		{
			//Print out all the modules
			$description = "<Assignments>";
			echo "<table>";

while ($row = mysql_fetch_row($result))
{



echo "<tr>";

echo "<td>".$row[0]."</td>";

echo "<td>".$row[1]."</td>";

echo "<td>".$row[2]."</td>";

echo "<td>".$row[3]."</td>";

echo "<td>".$row[4]."</td>";

echo "<td>".$row[5]."</td>";

echo "<td>".$row[6]."</td>";

echo "<td>".$row[7]."</td>";

echo "<td>".$row[8]."</td>";

echo "<td>".$row[9]."</td>";

echo "<td>".$row[10]."</td>";

echo "<td>".$row[11]."</td>";

echo "<td>".$row[12]."</td>";

echo "<td>".$row[13]."</td>";

echo "</tr>";
}
echo "</table">
			//Get one row
			$row = mysql_fetch_row($result);
			echo "Farm Name:  ".$row[0];
			echo  "Farmer Name:    ".$row[1];
			echo  "Address:    ".$row[2];
			echo  "Claim No:    ".$row[3];
			echo  "Region Name:    ".$row[4];
			echo "NoOfCows:".$row[5];
			echo "NoOfBulls:".$row[6];
			echo "NoOfSheep:".$row[7];
			echo "Cereal:" .$row[8];
			echo "Oilseed:" .$row[9];
			echo "Linseed:".$row[10];
			echo "Protein:".$row[11];
			echo "PhoneNumber:".$row[12];
			echo "CurrentSubsidyEntitlement:".$row[13];

			//Get all the rows
			while ($row = mysql_fetch_row($result))
			{
				echo "Farm Name:     ".$row[0]."<br />";
				echo "Farmer Name:     ".$row[1]."<br />";
				echo  "Address:     ".$row[2]."<br />";
				echo  "Claim No:    ".$row[3]."<br />";
				echo  "Region Name:    ".$row[4]."<br />";
				echo "NoOfCows:".$row[5]."<br />";
				echo "NoOfBulls:".$row[6]."<br />";
				echo "NoOfSheep:".$row[7]."<br />";
				echo "Cereal:" .$row[8]."<br />";
				echo "Oilseed:" .$row[9]."<br />";
				echo "Linseed:".$row[10]."<br />";
				echo "Protein:".$row[11]."<br />";
				echo "PhoneNumber:".$row[12]."<br />";
				echo "CurrentSubsidyEntitlement:".$row[13]."<br />";

			}


		}
	}
?>