title: inserting data error code 23000 mysql pdo php
body: <p>i have a table in my databse</p>
  
  <p>i am trying to insert some data inside it</p>
  
  <p>but i keep getting pdo error code 23000</p>
  
  <p>i tried the query manually and it worked so the proplem isn't with the query</p>
  
  <p>my code : </p>
  
  <pre><code>&lt;?
  include ('config.php');
  $text=$_POST['text'];
  if (!isset ($text)) exit();
  $query=$db-&gt;prepare("INSERT INTO posts (post,userid,votes) VALUES (?,?,0)");
  $query-&gt;bindValue(1,$text,PDO::PARAM_STR);
  $query-&gt;bindValue(2,$id,PDO::PARAM_INT);
  $re=$query-&gt;execute();
  if ($re)
  echo 'Added';
  else die($query-&gt;errorcode()." ".$query-&gt;errorinfo());
  ?&gt;
  </code></pre>
  
  <p>and config look like </p>
  
  <pre><code>&lt;?
  session_start();
  try{
  $db=new PDO ('mysql:host=localhost;dbname=test;charset=utf8','root','');
  }
  catch (PDOException $error) {
      echo $error-&gt;getmessage();
  }
  $id=$_SESSION['id'];
  $username=$_SESSION['username'];
  $password=$_SESSION['password'];
  ?&gt;
  </code></pre>