str_replace

BluntedbyNature

ok, im working a blog type of site. and i want to add smilies to it, so i am using a the str_replace function on the page that out puts the data. like this:

<?php require_once('Connections/conn.php'); ?>
<?php
$currentPage = $HTTP_SERVER_VARS["PHP_SELF"];

$maxRows_m = 5;
$pageNum_m = 0;
if (isset($HTTP_GET_VARS['pageNum_m'])) {
  $pageNum_m = $HTTP_GET_VARS['pageNum_m'];
}
$startRow_m = $pageNum_m * $maxRows_m;

mysql_select_db($database_conn, $conn);
$query_m = "SELECT * FROM blog ORDER BY id DESC";
$query_limit_m = sprintf("%s LIMIT %d, %d", $query_m, $startRow_m, $maxRows_m);
$m = mysql_query($query_limit_m, $conn) or die(mysql_error());
$row_m = mysql_fetch_assoc($m);

if (isset($HTTP_GET_VARS['totalRows_m'])) {
  $totalRows_m = $HTTP_GET_VARS['totalRows_m'];
} else {
  $all_m = mysql_query($query_m);
  $totalRows_m = mysql_num_rows($all_m);
}
$totalPages_m = ceil($totalRows_m/$maxRows_m)-1;

$queryString_m = "";
if (!empty($HTTP_SERVER_VARS['QUERY_STRING'])) {
  $params = explode("&", $HTTP_SERVER_VARS['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_m") == false && 
        stristr($param, "totalRows_m") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_m = "&" . implode("&", $newParams);
  }
}
$queryString_m = sprintf("&totalRows_m=%d%s", $totalRows_m, $queryString_m);
?>
<?php echo "<?xml version=\"1.0\" encoding=\"iso-8859-1\"?".">"; ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>News...</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<link href="styles.css" rel="stylesheet" type="text/css" />
</head>

<body>
<? $row_m['blog'] = str_replace("\n", "<br>", $row_m['blog']); ?>
<? $row_m['blog'] = str_replace(":)", "<img src='images/smile.gif'>", $row_m['blog']); ?>
<? $row_m['blog'] = str_replace(":D", "<img src='images/grin.gif'>", $row_m['blog']); ?>
<? $row_m['blog'] = str_replace(":wub:", "<img src='images/wub.gif'>", $row_m['blog']); ?>
<? $row_m['blog'] = str_replace("^_^", "<img src='images/happy.gif'>", $row_m['blog']); ?>
<? $row_m['blog'] = str_replace(":blink:", "<img src='images/blink.gif'>", $row_m['blog']); ?>
<? $row_m['blog'] = str_replace(":blush:", "<img src='images/blush.gif'>", $row_m['blog']); ?>
<? $row_m['blog'] = str_replace(":crazy:", "<img src='images/crazy.gif'>", $row_m['blog']); ?>
<? $row_m['blog'] = str_replace(":cry:", "<img src='images/cry2.gif'>", $row_m['blog']); ?>
<? $row_m['blog'] = str_replace(":hehe:", "<img src='images/hehe.gif'>", $row_m['blog']); ?>
<? $row_m['blog'] = str_replace(":huh:", "<img src='images/huh.gif'>", $row_m['blog']); ?>
<? $row_m['blog'] = str_replace(":haha:", "<img src='images/laugh.gif'>", $row_m['blog']); ?>
<? $row_m['blog'] = str_replace(":zZz:", "<img src='images/sleeping.gif'>", $row_m['blog']); ?>
<? $row_m['blog'] = str_replace(":sleepy:", "<img src='images/sleepy.gif'>", $row_m['blog']); ?>
<? $row_m['blog'] = str_replace(":P", "<img src='images/tongue.gif'>", $row_m['blog']); ?>

<table width="100%" border="0" cellspacing="1" cellpadding="0">
  <tr>
    <td valign="top"><div align="right">
        <?php do { ?>
        <table width="100%" border="0" cellspacing="1" cellpadding="0">
          <tr> 
            <td colspan="2" class="top"><?php echo $row_m['title']; ?></td>
          </tr>
          <tr> 
            <td colspan="2" class="main"><?php echo $row_m['blog']; ?></td>
          </tr>
          <tr> 
            <td width="84%" class="bottom">&nbsp;</td>
            <td width="16%" class="bottom"><div align="center"><?php echo $row_m['date']; ?></div></td>
          </tr>
        </table>
        <br />
        <?php } while ($row_m = mysql_fetch_assoc($m)); ?>
        <p class="pages">&nbsp;<a href="<?php printf("%s?pageNum_m=%d%s", $currentPage, max(0, $pageNum_m - 1), $queryString_m); ?>">Previous</a> 
          | <a href="<?php printf("%s?pageNum_m=%d%s", $currentPage, min($totalPages_m, $pageNum_m + 1), $queryString_m); ?>">Next</a> </p>
      </div></td>
  </tr>
</table>
</body>
</html>
<?php
mysql_free_result($m);
?>

the problem i have with this, is that its only doing it for one row, so i was told i should phase it into the MySQL database before i pull it out... but i dont know how this would be done... im still sort of a newbie at php. this is the page that inputs the data into the database.

<?php require_once('../Connections/conn.php'); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    

    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}

