Want to call php file from javascript file

Question

I have php file which includes arrays and I want to call it from javascript file but I don't know the way

I tried this way but gives me unexpected error:

script.js file:

  google.charts.load('current', {'packages':['corechart', 'line']});
  google.charts.setOnLoadCallback(drawLineColors);
  function drawLineColors() {

    var data = new google.visualization.DataTable();
    data.addColumn('string', 'time');
   data.addColumn('number', 'Temperature');
   data.addColumn('number', 'Humidity');

    data.addRows([  

           <?php include 'data.php' ?>

    ]);

data.php file :

   <?php 
  $servername = "localhost";
 $database = "db";
 $username = "db";
 $password = "124";

 $connect = mysqli_connect($servername, $username, $password, $database);
 if (!$connect) {
  die("Connection failed: " . mysqli_connect_error());
  }
$query = 'SELECT * FROM climate';

$result = mysqli_query($connect, $query);


 ?>

<?php 


        if ($result->num_rows > 0) {
          while ($row = $result->fetch_assoc()) {
          echo "['".$row['time']."',".$row['temp'].",".$row['hum']."],";
           }
        }

      ?>

You will need to share how you output your values in data.php — Carlos Alves Jorge
– Carlos Alves Jorge, Commented May 14, 2019 at 10:03

Kunal Virk · Accepted Answer · 2019-05-14 10:06:15Z

1

I am assuming that you want your arrays from 'data.php' file to be pushed into data.addRows.

You can use jQuery AJAX, please find the below snippet :

$.get('data.php',function(arr, status) {
  console.log("YOUR ARRAY HERE", arr);
})

Hope it helps!!!

answered May 14, 2019 at 10:06

Kunal Virk

1715 bronze badges

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

4 Comments

M.Saeed Over a year ago

I have array in data.php I want to echo it and show it to data.addRows from javascript file

Kunal Virk Over a year ago

You can use json_encode in data.php to get it in your javascript file. ``` <?php $data = array(); if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { array_push($data, [$row['time'], $row['temp'], $row['hum']]); echo "['".$row['time']."',".$row['temp'].",".$row['hum']."],"; } } echo json_encode($data); ?> ```

M.Saeed Over a year ago

thanks Kunal , But I am still confused how can I call data.php file in my javascript file

Kunal Virk Over a year ago

Okay. In your scripts.js file : $.get snippet and in your php file use json_encode

Collectives™ on Stack Overflow

Want to call php file from javascript file

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related