Get sum of MySQL column in PHP

by

You can completely handle it in the MySQL query:

SELECT SUM(column_name) FROM table_name;

Using PDO (mysql_query is deprecated)

$stmt = $handler->prepare('SELECT SUM(value) AS value_sum FROM codes');
$stmt->execute();

$row = $stmt->fetch(PDO::FETCH_ASSOC);
$sum = $row['value_sum'];

Or using mysqli:

$result = mysqli_query($conn, 'SELECT SUM(value) AS value_sum FROM codes'); 
$row = mysqli_fetch_assoc($result); 
$sum = $row['value_sum'];

More Related Contents:

  1. How to get the value which user has selected in php?
  2. Organization db for blog posts with Mysql and Php [closed]
  3. How to resolve ambiguous column names when retrieving results?
  4. Incorrect Integer (2147483647) is inserted into MySQL?
  5. I need my PHP page to show my BLOB image from mysql database
  6. Delete multiple rows by selecting checkboxes using PHP
  7. Object of class DateTime could not be converted to string
  8. PHP MYSQL UPDATE if Exist or INSERT if not?
  9. mysql_real_escape_string VS addslashes
  10. Codeigniter Transactions
  11. PDO::rowCount VS COUNT(*)
  12. How can I select rows in MySQL starting at a given row number?
  13. how to fetch all the row of the result in php mysql?
  14. Coverting Hex to Image in PHP?
  15. How to log in to phpMyAdmin with WAMP, what is the username and password?
  16. Save Accents in MySQL Database
  17. PHP: mysql v mysqli v pdo [closed]
  18. How do I ensure I caught all errors from MySQLi::multi_query?
  19. PHP MySQL set Connection Timeout
  20. Sort by date (newest)
  21. How can I insert large files in MySQL db using PHP?
  22. The ultimate emoji encoding scheme
  23. mysql count occurrences of special character in a field
  24. How can I generate a round robin tournament in PHP and MySQL?
  25. get_result() Doesn’t Work even mysqlnd is enabled
  26. Add Prefix to auto-increment in mysql db
  27. Why cannot the PHP hide the error message thrown by the MySQL connection?
  28. MySQL Join Multiple Rows as Columns
  29. MySQL PHP – SELECT WHERE id = array()? [duplicate]
  30. Join subquery with doctrine 2 DBAL

Leave a Comment