•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 392,047 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,300 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser:
Views: 7516 | Replies: 13
 |
•
•
Join Date: Feb 2005
Posts: 427
Reputation: 
Rep Power: 4
Solved Threads: 12
Posting Pro in Training
simply generate user front end for mysql ? 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: Nov 2003
Location: Toronto, Canada
Posts: 354
Reputation:
Rep Power: 6
Solved Threads: 5
PHP/vBulletin Guru
•
•
Join Date: Feb 2005
Posts: 427
Reputation:
Rep Power: 4
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
Location: Toronto, Canada
Posts: 354
Reputation:
Rep Power: 6
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:
Rep Power: 4
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
Location: Toronto, Canada
Posts: 354
Reputation:
Rep Power: 6
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:
Rep Power: 4
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!
•
•
Join Date: Apr 2005
Posts: 1
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
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.
•
•
Join Date: Mar 2005
Location: LTT, South Africa
Posts: 125
Reputation:
Rep Power: 4
Solved Threads: 1
Junior Poster
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:
Rep Power: 4
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. ????
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
Linear Mode
Other Threads in the MySQL Forum
- Previous Thread: create user copy priveleges
- Next Thread: Interface page for my new database...
