Populate Javascript array with PHP values and add quotes around each one

Question

I have the following query to select the last five days price values:

$five_days_history = self::$db->select("SELECT CLOSE, TRADE_DATE
  FROM FF_HISTORICAL_STOCK_PRICE
  WHERE TRADE_DATE >= DATE_SUB(CURDATE(), INTERVAL 5 DAY) AND date <= CURDATE() and SYMBOL='$stock_symbol'
  ORDER BY TRADE_DATE DESC");

I need to get the TRADE_DATE output into the following type of JS array:

labels: ["January", "February", "March", "April", "May", "June", "July"],

I want to replace the months with my date output. I try and get it into a comma separated list which works fine with the below code:

$five_day_ouput = array();
foreach ($five_days_history as $five_history) {
    $display_date = date('m/d/Y', strtotime($five_history['TRADE_DATE']));
    array_push($five_day_ouput, $display_date);
}
$five_day_ouput = implode(', ', $five_day_ouput);

When I do a print_r I get the following results:

06/08/2016, 06/07/2016, 06/06/2016, 06/05/2016, 06/04/2016, 06/03/2016

I then tried to replace my label with the following code:

labels: [<?php echo $five_day_output; ?>],

It isn't working because I don't have quotes around my values. How could I do this?

Chin Leung · Accepted Answer · 2016-06-08 20:23:52Z

1

You could simply add the quotes to the date when you're converting it to another format.

Try replacing:

$display_date = date('m/d/Y', strtotime($five_history['TRADE_DATE']));

By:

$display_date = date('"m/d/Y"', strtotime($five_history['TRADE_DATE']));

Now when you do the print_r, instead of displaying:

06/08/2016, 06/07/2016, 06/06/2016, 06/05/2016, 06/04/2016, 06/03/2016

It should display:

"06/08/2016", "06/07/2016", "06/06/2016", "06/05/2016", "06/04/2016", "06/03/2016"

edited Jun 8, 2016 at 20:23

answered Jun 8, 2016 at 19:33

Chin Leung

15k4 gold badges38 silver badges64 bronze badges

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

6 Comments

user1048676 Over a year ago

Thanks, if I do that the results on the graph aren't as I expect when I use the new variable and put it in the labels as a PHP variable. However if I print_r the array and copy and paste that into the labels it outputs correctly. Any idea why it would do that and doesn't like it straight from the PHP variable?

Chin Leung Over a year ago

Oops @RolandStarke ! Corrected :)

user1048676 Over a year ago

Oddly enough, I'm not sure what happened but your first answer works now.

Chin Leung Over a year ago

The one where I asked your to add quotes @user1048676?

Chin Leung Over a year ago

Well it's working because it's adding the double quotes to the date. But I thought you needed the date value somewhere else @user1048676?

|

D.Dimitrioglo · Accepted Answer · 2016-06-08 19:36:51Z

1

Just encode your array to json with json_encode php command.

json_encode(['06/08/2016', '06/07/2016', '06/06/2016', '06/05/2016', '06/04/2016', '06/03/2016']);

answered Jun 8, 2016 at 19:36

D.Dimitrioglo

3,6632 gold badges25 silver badges43 bronze badges

7 Comments

user1048676 Over a year ago

If I do this, the output to the screen is null. I tried echo json_encode($five_day_output);

D.Dimitrioglo Over a year ago

are you sure that your $five_day_output is an array and not empty?

user1048676 Over a year ago

yes, if I do print_r for the array I get 06/08/2016, 06/07/2016, 06/06/2016, 06/05/2016, 06/04/2016, 06/03/2016

D.Dimitrioglo Over a year ago

if it is an array you shoud receive something like this: Array ( [0] => 06/08/2016 [1] => 06/07/2016 [2] => 06/06/2016 [3] => 06/05/2016 [4] => 06/04/2016 [5] => 06/03/2016 ) do you? You also can check your variable print_r(is_array($five_day_output));

user1048676 Over a year ago

Sorry, I forgot a line where I was imploding it to get the commas which I thought I needed. When I do the json_encode, it still shows up weird on the graph. Only when I type the same string in manually does the graph show up correctly.

|

Collectives™ on Stack Overflow

Populate Javascript array with PHP values and add quotes around each one

2 Answers 2

6 Comments

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related