Remove commas from php array

Question

I'm currently working on displaying some arrays using PHP and MySQL.

Simplified code looks like this:

$sql = "SELECT * FROM workorder";
$result = mysqli_query($dbc3,$sql);
$tryout_reports = array();
while ( $row = mysqli_fetch_assoc($result) ) {
   $tryout_reports[] = $row['file_name'] . "<br />";
}
$detail_report['tryout_reports'] = $tryout_reports;

I took a lot out of the SQL here, so if there's something wrong in there please don't mind. The SQL statement works fine.

The problem is it's being outputted with commas separating each value, and it's looking real bad.

The HTML on the page when run looks something like this:

File1.pdf <br>
","
File2.pdf <br>
","
etc..

Now, I've looked around quite a bit and i've tried the following:

ltrim()
rtrim()
explode()
str_replace()

I know rtrim works, but it doesn't remove the commas. I tried something like:

$tryout_reports[] = rtrim($row['file_name'],"pdf");

And it took the pdf out of the end of each one, but when I replace "pdf" with "," it does nothing.

Feeling really stuck, any help would be really appreciated!

Thanks

EDIT: Forgot to add, the page that uses this data and displays it on the page has this:

table.append("<tr><th>Tryout Reports </th><td>" + data[0].tryout_reports + "</td></tr>");

That is inside of a jQuery function which runs when a job number is clicked to display additional information.

It's on a separate page. Using TWIG framework. There isn't much there, very basic. I'll edit it into the question, though — noelllll
– noelllll, Commented Nov 4, 2014 at 19:24
That comma comes from javascript because you parse directly the array. You can use join: w3schools.com/jsref/jsref_join.asp — Stefan
– Stefan, Commented Nov 4, 2014 at 19:28
possible duplicate of PHP preg_split remove commas and trailing white-space — Bijan
– Bijan, Commented Nov 4, 2014 at 19:32
where is comma added ?. As per your code, I don't see the comma.. — Asik
– Asik, Commented Nov 4, 2014 at 19:37

Stefan · Accepted Answer · 2014-11-05 20:08:42Z

1

That comma comes from javascript because you parse directly the array. You can use join: w3schools.com/jsref/jsref_join.asp

answered Nov 5, 2014 at 20:08

Stefan

1,2586 silver badges23 bronze badges

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

Collectives™ on Stack Overflow

Remove commas from php array

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related