Insert

[guestabc]

Hi i'm trying to insert into my access database a comment from the user. Although this works fine i have discovered that special character brings out a error such as if the user types a ' how do i get around this? thanks

[gevans]

mysql_real_escape_string()

 

so

 

$foo = mysql_real_escape_string($_POST['name_from_form'])

[guestabc]

thanks not able to try now as my host is down argh!!!! just something i noticed. will give it a try in the morning thanks for your help

[gevans]

You should try installing php and Apache locally with something like xampp, then you can develop all you want!!

[guestabc]

yer i have it installed though only had my files on the online server. But i have them backed up now. I've tried the mysql_real_escape_string() however i get a connection error, I guess its because i'm using Access (don't ask why, its a requirement for the project).

[premiso]

yer i have it installed though only had my files on the online server. But i have them backed up now. I've tried the mysql_real_escape_string() however i get a connection error, I guess its because i'm using Access (don't ask why, its a requirement for the project).

 

As long as you have a mysql db setup, you just have to make a connection to that DB and do not necessarily have to use that db.

 

But if you do some googling you can find functions that "simulate" the mysql_real_escape_string in fact you may be able to find it in the comments on the page.

 

However it simulates it, it is not it. So yea.

[guestabc]

yer i have it installed though only had my files on the online server. But i have them backed up now. I've tried the mysql_real_escape_string() however i get a connection error, I guess its because i'm using Access (don't ask why, its a requirement for the project).

 

As long as you have a mysql db setup, you just have to make a connection to that DB and do not necessarily have to use that db.

 

But if you do some googling you can find functions that "simulate" the mysql_real_escape_string in fact you may be able to find it in the comments on the page.

 

However it simulates it, it is not it. So yea.

 

so i have to setup a MYSQL database along as my Microsoft Access database?  :-\

[premiso]

There are a few different alternative options to it:

 

http://www.google.com/search?hl=en&q=mysql_real_Escape_string+alternative&btnG=Google+Search&aq=f&oq=

 

The best example that I used to use is:

 

function my_real_escape_string($value)
{
$search = array("\x00", "\n", "\r", "\\", "'", "\"", "\x1a");
$replace = array("\\x00", "\\n", "\\r", "\\\\" ,"\'", "\\\"", "\\\x1a");

return str_replace($search, $replace, $value);
}