| Re: mysqli --- who does the switching? [message #182010 is a reply to message #182009] |
Sat, 29 June 2013 03:43   |
Thomas 'PointedEars'
Messages: 701
Registered: October 2010
Karma:
|
Senior Member |
|
|
Scott Johnson wrote:
> On 6/28/2013 6:54 PM, richard wrote:
>> On Fri, 28 Jun 2013 18:36:42 -0700, Scott Johnson wrote:
> <snip>
>> Or would this be the more proper way of doing mysql_query()?
>>
>> http://www.php.net/manual/en/mysqli-result.data-seek.php
>>
>
> I have not used data_seek but it just seems like a way to place a
> pointer in the result set. Not 100% since I just glanced at it.
>
> Look at the fecth_???? methods but with the mysqli_query not the
> mysql_query. The (i) is the key.
>
> And if you have issues getting it to work just throw the code you are
> using up here and I am sure someone can help since you are updating your
> code.
Sorry to kill the mysqli hype here, but the most intuitive and easiest to
learn database API to replace mysql is by far PHP Data Objects (PDO), which
is stable since PHP 5.1 (2005) [1]. It is also database-agnostic. Use that
instead of mysql(i) if possible. And avoid servers running PHP < 5.3 if you
value your data. The last PHP 5.2.x was released more than two years ago.
[2]
[1] <http://php.net/pdo>
[2] <http://php.net/ChangeLog-5.php>
PointedEars
--
var bugRiddenCrashPronePieceOfJunk = (
navigator.userAgent.indexOf('MSIE 5') != -1
&& navigator.userAgent.indexOf('Mac') != -1
) // Plone, register_function.js:16
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]