[RESOLVED] Losing backslashes in MySQL data

[joshmpratt]

How can I prevent this?

I am storing strings that are server paths and they consist of multiple backslashes. They look like this:

\Server5\CAD\Current\PIM_student_book06_PIM_student_book05.qxd.pdf

When I put it into the database the first time, it keeps all the slashes. However, if I put it back into a form that people often edit, even if they don't edit this string, the next time it is submitted, the slashes disappear from the string in the database.

So for instance, if I do a query of this row, and store it in $data, I do a check like this:

if ($data['serverstring1'] != "") {
$path1 = $data['serverstring1'];
}

So, if it is not edited, it is stored in $path1 and it is written back to the database, but without the slashes.

I hope this makes sense. Anyone willing to help?

[david4ie]

I didnt quite follow what you were saying but if you would like to add or remove slashes you can use addslashes() or stripslashes()

For e.g

if ($data['serverstring1'] != "") {
$path1 = addslahses($data['serverstring1']);
}