include 'config/header.php';
?>
| Network Name |
Manufacturer |
Model |
CPU |
RAM |
HDD |
Serial No. |
Location |
Main User |
Purchase Date |
Warranty End Date |
Cost When New |
Other Notes | Delete? |
include 'config/db.php';
mysql_connect($host,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM stafflaptops";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
echo "Inventory
";
$i=0;
while ($i < $num) {
$networkname=mysql_result($result,$i,"Network Name");
$make=mysql_result($result,$i,"Manufacturer");
$model=mysql_result($result,$i,"Model");
$cpu=mysql_result($result,$i,"CPU");
$ram=mysql_result($result,$i,"RAM");
$hdd=mysql_result($result,$i,"HDD");
$serial=mysql_result($result,$i,"Serial");
$location=mysql_result($result,$i,"Location");
$mainuser=mysql_result($result,$i,"Main User");
$purchdate=mysql_result($result,$i,"Purchase Date");
$wardate=mysql_result($result,$i,"Warranty End");
$cost=mysql_result($result,$i,"Cost When New");
$notes=mysql_result($result,$i,"Notes");
?>
| echo $networkname; ?> |
echo $make; ?> |
echo $model; ?> |
echo $cpu; ?> |
echo $ram; ?> |
echo $hdd; ?> |
echo $serial; ?> |
echo $location; ?> |
echo $mainuser; ?> |
echo $purchdate; ?> |
echo $wardate; ?> |
echo $cost; ?> |
echo $notes; ?> |
Delete | ; ?>