title: Can't find my registered details in the database
body: <p>I'm a newbie to php and have been having issues on a project.I created a database and a table,created the register page and everything seems ok.however,all the details entered on the register page aren't appearing in the database.please can anyone help debug?the php code is as shown below</p>
  
  <pre><code>&lt;?php 
  session_start(); 
  
  require_once('config.php'); 
  
  ?&gt; 
  
  &lt;?php 
  if (isset($_POST['register'])){ 
  $name = $_POST['name']; 
  $email = $_POST['email']; 
  $password = $_POST['password']; 
  $cpassword = $_POST['confirm_password']; 
  
  $sql = $con-&gt;query("INSERT into   'users' (id, name, email, 
  password,confirm_password) VALUES     ('', {$name}', '{$email}', 
  '{$password}', '{$cpassword}')"); 
  die ("cannot connect to database;"); 
  } 
  
  ?&gt; 
  
  CONFIG FILE: 
  &lt;?php 
  
  $con = mysqli_connect("localhost",       "root", "","knux"); 
  
  ?&gt; 
  </code></pre>