Re: To slash or not to slash....

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, 2 Sep 2003 16:45:28 +0100, Craig Cameron wrote:

>
>Ok simple problem I hope.
>
>
>Have the following code, used to store the location and a few details about meeting minutes.
>
><snip>
>		$connection = mssql_connect("server","user","password");
>		mssql_select_db("DocumentManager",$connection);
>	
>		$AlteredMinutesLocation = str_replace("\\","\",$MinutesLocation);
>
>		$SQL_STRING = "INSERT INTO tblMeetingMinutes VALUES('$Date','$Type','$AlteredMinutesLocation','$Centre')"; 
>
>		$Result = mssql_query($SQL_STRING,$connection);
>		mssql_close($connection);
>
></snip>
>
>Problem is the backslashes. When I collect the filepath ($Location) it puts \\ into the db. However, when I change this it stops dead. Basically due to the escape charateristics of the backslash. I can get around this with single quotes of course but can't put these in the SQL_STRING as it falls down there then!
>
>Somebody must have come across this before, any help much appreciated.
>
>Cheers
>
>Craig
> 

Try using the built-in functions addslashes() and stripslashes().

Doug

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux