PHP - Remove The Last Comma

Hello Guys,

I am trying to strip the last comma but I can't get it to work... Please advise

Here is my code, it adds the coma in between all numbers and on the end.

Code: [Select]
$query1 = mysql_query("SELECT b_id FROM benefits");
while ($row = mysql_fetch_array($query1)) {
$b_id = $row['b_id'];

$b_id . ",";

     echo $b_id2;

}

displays 1,2,3,4,5,6,7,8,9,10,


I also tried this but it didn't work. It removed all the commas

Code: [Select]

$query1 = mysql_query("SELECT b_id FROM benefits");
while ($row = mysql_fetch_array($query1)) {
$b_id = $row['b_id'];


$b_id . ",";
$b_id2 = rtrim($b_id,',');
     echo $b_id2;


}

This seems like such a simple error, however I've no idea why I am getting it.

apparently I have an unexpected comma on line 4 of the code below.  I can't work out what the error is.

Any ideas?  Sorry to be a pain if it really is something simple, but I'm a bit new to all this php stuff.

<?php
function percentCalc($value1,$value2,$value3,$value4,$value5,$total)
{
$array=($value1,$value2,$value3,$value4,$value5);
while (list($key,$arraycontent)= each($array))
{
$c_percent=(($arraycontent/$total)*100);
$final_array[]=$c_percent;
}

return $final_array;
}
?>

Hi,
If I need to put commas within a variable how can this be achieved?

