Hello there, I am seeking guidance on how to implement an ajax function in yii2.
I am currently developing a product within the yii2 framework and wish to incorporate charts such as chartJs, googleChart, or d3. In the index file of the backend area (xx/xx/xx/dashboard/index.php), I aim to make an ajax request to another PHP file located in the same folder (xx/xx/xx/dashboard).
However, despite successful results when testing my files (indexAjax and phpDB) outside of the framework folders, they fail to work once integrated into the framework.
Below is the snippet of code from my index file:
<canvas id="mycanvas" width="400" height="400"></canvas>
<script>
$(function()
{
$.ajax({
url: "chartData.php",
type:'POST',
data:{'trigger':'trigger'},
success: function(data) {
alert(data);
console.log(data);
var idTab = [];
var resultatTab = [];
for(var i in data) {
idTab.push("data " + data[i].id);
resultatTab.push(data[i].resultat);
}
var chartdata = {
labels: idTab,
datasets : [
{
label: 'Player Score',
backgroundColor: 'deepskyblue',
borderColor: 'dodgerblue',
hoverBackgroundColor: 'orange',
hoverBorderColor: 'yellow',
data: resultatTab
}
]
};
var ctx = $("#mycanvas");
var doughnutGraph = new Chart(ctx, {
type: 'doughnut',
data: chartdata,
options:{responsive:false}
});
},
error: function(data) {
alert(JSON.stringify(data));
console.log(data);
}
});
}); // end jQuery
</script>This is the content of the second PHP file:
<?php
if (isset($_POST['trigger']))
{
// setting header to json
header('Content-Type: application/json');
// database connection details
define('DB_HOST', '127.0.0.1');
define('DB_USERNAME', 'root');
define('DB_PASSWORD', '');
define('DB_NAME', 'lab');
// establish connection
$mysqli = new mysqli(DB_HOST, DB_USERNAME, DB_PASSWORD, DB_NAME);
if(!$mysqli){
die("Connection failed: " . $mysqli->error);
}
// query to retrieve data from the table
$query = sprintf("SELECT * FROM score");
// execute query
$result = $mysqli->query($query);
// iterate through the returned data
$data = array();
foreach ($result as $row) {
$data[] = $row;
}
// free memory associated with result
$result->close();
// close connection
$mysqli->close();
// output the data
print json_encode($data);
}Note: I acknowledge that I did not strictly adhere to the principles of MVC by placing everything in the same folder, but it was a conscious decision.
Thank you for your assistance.