php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #64411 ?(question sign) in mysql query comment
Submitted: 2013-03-12 09:54 UTC Modified: 2013-03-14 15:10 UTC
From: pingvein at gmail dot com Assigned:
Status: Not a bug Package: PDO related
PHP Version: 5.4.12 OS: Linux debian 3.2.0-4-amd64 #1 SM
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: pingvein at gmail dot com
New email:
PHP Version: OS:

 

 [2013-03-12 09:54 UTC] pingvein at gmail dot com
Description:
------------
question sign in sql comment perceived as a parameter.

Test script:
---------------
<?php

$dbhost ='localhost';
// username and password to log onto db server
$dbuser ='root';
$dbpass ='test';
// name of database
$dbname='test';
//Charset
$sqlchar='utf8';
 
$db = new PDO ( 'mysql:host=' . $dbhost . ';dbname=' . $dbname, $dbuser, $dbpass);

$sth = $db->prepare("SELECT * from users where id = :user /* find user by id script ?\ */");
$sth->execute(array(':user' => 1));
$sth->fetch();

Expected result:
----------------
Exception not thrown

Actual result:
--------------
Exception is thrown

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2013-03-14 14:12 UTC] pingvein at gmail dot com
Change Package
 [2013-03-14 14:12 UTC] pingvein at gmail dot com
-Package: PECL +Package: PDO related
 [2013-03-14 15:10 UTC] johannes@php.net
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.php.net/manual/ and the instructions on how to report
a bug at http://bugs.php.net/how-to-report.php

This is a limitation in PDO's parser.This can't easily be fixed as people might rely on it (in workarounds etc.) and as the parser would have to become driver and database version-specific
 [2013-03-14 15:10 UTC] johannes@php.net
-Status: Open +Status: Not a bug
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Fri Dec 27 08:01:28 2024 UTC