CMS to mySQL
Moderator: General Moderators
CMS to mySQL
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
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
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
- Chris Corbyn
- Breakbeat Nuttzer
- Posts: 13098
- Joined: Wed Mar 24, 2004 7:57 am
- Location: Melbourne, Australia
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.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?
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
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.
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.
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.
Set Search Time - A google chrome extension. When you search only results from the past year (or set time period) are displayed. Helps tremendously when using new technologies to avoid outdated results.
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
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
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
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
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.
-
d3ad1ysp0rk
- Forum Donator
- Posts: 1661
- Joined: Mon Oct 20, 2003 8:31 pm
- Location: Maine, USA