Subject Re: [firebird-php] Migration from Clarion To AdoDb + PHP
Author Lester Caine
JJHERMOSILLO wrote:

> I'm a newbie in PHP, i have been programing very basic scripts so
> i want to improve my knowledge in this topic.
>
> I used to program only apps for desktop enviroments, using
> Clarion and FireBird. but i really want to migrate from desktops apps
> to web Apps using Firebird and PHP.
>
> I read about AdoDb but i don't know if there is another tool that i
> can use to develop Cool Web apps.

PearDB and other abstraction layers, but all just simplify using SQL
from within PHP. They do not do any more

> i would like to know if somebody knows
> where can i find good examples about how to use AdoDb with
> PHP+FireBird or Tools that i can use for web developing.

You need to look at the hundreds of PHP applications available on the
internet. A good one to start with is ibWebAdmin, which provides a web
based manager for your Firebird Databases. ibwebadmin.sourceforge.net
It's not ADOdb based, but does provide all the IBOConsole facilities.

> I have read the doc's included with AdoDB, but in my opinion they
> where very basic.
>
> for example, how can i modify the class that can let my show a
> resulset in HTML.

The rs2html routine is the key here. It takes a query, and displays the
results as a grid. Used in conjunction with pager.php it can provide
navigable paging through large result sets. I took this and added a
means of colour coding results, based on an additional two hidden
columns. So ADOdb can be easily expanded depending on what you want.

> At the same time, i want to program a system y password verification
> for each user. and forms to view and edit information.

Forms are another package which I 'borrowed' and converted to ADOdb, but
the Pear modules are probably tidier now. As is the authentication package.

> Any suggestions are well recived.

The best starting point I have at the moment id TikiPro. www.tikipro.org
This gives password management, user authentication, and just about
everything else you could need for a content management system.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services