PHP - Stipping Last Comma

hello all,

i have a small problem.  i have a bunch of prices in a database like 243.49 and 1,256.22 etc.

the problem is that when i try to add multiple prices that one of the fields is over 1000, it is treating it as 1 (i believe because of the comma.)

is there a way to remove the comma, but not the decimal if it exists and then add it back to the $total if it is over 1000?

Code: [Select]
  $pamount=$row2['amount'];
 
$total += $pamount;

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!

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

Hi guys,

Currently my result displayed a 'comma' at the end

Lower Primary
English, Math, Science, Chinese,

How do I remove the comma which is bold in red? Thank you so much

My code
Code: [Select]
while($row3 = mysqli_fetch_array($data3)) {
         if ($row3['level_id'] == 2) {
            echo ''.$row3['subject_name'].', ';
         }
      }

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 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 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, 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 have the following script which outputs different results based on weather a result is odd or even, pretty simple. The prblem lies with the very last result ouputted, as you can see from the code it will have a comma trailing it, which causes IE to not display the gallery.

Can Anyone advise me on how to remove this last comma/echo the last result differently.

Thank you


<?php
include "config.inc.php";
$num = 1;

function checkNum($num){
  return ($num%2) ? TRUE : FALSE;
}

$result = mysql_query( "SELECT photo_id, photo_filename FROM gallery_photos WHERE photo_category= 6 AND promo= 1 ");

$nr = mysql_num_rows( $result );

$NumOfRecords = mysql_num_rows($result);

while($row = mysql_fetch_array($result)) {

  

  $id = $row['photo_id'];

  $img = $row['photo_filename'];

  

  

  if(checkNum($num) === TRUE){

   echo "

   

  { src: 'admin/photos/".$img."', dir: 'left'   },";

  

  $num++;

  }

  
elseif ($num == $NumOfRecords) {
      echo "  { src: 'admin/photos/".$img."', dir: 'left'   }";
   }

  

  else{
  echo  "

   

  { src: 'admin/photos/".$img."', dir: 'right'   },";

  $num++;
}

}

      ?>

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 

So i have a blog that has the tags store in one field in my blog table. So tags are saved as this in each blog post with its respective tags.    Tags: john, carlos, the great tag, this is a tag   What i want to do is get random tags from each blog post and display them. I am not sure how i can begin to make this query. Do you guys have an idea on how to do this?     

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

I am extracting data from one of the sites.I would join these sentences separated by , (comma). The solution that comes to my head is by inserting the text in the file and then using file functions.However, i  was wondering if i can use str_replace here . Can anyone please point me in the right direction.

Code: [Select]
      Hospital 30-Day Death (Mortality) Rates from Heart Attack: 15.2% (No different than U.S. National Rate)
   
      Hospital 30-Day Readmission Rates from Heart Attack: % (Number of Cases Too Small*)
   
      Hospital 30-Day Death (Mortality) Rates from Heart Failu 10.5% (No different than U.S. National Rate)
   
      Hospital 30-Day Readmission Rates from Heart Failu 29.9% (Worse than U.S. National Rate)
   
      Hospital 30-Day Death (Mortality) Rates from Pneumonia: 9.8% (No different than U.S. National Rate)
   
      Hospital 30-Day Readmission Rates from Pneumonia: 20.6% (No different than U.S. National Rate)

I need to loop through my db and create strings from 2 columns on my db.

data in column1 is '22,33,33,33,25,25,25,14,14,14,14,14,14'
data in column2 is '11am,12pm,1pm,2pm,3pm,4pm,5pm,6pm,7pm,8pm,9pm,10pm, 11pm'

the end result I need is a string such as:

$body= "11am, 22 <line break> 12pm, 33 <line break> ......

If anyone has any examples of something like this or can get me started it would be much appreciated.

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