Hello all ive been following a tutorial from youtube to try achive what im wanting heres the link PHP and MySQL with MySQLi: Example Application (Part 8/9) - YouTube

I host a game server and want to keep a log of how many times a player is kicked so that after x times i can ban them. Using the video above i've tweaked it to what i thought was right and with some googling to get what i was wanting

so far i have it so it connects to my db and selects the table. But the php for doesn't seem to update or add in anything to the table. the page will only be accessed by me and a trusted friend so if you think im overkilling it please let me know.

The form is meant to let a user (ie me) input a players In Game Name, which gets inserted into the database and adds a 1 to the kick amount with a timestamp of when the last action was.
Heres my code

INDEX.PHP:-

Code:
<?php
//error_reporting(0);
require ('connect.php');
require ('security.php');

$records = array();

if(!empty($_POST)) {
	if(isset($_POST['ign'])) {
		$ign = trim($_POST['ign']);
		
		if(!empty($ign)) {
			$insert = $db->prepare("INSERT INTO people (ign, when) VALUES (?, NOW())");
			$insert->bind_param('s', $ign);
			$kickup = $db->query("UPDATE `mydb`.`people` SET `kicks` = kicks + 1 WHERE `people`.`ign` = $ign;");
			
			if($insert->execute()){
				header('Location: index.php');
				die();
			}
		}
		
	}
	
}

if($results = $db->query("SELECT * FROM people")) {
	if($results->num_rows) {
		while($row = $results->fetch_object()) {
			$records[] = $row;
		}
		$results->free();
	}
}



?>
<!DOCTYPE html>
<html>
	<head>
    	<title>Ban List</title>
    </head>
    <body>
    	<h3>Ban List</h3>
		<?php
		if(count($records)) {
			echo 'No Records';
		} else {
		
		?>
          <table>
              <thead>
                  <tr>
                      <th>In Game Name</th>
                      <th>Kicks</th>
                      <th>Last Kick</th>
                  </tr>
              </thead>
              <tbody>
              	<?php
				foreach($records as $r) {
				  ?>
					<tr>
						<td><?php echo escape($r->ign); ?></td>
						<td><?php echo escape($r->kicks); ?></td>
						<td><?php echo escape($r->when); ?></td>
					</tr>
                <?php
				}
				?>
              </tbody>
          </table>
        <?php
		}
		?>
        
        <hr>
        
        <form action="" method="post">
        	<div class="field">
            <label for="ign">In Game Name</label>
            <input type="text" name="ign" id="ign" autocomplete="off">
            </div>
            <input type="submit" value="Insert">
    </body>
</html>
CONNECT.PHP:-
Code:
<?PHP
$db = new mysqli('localhost','myuser','mypass','mydb');

if($db->connect_errono) {
	die('Sorry database connection issues.');

}

?>
SECURITY.PHP:-
Code:
<?PHP
function escape($string){
	return htmlentities(trim($string), ENT_QUOTES, 'UTF-8');
}
?>
MASSIVE THANKS to who can help me out!