Preserved Topic: Getting started - PHP/MySQL user database

OK, I've built (and am building new) PHP publishing tools, that's my focus all this week anyway. I've not really done much of it using MySQL though, since I only need to deal with one user, the admin. (What I've been doing is writing the files directly to disk, and then just calling them direct. Fast and neat, usually.)

What I *am* going to have to do is create a user database for random visitors to setup and account in which I'll save some low-security settings, bookmarks of pages mostly. Now I've setup several packaged script bundles with MySQL (PHP Nuke, post-nuke, PHProjekt, etc...) but now I need to do my own thing, and I'm a little bit scared. Ideally, I'll find a simple utility, a set of scripts that would contain a mysql.dump file and a couple of generic scripts to access user variables, and that's it. I've looked through sourceforge, but all I find is huge, complete packages, but all I want is a start, a leg up to get into this stuff proper!

If anyone knows of such a library that is open-source and available for download, let me know, would you? I want to start with something really simple; I promise, once I get over this hurdle I'll become a SQL wizard of sorts, or at least develop my own set of crude hacks that work easily!

Your pal, -doc-

I think I've got what seems to be the recepie for you needs (or at least something that gives you the database plus a series of generic functions for creating/editing/deleting almost anything, pages objects, properties, users permissions and so on).

Do this, step over here: http://www.dmsproject.com/ and read the two first articles and holler if it sounds interesting.

If so, I'll put together a package plus some documentation that you can use as a base.
The whole shebang will be released as opensource and targeted as a rapid site development platform more than an ordinary CMS (PHP-nuke and the rest). It's not quite there yet, that's why it's not out there yet.
I am developing sites on it for clients though so it's working.

It is built in different independent modules (as far as I know how to) and quite understandable (IMHO), even if it doesn't do exactly what you need right now, it's very possible and easy to just use the db and the db-api to create you own presentation functions, using exactly what you need and nothing else.

Let's see what you think.
/Dan

{cell 260}
-{ a vibration is a movement that doesn't know which way to go }-

hm, since I'm more the roll my own kind of guy, I can't help you with an open source solution.

I could send you the user system we I used at pspong, and once you stripped all the 'request match', 'deny match', 'listMatches'... stuff from it, you'd be ready to roll.

If you're interested, you know how to contact me ;-)

so long,
Tyberius Prime

Tyberius Prime

The poster has demanded we remove all his contributions, less he takes legal action.
We have done so.
Now Tyberius Prime expects him to start complaining that we removed his 'free speech' since this message will replace all of his posts, past and future.
Don't follow his example - seek real life help first.

A couple of places first check out the script library at zend and then you may want to check out phpclasses.org (free reg) Both of these offer code snippets (usually OOP classes) that do much of this. I usually hate using pre-built "applications" such as PHP-Nuke etc. These are usually much more than I need so these two resources have been invaluable.

After that you may also want to check out PEAR (PHP Appliction and Extension Repository) PEAR is quickly becoming the PHP equivalent of CPAN Again some of it I find bloated but it's a great place to look for some "how'd he do that" stuff. Finally there's phplib It's kinda a PEAR equivalent and I tend to use it in parts and for instruction more than the code as is.



.:[ Never resist a perfect moment ]:.

[This message has been edited by bitdamaged (edited 08-27-2002).]

[This message has been edited by bitdamaged (edited 08-28-2002).]