Remove spaces in field

Question

I have a database of names of people in this format

First Second

I want to take these names from the URL then REMOVE THE WHITE SPACES in the middle of the URL then add .gif to the end to turn it into the reference for an image.

So I want to get this out: FirstSecond.gif

I have read through all the other posts on similar questions, but nothing seems to work!

I am using this code (not that I understand it) to do the stripping.....

<?php

$sTestString = '<?php echo ($_GET['secondary']); ?>';

$sPattern = '/\s*/m';

$sReplace = '';

echo preg_replace( $sPattern, $sReplace, $sTestString ); ?>

I get this error:

Parse error: syntax error, unexpected T_STRING in /content/HostingPlus/h/a/hands-together.org/web/testspaces.php on line 3

Any ideas? or is there something REALLY simple I can do in formats to get this to work. It seems so basic !

Thanks

David_Powers · Answer

I am using this code (not that I understand it) to do the stripping.....

Using code without understanding it is a rapid way to hair loss.

The reason you're getting a parse error is because you're nesting PHP tags inside PHP tags. You can't do it.

This:

$sTestString = '<?php echo ($_GET['secondary']); ?>';

Should be this:

$sTestString = $_GET['secondary'];

In your question, you refer to a database and a URL. Where is the data coming from: the database or a URL?

If it's coming from the database, you can do it all with SQL:

SELECT *, CONCAT(First, Second, '.gif') AS image
FROM myTable

Assuming that First and Second are the names of columns in your database, this will produce a result similar to DavidPowers.gif in the recordset, which can be retrieved as "image".

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded