str_replace is doing my brain in

[spcomputing_com]

Hi all, I'm using the following code to retrieve some data from a MySQL database. (I'm trying to build a simplified PHP / MySQL shoutbox).

the username/password/db_name fields are blanked on purpose 😉

<?php
$host = 'localhost';
$user = '';
$pass = '';
$db = '';
$link = mysql_connect($host, $user, $pass);
mysql_select_db($db);
$query = "SELECT * from shoutbox ORDER BY id DESC;";
$result = mysql_query($query) or die ("Query Failed");
while ($line = mysql_fetch_array($result, MYSQL_ASSOC))
echo "<div align=\"left\"><font size=\"1\" face=\"Verdana\" color=\"#006699\"><strong>".$line["Nickname"]."</strong></font><br><font size=\"1\" face=\"Verdana\" color=\"#CC0000\">".$line["Message"]."</font></div><br><br>";
mysql_free_result($result);
mysql_close($link);
?>

".$line["Message"]." retrieves data from the message field, which is actually from a textarea.

anyway, how can i use str_replace to remove < and > from the outputted code and incorporate it with the above code?

Thanks in advance 🙂

[chads2k2]

Hey ... try this ... I haven't programmed in like 8 months so I am a bit rusty. See if this works. If NOT then take out the "$line["Message"]" ---> and replace with ",$line["Message"]);

<?php
$host = 'localhost';
$user = '';
$pass = '';
$db = '';
$link = mysql_connect($host, $user, $pass);
mysql_select_db($db);
$query = "SELECT * from shoutbox ORDER BY id DESC;";
$result = mysql_query($query) or die ("Query Failed");
while ($line = mysql_fetch_array($result, MYSQL_ASSOC))

// Takes out the < and replaces with nothing.
$message = str_replace("<","","$line["Message"]");

// Takes out the > and replaces with nothing.
$final_message = str_replace(">","","$message");

echo "<div align=\"left\"><font size=\"1\" face=\"Verdana\" color=\"#006699\"><strong>".$line["Nickname"]."</strong></font><br><font size=\"1\" face=\"Verdana\" color=\"#CC0000\">".$final_message."</font></div><br><br>";
mysql_free_result($result);
mysql_close($link);
?>

IF that doesn't work then try this one...

<?php
$host = 'localhost';
$user = '';
$pass = '';
$db = '';
$link = mysql_connect($host, $user, $pass);
mysql_select_db($db);
$query = "SELECT * from shoutbox ORDER BY id DESC;";
$result = mysql_query($query) or die ("Query Failed");
while ($line = mysql_fetch_array($result, MYSQL_ASSOC))

// Takes out the < and replaces with nothing.
$message = str_replace("<","",$line["Message"]);

// Takes out the > and replaces with nothing.
$final_message = str_replace(">","","$message");

echo "<div align=\"left\"><font size=\"1\" face=\"Verdana\" color=\"#006699\"><strong>".$line["Nickname"]."</strong></font><br><font size=\"1\" face=\"Verdana\" color=\"#CC0000\">".$final_message."</font></div><br><br>";
mysql_free_result($result);
mysql_close($link);
?>

Hope I can help... NOW if neither one works (which I would not be surprised!) then go here http://www.php.net/manual/en/function.str-replace.php

and all will be good. Take care!

Chad

[spcomputing_com]

Jesus christ almighty 😃 it works 🙂

However it does not show the nick name, and it will only display the first entry in the database???

[kevinsequeira]

can u post the edited code ??

reg
kevin