sign ' is bounced by mysql

[Anon]

When i insert a ' in my text, as in foto's or another word within a textfield of a form, the database does not accept the new record.
Is there a way to handle this problem, or does somebody know what might be wrong??????

[livetek]

Hello
This problem is because ' is treated as end of input string in database so it creates problem so to insert ' you have to put a slash before ' like \' and this will work properly.
You can use an inbuilt function provided by PHP

string addslashes (string str)

$str="It's my string";
$newstr=addslashes ($str)

which will add slashes before all ' and take you out of trouble or other wise you can have an alternative solution by using string replace function you can replace all the ' with \'

mixed str_replace (mixed search, mixed replace, mixed subject)

$newstr = str_replace ("'", "\'", $str);

From Neetika

[Anon]

hi,

I think this might help u:

<?php

//Connection to mysql
$link = mysql_connect("localhost", "root", "rootmysql")
or die ("Could not connect");

//Connection to database
mysql_select_db ("test")
or die ("Could not select database");

$name="preetha's";

/Here addslashes fn. is used. It escapes
special characters like ' by adding slashes/
$name=addslashes($name);

$query = "insert into name values ('$name')";
$result = mysql_query ($query)
or die ("Query failed");
?>