$editFormAction = $HTTP_SERVER_VARS['PHP_SELF'];
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
  $editFormAction .= "?" . $HTTP_SERVER_VARS['QUERY_STRING'];
}

if ((isset($HTTP_POST_VARS["MM_insert"])) && ($HTTP_POST_VARS["MM_insert"] == "insert")) {
  $insertSQL = sprintf("INSERT INTO blog (id, title, blog, `date`) VALUES (%s, %s, %s, %s)",
                       GetSQLValueString($HTTP_POST_VARS['id'], "int"),
                       GetSQLValueString($HTTP_POST_VARS['title'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['blog'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['date'], "text"));

  mysql_select_db($database_conn, $conn);
  $Result1 = mysql_query($insertSQL, $conn) or die(mysql_error());

  $insertGoTo = "../index.php";
  if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $HTTP_SERVER_VARS['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}

mysql_select_db($database_conn, $conn);
$query_a = "SELECT * FROM blog";
$a = mysql_query($query_a, $conn) or die(mysql_error());
$row_a = mysql_fetch_assoc($a);
$totalRows_a = mysql_num_rows($a);
?>
<html>
<head>
<title>Insert News</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<table width="100%" border="0" cellspacing="1" cellpadding="0">
  <tr>
    <td>
<form action="<?php echo $editFormAction; ?>" method="POST" name="insert" id="insert">
        <p> 
          <input name="id" type="hidden" id="id">
          <br>
          title: 
          <input name="title" type="text" id="title">
          <br>
          blog:<br>
          <textarea name="blog" cols="60" rows="10" id="blog"></textarea>
          <br>
          <input name="date" type="hidden" id="date" value="<? echo gmdate('m.d.y g:ia \E\S\T', time() -18000) ?>">
          <br>
          <input type="submit" name="Submit" value="Submit">
        </p>
        <input type="hidden" name="MM_insert" value="insert">
      </form></td>
  </tr>
</table>
</body>
</html>
<?php
mysql_free_result($a);
?>

if you could tell me how to do this i would be very grateful.

seby

well if you want to store it in the database you can do something like this:

Create database for smilies:

CREATE TABLE smilies (
  id int(11) NOT NULL auto_increment,
  parse varchar(20) NOT NULL default '',
  image varchar(40) NOT NULL default '',
  cat varchar(8) NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

then insert the the smilies into the database:

INSERT INTO smilies VALUES (1, ':smiliecode:', 'image/smilies/icon.gif', 'emoticon');
INSERT INTO smilies VALUES (2, ':smiliecode:', 'image/smilies/icon.gif', 'emoticon');
INSERT INTO smilies VALUES (3, ':smiliecode:', 'image/smilies/icon.gif', 'emoticon');
INSERT INTO smilies VALUES (4, ':smiliecode:', 'image/smilies/icon.gif', 'emoticon');
INSERT INTO smilies VALUES (5, ':smiliecode:', 'image/smilies/icon.gif', 'emoticon');

then fetch smiles from database for use where ever you want them parsed:

function parsesmileys($row_m[blog]) {
   $result = mysql_query("SELECT * FROM smilies WHERE cat = 'emoticon'");
    while($row=mysql_fetch_row($result)) {
		$row_m['blog'] = str_replace("$row[1]","<img src=\"$row[2]\" border=\"0\">",$row_m[blog]);
    } return $row_m[blog];
 }

you will have to tweak and change some of the variables to your variables, hope this helps.

BluntedbyNature

i understand most of what you said, but where does the $row[1] and $row[2] come from?

seby

while($row=mysql_fetch_row($result)) {

from there..

to explain a little bit, $row[1] and $row[2] are mysql columes, $row[1] (in our case) is the smilie code, "🙂" or whatever the code you made. $row[2] is the "image" colume in the smilie database and its the path of the smilie... i hope this makes sense.

BluntedbyNature

ok, i understand that pretty much, would i put that code on the page that i insert the data or the page that i fetch the data?

BluntedbyNature

bump i dont want it to get lost... these forums update quickly...

Weedpacket

Er... it could probably go in either.

Doing it before you INSERT the blog into the database would be the faster approach. Do the string replacements once and then it goes in the database. Smilie <img> tag and all.

Doing it after you SELECT the blog from the database would be more flexible. You'll need to do the string replacements every time the text is fetched for display (which is why it's slower), but you're free to change what they get replaced with whenever you like (something you can't do using the first method without a lot of hassle). Or not change them at all, if you're so inclined.

This forum uses the second method, FYI. That's why it can offer "Disable Smilies in This Post", and allow the smilies to still appear as 🙂 when you edit.

So in general, doing it after the fetch for display is probably the better approach.

BluntedbyNature

thanks alot man. i will do it after then... but this way it will let all the rows use the str_replace cause as of right now. its only doning the 1st row...