1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
|
<?php
include('includes/sql.php');
// Create connection
$conn = new mysqli(dServername, dUsername, dPassword, dDbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$dataPoints = []; // on initialise le tableau
$sql_asset = "SELECT date, open, high, low, close FROM asset";
$result_asset = $conn->query($sql_asset);
while ($row = $result_asset->fetch_assoc()) {
$dataPoints[] = ["x" => $row['DATE'], "y" => [$row['OPEN'], $row['HIGH'], $row['LOW'], $row['CLOSE']]];
}
echo '<pre>';
var_dump($dataPoints);
echo '</pre>'; |