Trim Text area (charcter return values)
Posted: Tue Oct 05, 2010 2:02 pm
Hi there,
I am trying to trim a textarea called comments in my enquiries form of character returns. I am told the trim function does this and have applied it to my php however it doesn't seem to be working.
<?php
$con = mysql_connect("*********","*********","*********");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("safe", $con);
$number = preg_replace('/[^0-9]/', '', $_POST['number']);
$realname = mysql_real_escape_string($_POST['realname']);
$email = mysql_real_escape_string($_POST['email']);
$comments = trim($_POST['comments']);
$comments = mysql_real_escape_string($_POST['comments']);
$sql="INSERT INTO Enquiries (Name, Number, Email, Comments, Date)
VALUES
('$realname','$number','$email','$comments', CURDATE())";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "";
mysql_close($con)
?>
Can anyone see why this might not be working?
Thanks in advance for any input. It is much appriciated.
Kind regards
Mike
I am trying to trim a textarea called comments in my enquiries form of character returns. I am told the trim function does this and have applied it to my php however it doesn't seem to be working.
<?php
$con = mysql_connect("*********","*********","*********");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("safe", $con);
$number = preg_replace('/[^0-9]/', '', $_POST['number']);
$realname = mysql_real_escape_string($_POST['realname']);
$email = mysql_real_escape_string($_POST['email']);
$comments = trim($_POST['comments']);
$comments = mysql_real_escape_string($_POST['comments']);
$sql="INSERT INTO Enquiries (Name, Number, Email, Comments, Date)
VALUES
('$realname','$number','$email','$comments', CURDATE())";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "";
mysql_close($con)
?>
Can anyone see why this might not be working?
Thanks in advance for any input. It is much appriciated.
Kind regards
Mike