Sfrgttk

How to cover method return statement in Apex Class?

System.QueryException unexpected token

What is the evidence for the "tyranny of the majority problem" in a direct democracy context?

Quoting Keynes in a lecture

How to explain what's wrong with this application of the chain rule?

Angel of Condemnation - Exile creature with second ability

Is aluminum electrical wire used on aircraft?

Mimic lecturing on blackboard, facing audience

Strong empirical falsification of quantum mechanics based on vacuum energy density

Why is this estimator biased?

Mixing PEX brands

Can I still be respawned if I die by falling off the map?

Why can Carol Danvers change her suit colours in the first place?

How to hide some fields of struct in C?

What to do when eye contact makes your subordinate uncomfortable?

Is this toilet slogan correct usage of the English language?

Probability that THHT occurs in a sequence of 10 coin tosses

putting logo on same line but after title, latex

Store Credit Card Information in Password Manager?

creating a ":KeepCursor" command

What exact color does ozone gas have?

Novel, Lo Tech SF/Fantasy

When were female captains banned from Starfleet?

Invalid date error by date command

Trying to SUM two separate columns but not together as part of a search result

index doesn't work properlyConnecting to MYSQL on an EC2 instanceQuotation and invoice mysql tableMySQL indexing issue when trying to search for a part of a string/wordMySQL is trimming my numbers and I can't figure out whyHow can I execute multiple procedures continuously?Trying to update timestamp using FROM_UNIXTIMEIn PHP MySQL how to sum or not sum multiple columns?Aggregate row sum two columns on table from same keyHow to group same columns from same two tables, but from two different result sets and/or conditions

-1

Code below:

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







       } catch(PDOException $error) {

             echo $sql . "<br>" . $error->getMessage();

             die();

             }



    }

the table is joblist, columns are work_order, customer, description, value, balance, staus and notes.

Current code in this screen works to the extent that it pulls data into my HTML table, I just need to fnd out how to pull the data in the array into the totals spot in the HTML table.

Here is an example of the table..

Ok i have touched this up, likely not correct but I am getting a var_dump from my array. I just don't know how to get the array into the HTML table now.

Link to my current code work

mysql php

share|improve this question

edited 5 mins ago

freebs

asked yesterday

freebsfreebs

11

New contributor

freebs is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Why the WHERE value = :total_value... ? What is it you want to show? A small sample of rows with wanted output would help.
  
  – ypercubeᵀᴹ
  yesterday
  
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  total_value I was trying to use a place holder for the SUM data to echo out to a line like I say I'm no guru on this stuff. just trying to get through it :)
  
  – freebs
  yesterday
  

  
  
  
  

add a comment | 

-1

Code below:

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







       } catch(PDOException $error) {

             echo $sql . "<br>" . $error->getMessage();

             die();

             }



    }

the table is joblist, columns are work_order, customer, description, value, balance, staus and notes.

Current code in this screen works to the extent that it pulls data into my HTML table, I just need to fnd out how to pull the data in the array into the totals spot in the HTML table.

Here is an example of the table..

Ok i have touched this up, likely not correct but I am getting a var_dump from my array. I just don't know how to get the array into the HTML table now.

Link to my current code work

mysql php

share|improve this question

edited 5 mins ago

freebs

asked yesterday

freebsfreebs

11

New contributor

freebs is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Why the WHERE value = :total_value... ? What is it you want to show? A small sample of rows with wanted output would help.
  
  – ypercubeᵀᴹ
  yesterday
  
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  total_value I was trying to use a place holder for the SUM data to echo out to a line like I say I'm no guru on this stuff. just trying to get through it :)
  
  – freebs
  yesterday
  

  
  
  
  

add a comment | 

Code below:

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







       } catch(PDOException $error) {

             echo $sql . "<br>" . $error->getMessage();

             die();

             }



    }

the table is joblist, columns are work_order, customer, description, value, balance, staus and notes.

Current code in this screen works to the extent that it pulls data into my HTML table, I just need to fnd out how to pull the data in the array into the totals spot in the HTML table.

Here is an example of the table..

Ok i have touched this up, likely not correct but I am getting a var_dump from my array. I just don't know how to get the array into the HTML table now.

Link to my current code work

mysql php

share|improve this question

edited 5 mins ago

freebs

asked yesterday

freebsfreebs

11

New contributor

freebs is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

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







       } catch(PDOException $error) {

             echo $sql . "<br>" . $error->getMessage();

             die();

             }



    }

share|improve this question

edited 5 mins ago

freebs

asked yesterday

freebsfreebs

11

New contributor

freebs is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

edited 5 mins ago

freebs

asked yesterday

freebsfreebs

11

New contributor

freebs is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked yesterday

freebsfreebs

11

New contributor

freebs is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked yesterday

freebsfreebs

11