Page 1 of 1

Need to find a database interface builder to generate php

Posted: Thu Jan 11, 2007 1:19 pm
by DroidDr
hello all.

I need to find a tool that can connect to a database and generate me a page that will display me a table, joins of tables or that can permit me to edit tables.

Basically I need the tool to connect to the database and generate skeleton php code that can be used to view and edit the data in the tables. The point would be to automate the code generation to streamline the process of creating those interface pages. The end users would be people using those pages, and would serve as their interface to the database for viewing and modifying data.

I hope I am being clear. I am new to php, but I am a programmer so coding is not an issue. However building those pages could be a long process and I would rather use a tool that could save me loads of time if that tool exists.

best wishes to all.

Posted: Thu Jan 11, 2007 1:27 pm
by Kieran Huggins
phpMyAdmin?

Posted: Thu Jan 11, 2007 3:06 pm
by DroidDr
Thx for the answer,

However, I don't want a package to admin a database, but a tool to generate php code to modify/ view a table (need to query oracle and mssql as well)

As an example I have table ABC. I tell the tool to generate the php code. I take the php code (php page) and copy it over to the web server, so that user can request that php page to view/edit the table.

I hope this makes it clearer

Posted: Thu Jan 11, 2007 3:28 pm
by Kieran Huggins
DroidDr wrote: I tell the tool to generate the php code
There seems to be an enormous feat of magic happening here.

Posted: Fri Jan 12, 2007 12:30 am
by jmut

Posted: Fri Jan 12, 2007 2:56 am
by onion2k
Kieran Huggins wrote:There seems to be an enormous feat of magic happening here.
Code generators are great fun.

A long time ago I wrote a code generator to create database admin systems: http://www.ooer.com/onion/mm.zip You'll need to change the database connection details in includes/constants.inc.php so it can see some databases. It creates a standalone folder of code in the directory you put mm (stands for Magic Manager) into.

As with 90% of my projects it's not finished. It's very old code. I wrote it about 4 years ago. So I'll not support it at all because I won't be able to remember how most of it works. You're free to hack it though.

Posted: Fri Jan 12, 2007 7:55 am
by DroidDr
Well I found a decent tool to do at least part of what I want.

It is called codecharge studio. http://www.yessoftware.com/index2.php
It is not a free tool, but it did exactly what I wanted: I created a connection to my oracle database in the software, chose a table, chose a grid, a template, certain options and it generated a php page complete with code and css. It took me 5 minutes and I was looking at the data in the table through this page with convenient scroll buttons etc. All I did is copy the files it generated to a webserver and that's it. So this program did it's 'magic' pretty well.

As jmut mentionned, the php editor at phpguru seems decent, however, I will need to connect to both SQLserver and oracle....

If anyone has an open source program to suggest that does something similar I am all ears.

Thanks for the replies so far!