PHP生成jQuery数据

Question

I want to use a jQuery powered chart. If the jQuery wants data like such:

 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
 }],

How do I generate this using MySQL and PHP?

Answer 1

This code may helps you

$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);