title: mysqli_stmt::bind_param(): Number of elements in type definition string doesn't match number of bind variables warning
body: <p>My codes for the prevention of SQL injection isn't working. Can anyone help me? </p>
  
  <p>I'm receiving this warning: 
  Warning: mysqli_stmt::bind_param(): Number of elements in type definition string doesn't match number of bind variables.</p>
  
  <p>Thanks.</p>
  
  <pre><code>$mysqli = new mysqli('localhost', 'root', '', 'Muproj');    
  $query="INSERT INTO tblmember VALUES (':id', ':uname' , ':passwrd' , ':name' , ':surname' ,':0' )";
  $stmt = $mysqli-&gt;prepare($query);
  $stmt-&gt;bind_param(':id', $newid);
  $stmt-&gt;bind_param(':uname', $C_uname);
  $stmt-&gt;bind_param(':passwrd', $C_passwrd);
  $stmt-&gt;bind_param(':name', $C_name);
  $stmt-&gt;bind_param( ':surname', $C_surname);
  $stmt-&gt;bind_param(':0', '0');
  $stmt-&gt;execute();
  $result=mysql_query($stmt);
  </code></pre>