db.php

WAR - consists the JSP/Servlet & demo pages

<?
$username="demo";
$password="demo";
$database="demo";

mysql_connect("localhost",$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM employees";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

echo "<b>MySQL database example:</b><br>";
echo "<b>Following output is from database:</b><br>";

$i=0;
while ($i < $num) {

$first=mysql_result($result,$i,"first");
$last=mysql_result($result,$i,"last");

echo "<b>$first $last</b>";

$i++;
}

?>