[RESOLVED] Apostrophe causing problems.

crzyman

Here is the code. It selects an artistname from the database and removes the spaces (if any) and turns it into a link. Everything works fine except for when I enter a name in the database with an Apostrophe. The name is "Ol' Scratch". It displays the full name, but the link that is created points to "Ol"? I need it to be "OlScratch". Any help would be most appreciated. Thanks.

mysql_connect("mysql","username","password");

mysql_select_db("database");

$name=$_GET['id'];

$result = mysql_query("SELECT * FROM artist WHERE artist_name LIKE '$name%' order by artist_dts desc limit 8");

//grab all the content
while($r=mysql_fetch_array($result))
{

$artist_name=$r["artist_name"];
$artist_genre=$r["artist_genre"];

$clean = str_replace(" ","",$artist_name);

//display the row
echo "<FONT size=4><center><a href='/$clean'>$artist_name</center></a>";
}

mrhappiness

[man]url_encode[/man]?

crzyman

Thanks for your response, but that just encodes the string. If I do that the output is "Ol%27+Scratch" and I need it to be "OlScratch". I know it has to be something simple, I'm just not sure what. I am new to PHP. I searched the manual for a solution, but can't seem to find one. I do appretiate you help though. If you have any other ideas please let me know. Thanks. Jamie.

leatherback

Use str_replace to remove the non-wanted characters

crzyman

I tried that $clean = str_replace("\'","",$artist_name); and it didn't work. I also tried it without the "\" and still no luck. I must be doing something wrong, but what? Thanks for your help. Jamie.

leatherback

Just a sec,

let me start my server, and give you a working solution

crzyman

Thanks. I so appreciate it.

leatherback

<?
$username = "Ol' Scratch";
  echo "Input: ".$username."<br />";

$out = str_replace("' ", "", $username);
  echo "Clean: ".$out."<br />";

// or:

$unwanted = array(
0 => "'",
1 => " ");

$out2 = str_replace($unwanted, "", $username);
echo "Also clean: ".$out2."<br />";

  ?>

crzyman

Thanks! Let me try it.

crzyman

I tried it, but it doesn't work. Any ideas? Thanks. Here is what I have:

mysql_connect("mysql","username","password");

mysql_select_db("ims_search");

$name=$_GET['id'];

$result = mysql_query("SELECT * FROM artist WHERE artist_name LIKE '$name%' order by artist_dts desc limit 8");

//grab all the content
while($r=mysql_fetch_array($result))
{

$artist_name=$r["artist_name"];

$unwanted=array(0=>"'", 1=>" ");

$clean=str_replace($unwanted,"",*$username);

//display the row
echo "<FONT size=4><center><a href='/$clean'>$artist_name</center></a>";
}

leatherback

How where did all the stars and stuff come from? Get rid of that! I gave you a working code. Why did you change it? Of course it willm stop working then.

Also, if you use a name with apostroph in the query, you may need to use addslashes, if this is not done automatically by your server.

crzyman

Thank you. For some reason when I copied and pasted the code those characters where inserted. I removed them and all is working fine. Thank you so much. Jamie