[SOLVED] White space problem

[ptolomea]

I'm trying to retrieve an image from my database, the code i have works for anything with out a space but once there is a space in a title it only sends the first word.

 

I have tried str_replace, and addslashes to no avail.

 

request for image.

getImage.php?title='" . $title . "'>

 

getImage.php

$title = $_REQUEST['title'];
mysql_select_db("movies");
$results = mysql_query("SELECT * FROM currentlist WHERE title = '" . $title . "'");
while ($row = mysql_fetch_array($results)){
echo $row['coverFront'];
}

[hvle]

$title = urlencode($title);
getImage.php?title='" . $title . "'>

[Wes1890]

^ you posted the same thing as me lol

 

Also, i would try to avoid using $_REQUEST. I hear it's not a good security idea.

 

Stick to $_POST or $_GET depending on what it is.

[ptolomea]

thats sending it now but still unable to load image thought it was because of the + that were now added but adding urldecode still didn't show the image.

 

even threw decode into a new variable same result.

 

$newTitle = urldecode($title);
$results = mysql_query("SELECT * FROM currentlist WHERE title = '" . $newTitle . "'");

[hvle]

what exactly the error that you got?

[ptolomea]

i'm not actually getting an error, just a broken image link, but when i type the information in the browser window i'm able to see that it is in fact grabbing an image from the database and that it is in fact searching the right title.

 

which makes me think that this problem is not related to the original problem.

 

 

edit:

getImage.php?title='" . $title . "'>

 

problematic little single quotes.

changed to

getImage.php?title=" . $title . ">

 

works just fine

 

[hvle]

broken image link,

 

Check the image link to see if it point to the valid img file and go from there.