RE: [firebird-support] migrate mysql 5 php script to firebird 2.5

[Hans]

        //Get records from database
        $result = mysql_query("SELECT * FROM people;");
        
        //Add all records to an array
        $rows = array();
        while($row = mysql_fetch_array($result))
        {
            $rows[] = $row;
        }

=======================================================
I have something like this working

       //Connect
      $dbhandle =
      ibase_pconnect'c:/supply/people.fdb', 'DBUserName'DBPassword')
      or die('DBase access denied to' people.fdb '); //die(ibase_errmsg());

        //Get records from database
       $sql = ' SELECT * FROM people';
       $result = ibase_query($dbhandle, $sql) or die(ibase_errmsg());

        //Add all records to an array
        $rows = array();
        while($row =  ibase_fetch_object ($result))
        {
            $rows[] = $row;
        }

-----Original Message-----
From: firebird-support@yahoogroups.com 
[mailto:firebird-support@yahoogroups.com] On Behalf Of Roberto Carlos
Sent: Monday, October 22, 2012 3:45 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] migrate mysql 5 php script to firebird 2.5

How could I convert the following php script from mysql to firebird?
 
        //Get records from database
        $result = mysql_query("SELECT * FROM people;");
        
        //Add all records to an array
        $rows = array();
        while($row = mysql_fetch_array($result))
        {
            $rows[] = $row;
        }

        //Return result to jTable
        $jTableResult = array();
        $jTableResult['Result'] = "OK";
        $jTableResult['Records'] = $rows;
        print json_encode($jTableResult);


thanks for any help.


------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item on the main (top) 
menu.  Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com 

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links