Need to find a database interface builder to generate php

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
DroidDr
Forum Newbie
Posts: 3
Joined: Thu Jan 11, 2007 12:58 pm

Need to find a database interface builder to generate php

Post 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.
User avatar
Kieran Huggins
DevNet Master
Posts: 3635
Joined: Wed Dec 06, 2006 4:14 pm
Location: Toronto, Canada
Contact:

Post by Kieran Huggins »

phpMyAdmin?
DroidDr
Forum Newbie
Posts: 3
Joined: Thu Jan 11, 2007 12:58 pm

Post 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
User avatar
Kieran Huggins
DevNet Master
Posts: 3635
Joined: Wed Dec 06, 2006 4:14 pm
Location: Toronto, Canada
Contact:

Post 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.
jmut
Forum Regular
Posts: 945
Joined: Tue Jul 05, 2005 3:54 am
Location: Sofia, Bulgaria
Contact:

Post by jmut »

User avatar
onion2k
Jedi Mod
Posts: 5263
Joined: Tue Dec 21, 2004 5:03 pm
Location: usrlab.com

Post 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.
DroidDr
Forum Newbie
Posts: 3
Joined: Thu Jan 11, 2007 12:58 pm

Post 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!
Post Reply