looking for a portal type program

[tom11011]

Hi, I don't if this exists or if I can explain it well enough.

Basically, I'm looking for a program that will allow me to specify how many fields I would like in my database. I tell it the number of fields and the names, and when I click submit, the database is created. I can add or remove fields in the database. I can search each field in the database.

Basically, this program would have a public querry capability and backend administration.

hope I explained this ok.

 

[Kozusnik]

What is the database? MySQL, Microsoft SQL Server, Oracle, DB2 ???

I use phpMyAdmin to administer MySQL databases under Linux. I don't do Windows, so someone else may help.

Mark

 

[tom11011]

It would by mysql. I use phpmyadmin too.

I'm looking for a php tool that would take the pain out of designing websites for databases.

I tell it what I want, and something raw is spit out, I can develope around that.

 

[Xaqte]

I know of such a tool, but it is embedded in a CMS (which makes sense):

SQLForm

Good news: it is used often & well maintained.

Bad news: while this is cms is free, it can be a bear to install (sometimes). However there is a WRE package for easy install (which contains mysql & apache) & they do offer hosting at a reasonable price.

Let us know your results!

X

 

[jpadie]

please take a look at formbuilder and data_object in the PEAR repository (pear.php.net). steep learning curve but worthwhile once you've cracked it.

otherwise google for "CRUD php mysql"

i also posted a very basic CRUD system on this forum the other day. will give you a headstart in building your own. for example, adding a select query mechanism would be very simple.

the thread ref is thread434-1254677

 

[tom11011]

thanks everyone, I will check them out and report back.