Page 1036 - 3-2

}
$result3 = mysqli_query($con,"SELECT inuse FROM test WHERE boxnum='3'");

$row3 = mysqli_fetch_array($result3);
$data3 = $row3[0];

if($data3 == "O") {
$box3 = "O";

}
else {

$box3 = "X";
}

echo "$box1$box2$box3";
mysqli_close($con);

?>

******************** < select.php > ***********************************
<?php

$con=mysqli_connect("127.0.0.1","root","raspberry","testbox");
if (mysqli_connect_errno($con)) {

echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

$username = $_POST['username'];
$userpassword = $_POST['userpassword'];

$result = mysqli_query($con,"SELECT boxnum FROM test WHERE username='$username'
and userpassword='$userpassword'");
$row = mysqli_fetch_array($result);

$data = $row[0];
echo $row[0];

mysqli_close($con);
?>

******************** < delete.php > ***********************************

<?php
$con=mysqli_connect("127.0.0.1","root","raspberry","testbox");

if (mysqli_connect_errno($con)) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();

}

- 1036 -