Page 1035 - 3-2

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

}
$boxnum = $_POST['boxnum'];

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

$inuse = $_POST['inuse'];
$result = mysqli_query($con,"INSERT INTO test(boxnum,username,userpassword,inuse)

values('$boxnum','$username','$userpassword','$inuse')");
mysqli_close($con);

?>

******************** < load.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();
}

$result1 = mysqli_query($con,"SELECT inuse FROM test WHERE boxnum='1'");
$row1 = mysqli_fetch_array($result1);

$data1 = $row1[0];
if($data1 == "O") {

$box1 = "O";
}

else {
$box1 = "X";

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

$row2 = mysqli_fetch_array($result2);
$data2 = $row2[0];

if($data2 == "O") {

$box2 = "O";
}

else {
$box2 = "X";

- 1035 -