How to get a value from a mysql table using php to convert to json and then operate on it in javascript?

Question

JavaScript

I have a task book. And according to the assignment, I need to add a function for displaying notifications. The user specifies the time it is recorded in the database. And when the page is loaded, all data from the database goes to json, from there to an array that checks every 10 seconds whether the condition is true (the time specified by the user and the present time).

Answer 1

It's primitive, but it's reliable... json_name= can already be written in the script, so that it would be more convenient to read later

var a = json_name={
name: ''+event.target.id+'',
time: '<?php echo''.$fulluri2.'' ; ?>',
 c: ' собака <?php  echo ''.$list.''; ?>'
};
var dAnimal = JSON.stringify(a);

Answer 2

Connecting to a database in PHP.

$mysqli = new mysqli("HOSTNAME","USERNAME", "PASSWORD", "DATABASE");
$mysqli->query("SET NAMES utf8");

$result = $mysqli->query("SELECT * FROM users");
return json_encode($result); // полученные данные преобразует в JSON