Php Sum with PDO Function with mysql

Question

New to PDO ... i am trying to get sum but getting error here is my code

function test_score_month($student_id){
    global $host, $dbname, $user, $pass;

    $DBH = new PDO("mysql:host=$host;dbname=$dbname", $user, $pass);
    $STH = $DBH->query("SELECT SUM(score), SUM(score_from) FROM school_test_report
    WHERE 
     school_test_report.test_date >= last_march() and school_test_report.test_date <= march()" );
    $STH->setFetchMode(PDO::FETCH_BOTH);
    return $STH;
}

out put is

$student_id = test_score_month($name);
echo $student_id['SUM(score)'];

but getting error

Call to a member function setFetchMode() on a non-object in

i have tryed

$STH->setFetchMode(PDO::FETCH_ASSOC);

but still same error

Does $STH have error info? nl3.php.net/manual/en/pdostatement.errorinfo.php — dododedodonl
– dododedodonl, Commented May 27, 2012 at 11:09
This is why PDO should be configured to throw exceptions on errors. Your query fails to be executed (because of WHERE AND), but you don't check the return value. — user1233508
– user1233508, Commented May 27, 2012 at 11:11
sorry ad was typing mistake still getting that error without AND — Harinder
– Harinder, Commented May 27, 2012 at 11:14

dev-null-dweller · Accepted Answer · 2012-05-27 11:20:53Z

1

You have syntax error in your query:

WHERE 
    and

also are you sure that you have march() and last_march() functions in your DB ?

[+] Always check for errors after querying database:

if($STH){
 // do your stuff
}else{
 die($DBH->errorInfo()); // see the error
}

See http://www.php.net/manual/en/pdo.errorinfo.php

edited May 27, 2012 at 11:20

answered May 27, 2012 at 11:11

dev-null-dweller

29.5k3 gold badges68 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Harinder Over a year ago

sorry and was typing mistake still getting that error without AND

Harinder Over a year ago

now i am trying to modify my script and still getting error SELECT SUM(score), SUM(score_from) FROM school_test_report WHERE student_id='$student_id' keeping it simple now i am getting output error $student_id = test_score_month($name); echo $student_id['SUM(score)']; Cannot use object of type PDOStatement as array

Alix Axel Over a year ago

@Harinder: Are you doing $STH->fetch()?

Collectives™ on Stack Overflow

Php Sum with PDO Function with mysql

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related