PHP IDE :: NuSphere Forums :: View topic - Create complex form with Db-Form

Posted: Tue Jan 29, 2008 1:11 am

Hello all!

Is it possible to have the DB-Form wizard to create a form from several databases? i.e.

tblCountry
-------------
CountryId
CountryName

tblCity
-------------
CityId
CityName
CountryId

tblNeighborhood
-------------------
CountryId
CityId
NeighborhoodId
NeighborhoodName

And i want to create a form that displays a table with the Neighborhoods like this: CountryName, CityName and NeigborhoodName

then when inserting a new Neighborhood to have the input form display the Country and City as Selectboxes with their id values

Is it possible? if so, can you give some guidance?

Thnx in advance!!

Lachof

Posted: Tue Jan 29, 2008 11:28 am

It looks like you mean different tables, not databases. Yes it's possible for example with Oracle, where you can create a view that will join the tables according to your needs and you'll also need to create rules for updating the view. The resulted updatable view can be used in the DB Wizard.

Posted: Tue Jan 29, 2008 12:57 pm

Yes tables, sorry Wink

is it possible using MYSQL?

Posted: Wed Feb 06, 2008 1:30 pm

Here is what i did, if someone has a better way please let me know:

In the table_tblname.php
Right after the fields array i added this:

Code:

// Get ciudad
$clsCiudad = new ciudadDAL();
$res = $clsCiudad->getCiudades();
foreach($res as $arr) {
$f3_values[$arr['IdCiudad']]=$arr['Nombre'];
}

The ciudadDAL class returns an array of cities (ciudad) and i just add them to the values array of the selectbox

This is done for every select iwant to display as name instead of id

Hope it helps someone.