php - PHP生成jQuery数据

我想使用jQuery驱动的图表。如果jQuery需要这样的数据：

 data: [{
     period: '2011 Q1',
     sales: 1400,
     profit: 400
 }, {
     period: '2011 Q2',
     sales: 1100,
     profit: 600
 }, {
     period: '2011 Q3',
     sales: 1600,
     profit: 500
 }, {
     period: '2011 Q4',
     sales: 1200,
     profit: 400
 }, {
     period: '2012 Q1',
     sales: 1550,
     profit: 800
 }],

如何使用MySQL和PHP生成此文件？

最佳答案

此代码可以帮助您

$my_array = array();
$custom_variable = "anything";
$con=mysqli_connect("localhost",'username','password','databaseName');
// Check connection
if (mysqli_connect_errno())
{
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

$fetch = mysqli_query($con,"SELECT * FROM your_table");

while ($row = mysqli_fetch_array($fetch)) {
    $my_array['col1'] = $row['col1'];
    $my_array['col2'] = $row['col2'];
    $my_array['custom_col'] = $custom_variable;
}

echo "data:".json_encode($my_array);
mysqli_close($con);