Need some n2lbr help.....

[kona72]

Hey All,
I have been creating my own CMS to an extent for some of my clients using PHP MySQL and using add, edit and delete pages but i have hit a small snag with the nl2br function. The problem is that when the intial add is made it adds the <br> tag which is great!! BUT when I try to update the existing content it adds another <br>tag were ever it sees a line break....

basically I guess what I am asking is if there is any way to strip the <br> tags before the php calls it form the DB to be displayed?

Here is my add code....

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

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($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 = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
  $insertSQL = sprintf("INSERT INTO blog (entrydate, title, content) VALUES (%s, %s, %s)",
                       GetSQLValueString($_POST['entrydate'], "text"),
                       GetSQLValueString($_POST['title'], "text"),
                       GetSQLValueString(nl2br($_POST['content']), "text"));

  mysql_select_db($database_carlyhenry, $carlyhenry);
  $Result1 = mysql_query($insertSQL, $carlyhenry) or die(mysql_error());

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

And here is my edit page code.......

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

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($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 = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
  $updateSQL = sprintf("UPDATE blog SET entrydate=%s, title=%s, content=%s WHERE rec_num=%s",
                       GetSQLValueString($_POST['entrydate'], "text"),
                       GetSQLValueString($_POST['title'], "text"),
                       GetSQLValueString(nl2br($_POST['content']), "text"),
                       GetSQLValueString($_POST['rec_num'], "int"));

  mysql_select_db($database_carlyhenry, $carlyhenry);
  $Result1 = mysql_query($updateSQL, $carlyhenry) or die(mysql_error());

  $updateGoTo = "success.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";
    $updateGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $updateGoTo));
}

$colname_rsEdit = "-1";
if (isset($_GET['rec_num'])) {
  $colname_rsEdit = (get_magic_quotes_gpc()) ? $_GET['rec_num'] : addslashes($_GET['rec_num']);
}
mysql_select_db($database_carlyhenry, $carlyhenry);
$query_rsEdit = sprintf("SELECT * FROM blog WHERE rec_num = %s", GetSQLValueString($colname_rsEdit, "int"));
$rsEdit = mysql_query($query_rsEdit, $carlyhenry) or die(mysql_error());
$row_rsEdit = mysql_fetch_assoc($rsEdit);
$totalRows_rsEdit = mysql_num_rows($rsEdit);
?>

[ClarkF1]

What I do is store the data as it is in the form with newline characters and then replace them with nl2br when retrieving the data for output.

What you could do before editing the data is use str_replace to replace all the existing <br> with \n and then run nl2br on the resulting string

[greenie2600]

ClarkF1's right. There's no need to convert newlines to break tags to store stuff in the database. Perform the conversion when you're pulling the data out of the database for display.