$db = new PDO($dsn, $username, $password, $options);
    $db1 = new PDO($dsn, $username, $password, $options);
    $db2 = new PDO($dsn, $username, $password, $options);

    $sql = "SELECT
                *
            FROM joblist
            WHERE customer = :customer";

    $sql_val = "SELECT customer,
                        SUM(value) AS total_value
                FROM  joblist
                GROUP By customer";

    $sql_bal = "SELECT customer,
                    SUM(balance) AS total_balance
                FROM joblist
                GROUP By customer";

   //var_dump($sql_bal);


   $customer = $_POST['customer'];
   $statement = $db->prepare($sql);
   $statement->bindParam(':customer', $customer, PDO::PARAM_STR);
   $statement->execute();
   $result = $statement->fetchAll();

   // total SUM for value

   $stmt = $db1->prepare($sql_val);
   $stmt->execute();
   $totalv = $stmt->fetchAll(\PDO::FETCH_GROUP|\PDO::FETCH_ASSOC);

   $sumv = array_sum(array_column($totalv, 'total_value'));

   var_dump($totalv);


   // total SUM for balance

   $stmt1 = $db2->prepare($sql_bal);
   $stmt1->execute();
   $totalb = $stmt1->fetchAll(\PDO::FETCH_GROUP|\PDO::FETCH_ASSOC);
   $sumb = array_sum(array_column($totalb, 'total_balance'));
   //var_dump($totalb);

   } catch(PDOException $error) {
        echo $sql . "<br>" . $error->getMessage();
       die();
       }

 }