Re: Problem with mysqli_stmt_bind_param()

Path	csiph.com!usenet.pasdenom.info!weretis.net!feeder1.news.weretis.net!feeder.erje.net!eu.feeder.erje.net!fu-berlin.de!uni-berlin.de!not-for-mail
From	"M. Strobel" <sorry_no_mail_here@nowhere.dee>
Newsgroups	comp.lang.php
Subject	Re: Problem with mysqli_stmt_bind_param()
Date	Fri, 09 Nov 2012 09:51:30 +0100
Lines	52
Message-ID	<ag3ugiFk2glU1@mid.uni-berlin.de> (permalink)
References	<_vOdnZvEQpjeuwHNnZ2dnUVZ7q6dnZ2d@giganews.com>
Mime-Version	1.0
Content-Type	text/plain; charset=UTF-8
Content-Transfer-Encoding	7bit
X-Trace	news.uni-berlin.de BO+ySk9AdfPTfSxSMlRjYwUtdlmehBqJ2nCq7JIfNLmv1g9MDqioXk8jYgS30KXEA=
User-Agent	Mozilla/5.0 (X11; Linux x86_64; rv:16.0) Gecko/20121025 Thunderbird/16.0.2
In-Reply-To	<_vOdnZvEQpjeuwHNnZ2dnUVZ7q6dnZ2d@giganews.com>
Xref	csiph.com comp.lang.php:7507

Show key headers only | View raw

Am 08.11.2012 22:38, schrieb rayven:
> Can anyone help as I am at my wits end.
> On my PHP page, the following code works perefectly:
> 
> <?php
> $connection = new mysqli("localhost", "...", "...", "...");
> $sql="SELECT field1, field2 FROM mytable";
> if($stmt = mysqli_prepare($connection, $sql))
> {
> 	mysqli_stmt_bind_param($stmt, "s", $emailaddress);
> 	mysqli_stmt_execute($stmt);
> 	mysqli_stmt_bind_result($stmt, $clientid, $siteadmin);
> 	mysqli_stmt_fetch($stmt);
> 	echo($clientid);
> 	echo($siteadmin);
> 	mysqli_stmt_close($stmt);
> }
> mysqli_close($connection);
> ?>
> 
> But the moment I introduce mysqli_stmt_bind_param() and a parameter on the SELECT statement, I get rows_affected = -1 and no error returned, and no data is returned either.  But if I run the same statement with the same parameters (and I have checked the parameter variables are populated correctly) in the mysql administrator, it works!
> 
> <?php
> $connection = new mysqli("localhost", "...", "...", "...");
> $sql="SELECT field1, field2 FROM mytable WHERE field3=?";
> if($stmt = mysqli_prepare($connection, $sql))
> {
> 	mysqli_stmt_bind_param($stmt, "s", $myparam);
> 	mysqli_stmt_execute($stmt);
> 	mysqli_stmt_bind_result($stmt, $clientid, $siteadmin);
> 	mysqli_stmt_fetch($stmt);
> 	echo($clientid);
> 	echo($siteadmin);
> 	mysqli_stmt_close($stmt);
> }
> mysqli_close($connection);
> ?>
> 
> What on earth am I doing wrong?

On my system (not mysql), I would enable full statement logging in the database and
see what is sent.

Another observation: your code is not very stable, the only time you check a return
code is the prepare step. And you do not check the number of returned rows.

Then style: I wonder why the OO style is not used, it is shorter to write and read.
And you can extend mysqli and put your utility functions into it.

But your problem seems to depend only on the values of your variables.

/Str.

Back to comp.lang.php | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

Problem with mysqli_stmt_bind_param() rayven <rayven@blueyonder.co.uk> - 2012-11-08 15:38 -0600
  Re: Problem with mysqli_stmt_bind_param() Jerry Stuckle <jstucklex@attglobal.net> - 2012-11-08 19:12 -0500
  Re: Problem with mysqli_stmt_bind_param() "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2012-11-09 09:51 +0100

csiph-web