[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
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
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
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