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.
Need to find a database interface builder to generate php
Moderator: General Moderators
- Kieran Huggins
- DevNet Master
- Posts: 3635
- Joined: Wed Dec 06, 2006 4:14 pm
- Location: Toronto, Canada
- Contact:
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
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
- Kieran Huggins
- DevNet Master
- Posts: 3635
- Joined: Wed Dec 06, 2006 4:14 pm
- Location: Toronto, Canada
- Contact:
Code generators are great fun.Kieran Huggins wrote:There seems to be an enormous feat of magic happening here.
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.
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!
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!