File Write " and ' closing early issu

[kiksy]

Hi there,

 

Ive searched around , but due to the grammatical style of my problem its been hard to find an answer on Google or here.

 

I am inserting some PHP/MySQL commands into a new .php file using 'fwrite' :

 

$stringData = '";
$dbresult = mysql_query("SELECT * FROM PhotoUsers WHERE id = "';
fwrite($fh, $stringData);
$stringData = '$idselect';
fwrite($fh, $stringData);
$stringData = '");

 

When run the resulting .php file contains :

$dbresult = mysql_query("SELECT * FROM PhotoUsers WHERE id = "$idselect"");

 

Where as it needs to be :

 

$dbresult = mysql_query("SELECT * FROM PhotoUsers WHERE id = '$idselect'");

 

with '' instead of "" around $idselect.

 

The issue is that when I put ' around $stringData = '$idselect'; in the first page it closes it.

 

I hope Ive explained my issue clearly, thanks in advance for any help, Im sure its a simple fix!

 

 

 

 

[Adam]

Escape the single quotes with a backslash. For example..

 

$str = 'it\'s';

[scept1c]

well Kiksy doesn't use slash here. Or I misunderstood the suggestion.

[Adam]

well Kiksy doesn't use slash here. Or I misunderstood the suggestion.

I believe he was having troubles trying to achieve the second output; with single quotes closing the string.. Basically using a single quote within single-quoted string.

 

If I've confused you, this should work for you kiksy:

 

$stringData = '$dbresult = mysql_query("SELECT * FROM PhotoUsers WHERE id = \'$idselect\'");';
fwrite($fh, $stringData);

[kiksy]

Thanks,

 

I was jut away entering what you suggested when you put that second post down. It works perfectly with :

 

$stringData = '";
$dbresult = mysql_query("SELECT * FROM PhotoUsers WHERE id = ';
fwrite($fh, $stringData);
$stringData = '\'$idselect\'';
fwrite($fh, $stringData);

 

Thanks for the quick response! 

[Adam]

Ah, of course in your example you could just use:

 

$stringData = "'$idselect'";