|
|
Posted by Andy Hassall on 09/27/28 11:37
On 17 Jan 2006 09:56:09 -0800, sam.s.kong@gmail.com wrote:
>I've been programming ASP for 5 years and am now learning PHP.
>In ASP, you can use GetRows function which returns 2 by 2 array of
>Recordset.
>Actually, it's a recommended way in ASP when you access DB as it
>disconnects the DB earlier.
>Also, it's handy as you can directly access any data in the array
>without looping.
>
>As far as I know, there's no such function in PHP and I can make one.
>My question is whether it's good in PHP.
>
>pseudo-code:
>
>$data = get_data("select * from table1");
>$var = $data[3][2]; //value at 4th row, 3rd column
>
>This way, I can wrap db connection, data retrieval, and error handling
>with one function (or maybe a class).
>Is the idea workable?
Rather than re-invent the wheel, look at:
http://adodb.sourceforge.net/
http://phplens.com/adodb/reference.functions.getarray.html
--
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
Navigation:
[Reply to this message]
|