PHP - Separating By Comma

Hi Guys

I'm returning to programming after 5 years, almost a newbie.

I have a field(column) in a MySQL database table that has strings of characters separated by a delimiter (||).

For example: (TOM||PAUL||HARRIS)

I would like to separate the strings into an array.

Something like this:
ARRAY[0] = 'TOM';
ARRAY[1]='PAUL';
ARRAY[3]='HARRIS';

Can some one tell me how to do this?

TIA.

This is a LINK to the page -> http://shoutkey.com/carriage

I have a problem of separating MySQL concatenated info, yet still maintaining their relationship to other arrays in the same order. First off here is the MySQL code:

Code: [Select]
$query ="SELECT report,";
$query.="GROUP_CONCAT(DISTINCT docID) AS docIDs, ";
$query.="GROUP_CONCAT(DISTINCT analyst) AS analysts, ";
$query.="GROUP_CONCAT(DISTINCT region) AS regions, ";
$query.="GROUP_CONCAT(DISTINCT country) AS countries, ";
$query.="GROUP_CONCAT(DISTINCT topic) AS topics, ";
$query.="GROUP_CONCAT(DISTINCT date) AS dates, ";
$query.="GROUP_CONCAT(DISTINCT event) AS events, ";
$query.="GROUP_CONCAT(DISTINCT link) AS links, ";
$query.="GROUP_CONCAT(DISTINCT province) AS provinces ";
$query.="FROM reports GROUP BY report ORDER BY dates DESC, docIDs DESC";
The most important thing is to get all attributes about each report. The thing is, each report can have as many records as it must, in order to store various types of information, like, if multiple analysts are working on the report, then each one saves their own record, but when retrieving these records MYSQL concatenates the records, to make it look to the analysts like this

Report 1 --- Josh, Rebecca --- Philippines

However, my problem is trying to display the reports by country... as you can see http://shoutkey.com/carriage. I have no idea about how to split up the countries, while maintaining their relationship to the $rows pulled from MySQL. I am gonna post the entire code, and let me know if anybody has any ideas.

Code: [Select]
$result = mysql_query($query);

$numrows = mysql_affected_rows();


$current = false;                 
while($row=mysql_fetch_assoc($result)) {
$dates = $row['dates'];
$analysts = $row['analysts'];
$provinces = $row['provinces'];
$topics = $row['topics'];
$regions = $row['regions'];
$countries = $row['countries'];
$reports = $row['report'];
$links = $row['links'];
$events     = $row['events'];

if (!$current){ //first call
echo "<h3><a href=\"#\">{$countries}</a></h3>"; //echo first call
  $current = $countries;
echo "<div>" ;//open content div
}
elseif($current != $countries){ // country has changed
echo "</div>"; //close previous content div
echo "<h3><a href=\"#\">{$countries}</a></h3>"; //echo subsequent countries
    $current = $countries;
    echo "<div><p>" ;//open content div
}


echo $analysts." ----- ".$provinces." ----- ".$reports;
echo "<br /><br />";

}
echo "</div>";
?>
    </div>       

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 All,
I'm sure there is an easy solution for this but I am unable to find it.
I am new to PHP and after a little help...

the via data is stored in a database in this format... |51.105166,-1.695971|51.011055,-2.1068|50.945233,-2.617664||||

I'm trying to find a way of loosing the last comma if there are 1 or more entries, any ideas guys.



What I'm getting is : Code: [Select]
var points = [{location: '51.105166,-1.695971'},{location: '51.105166,-1.695971'},];
What I'm after is: Code: [Select]
var points = [{location: '51.105166,-1.695971'},{location: '51.105166,-1.695971'}];

Code: [Select]
<?php
if($via != null){
echo "var points = [";
foreach($via as $point){
if($point != ""){
echo "{location:";
echo " '".$point."'";
echo "},";
}
}
echo "];\n";
}
?>

Hey,
i got this code which takes info from mysql:

  while ($row= mysql_fetch_array($result)) {
  $title = $row["alertid"];
  $title2 = $row["alerttext"];
  $title3 = $row["alertdate"];



$bla = "{\"alertid\":\"$title\",\"alerttext\":\"$title2\",\"alertdate\":\"$title3\"},";

echo "$bla";
}

it is displayed like this:

[{"alertid":"1","alerttext":"text1","alertdate":"date1"},{"alertid":"2","alerttext":"text2","alertdate":"date2"},{"alertid":"3","alerttext":"text3","alertdate":"date3"},]


I wanted to ask, how can I remove the last comma, after date3"}, but keep other commas..?

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!

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;


}

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;

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

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!

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'].', ';
         }
      }

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!

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

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++;
}

}

      ?>