Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsGeneralPHPASPPerlColdFusionFlashHTML, CSS, ScriptsBrowsers

Webmaster Forum / Flash / Flash Remoting / June 2007



Tip: Looking for answers? Try searching our database.

AMFPHP returning access db rows

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
verbruggher - 25 May 2007 12:15 GMT
I have an AMFPHP service class wich opens an access database table, runs over
the rows and puts them in an array. Just like I do in mysql situation.
[h]
 function getUsers () {
        //$db = realpath("d:/www/rive.be/database/rive.mdb");
        $db = realpath("D:\\websites\\2006-Rive(V)\\database\\rive.mdb");
        $dbc = new COM('ADODB.Connection');
        @$dbc->Open("DRIVER={Microsoft Access Driver (*.mdb)};DBQ=$db");
       
        //return a list of all the users
        $rs = $dbc->Execute("SELECT * FROM tblMapCountries");
        while( !$rs->EOF ) {
            $ArrayOfUsers[] = $rs;
            //$id = $rs->Fields['id'];
            $rs->MoveNext( );
        }
       
       
        if($rs){$rs->Close();}
        if($dbc){$dbc->Close();}
        return( $ArrayOfUsers );
}[/h]

But my amfphp service browser displays 1big array with 16 arrays inside
containing each explicitType -> variant

But no column names to see with my data like usual happens, if I use amfphp
with mysql database. Has anyone a working AMFPHP-access-flash data connection?
And wants to give me a push?

Palides from Riga/Latvia
verbruggher - 07 Jun 2007 11:16 GMT
Nobody who has ever connected an MS Access database, amfphp and flash? And could give me a short hand?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.