Passing file paths...

[Anon]

Hi 🙂

I am having trubble passing a file path using PHP into an Access DB.

In ASP when i pass my string it looks like this in the DB & when i display it, and when i creat a link to it.

C:\Docs\Test.txt

However, using PHP to do the same thing, i get this.

Stored in DB as C:\Docs\Test.txt
Displayed as C:\Docs\Test.txt

When i create a link to it is shown as.

file///C://Docs//Test.txt

(i add in the file:// bit)

Can anyone please help as this is really puzzling me !!

Thanks

• Ben

[Anon]

Yep, it's really simple, '\' in php (and in most database implementations) is an escape character used to print things like quotation marks in strings:

Example:
$string = "this is a "test" string" //ERROR
$string = "this is a \"test\" string" //NO ERROR

PHP Provideds two functions to simplify this addslashes() and stripslashes(), so in your case just run strip slashes on the string when you want to print it.

Example:
$string = addslashes(C:\Docs\Test.txt); //This is whats done automaticly by your database.

echo stripslashes($string); //This is what you do to get it back to the original string.

Hope this solves your cunfuzzlement a bit.

[Anon]

nice, thanks m8.

🙂