Call to a member function bind_param() on a non-object on SELECTION statement

Question

I'm using the following code snippet to select number of rows from students table. But it shows the error "Fatal error: Call to a member function bind_param() on a non-object". In my table 'stacyear' is VARCHAR, and 'courseid' is TINY INT.

$stmt = $mysqli->prepare("SELECT count (*) FROM students WHERE stacyear = ? and courseid = ?");
$stmt->bind_param('si', $acyear, $courseid); 
$stmt->execute();    
$stmt->store_result();
$stmt->bind_result($utype);
$stmt->fetch();

Put this after your prepare: `if(!$stmt){ exit($mysqli->error); }` — TiiJ7, Apr 09 '15 at 09:50
It shows "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*) FROM students WHERE stacyear = ? and courseid = ?' at line 1" — Prasanth, Apr 09 '15 at 09:51
@paddyfields No they shouldn't. They're not reserved words, they don't have any special characters that need to be escaped. — Barmar, Apr 09 '15 at 09:53
I've solved it. I use the statement like this: $stmt = $mysqli->prepare("SELECT count(stname) FROM students WHERE stacyear = ? and courseid = ?"); — Prasanth, Apr 09 '15 at 09:59
You shouldn't use `COUNT(columnname)` intead of `COUNT(*)` unless the column might have nulls and you need to exclude them from the count. — Barmar, Apr 09 '15 at 10:03
See http://stackoverflow.com/questions/2876909/count-and-countcolumn-name-whats-the-diff — Barmar, Apr 09 '15 at 10:06

score 2 · Answer 1 · answered Apr 09 '15 at 09:52

2

You're not allowed to have a space between COUNT and (*). Change to

$stmt = $mysqli->prepare("SELECT count(*) FROM students WHERE stacyear = ? and courseid = ?");

answered Apr 09 '15 at 09:52

Barmar

741,623
53
500
612

For showing the correct issue instead of changing the query – Narendrasingh Sisodia Apr 09 '15 at 10:05

Call to a member function bind_param() on a non-object on SELECTION statement

1 Answers1