CMS to mySQL

Not for 'how-to' coding questions but PHP theory instead, this forum is here for those of us who wish to learn about design aspects of programming with PHP.

Moderator: General Moderators

Post Reply
mr.morton
Forum Newbie
Posts: 5
Joined: Wed May 10, 2006 8:52 am

CMS to mySQL

Post 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
User avatar
pickle
Briney Mod
Posts: 6445
Joined: Mon Jan 19, 2004 6:11 pm
Location: 53.01N x 112.48W
Contact:

Post by pickle »

phpMyAdmin would probably do it for you.
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
mr.morton
Forum Newbie
Posts: 5
Joined: Wed May 10, 2006 8:52 am

Post 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... ??
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post 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?
User avatar
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098
Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia

Post 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.
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post 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.
User avatar
s.dot
Tranquility In Moderation
Posts: 5001
Joined: Sun Feb 06, 2005 7:18 pm
Location: Indiana

Post 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.
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.
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post 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! :lol: I thought I was the only one...
mr.morton
Forum Newbie
Posts: 5
Joined: Wed May 10, 2006 8:52 am

Post 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 :-)
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post 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.
User avatar
cj5
Forum Commoner
Posts: 60
Joined: Tue Jan 17, 2006 3:38 pm
Location: Long Island, NY, USA

Post 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.
d3ad1ysp0rk
Forum Donator
Posts: 1661
Joined: Mon Oct 20, 2003 8:31 pm
Location: Maine, USA

Post 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.
Post Reply