Page 1 of 1
CMS to mySQL
Posted: Wed May 10, 2006 9:03 am
by mr.morton
Hi,
I am creating a site, which will mainly consist of flash, with a mySQL backend.
So all data will come from the sqlserver go to flash via PHP/XML...
But the access to the database will go through PHP, so the people adding news and other content wil be using PHP based admin interface.
Which brings me to my question, does anybody know of any existing product made for editing, adding and deleting a mySQL database. Some kind og database only CMS?
Where you can state which tables and fields are allowed to be editted, deleted and so on...
If a suitable solution already exist (which is likely) I would prefer using it, istead of starting from scratch.
Kind regards
Mr. Morton
Posted: Wed May 10, 2006 9:53 am
by pickle
phpMyAdmin would probably do it for you.
Posted: Wed May 10, 2006 1:29 pm
by mr.morton
I have not used phpMyAdmin very much, but is i remember it, is is not very userfriendly for at person knowing nothing about database and such...
What I am looking for should be much more simple...
But maybe you could do it with phpMyAdmin... ??
Posted: Wed May 10, 2006 1:34 pm
by RobertGonzalez
If you know nothing about databases then you might not want mess around with the database itself. However, PMA is a very user friendly application if you know your way around a database.
When you say simple, what do you mean?
Posted: Wed May 10, 2006 1:36 pm
by Chris Corbyn
Everah wrote:If you know nothing about databases then you might not want mess around with the database itself. However, PMA is a very user friendly application if you know your way around a database.
When you say simple, what do you mean?
It's a very user friendly application even if you don't know much about databases.... I couldn't think of anything easier if you're after a nice GUI for MySQL.
Posted: Wed May 10, 2006 1:39 pm
by RobertGonzalez
I agree. To qualify my first part of that statement, when I first started using PMA, and knew next to nothing about how a real database worked, I continually hosed my db. Not because of the app, mind you. But because I didn't know what I was doing with the app. Now it is installed on every machine that I use mysql on.
Posted: Wed May 10, 2006 4:23 pm
by s.dot
PMA is very straightfoward. Perhaps TOO straightforward. I say that because I couldn't create tables without PMA if my life depended on it.
I'd highly recommend it. And also, you might just be too caught up in the look of it. All those table cells and rows, left frame & right frame, etc.. but if you just stop and look at what it does, it's not very hard at all.
Posted: Wed May 10, 2006 4:31 pm
by RobertGonzalez
That is too funny. When I come to think of it, there are times that I will do something in PMA just to see the SQL command issued by it so I can use it in my apps.
Ha!

I thought I was the only one...
Posted: Wed May 10, 2006 4:36 pm
by mr.morton
Well i need something more like where you can specify which tables and which field can be edited. And something that the user will not be able to delete/create entire tables/databases.
I guess i have to make it from scratch, just thought someone would have made something like it, since add, edit and delete records is af pretty normal thing, maybe i should make somethinh my self

Posted: Wed May 10, 2006 5:07 pm
by RobertGonzalez
I think you can set the users privileges to allow only certain things in the database. PMA can enforce that, and perform the utility functions you are talking about.
Posted: Wed May 10, 2006 6:08 pm
by cj5
I would have to agree with the others here PMA is a great database admin tool. And, if you are looking for a CMS editor, which should only allow add/edit/delete features from a frontend perspective, then use any of the available PHP CMS packages out there (there are plenty, GOOGLE IT). Are you a developer? Do you have enough expertise to do this type of maintainence on a database? Building your own data administrator is cool, but why reinvent the wheel?! You're going to waste your time. I assume you're are looking for a customized content manager. Customization is time, take it from there Mister Morton! LMAO.
Posted: Wed May 10, 2006 9:16 pm
by d3ad1ysp0rk
I guess I'm the oddball here. I just fire up the command line and login to mysql to execute commands I write myself.