Req #38509 [Opn->Csd]: MYSQL: PDO FEATURES
Edit report at https://bugs.php.net/bug.php?id=38509&edit=1
ID: 38509
Updated by: cmb@php.net
Reported by: roberto at spadim dot com dot br
Summary: MYSQL: PDO FEATURES
-Status: Open
+Status: Closed
Type: Feature/Change Request
Package: PDO MySQL
Operating System: ANY
PHP Version: 5.2.0RC2
-Assigned To:
+Assigned To: cmb
Block user comment: N
Private report: N
New Comment:
PDO supported scrollable cursors (and a respective $offset
parameter of PDOStatement::fetch()) even when you filed this
feature request. However, MySQL doesn't support scrollable
cursors, so there's nothing we can do about that. Consider to
file a feature request upstream.
Previous Comments:
------------------------------------------------------------------------
[2006-08-22 02:51:39] roberto at spadim dot com dot br
setting current row could help like sqlite2 lib do
sqlite_seek
we will need buffered query!
------------------------------------------------------------------------
[2006-08-21 16:44:09] roberto at spadim dot com dot br
Today i'm using mysql in this way:
$tmp_tbl=mysql_query($sql);
for ($i=0;$i<mysql_num_rows($tmp_tbl);$i++)
echo mysql_result($tmp_tbl,$i,0);
in pdo sometimes i can't do it because i made an array lke this:
$tmp_tbl=mysql_query($sql);
$array=array(9,3,6,2,6);
for ($i=0;$i<count($array);$i++)
echo mysql_result($tmp_tbl,$array[$i],0);
so i can't use pdo cause my rows are not sequencialy
if pdo could have a function like
$PDO_STATMENT = $dbh->prepare($SQL);
$PDO_STATMENT->execute();
$array=array(9,3,6,2,6);
for ($i=0;$i<count($array);$i++)
echo $PDO_STATMENT->result($array[$i],0); <-----
could help alot
today i'm creating a array putting all data to it and reading the array, but i need many memory
and time...
could you undestood?
sorry the poor english
------------------------------------------------------------------------
[2006-08-19 03:42:34] roberto at spadim dot com dot br
Description:
------------
could PDO have features like mysql_result ???
i use a lot it cause i have to read the last rown and after the first after the last-1 and after the
second...
with PDO i can only make it if i read all data to an array and after read array :/
any feature in this area could help
thankx
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=38509&edit=1
Thread (5 messages)