Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- "Branch1": 663134.44
- "Branch1": 492784.54
- "Branch1": 757639.93
- "Branch1": 569404.61
- <?php
- $dbhost = 'localhost';
- $dbname = 'spmdb';
- $dbuser = 'root';
- $dbpass = '';
- try{
- $dbcon = new PDO("mysql:host={$dbhost};dbname={$dbname}",$dbuser,$dbpass);
- $dbcon->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- }catch(PDOException $ex){
- die($ex->getMessage());
- }
- $stmt = $dbcon->prepare("SELECT month.monthname,coll.branch,coll.cf FROM coll INNER JOIN month ON month.id = coll.`month` group by coll.month,coll.branch");
- $stmt->execute();
- $row1 = [];
- while($row=$stmt->fetch(PDO::FETCH_ASSOC))
- {
- extract($row);
- $row1[]= ['month' => $monthname, $branch => $cf];
- }
- echo json_encode($row1,JSON_NUMERIC_CHECK);
- ?>
- [{"month":"Jan","Branch4":40275}
- ,{"month":"Feb","Branch5":165173.91}
- ,{"month":"Feb","Branch1":93360.33}
- ,{"month":"Apr","Branch1":65415.75}]
Add Comment
Please, Sign In to add comment