Re: [PHP] database stuff and conditions
Why domains.domain_id and users.user_id are not auto_increment? Mat Harris wrote: attached is a dump of the mysql database. The passkeys are not on a per user basis, but rather per domain. this can change if that is not good. On Wed, Oct 30, 2002 at 03:36:58 +0100, Martin Hudec wrote: Hello Mat, MH> hi, i am a competant perl programmer of nearly a year and a half and I have MH> just this week started looking at php. I am the same but reversed ;)...just started perl :) MH> I am trying to write a couple of webpages that will allow me to update a MH> mysql database which is powering a dns server, for a dynamic dns service. sounds pretty easy for me MH> every time i have tried to grab some stuff from the database and check the MH> login or domain permissions, I get stuck in a mess of ifs and whiles. what kind of ifs and whiles? well when i am looking below to see tables in db i think user will log in...then he will see only his domains (identified by user_id) and he need to be able to modify them, delete them etc...am I right? Hmmm what kind of keys?...i cant see any password or something like that in users table, only user_ids (probably auto_incrementing PK) and usernames...hmmm MH> can anyone give me an idead on the best method/starting place. MH> my database looks like this: MH> users -- pairs of usernames/user_ids MH> domains -- matches domainnames/domain_ids/passkeys to user_ids MH> records -- all the dns records. not got to this point yet. -- Best regards, Martinmailto:corwin@;corwin.sk -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] database stuff and conditions
there is no real hurry on the app but obviously I can't afford the lay down on the job. i would appreciate the help and especciallu the comments, but only if you are sure you have the time. this is the sort of options the user would have: sign up user login create domain delete domain administer domain update one A, one CNAME and one MX record they shouldn't have control to add unlimited records, but maybe a way to allow certain users to have certain limits. I hope I am not askin too much, just say the word and we'll drop it. thanks for all your help mat On Wed, Oct 30, 2002 at 04:08:05 +0100, Martin Hudec wrote: > Hello Mat, > > I would recommend to not use passkeys in domains...rather in per user > basis...it is better...one user can administer various domains i > think..he will have to remember many passwordsor even if they are > the same...you make passs key for each record in domain > tableso more data storedhmmm...okay i am going home > now,...will wait for while for your new mail...how fast you need this > app to be done? > > I can make you whole app if you want...also ill include comments for > you to see on things...just how fast you need it...and ..when user > logs in he only needs to create, update and delete records right? > > anyway thanks for sql dump, itll help a lot :) > > -- > Best regards, > Martinmailto:corwin@;corwin.sk > > Wednesday, October 30, 2002, 3:55:28 PM, you wrote: > > MH> attached is a dump of the mysql database. The passkeys are not on a per user > MH> basis, but rather per domain. this can change if that is not good. -- Mat Harris OpenGPG Public Key ID: C37D57D9 [EMAIL PROTECTED]matthewh.genestate.com msg83358/pgp0.pgp Description: PGP signature
Re: [PHP] database stuff and conditions
attached is a dump of the mysql database. The passkeys are not on a per user basis, but rather per domain. this can change if that is not good. On Wed, Oct 30, 2002 at 03:36:58 +0100, Martin Hudec wrote: > Hello Mat, > > MH> hi, i am a competant perl programmer of nearly a year and a half and I have > MH> just this week started looking at php. > > I am the same but reversed ;)...just started perl :) > > MH> I am trying to write a couple of webpages that will allow me to update a > MH> mysql database which is powering a dns server, for a dynamic dns service. > > sounds pretty easy for me > > MH> every time i have tried to grab some stuff from the database and check the > MH> login or domain permissions, I get stuck in a mess of ifs and whiles. > > what kind of ifs and whiles? well when i am looking below to see > tables in db i think user will log in...then he will see only his > domains (identified by user_id) and he need to be able to modify them, > delete them etc...am I right? Hmmm what kind of keys?...i cant see any > password or something like that in users table, only user_ids > (probably auto_incrementing PK) and usernames...hmmm > > MH> can anyone give me an idead on the best method/starting place. > > MH> my database looks like this: > > MH> users -- pairs of usernames/user_ids > MH> domains -- matches domainnames/domain_ids/passkeys to user_ids > MH> records -- all the dns records. not got to this point yet. > > > > -- > Best regards, > Martinmailto:corwin@;corwin.sk -- Mat Harris OpenGPG Public Key ID: C37D57D9 [EMAIL PROTECTED]matthewh.genestate.com pdnstest.gz Description: application/gunzip msg83355/pgp0.pgp Description: PGP signature
[PHP] database stuff and conditions
hi, i am a competant perl programmer of nearly a year and a half and I have just this week started looking at php. I am trying to write a couple of webpages that will allow me to update a mysql database which is powering a dns server, for a dynamic dns service. every time i have tried to grab some stuff from the database and check the login or domain permissions, I get stuck in a mess of ifs and whiles. can anyone give me an idead on the best method/starting place. my database looks like this: users -- pairs of usernames/user_ids domains -- matches domainnames/domain_ids/passkeys to user_ids records -- all the dns records. not got to this point yet. the keys also have to be digetst::md5 encrypted to compare with those in the database. I think i may need cookies for this so any help would be greatly appreciated. -- Mat Harris OpenGPG Public Key ID: C37D57D9 [EMAIL PROTECTED]matthewh.genestate.com msg83347/pgp0.pgp Description: PGP signature