4

I've gone through this address:

Passing an array to a query using a WHERE clause

and found that if I use a join clause to separate values , is also at the end of the array. How can I remove last?

I am using like this 

$ttst=array();
$ttst=array(); 
$tt = "SELECT frd_id FROM network WHERE mem_id='$userId'"; 
$appLdone = execute_query($tt, true, "select"); 
foreach($appLdone as $kk=>$applist){ 
    $ttst[] = $applist['frd_id']; 
} 
$result = implode(',', $ttst);

then also coming last ,

Thanks.

but it doesn't give single quote to each value .

Community
  • 1
  • 1
RockDance
  • 91
  • 1
  • 1
  • 8

7 Answers7

10
join(',', array_filter($galleries))

array_filter gets rid of empty elements that you seem to have. Of course, you should take care not to have empty elements in there in the first place.

deceze
  • 510,633
  • 85
  • 743
  • 889
9

You could use trim() (or rtrim()):

$myStr = 'planes,trains,automobiles,';
$myStr = trim($myStr, ',');
jensgram
  • 31,109
  • 6
  • 81
  • 98
4
$str = "orange,banana,apple,";
$str = rtrim($str,',');

This will result in

$str = "orange,banana,apple";

Update

Based on your situation:

$result = implode(',', $ttst);
$result = rtrim($result,',');
Shef
  • 44,808
  • 15
  • 79
  • 90
0

No need for length. Just take from beginning to the (last character - 1)

$finalResult = $str = substr($result, 0, -1);
Steward Godwin Jornsen
  • 1,181
  • 1
  • 7
  • 13
0
$arr = array(...); 
$last = end($arr); 
unset($last);
The Mask
  • 17,007
  • 37
  • 111
  • 185
0

If the trailing "," is an array element of itself, use array_pop(), else, use rtrim()

$array = array('one','two',3,',');
array_pop($array);
print_r($array);

Gives:

Array ( [0] => one 1 => two 2 => 3 )

Mattis
  • 5,026
  • 3
  • 34
  • 51
-1

Use implode() instead! See Example #1 here http://php.net/manual/en/function.implode.php

Edit:

I think a quick fix would be (broken down in steps):

$temp = rtrim(implode(',', $ttst), ','); //trim last comma caused by last empty value
$temp2 = "'"; //starting quote
$temp2 .=  str_replace(",", "','", $temp); //quotes around commas
$temp2 .= "'"; //ending quote
$result = $temp2; // = 'apples','bananas','oranges'

This should give you single-quote around the strings, but note that if some more values in the array are sometimes empty you will probably have to write a foreach loop and build the string.

Henrik Erlandsson
  • 3,797
  • 5
  • 43
  • 63
  • i am using like this $ttst=array();$ttst=array(); $tt = "SELECT frd_id FROM network WHERE mem_id='$userId'"; $appLdone = execute_query($tt, true, "select"); foreach($appLdone as $kk=>$applist){ $ttst[] = $applist['frd_id']; } $result = implode(',', $ttst); then also coming last , – RockDance Jun 16 '11 at 06:53
  • 1
    @RockDance, you should add that code (properly formatted) to the question. – Mischa Jun 16 '11 at 06:56
  • @deceze, ok, I've always used implode and never join, and knew that implode only puts commas *between* the items. It's apparent now that he has 1 (or more) empty string results in the array, but it was hard to make that out before he edited the question. – Henrik Erlandsson Jun 16 '11 at 14:06