Filling Javascript array with objects properties from database

Question

Hi I'm trying to make an array " events" in javascript that is filled with objects of two properties {Title: , Date:}

But, the value of those two properties is brought from the database using PHP!

Here's my code but I don't know why it doesn't work..

var events = [ 
    <?php 



//Connect to mysql server
//Select database

    $result=mysql_query("SELECT * FROM event");
    $count = mysql_num_rows($result);
    if($count>0){
    for($i=0;$i<$count-1;$i++){
    $row= mysql_fetch_row($result);

    echo "{ Title: ".$row['title'].", Date: ".$row['date']." },";
        }

    $row= mysql_fetch_row($result);
    echo "{ Title: ".$row['title'].", Date: ".$row['date']." }";

    }
    ?>];

This code is wrong on so many levels that it's hard to describe exactly how. Take a step back and try one thing at a time. — Jon
– Jon, Commented Dec 13, 2012 at 23:30
Do you really mean the following: $i<$count-1 If $count is 1, you won't get any results. — user1884047
– user1884047, Commented Dec 13, 2012 at 23:31
@Jon I'm a beginner and I'm trying to collect things together. I'll try again. :( — Lamia
– Lamia, Commented Dec 13, 2012 at 23:31

Jason Sperske · Accepted Answer · 2012-12-13 23:46:18Z

1

Let's first take the building of your results:

Use array_push to create your data from your SQL (this is called an associative arrays:

var events = 
<?php 
  $json = array();
  $result=mysql_query("SELECT * FROM event");
  $count = mysql_num_rows($result);
  for($i=0;$i<$count;$i++) {
    $row= mysql_fetch_row($result);
    $item = array();
    $item['Title'] = $row['title'];
    $item['Date'] = $row['date'];
    $json[] = $item;
  }

Now echo the results as JSON using json_encode:

  echo json_encode($json);
?>;

Tested in PHP 5.3.2

edited Dec 13, 2012 at 23:46

answered Dec 13, 2012 at 23:39

Jason Sperske

30.5k8 gold badges77 silver badges127 bronze badges

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

6 Comments

Lamia Over a year ago

It didn't work unfortunately. It only works with this var events = [ { Title: "Five K for charity", Date: new Date("02/13/2011") }, { Title: "Dinner", Date: new Date("02/25/2011") }, { Title: "Meeting with manager", Date: new Date("12/01/2012") } ]; but when I try php nothing happens :( Thank you anyway.

Jason Sperske Over a year ago

Can you add an example of the JSON you want it to return?

Lamia Over a year ago

like this ? var events = [ { Title: "Five K for charity", Date: new Date("02/13/2011") }] Title and Date are retrieved from database.

Jason Sperske Over a year ago

Sorry, I understand that part, maybe I'm having trouble understanding where your code was breaking. Are you having trouble before you get to the encode part? Your question title suggests that you are having trouble encoding an array into JavaScript

Jason Sperske Over a year ago

can you look at the /var/log/apache/error.log it will have the last PHP error at the bottom

|

Collectives™ on Stack Overflow

Filling Javascript array with objects properties from database

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related