[RESOLVED] Call to undefined method mysqli_stmt::bindParam()

Gambid

Hi everyone,

I am currently trying to convert my PHP Website statemets from the old mysql to mysqli and use prepared statements. I use Eclipse with PDT and a ZendDebugger on a Windows 7 OS with IIS 7.

The following code produces the following error: Call to undefined method mysqli_stmt::bindParam()

$stmt = $GLOBALS['f_dbLink'] -> prepare("SELECT post_text, bbcode_uid
		FROM phpbb3_topics t, phpbb3_posts p, phpbb3_users u
		WHERE t.forum_id = ? AND t.topic_id = ?
		AND topic_first_post_id = post_id AND topic_first_poster_name = username");

$stmt->bindParam(1, $GLOBALS['contentForumID']);
$stmt->bindParam(2, $GLOBALS['contentID']);

$stmt -> execute();

The $stmt is created successfully as far as I can tell from the Debugger.

Does any of you have an idea?

Gambid

Ops, sorry forgot something:

I am using PHP Version 5.2.10 and MySQL 5.1.37

NogDog

The method name is "bind_param", not "bindParam". (I think there's something confusing in the data editors use for auto-completion, because I remember running into the same confusion.)

Gambid

Now, this is embarrassing.

I guess I am so used to Eclipse showing errors in Java directly, that I don't even think of misspelling errors.

It's a bad thing that PDT do not support auto-completion for member Methods nor recognize non existing ones.

Thanks for the help man, you sure saved me a lot of time.

I guess this can be marked as resolved. I have a few more questions but will post them in separate topic.

NogDog

As thread starter, you can mark it resolved via the "Thread Tools" link at the top.