Tag:

Brand:

Model:

SN:

Purchased Date:

Supplier:

Price:

Company:

Department:

Dimenton:

Location:

User ID:

Status:
Transfer
New Damaged

User:


connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "SELECT * FROM mon"; if ($result = mysqli_query($conn, $sql)) { $rowcount = mysqli_num_rows($result); printf("Total Device: %d\n", $rowcount); } mysqli_close($conn) ?>

connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "SELECT * FROM mon ORDER BY musername"; $result = $conn->query($sql); if ($result->num_rows > 0) { // output data of each row while($row = $result->fetch_assoc()) { echo ""; } echo "

Tag	Brand	Model	SN	Purchsed Date	Supplier	Price	Company	Department	Dimention	Location	User ID	Status	User
". $row["mtag"]. "	" .$row["mbrand"]. "	" .$row["mmodel"]. "	" .$row["msn"]. "	" .$row["mpdate"]. "	" .$row["msupplier"]. "	" .$row["mprice"]. "	" .$row["mcompany"]. "	" .$row["mdepartment"]. "	" .$row["mdimention"]. "	" .$row["mlocation"]. "	" .$row["muserid"]. "	" .$row["mstatus"]. "	" .$row["musername"]. "

"; } else{ echo "0 result"; } ?>