I couldn't find clear answer for this simple(?) question.
I recently moved to PDO and I made simple insert-query:
$sql = "INSERT INTO item(name) values (:name)";
$q = $db->prepare($sql);
$q->bindParam(':name', $name);
Now, when I throw parameter "Dina's", it's apparently converted to
"Dina's"
(or atleast this is what it seems in phpmyadmin).
Can I prevent this conversion somehow, so that data is stored as it was supplied on bindParam? Or is this current converted value the best way to have data stored?
This code converts nothing, you should check where $name comes from and what value it really has.