[RESOLVED] Appending a % sign to the end of a string

dcjones

Hi all,

I have a form which contains a feild that holds data input by a user. For various reasons the feild has to be VARCHAR.

What I need to do is append a % sign to the end of the input before the data is written to the data table.

As an example:
If the user enters 10, I want the input data to be 10 %, including the space.

Can anyone please advise.

laserlight

Just append a ' %' to the string, and then insert.

dcjones

Hi LaserLight and thank you for your reply.

This is what I have so far:

$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 amember_bcoupon SET `comment`=%s, discount=%s, begin_date=%s, expire_date=%s WHERE code=%s",
                       GetSQLValueString($_POST['comment'], "text"),
                       GetSQLValueString($_POST['discount']['%'], "text"),
                       GetSQLValueString($_POST['begin_date'], "date"),
                       GetSQLValueString($_POST['expire_date'], "date"),
                       GetSQLValueString($_POST['code'], "text"));

  mysql_select_db($database_bpin, $bpin);
  $Result1 = mysql_query($updateSQL, $bpin) or die(mysql_error());

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

Its this part I am working on.

GetSQLValueString($_POST['discount']['%'], "text"),

Am I doing this right.

laserlight

$POST['discount']['%'] accesses an element of the array $POST['discount'] which has the key '%'. Of course, $POST['discount'] is probably actually a string, so that it incorrect. What you want is probably $POST['discount'] . ' %', where "." is PHP's concatenation operator.

That said, why bother appending the ' %' when inserting into the database? Why not append it when retrieving from the database?

dcjones

Hi LaserLight.

Many thanks for sorting me out, once again Laserlight to the rescue.

Many thanks