can't get single quotes in MS access

Hi there, 

I'm very new with PHP and havong troubles with single quotes when I try to write them to a ms access database.  

This is my test code so far. It all works if the single quote is removed from $test. 

<?php
$test = "arjan'pollski"; 

$conn=odbc_connect('starmakertest2','','');
if (!$conn)
  {exit("Connection Failed: " . $conn);}
$sql="UPDATE starmaker1test SET ID = '$kommatest' WHERE Id1 = 383";
$rs=odbc_exec($conn,$sql);
if (!$rs)
  {exit("Error in SQL");}
?>

[Reply] [Back to Top]

extra info

I've been working with addslashes etc but the db still doesnt take it, while there are slashes added to the string when I did that. 

I hope someone knows a solution to my problem. 

Thanx in advance 

Arjan

[Reply] [Back to Top]

hardcode the string into $test

Hi Arjan, 

Have you tried putting a slash before the ' into $kommatest? 

For example, does the DB return error when you set 

$kommatest='It\'s a fine day';

[Reply] [Back to Top]

the solution

I, ve found the solution to my problem.  

here it is... 

<?php
$newtest = str_replace("'","’",$_POST[kortenaam]);  

$conn=odbc_connect('starmakertest2','','');
if (!$conn)
  {exit("Connection Failed: " . $conn);}
$sql="UPDATE starmaker1test SET ID = '$newtest' WHERE Id1 = $_POST[idnummer]";
$rs=odbc_exec($conn,$sql);
if (!$rs)
  {exit("Error in SQL");} 

echo "$_POST[kortenaam]";
?> 

This strips the $string from its qoute and replaces it with it's html entity. Maybe a "russian" solution but it works

[Reply] [Back to Top]