 |  |  |  |  |  |  |  |
simply generate user front end for mysql ?
Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
•
•
Join Date: Feb 2005
Posts: 427
Reputation: 
Solved Threads: 12
Posting Pro in Training
Hi folks......
I'm a bit new to this... played with DB's on an off for years...... now getting back to programming and web design, learning to play with all the big boy's toys etc.
LOL
Yet I must admit that I have fallen for the simplicity of access's ability to generate the user front end so easily.... is there not a similar way to do the same using php or even html?
Now I've got software to connect to mysql and generate the DB's backend much like access, and think this is a god send, as I find it easier to construct with a visual aid rather than the old ascii appearance....
I've seen software that claims to be able to take asp and turn it to php... so I am assuming that it should be able to take a database front end f asp and turn it into a database front end of php?
(jaguar asp to php)
So, I'm not sure 100%, and thought I'd ask....
Is there not software that can link up to a mysql DB and visually build user frontends as in access?
I'm a bit new to this... played with DB's on an off for years...... now getting back to programming and web design, learning to play with all the big boy's toys etc.
LOL
Yet I must admit that I have fallen for the simplicity of access's ability to generate the user front end so easily.... is there not a similar way to do the same using php or even html?
Now I've got software to connect to mysql and generate the DB's backend much like access, and think this is a god send, as I find it easier to construct with a visual aid rather than the old ascii appearance....
I've seen software that claims to be able to take asp and turn it to php... so I am assuming that it should be able to take a database front end f asp and turn it into a database front end of php?
(jaguar asp to php)
So, I'm not sure 100%, and thought I'd ask....
Is there not software that can link up to a mysql DB and visually build user frontends as in access?
•
•
Join Date: Feb 2005
Posts: 427
Reputation:
Solved Threads: 12
Posting Pro in Training
will that have a forms like interface that access does to creat front ends?
I mean, a visula builder...wysiwyg sort of thing, or is it merely a visual DB builder?
I mean, a visula builder...wysiwyg sort of thing, or is it merely a visual DB builder?
•
•
Join Date: Nov 2003
Posts: 360
Reputation:
Solved Threads: 5
PHP/vBulletin Guru
I suppose it's not completely like Access. It's just a visual DB builder; you still need to have some sort of knowledge w/MySQL in order to move around in it.
•
•
Join Date: Feb 2005
Posts: 427
Reputation:
Solved Threads: 12
Posting Pro in Training
hmmm...well I learned access in 1 month (the basics), and I'm pretty good with DB design in general... so it shouldn't take to longh to get the basics... it's all teh advanced stuff that concerns me...still, I'll get there (Just asfter I finsih bodging through CSS!)
•
•
Join Date: Nov 2003
Posts: 360
Reputation:
Solved Threads: 5
PHP/vBulletin Guru
MySQL = easy. What do you know about Access? How to use it? Or do you know the actual querying language?
•
•
Join Date: Feb 2005
Posts: 427
Reputation:
Solved Threads: 12
Posting Pro in Training
I know how to use access... pretty good... not to hot on the sql language, yet can get it to do the simple stuff (which you can do with access any way, so no great advantage there ! LOL).
Still... design a DB layout, create the DB, run it to ensure basic function, then start adding all the little extra bits.... that I can do... the principal should be the same with MySQL... epc. as I have software that works like access for mysql DB creation!
Still... design a DB layout, create the DB, run it to ensure basic function, then start adding all the little extra bits.... that I can do... the principal should be the same with MySQL... epc. as I have software that works like access for mysql DB creation!
You could use an Access front end to a MySQL back end, to help you with the cross over.
However, unless you need reporting that php can't give you, I would suggest dumping Access and using something like NaviCat or phpMyAdmin. Both will give you the sql statements so that you understand what is actually going on with your db. However, Access uses a different flavour of sql than MySQL, so your statements will be inconsistent when you go to ask for help on forums, etc.
However, unless you need reporting that php can't give you, I would suggest dumping Access and using something like NaviCat or phpMyAdmin. Both will give you the sql statements so that you understand what is actually going on with your db. However, Access uses a different flavour of sql than MySQL, so your statements will be inconsistent when you go to ask for help on forums, etc.
MySQL Query Browser from MySQL website helps ALOT to get mysql specific SQL (access and MySQL not quite the same) at the same time you can test a sql statement. i started by creating my tables and stuff in access and the export it to MySQL - it worked ok but far easier to use phpmyadmin from the beginning
•
•
Join Date: Feb 2005
Posts: 427
Reputation:
Solved Threads: 12
Posting Pro in Training
All of thats fine.... it's just tha thaving to parse it all through a web server to test etc... where as access lets me run from my desktop!
No reason I can't do both.... get the basic running in access, then build it in mysql etc.... run them paralell.
Yet my real want is for something that will generate the php/html etc for the db... like the forms part of access....a wysiwyg approach to the page layout and fields, relations etc. ????
No reason I can't do both.... get the basic running in access, then build it in mysql etc.... run them paralell.
Yet my real want is for something that will generate the php/html etc for the db... like the forms part of access....a wysiwyg approach to the page layout and fields, relations etc. ????
|
Other Threads in the MySQL Forum
- Previous Thread: create user copy priveleges
- Next Thread: Interface page for my new database...
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest MySQL Posts
- Today's Posts
- Unanswered Threads
agplv3 alfresco amazon api artisticlicense aws bizspark breathalyzer camparingtocolumns changingprices cmg communityjournalism contentmanagement contractors copyright count court crm database design developer development distinct drupal dui ec2 email enterprise eudora facebook form foss gartner gnu government gpl greenit groklaw groupware hiring hyperic images innerjoins insert ip joebrockmeier join journalism keyword keywords kickfire laptop legal license licensing linux maintenance mariadb matchingcolumns metron micromanage microsoft microsoftexchange mindtouch montywidenius mozilla multiple music mysql mysqlcolumnupdating mysqldatetimeordermax() mysqlindex mysqlinternalqueries mysqlquery mysqlsearch news open-xchange opendatabasealliance opengovernment opensource oracle penelope php priceupdating query referencedesign reorderingcolumns saas select sharepoint simpledb sourcecode spotify sql sugarcrm syntax techsupport thunderbird transparency virtualization
