adding pipe to end of result

pattyaunt

$sql2="select * from ipbann";
$result2=mysql_query($sql2);
while($rows=mysql_fetch_array($result2))
{
$ipz[] = $rows['banaid'];
}
echo implode(',', $ipz);//seperates each with comma
//which shows this 11.11.11.111,22.22.22.222,33.33.33.333

//What I need to do is have it insert a pipe | at very end of results like:
//11.11.11.111,22.22.22.222,33.33.33.333|

What I need to do is have it insert a pipe | at very end of results like:
11.11.11.111,22.22.22.222,33.33.33.333|

bradgrafelman

So what have you tried? All you need to do is a basic string concatenation (e.g. the "." operator). See this manual page for more info: [man]language.operators.string[/man].

pattyaunt

I looked at that page and I cant get anything out of it, I played around so much with it, and now I need help cause I cant get it.

bradgrafelman

Can you show us what you tried? Like I said, you're just doing a basic concatenation to combine two different strings together. For example, the following three lines of code produce identical output:

echo "Hello world!";

echo "Hello " . "world!";

echo "Hello" . " " . "world!";

pattyaunt

What you saying to me doesnt make sence either, cause all I want to do is at very end of the results that get echo to page with the comma seperating each, I need a pipe at very end.
For you this may be easy, but not for this newbie 🙂

bradgrafelman

I realize you might be new, but I'm trying to give you the pieces and all you have to do is put them together. For example, you say this:

echo implode(',', $ipz);

outputs the data you want, but you want to add a pipe to the end of it.

So.. you've got one string piece:

implode(',', $ipz)

and you want to add another on to it:

"|"

in the same away I added " world!" onto the end of "Hello" above.

Sorry if it seems like I'm being tough, but you're going to have a tough time learning a programming language (any, not just PHP) if someone just feeds you code rather than letting you figure out a basic syntax problem on your own.

Look at the comparison I made above, then look at my coding snippet in my previous post. Try to do the same with your code and post what you end up with - even if you think it's horribly wrong.

pattyaunt

I am doing this wrong arnt I

echo implode(',', "$ipz" . " " . "|");

pattyaunt

in your example your just using echo, while in my example I am using echo implode.

pattyaunt

wow I dont care how I arrange my echo implode, I get errors

bradgrafelman

pattyaunt wrote:
while in my example I am using echo implode.

The thing is, though, that the two are unrelated. [man]implode/man returns a string, so the end result is that it's no different that if you had "Hello" in place of the implode() function.

Once you realize that, it should make sense why this works:

echo implode(',', $ipz) . "|";

pattyaunt

Ahh see I thought it was suppose to be inside the Parentheses and everything I tried were inside the Parentheses like below

echo implode(',', $ipz . "|");// wrong
echo implode(',', $ipz) . "|";//right