Checkbox checked insert or update to database(mySQL)

<form action="nameofphpscript.php" method="post">
    Want to go home?
    <input type="checkbox" id="homepage" name="homepage" value="1" />
    <input type="submit" name="formSubmit" value="Submit" />
</form>

<?php

$status = '0';

if(isset($_POST['homepage']) && $_POST['homepage'] == '1')
{
	$status = $_POST['homepage'];
}

$mysqli = new mysqli('localhost', 'username', 'password', 'databasename');
 
// check connection
if (mysqli_connect_errno()) {
        printf("Connect failed: %s\n", mysqli_connect_error());
        exit();
}
 
// assuming there is a checkstatus field in the table
$stmt = $mysqli->prepare("UPDATE tablename SET checkstatus =  ? WHERE userid = 'bill123'");

$stmt->bind_param('s', $status);
 
// execute prepared statement
$stmt->execute();
 
// close statement
$stmt->close();
 
// close connection
$mysqli->close();

?>