php mysql- put mysql_fetch_array() result in to a string and split the string by comma

Question

I have a mysql table(request) here:

request:
r_id     item_no
  1         1
  13        10
  22        20
  33        30 
  55        40

Now, I'm using php to take r_id out using mysql_fetch_array() and try to put mysql_fetch_array() result in to a string also split the string by comma.

<?php   
include('config.php'); //connect to mysql
function f(){
    $sql = "SELECT r_id FROM `request` ";
    $result=mysql_query($sql);
    $string = '';
    $i = 0; 
    while ($row = mysql_fetch_array($result)) {
        $string .= $row[$i];
    }
    $newstring = implode(", ", preg_split("/[\0-9]+/", $string));
    return  $newstring ;
}

$get=f();
echo $get;
?>

But I cannot get the right string form my php code.

I want to get the string like

1,13,22,33,55

How can I fix the problem?

what you are getting??

Priyank
– Priyank

2015-04-08 07:31:18 +00:00
Commented Apr 8, 2015 at 7:31 — Priyank
– Priyank, Commented Apr 8, 2015 at 7:31

n-dru · Accepted Answer · 2015-04-08 07:25:00Z

4

You don't need to split that and implode, just do this:

while ($row = mysql_fetch_array($result)) {
    $string .= $row[$i].',';// append comma after each value you append to the string
}
return substr($string,0,-1);// cut off the trailing comma from the final string

answered Apr 8, 2015 at 7:25

n-dru

9,4402 gold badges31 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sanjay Kumar N S · Accepted Answer · 2015-04-08 07:24:37Z

0

<?php   
include('config.php'); //connect to mysql
function f(){
    $sql = "SELECT GROUP_CONCAT(r_ID) FROM `request` ";
    $result=mysql_query($sql);
    return  $result ;
}

$get=f();
echo $get;
?>

answered Apr 8, 2015 at 7:24

Sanjay Kumar N S

4,7595 gold badges25 silver badges41 bronze badges

Comments

Priyank · Accepted Answer · 2015-04-08 07:47:38Z

0

Try my updated answer:

$sql = "SELECT r_id FROM `request` ";
$result=mysql_query($sql);
$string = '';
$i = 0; 
while ($row = mysql_fetch_array($result)) {
    $string .= $row[$i].",";
}
return  $string ;
}

edited Apr 8, 2015 at 7:47

answered Apr 8, 2015 at 7:23

Priyank

3,8884 gold badges33 silver badges50 bronze badges

Comments

Sheepy · Accepted Answer · 2015-04-08 08:28:33Z

0

$array = array();
while(...){
   $array = $row[$i]; //first you need array 
}
$string = implode(",",$array); //now you have your string

edited Apr 8, 2015 at 8:28

Sheepy

18.1k4 gold badges49 silver badges70 bronze badges

answered Apr 8, 2015 at 7:31

Vlad Mazur

641 silver badge6 bronze badges

1 Comment

Priyank Over a year ago

always follow the stackover flow standards for giving the answer

Collectives™ on Stack Overflow

php mysql- put mysql_fetch_array() result in to a string and split the string by comma

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related