[Resolved] white space problem

[slimjim]

Well after hours of trying to figure out my problem, I figured out, but do not understand on how to fix it.

I submit information to the database thru a textarea. If i leave a white space at the end it causes my javascript on the page to show thru on the page where i echo the Description.

Not sure how to fix this issue, but here is part of the page if you can help me out here...

Is there a way in the way I submit the information to the database to prevent this, without me having to worry about removing white space ? Or maybe a way I echo it to prevent it.

<SCRIPT LANGUAGE="JavaScript">
var txt = "Bookmark Us!";
var url = "<? echo $SITE_URL; ?>/Dir/AdManagementprod.php?subcatid=<? echo $myrow["subcatid"]?>";
var who = "<? echo $pname; ?> Listing at <? echo $SITE_NAME; ?>";

var ver = navigator.appName;
var num = parseInt(navigator.appVersion);
if ((ver == "Microsoft Internet Explorer")&&(num >= 4)) {
document.write('<A HREF="javascript:window.external.AddFavorite(url,who);" ');
document.write('onMouseOver=" window.status=');
document.write("txt; return true ");
document.write('"onMouseOut=" window.status=');
document.write("' '; return true ");
document.write('">'+ txt + '</a>');
}else{
txt += "  (Ctrl+D)";
document.write(txt);
} 
</script>
</b>
                        <li><a href="<?php echo $SITE_URL;?>/Dir/feedback.php?subcatid=<? echo $subcatid; ?>&subcat=<? echo $subcat;?>"><b>Report
                          This Link</b></a></li>
                      </ul>
                      </font></td>
                  </tr>
                </tbody>
              </table>
              <br>
              <table cellSpacing="1" cellPadding="2" width="100%" border="0">
                <tbody>
                  <tr>
                    <td><b>Description:</b><BR>
                    <? echo $myrow["Description"]?></td>
                  </tr>
                </tbody>
              </table>

[tsinka]

Hi,

I'd suggest to use the trim function on the values prior to storing them in the database.

Thomas

[slimjim]

I am using a textarea on my form, such as below, is that how i would use trim to store the Description ?

<td>Description</td><td><textarea name="Description" cols="30" rows="5" class="mytext" id="Description"><?echo trim($Description);?></textarea>

[tsinka]

Hi,

do it in the part of the code that checks the posted data, like e.g.

// the section that checks and stores the posted data
$desc = trim($_POST['description']);
$theotherfield = trim($_POST['description']);
// now save it 
$sql = "INSERT INTO table (field1,field2) VALUES (...,$desc,...)";

If you want to display the contents in the database in form afterwards you can just use the values since they've been trimed before.

If there's already data in the database with whitespaces you additionally need to use trim like you wrote in your last post.

Make sure that you use $POST['variablename'] in any case if the data comes from a form (or $GET['variablename'] if the form method is GET).

Thomas

[slimjim]

Great thank you it worked...

[tsinka]

Hi,

glad to hear that 🙂

Please mark this thread resolved.

Thomas