Bug #43130 [PATCH]: bind parameter cannot contain dashes

From: Date: Sun, 08 Mar 2020 17:24:56 +0000
Subject: Bug #43130 [PATCH]: bind parameter cannot contain dashes
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-225950@lists.php.net to get a copy of this message
Edit report at https://bugs.php.net/bug.php?id=43130&edit=1 ID: 43130 Patch added by: vinocuek51@gmail.com Reported by: joel at purerave dot com Summary: bind parameter cannot contain dashes Status: Wont fix Type: Bug Package: PDO related Operating System: Windows XP Home PHP Version: 5.2.4 Assigned To: iliaa Block user comment: N Private report: N New Comment: The following pull request has been associated: Patch Name: fix typo: mysqlx => mysqlx_x On GitHub: https://github.com/php/pecl-database-mysql_xdevapi/pull/8 Patch: https://github.com/php/pecl-database-mysql_xdevapi/pull/8.patch Previous Comments: ------------------------------------------------------------------------ [2018-10-25 16:28:56] neelaraghavendra1 at gmail dot com i cant store php form data in mysql ------------------------------------------------------------------------ [2011-12-27 16:48:36] mariuz@php.net Automatic comment from SVN on behalf of mariuz Revision: http://svn.php.net/viewvc/?view=revision&revision=321439 Log: http://gcov.php.net/viewer.php?version=PHP_5_3&func=tests&file=ext%2Fpdo_firebird%2Ftests%2Fbug_43130.phpt fix failure for bug 43130 ------------------------------------------------------------------------ [2007-12-08 17:21:44] sfox@php.net The fix for this bug that went into CVS on 29th Oct was reverted on 26th Nov following advice from various database experts. See http://news.php.net/php.cvs/46848, http://news.php.net/php.cvs/47302 and anything else on that thread for details. ------------------------------------------------------------------------ [2007-10-30 09:51:43] uw@php.net I disagree with the decision to allow "-" in parameter names. Parameter names should consist of [a-zA-Z] and nothing else. "-" is an operator in most databases. For BC compatibility I'm also fine with the old pattern [:][a-zA-Z0-9_]+ . Though I must say, that I'd prefer [:][a-zA-Z]+[a-zA-Z0-9_]+, don't allow ":0". ":0" looks a bit like "operator" + "number"... However, the underlying problem here is that there is absolutely no specification for PDO. This makes PDO a guessing game and error prone. ------------------------------------------------------------------------ [2007-10-29 22:37:51] iliaa@php.net This bug has been fixed in CVS. Snapshots of the sources are packaged every three hours; this change will be in the next snapshot. You can grab the snapshot at http://snaps.php.net/. Thank you for the report, and for helping us make PHP better. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at https://bugs.php.net/bug.php?id=43130 -- Edit this bug report at https://bugs.php.net/bug.php?id=43130&edit=1

« previous php.bugs (#225950) next »