i.e. if statement..... {
$output = "text1,text2,text3";

Incase your wondering what I'm trying to do.. basically im using a header file on my site... i want different keywords within the meta tags depending on the page the user is on, so i want to include aprox 20 keywords in the $output which will be inserted in the comma area of the meta tags.


Probably quite an easy way to do it but I'm not sure how to do it! Any help appreciated!

Lets say I pull a value from a database field that has a value of 1,2 and what I want to do is seperate them and then run each of those values against a separate table how would that be accomplished.

How can I replace the comma from a string like this:

You, like this => You like this
You, Derp, like this => You and Derp like this
You, Derp, Derpina, like this => You, Derp and Derpina like this
You, Derp, Derpina, Derpson, like this => You, Derp, Derpina and Derpison like this

After a lot of lurking, thanks for all the great topics I now have a guestion where I could really use your help.

I am parsing some xml data with the following php:

Code: [Select]
<?php
$data = file_get_contents("XML URL");
$actors = preg_match_all("/<actors>(.+)<\/actors>/", $data, $match);
foreach ($match[1] as $actors)
{
echo $actors; 
} ?>
For the following XML part:

<actors>
<actor id="1234">Actor #1</actor>
<actor id="12345">Actor #2</actor>
<actor id="123456">Actor #3</actor>
</actors>

This gives the ouput: Actor #1 Actor #2 Actor #3

Now I would like to separate the actor names by comma, like this: Actor #1, Actor #2, Actor #3

Does anybody know how to modify the php code for this? Thanks 

This is going to sound like a very beginner question, because it is. I am modifying some free code snippets to fit my use and stuck. It's probably a simple fix.

First here is the code. This is printing from a while loop.
<?php print("[". $current_month .",". number_format($remaining_balance, "2", ".", ",") . "],");?>

Here is the last remaining items from the loop at it comes to an end:
[343,14,495.86], [344,13,682.26], [345,12,863.91], [346,12,040.79], [347,11,212.87], [348,10,380.12], [349,9,542.52], [350,8,700.02], [351,7,852.61], [352,7,000.26], [353,6,142.94], [354,5,280.62], [355,4,413.26], [356,3,540.85], [357,2,663.34], [358,1,780.72], [359,892.95], [360,0.00], 

My question is kind of simple, how do I get it do the comma doesn't print on the last print? I need it to end like this: [359,892.95], [360,0.00]

Does that make sense? I don't know if I explained it well. I could really use some help! Thanks so much!

Code: [Select]
30|24|17,5|4|20,15|13|33,15|22|33,9|20|22
Let's say my output is that,

Realistically every 3numbers is 1 Ticket they are seperated by a "," (comma)

I want to wrap parenthesis around them so the output would look like this

Code: [Select]
(30|24|17) (5|4|20) (15|13|33) (15|22|33) (9|20|22)
Now would I have to use regex.. or not cuz regex is extremely difficult

Thanks 

Hi,

I have in column "keywords" comma separated keywords in one row/news. Example in ID "1" in column "keywords" have: "Šport, Fudbal, Četvrta Liga". I want to make a tag-s from those words to be like: http://site.com/tag/sport,  http://site.com/tag/fudbal, http://site.com/tag/cetvrta-liga.

At first I separate those words by:

$input = $vest_keywords;
$removed_spaces = preg_replace('/\s*,\s*/', ',', $input);
$output = explode(',', $removed_spaces);
foreach($output as $tags) {
  echo $tags;
}

This give me: Šport | Fudbal | Četvrta liga

 

But I have a "slug-maker", and I have a problem with redeclare.

/* SLUG */
$string = $output;
  function my_str_split($string) {
    $slen = strlen($string);
    for ($i = 0; $i < $slen; $i++) {
      $sArray[$i] = $string{$i};
    }
    return $sArray;
  }
  function noDiacritics($string) {
    //cyrylic transcription
    $cyrylicFrom = array('А', 'Б', 'В', 'Г', 'Д', 'Е', 'Ё', 'Ж', 'З', 'И', 'Й', 'К', 'Л', 'М', 'Н', 'О', 'П', 'Р', 'С', 'Т', 'У', 'Ф', 'Х', 'Ц', 'Ч', 'Ш', 'Щ', 'Ъ', 'Ы', 'Ь', 'Э', 'Ю', 'Я', 'а', 'б', 'в', 'г', 'д', 'е', 'ё', 'ж', 'з', 'и', 'й', 'к', 'л', 'м', 'н', 'о', 'п', 'р', 'с', 'т', 'у', 'ф', 'х', 'ц', 'ч', 'ш', 'щ', 'ъ', 'ы', 'ь', 'э', 'ю', 'я');
    $cyrylicTo = array('A', 'B', 'W', 'G', 'D', 'Ie', 'Io', 'Z', 'Z', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'R', 'S', 'T', 'U', 'F', 'Ch', 'C', 'Tch', 'Sh', 'Shtch', '', 'Y', '', 'E', 'Iu', 'Ia', 'a', 'b', 'w', 'g', 'd', 'ie', 'io', 'z', 'z', 'i', 'j', 'k', 'l', 'm', 'n', 'o', 'p', 'r', 's', 't', 'u', 'f', 'ch', 'c', 'tch', 'sh', 'shtch', '', 'y', '', 'e', 'iu', 'ia');
    $from = array("Á", "À", "Â", "Ä", "Ă", "Ā", "Ã", "Å", "Ą", "Æ", "Ć", "Ċ", "Ĉ", "Č", "Ç", "Ď", "Đ", "Ð", "É", "È", "Ė", "Ê", "Ë", "Ě", "Ē", "Ę", "Ə", "Ġ", "Ĝ", "Ğ", "Ģ", "á", "à", "â", "ä", "ă", "ā", "ã", "å", "ą", "æ", "ć", "ċ", "ĉ", "č", "ç", "ď", "đ", "ð", "é", "è", "ė", "ê", "ë", "ě", "ē", "ę", "ə", "ġ", "ĝ", "ğ", "ģ", "Ĥ", "Ħ", "I", "Í", "Ì", "İ", "Î", "Ï", "Ī", "Į", "IJ", "Ĵ", "Ķ", "Ļ", "Ł", "Ń", "Ň", "Ñ", "Ņ", "Ó", "Ò", "Ô", "Ö", "Õ", "Ő", "Ø", "Ơ", "Œ", "ĥ", "ħ", "ı", "í", "ì", "i", "î", "ï", "ī", "į", "ij", "ĵ", "ķ", "ļ", "ł", "ń", "ň", "ñ", "ņ", "ó", "ò", "ô", "ö", "õ", "ő", "ø", "ơ", "œ", "Ŕ", "Ř", "Ś", "Ŝ", "Š", "Ş", "Ť", "Ţ", "Þ", "Ú", "Ù", "Û", "Ü", "Ŭ", "Ū", "Ů", "Ų", "Ű", "Ư", "Ŵ", "Ý", "Ŷ", "Ÿ", "Ź", "Ż", "Ž", "ŕ", "ř", "ś", "ŝ", "š", "ş", "ß", "ť", "ţ", "þ", "ú", "ù", "û", "ü", "ŭ", "ū", "ů", "ų", "ű", "ư", "ŵ", "ý", "ŷ", "ÿ", "ź", "ż", "ž");
    $to = array("A", "A", "A", "AE", "A", "A", "A", "A", "A", "AE", "C", "C", "C", "C", "C", "D", "D", "D", "E", "E", "E", "E", "E", "E", "E", "E", "G", "G", "G", "G", "G", "a", "a", "a", "ae", "ae", "a", "a", "a", "a", "ae", "c", "c", "c", "c", "c", "d", "d", "d", "e", "e", "e", "e", "e", "e", "e", "e", "g", "g", "g", "g", "g", "H", "H", "I", "I", "I", "I", "I", "I", "I", "I", "IJ", "J", "K", "L", "L", "N", "N", "N", "N", "O", "O", "O", "OE", "O", "O", "O", "O", "CE", "h", "h", "i", "i", "i", "i", "i", "i", "i", "i", "ij", "j", "k", "l", "l", "n", "n", "n", "n", "o", "o", "o", "oe", "o", "o", "o", "o", "o", "R", "R", "S", "S", "S", "S", "T", "T", "T", "U", "U", "U", "UE", "U", "U", "U", "U", "U", "U", "W", "Y", "Y", "Y", "Z", "Z", "Z", "r", "r", "s", "s", "s", "s", "ss", "t", "t", "b", "u", "u", "u", "ue", "u", "u", "u", "u", "u", "u", "w", "y", "y", "y", "z", "z", "z");
    $from = array_merge($from, $cyrylicFrom);
    $to = array_merge($to, $cyrylicTo);
    $newstring = str_replace($from, $to, $string);
    return $newstring;
  }
  function makeSlugs($string, $maxlen = 0) {
    $newStringTab = array();
    $string = strtolower(noDiacritics($string));
    if (function_exists('str_split')) {
      $stringTab = str_split($string);
    } else {
      $stringTab = my_str_split($string);
    }
    $numbers = array("0", "1", "2", "3", "4", "5", "6", "7", "8", "9", "-");
    //$numbers=array("0","1","2","3","4","5","6","7","8","9");
    foreach ($stringTab as $letter) {
      if (in_array($letter, range("a", "z")) || in_array($letter, $numbers)) {
        $newStringTab[] = $letter;
      } elseif ($letter == " ") {
        $newStringTab[] = "-";
      }
    }
    if (count($newStringTab)) {
      $newString = implode($newStringTab);
      if ($maxlen > 0) {
        $newString = substr($newString, 0, $maxlen);
      }
      $newString = removeDuplicates('--', '-', $newString);
    } else {
      $newString = '';
    }
    return $newString;
  }
  function checkSlug($sSlug) {
    if (preg_match("/^[a-zA-Z0-9]+[a-zA-Z0-9\-]*$/", $sSlug) == 1) {
      return true;
    }
    return false;
  }
  function removeDuplicates($sSearch, $sReplace, $sSubject) {
    $i = 0;
    do {
      $sSubject = str_replace($sSearch, $sReplace, $sSubject);
      $pos = strpos($sSubject, $sSearch);
      $i++;
      if ($i > 100) {
        die('removeDuplicates() loop error');
      }
    } while ($pos !== false);
    return $sSubject;
  }
  $vesti_tag_slug = makeSlugs($string, $maxlen = '0');
  /* /. SLUG */

So I want to have tags like: sport | fudbal | cetvrta-liga

Can You help how can I get the links that You se above?

Thanks in advanced!

T

Hi Guys,

 

How do i put a comma separator after a thousand ?

Example if $grand28 was equal to 1234.00 how do i get it to read 1,234.00

 

here is my code

" . sprintf("%.2f", $grand28) . "

 

hi, i have a script that inserts a csv into mysql.  i run into errors when there is an empty field

example:

Code: [Select]
filed1,field2,field3,,field5,,field7
here is my code that processes it.

Code: [Select]
$handle = fopen("uploads/$filename", "r");

while(($data = fgetcsv($handle, 1000, ",")) !== FALSE)      {



$import .= "INSERT into goaliestats(id,name,gp,w,so,gaa,date) values(NULL,'$data[0]','$data[2]','$data[8]','$data[26]','$data[18]','$data[28]')" . "\n";

mysql_query($import) or die(mysql_error());
}


fclose($handle);

is there a way i can make a ,, into ,0,

?

thanks!

I want to retrieve items from the DB and seperate them using a comma...

while i know how to actually do that, what i want is to automatically have stop adding comas at the last item...

so if there are 4 items i want it to show a comma after each item except the last one (1, 2, 3, 4).

Does anyone know of a function or can give me an example on how i can do this.

Hello Guys,

I check the price field on the server side and I am trying to figure out how to allow a comma in the price field

example 2,300

Here is the code I use to check the price.
Code: [Select]
function check_Price($price,$member_id,$description,$ip){
if (isset($price) && (!is_numeric($price)))
{
      do something here
}

}
Thanks in Advance!
Dan

Hi everyone,

Basically i have a little task to do and was wondering if anyone is able to help, i would very grateful

First task is for me to read a comma delimted file into PHP and store everything into an Array:

Comma Delimited File = "houses.txt" (As a reference it means, PostCode, Price ('000's), picture and houses visits)
HA11QS, 200, house1.jpg, 4
HA22BR, 280, house2.jpg, 10
HA33AB, 390, house3.jpg, 3
HA44CD, 320, house4.jpg, 8

my basic php for now is:
Code: [Select]
<?php

function getHouse ()
{
$filename = "houses.txt";
$fileRead   = fopen($filename, "r");

$rowsArr  = file ($filename);
for ($i=0; $i < count($rowsArr); $i++)
{
$lineDetails = $rowsArr[$i];
print  $lineDetails . "<br>" ;
}

fclose($fileRead);
}
?>

<h3> Welcome </h3>

<p> PostCode Number Picture Visits </p>

<?php

echo getHouse();

?>

What i need to do next is to have a static web form where a user can input a maximum price e.g. 300
And that will return all the houses which are under 300 by reading the whole array

I have a basic form setup:

Code: [Select]
<form method="post" action="maxtest.php" >
<input type="text" name="userprice" value="" />

<input type="submit" name="button" value="Submit" />
</form>
and also i have a an idea that i need something along the lines of:
Code: [Select]
$userValue = $_POST['userprice'];

if ($userValue == 300)

{
}

Im a bit stuck on how to incorporate the comma delimted array

Please help me, thank you

Sometimes my 3 column .csv file has commas within quotes:
fruit , cherry , red
vegetables , "celery, carrots" , green
flowers , rose , fresh

When I use this code, I need the data count to stay the same "3" for each row:

while (($data = fgetcsv($handle,2000,',')) !== FALSE) {
print count($data); // prints "3" ... then prints "4" .... then prints "3"
}

How do I get fgetcsv to see that "celery, carrots" is just one unit of data?

Thank you.

Edited April 15, 2020 by StevenOliver