Edit report at https://bugs.php.net/bug.php?id=55152&edit=1
ID: 55152
Updated by: ka...@php.net
Reported by: lenzai2004-dev at yahoo dot fr
Summary: Mysql relative seek
-Status: Open
+Status: Assigned
Type: Feature/Change Request
Package: MySQL related
Operating System: all
PHP Version: trunk-SVN-2011-07-06 (SVN)
-Assigned To:
+Assigned To: mysql
Block user comment: N
Private report: N
New Comment:
Hi
I believe the MySQL guys (namely Andrey, Ulf and Johannes) wants to only fix
bugs in the mysql module as the mysqli module was originally written to
deprecate the original mysql module one day.
I'll assign it to them so they can evaluate this report.
Previous Comments:
------------------------------------------------------------------------
[2011-07-08 23:47:03] lenzai2004-dev at yahoo dot com
Yes Indeed.
Well if mysql API is considered deprecated in PHP 5 the I should drop my
request.
If not, I believe it is a nice a simple addition.
------------------------------------------------------------------------
[2011-07-08 18:12:17] ka...@php.net
Hi, don't the mysqli module support this already, or with the MySQLi result
iterator from 5.4?
------------------------------------------------------------------------
[2011-07-06 15:01:55] lenzai2004-dev at yahoo dot fr
Description:
------------
There is currently a function to do absolute seek in Mysql API.
When you need to to relative seek , you have to implement integer counter to
keep track of the current cursor position. Then call seek
here is a sample code:
//iterating over rows
for/while....{
mysql_fetch_xxxx(....);
$current_row++;
[...]
// call relative seek
$current_row+= $seek_offset;
mysql_data_seek($id, $current_row);
This quite simple but when the code gets complicated, it s easy to miss on
$current_row update. The only only solution is to encapsulate php mysql
function in additional abstraction layer to handle counter updates safely.
I suppose the internal counter is already available in mysql module.
What I am suggesting, is to expose this internal counter by adding a new
function to mysql API.
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=55152&edit=1
