Re: [PHP] Syntax problem PDO and bindvalue

2011-12-12 Thread Fatih P. 
On Mon, Dec 12, 2011 at 4:22 PM, FeIn  wrote:

> I don't think you're suppose to end your queries with a semicolon. Try:
>

you can end your queries with semicolon in prepared statements.

How can I see the prepared SQL statement before it is executed?
try->  var_dump ($statement);

Re: [PHP] Syntax problem PDO and bindvalue

2011-12-12 Thread FeIn 
I don't think you're suppose to end your queries with a semicolon. Try:

$sql = "SELECT * FROM photographs WHERE
 photo_filename LIKE '%2%' LIMIT 0, :q";


On Mon, Dec 12, 2011 at 1:49 PM, Stephen  wrote:

> So I am getting this SQL error:
>
> Error selecting photographs: SQLSTATE[42000]: Syntax error or access
> violation: 1064 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
> ''4'' at line 2
>
> My code is:
>
> function updatephotos($dbh, $x) {
>
> echo $x['number'] . ""; < this echo is 4
>
>  $sql = "SELECT * FROM photographs WHERE
>  photo_filename LIKE '%2%' LIMIT 0, :q;";
>
>  $stmt = $dbh->prepare($sql);
>
>  try {
>
>$stmt->bindValue( ':q', $x['number'], PDO::PARAM_INT );
>$stmt->execute();
>
>  } catch (PDOException $e) {
>return 'Error selecting photographs: ' . $e->getMessage();
>}
>
> while ( list( $id, $name, $alt, $caption) = $stmt->fetch(PDO::FETCH_NUM)) {
> echo $name . "";
>}
>
>
>  return "test worked" ;
> }
>
> If I hard code the SQL as:
>
> $sql = "SELECT * FROM photographs WHERE
>  photo_filename LIKE '%2%' LIMIT 0, 4";
>
> all works well.
>
> Can anyone see what is wrong?
>
> How can I see the prepared SQL statement before it is executed?
>
> Thanks
> Stephen
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

Re: [PHP] Syntax problem PDO and bindvalue

2011-12-12 Thread Fatih P. 



On 12/12/2011 01:49 PM, Stephen wrote:

So I am getting this SQL error:

Error selecting photographs: SQLSTATE[42000]: Syntax error or access 
violation: 1064 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 ''4'' at line 2


My code is:

function updatephotos($dbh, $x) {

echo $x['number'] . ""; < this echo is 4

  $sql = "SELECT * FROM photographs WHERE
  photo_filename LIKE '%2%' LIMIT 0, :q;";

  $stmt = $dbh->prepare($sql);

  try {

$stmt->bindValue( ':q', $x['number'], PDO::PARAM_INT );
$stmt->execute();

  } catch (PDOException $e) {
return 'Error selecting photographs: ' . $e->getMessage();
}

while ( list( $id, $name, $alt, $caption) = 
$stmt->fetch(PDO::FETCH_NUM)) {

echo $name . "";
}


  return "test worked" ;
}

If I hard code the SQL as:

$sql = "SELECT * FROM photographs WHERE
  photo_filename LIKE '%2%' LIMIT 0, 4";

all works well.

Can anyone see what is wrong?

How can I see the prepared SQL statement before it is executed?

Thanks
Stephen



$x = $x['number'];

$stmt->bindValue( ':q', $x['number'], PDO::PARAM_INT );

i didnt dig deep down the problem [might be some C thing, pointer access 
or ...]  but this solves it.


Fatih P.
http://blog.teknober.com

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php