php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Request #38509 MYSQL: PDO FEATURES
Submitted: 2006-08-19 03:42 UTC Modified: 2014-01-02 13:39 UTC
Votes:3
Avg. Score:2.7 ± 0.5
Reproduced:1 of 1 (100.0%)
Same Version:0 (0.0%)
Same OS:1 (100.0%)
From: roberto at spadim dot com dot br Assigned:
Status: Open Package: PDO MySQL
PHP Version: 5.2.0RC2 OS: ANY
Private report: No CVE-ID: None
View Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please — but make sure to vote on the bug!
Your email address:
MUST BE VALID
Solve the problem:
45 + 26 = ?
Subscribe to this entry?

 
 [2006-08-19 03:42 UTC] 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


Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2006-08-21 16:44 UTC] 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-22 02:51 UTC] roberto at spadim dot com dot br
setting current row could help like sqlite2 lib do
sqlite_seek

we will need buffered query!
 [2011-01-01 23:49 UTC] jani@php.net
-Package: Feature/Change Request +Package: PDO related
 [2013-06-12 04:47 UTC] ssufficool@php.net
-Summary: PDO FEATURES +Summary: MYSQL: PDO FEATURES
 [2014-01-02 13:39 UTC] felipe@php.net
-Package: PDO related +Package: PDO MySQL
 
PHP Copyright © 2001-2019 The PHP Group
All rights reserved.
Last updated: Wed Dec 11 00:01:25 2019 UTC