Verifier l'insertion des données dans Mysql

echo'<div class="container"><br><div class="alert alert-success">
           <center>
<p><h2>INSCRIPTION COMPLETE</h2></p>

<p>Welcome '.stripslashes(htmlspecialchars($_POST['nickname'])).' you are now registered to our website</p>

<p>Click <a href="index" rel="nofollow noopener noreferrer" target="_blank">here</a> to go to index page</p>
     </center>
</div></div>';

$query=$db->prepare('INSERT INTO members (member_nickname, member_name, member_lname, member_password, member_email, member_registert)VALUES ($nickname, $name, $lname, $password, $email, $time)');
$query->bindValue(':nickname', $nickname, PDO::PARAM_STR);
$query->bindValue(':name', $name, PDO::PARAM_STR);
$query->bindValue(':lname', $lname, PDO::PARAM_STR);
$query->bindValue(':password', $password, PDO::PARAM_STR);
$query->bindValue(':email', $email, PDO::PARAM_STR);
$query->bindValue(':time', $time, PDO::PARAM_INT);
$query->execute();

if ($i==0)
{
echo'<div class="container"><br><div class="alert alert-success">
           <center>
              <p><h2>INSCRIPTION COMPLETE</h2></p>
     <p>Welcome '.stripslashes(htmlspecialchars($_POST['nickname'])).' you are now registered to our website</p>
     <p>Click <a href="index" rel="nofollow noopener noreferrer" target="_blank">here</a> to go to index page</p>
     </center>
     </div></div>';



//Successfuly logged in.

$query=$db->prepare('INSERT INTO members (member_nickname, member_name, member_lname, member_password, member_email, member_registert)VALUES ($nickname, $name, $lname, $password, $email, $time)');
$query->bindValue(':nickname', $nickname, PDO::PARAM_STR);
$query->bindValue(':name', $name, PDO::PARAM_STR);
$query->bindValue(':lname', $lname, PDO::PARAM_STR);
$query->bindValue(':password', $password, PDO::PARAM_STR);
$query->bindValue(':email', $email, PDO::PARAM_STR);
$query->bindValue(':time', $time, PDO::PARAM_INT);
$query->execute();

//SESSION v
$_SESSION['nickname'] = $nickname;
$_SESSION['id'] = $db->lastInsertId(); ;
$_SESSION['level'] = 0;
$query->CloseCursor();
}
else
{
 echo'<div class="container"><br><div class="alert alert-danger">
           <center>
              <p>Something went wrong please click<a href="register" rel="nofollow noopener noreferrer" target="_blank"> here </a>to try again</p>
     <p>If this error is showed many times please contact support</p>
     </center>
     </div></div>';
}