Dynamically Create JavaScript Object From MySQL Table

Question

Lets say I have this table mytable

id | name | x | y

I pull the the rows from mytable and create JavaScript objects with it like so:

PHP

$sql = "SELECT * FROM mytable";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {  
        echo '<script type="text/javascript">';
        echo "new Object({$row["id"]}, '{$row["name"]}', {$row["desk_x"]}, {$row["desk_y"]});";
        echo '</script>';            
    }
}

JS

function Object(id, name, x, y) {
    var obj = {
        id:id, 
        name:name, 
        x:x, 
        y:y
    };
}

At the moment this is fine but lets say I want to add another column color to mytable

Basically I'm asking what do I write in PHP and JS to make this object dynamically, so you can have any columns and the Object object will just add a new property with the name of the column?

Don't call your function Object! Object already exists, and you will overwrite it, losing access to the original Object. And also, Object isn't really an expressive name for a constructor, is it? — PeterMader
– PeterMader, Commented Jul 18, 2017 at 12:25

Ionut Necula · Accepted Answer · 2017-07-17 12:48:02Z

2

You can use AJAX to send data from serverside to clientside. Lets say you have a PHP file called script.php with your code:

if(isset($_GET['action']) && $_GET['action'] == 'testing'){
    $sql = "SELECT * FROM mytable";
    $result = $conn->query($sql);

    if ($result->num_rows > 0) {
          echo json_encode($result);
    }
}

And lets say you have a JS file called script.js. Here you will do your AJAX call towards the PHP script file like this:

$.ajax({
  type: 'GET',
  url: 'script.php',
  data: { action: 'testing' },
  success: function(response){
     console.log(response); //here you will have access to the object returned from the PHP script
  }
})

edited Jul 17, 2017 at 12:48

answered Jul 17, 2017 at 12:13

Ionut Necula

11.6k4 gold badges49 silver badges72 bronze badges

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

5 Comments

Adam Stück Over a year ago

Im looking for a way to get the columns from the table and make a java-script object with the same properties

Ionut Necula Over a year ago

The code from my answer should do just what you need.

Adam Stück Over a year ago

The console is printing my entire index.php file

Ionut Necula Over a year ago

It depends on what is in that PHP file. It should be only the part of code I just added to my answer. Or you can check the $_GET request.

Ionut Necula Over a year ago

@AdamStück, please check the updated code from my answer.

user5734311 · Accepted Answer · 2017-07-17 12:34:11Z

1

I guess what you're looking for is how to do this without AJAX (which you don't really need here).

Put the objects in an array, then output your JS variable:

PHP:

$rows = [];
if ($result->num_rows) 
  while($row = $result->fetch_assoc()) $rows[] = $row; // append to array
echo "<script> var objArray = " . json_encode($rows) . "; </script>";

answered Jul 17, 2017 at 12:34

user5734311

4 Comments

Adam Stück Over a year ago

How would you do this using AJAX if it is better?

user5734311 Over a year ago

That sounds as if you have no idea what AJAX is/does. And you didn't say whether you tried my code. Or whether it works.

Adam Stück Over a year ago

i tried your code and it works but if AJAX is the better option could you show me what you would write? I tried the AJAX code from @Ionut above but it didn't work well. I'm using AJAX to update data on my database already by the way.

user5734311 Over a year ago

I have no idea if AJAX is the better option or if you even need it. I'm sorry but it's kind of hard for me to estimate your level of knowledge, and I have no idea how much more info you need (and SO isn't a beginner's coding school). Asking me to transform my code to AJAX means you have no idea how to use it, and this question (or website) is not the place to learn how to use AJAX.

Collectives™ on Stack Overflow

Dynamically Create JavaScript Object From MySQL Table

2 Answers 2

5 Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related