Re: [PHP] Tutorials for Maintenance of State

2004-10-17 Thread Chris Shiflett
--- GH [EMAIL PROTECTED] wrote:
 I know about sessions... but I am even more concerened now about
 the use of cookies but I am not 100% sure on how to accomplish
 this

When you say you are concerned about cookies, what do you mean exactly?

When used properly, cookies can afford a heightened level of security to
users whose preferences allow them. Because they were created with the
specific purpose of adding state to HTTP, they tend to address this
problem the best.

Chris

=
Chris Shiflett - http://shiflett.org/

PHP Security - O'Reilly HTTP Developer's Handbook - Sams
Coming December 2004http://httphandbook.org/

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Tutorials for Maintenance of State

2004-10-14 Thread GH
I found it interesting... you did a good job. 

However I am running confused laps in my brain on what do I do to
actually set it up...  I know about sessions... but I am even more
concerened now about the use of cookies but I am not 100% sure on how
to accomplish this

when I was dabbling in ColdFusion a few years ago... this was my main
co(ld)nfusion...  I know i am probably rambiling so

Any advice or starting points would be great



On Tue, 12 Oct 2004 14:12:37 -0700 (PDT), Chris Shiflett
[EMAIL PROTECTED] wrote:
 
 
 --- GH [EMAIL PROTECTED] wrote:
  I would like to know if someone out there has or knows of a tutorial
  on Maintenance of State that allows only users who have logged in to
  successfully visit view pages?
 
 You might find this helpful, if I'm interpreting your question correctly:
 
 http://shiflett.org/articles/the-truth-about-sessions
 
 Hope that helps.
 
 Chris
 
 =
 Chris Shiflett - http://shiflett.org/
 
 PHP Security - O'Reilly HTTP Developer's Handbook - Sams
 Coming December 2004http://httphandbook.org/


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Tutorials for Maintenance of State

2004-10-12 Thread Chris Shiflett
--- GH [EMAIL PROTECTED] wrote:
 I would like to know if someone out there has or knows of a tutorial
 on Maintenance of State that allows only users who have logged in to
 successfully visit view pages?

You might find this helpful, if I'm interpreting your question correctly:

http://shiflett.org/articles/the-truth-about-sessions

Hope that helps.

Chris

=
Chris Shiflett - http://shiflett.org/

PHP Security - O'Reilly HTTP Developer's Handbook - Sams
Coming December 2004http://httphandbook.org/

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP] Tutorials for Maintenance of State

2004-10-12 Thread Jay Blanchard
[snip]
I would like to know if someone out there has or knows of a tutorial
on Maintenance of State that allows only users who have logged in to
successfully visit view pages?
[/snip]

PHP, being server side without a persistent connection to the client, is
stateless. You can use things like cookies and sessions to maintain
pseudo-state. http://www.php.net/session

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Tutorials for Maintenance of State

2004-10-12 Thread Greg Donald
On Tue, 12 Oct 2004 16:43:42 -0400, GH [EMAIL PROTECTED] wrote:
 I would like to know if someone out there has or knows of a tutorial
 on Maintenance of State that allows only users who have logged in to
 successfully visit view pages?

You can store most anything in a PHP session, variables, objects, etc.


-- 
Greg Donald
Zend Certified Engineer
http://gdconsultants.com/
http://destiney.com/

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Tutorials for Maintenance of State

2004-10-12 Thread GH
I will look into the into all of the items discussed and probably will
be sending in some questions


On Tue, 12 Oct 2004 16:17:37 -0500, Greg Donald [EMAIL PROTECTED] wrote:
 
 
 On Tue, 12 Oct 2004 16:43:42 -0400, GH [EMAIL PROTECTED] wrote:
  I would like to know if someone out there has or knows of a tutorial
  on Maintenance of State that allows only users who have logged in to
  successfully visit view pages?
 
 You can store most anything in a PHP session, variables, objects, etc.
 
 --
 Greg Donald
 Zend Certified Engineer
 http://gdconsultants.com/
 http://destiney.com/
 
 
 
 --
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP] tutorials for login system...

2004-03-24 Thread Chris W. Parker
Andy B mailto:[EMAIL PROTECTED]
on Wednesday, March 24, 2004 1:28 PM said:

 dont mean to bring up the subject again...but does anybody know of a
 real good login system tutorial that uses sessions/php4/sessions??
 looked at google and found some but dont know how good they really
 are (the comments on some of them are really bad)...   

i didn't read this one article i'm pointing out but the title seems
good. :)

http://www.sitepoint.com/article/users-php-sessions-mysql

also, were you looking for code or general guidelines?


chris.

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Tutorials on OOP

2002-12-22 Thread Justin French
Both of those classes would already exist on a site like phpclasses.org...
do you have to BUILD them, or do you NEED them?

Justin


on 23/12/02 11:43 AM, Davy Obdam ([EMAIL PROTECTED]) wrote:

 Hi people,.
 
 I have to build several classes for a project i am doing, but i am quite
 new to OOP programming. I need to make a database abstraction layer
 class and a user login class.. Does anyone know some good tutorials
 about these things and OOP in general. Thanks in advance..
 
 Best regards,
 
 Davy Obdam
 mailto:[EMAIL PROTECTED]
 
 


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP] Tutorials on OOP

2002-12-22 Thread Davy Obdam
Hi Justin,

Thanks for your quick reply.. Well in this case i needs to build em 
myself, because i am doing a course called Masterclass PHP and i have to 
learn OOP.. So i am looking for some good OOP tutorials/examples on the 
web I am very interested in creating a user login class using 
sessionsDo u know any good sites where i can find tutorials/examples 
about this.?

Best regards,

Davy Obdam
mailto:[EMAIL PROTECTED]

Justin French wrote:

Both of those classes would already exist on a site like phpclasses.org...
do you have to BUILD them, or do you NEED them?

Justin


on 23/12/02 11:43 AM, Davy Obdam ([EMAIL PROTECTED]) wrote:

 

Hi people,.

I have to build several classes for a project i am doing, but i am quite
new to OOP programming. I need to make a database abstraction layer
class and a user login class.. Does anyone know some good tutorials
about these things and OOP in general. Thanks in advance..

Best regards,

Davy Obdam
mailto:[EMAIL PROTECTED]


   



 





--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP] Tutorials on OOP

2002-12-22 Thread Stephen
I found thise one to be rather useful:

http://www.liquidpulse.net/articles/125


- Original Message -
From: Davy Obdam [EMAIL PROTECTED]
To: Justin French [EMAIL PROTECTED]
Cc: PHP [EMAIL PROTECTED]; PHP-WIN [EMAIL PROTECTED]
Sent: Sunday, December 22, 2002 8:30 PM
Subject: Re: [PHP] Tutorials on OOP


: Hi Justin,
:
: Thanks for your quick reply.. Well in this case i needs to build em
: myself, because i am doing a course called Masterclass PHP and i have to
: learn OOP.. So i am looking for some good OOP tutorials/examples on the
: web I am very interested in creating a user login class using
: sessionsDo u know any good sites where i can find tutorials/examples
: about this.?
:
: Best regards,
:
: Davy Obdam
: mailto:[EMAIL PROTECTED]
:
: Justin French wrote:
:
: Both of those classes would already exist on a site like
phpclasses.org...
: do you have to BUILD them, or do you NEED them?
: 
: Justin
: 
: 
: on 23/12/02 11:43 AM, Davy Obdam ([EMAIL PROTECTED]) wrote:
: 
: 
: 
: Hi people,.
: 
: I have to build several classes for a project i am doing, but i am quite
: new to OOP programming. I need to make a database abstraction layer
: class and a user login class.. Does anyone know some good tutorials
: about these things and OOP in general. Thanks in advance..
: 
: Best regards,
: 
: Davy Obdam
: mailto:[EMAIL PROTECTED]
: 
: 
: 
: 
: 
: 
: 
: 
:
:
:
:
: --
: PHP General Mailing List (http://www.php.net/)
: To unsubscribe, visit: http://www.php.net/unsub.php
:
:
:



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP] Tutorials on OOP

2002-12-22 Thread Wee Keat

 Hi Justin,

 Thanks for your quick reply.. Well in this case i needs to build em
 myself, because i am doing a course called Masterclass PHP and i have to
 learn OOP.. So i am looking for some good OOP tutorials/examples on the
 web I am very interested in creating a user login class using
 sessionsDo u know any good sites where i can find tutorials/examples
 about this.?


If that's the case... u can try looking at these tutorials on Zend.com...

http://www.zend.com/zend/tut/tutorial-johnson.php
http://www.zend.com/zend/tut/tutorial-johnson2.php

As well as these ones on DevArticles.com

http://www.devarticles.com/art/1/241
http://www.devarticles.com/art/1/245
http://www.devarticles.com/art/1/262
http://www.devarticles.com/art/1/285

HTH!

Yours,
Wee Keat


Good timber does not grow with ease; the stronger the wind, the stronger
the trees.



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP] Tutorials on OOP

2002-12-22 Thread Philip Olson

This tutorial lists many oop tutorials:

  Know of any basic tutorials on PHP Classes and OOP?
  ---
  http://www.faqts.com/knowledge_base/view.phtml/aid/7569

Regards,
Philip Olson


On Mon, 23 Dec 2002, Wee Keat wrote:

 
  Hi Justin,
 
  Thanks for your quick reply.. Well in this case i needs to build em
  myself, because i am doing a course called Masterclass PHP and i have to
  learn OOP.. So i am looking for some good OOP tutorials/examples on the
  web I am very interested in creating a user login class using
  sessionsDo u know any good sites where i can find tutorials/examples
  about this.?
 
 
 If that's the case... u can try looking at these tutorials on Zend.com...
 
 http://www.zend.com/zend/tut/tutorial-johnson.php
 http://www.zend.com/zend/tut/tutorial-johnson2.php
 
 As well as these ones on DevArticles.com
 
 http://www.devarticles.com/art/1/241
 http://www.devarticles.com/art/1/245
 http://www.devarticles.com/art/1/262
 http://www.devarticles.com/art/1/285
 
 HTH!
 
 Yours,
 Wee Keat
 
 
 Good timber does not grow with ease; the stronger the wind, the stronger
 the trees.
 
 
 
 -- 
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP] tutorials

2002-06-12 Thread Niklas Lampén

Well, it depends on how well you know the basics of programming. If
you're a total newbie, first of all learn how you use variables,
conditional statements and loops. Without these you're powerless! :)

One way is to just create a simple form on one page and then try
thingies you can do with the values sent from that form.

If you need a tutorial, try searching google with php tutorial.. :)


Niklas


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: 12. kesäkuuta 2002 10:17
To: [EMAIL PROTECTED]
Subject: [PHP] tutorials


hi 

i want to start learning this PHP, i've got the manual
but i need a kind of a starting point? any suggestions


Adriaan Putter

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

###
This message has been scanned by F-Secure Anti-Virus for Internet Mail.
For more information, connect to http://www.F-Secure.com/

###
This message has been scanned by F-Secure Anti-Virus for Internet Mail.
For more information, connect to http://www.F-Secure.com/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP] tutorials

2002-06-12 Thread Adriaan . Putter

im not a newbie programmer, not all the stuff

just want something on standards on PHP and how
to start a script, or something to start with in
the end i will use the manual on all the functions
just need some basics on PHP...





-Original Message-
From: Niklas Lampén [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 12, 2002 10:01 AM
To: Php-General
Subject: RE: [PHP] tutorials


Well, it depends on how well you know the basics of programming. If
you're a total newbie, first of all learn how you use variables,
conditional statements and loops. Without these you're powerless! :)

One way is to just create a simple form on one page and then try
thingies you can do with the values sent from that form.

If you need a tutorial, try searching google with php tutorial.. :)


Niklas


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: 12. kesäkuuta 2002 10:17
To: [EMAIL PROTECTED]
Subject: [PHP] tutorials


hi 

i want to start learning this PHP, i've got the manual
but i need a kind of a starting point? any suggestions


Adriaan Putter

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

###
This message has been scanned by F-Secure Anti-Virus for Internet Mail.
For more information, connect to http://www.F-Secure.com/

###
This message has been scanned by F-Secure Anti-Virus for Internet Mail.
For more information, connect to http://www.F-Secure.com/

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP] tutorials

2002-06-12 Thread SP

Here are some tutorials:
http://www.devshed.com/Server_Side/PHP/
http://www.phpbuilder.com/
http://www.phpdeveloper.org/tutorial.php

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: June 12, 2002 4:06 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP] tutorials


im not a newbie programmer, not all the stuff

just want something on standards on PHP and how
to start a script, or something to start with in
the end i will use the manual on all the functions
just need some basics on PHP...





-Original Message-
From: Niklas Lampén [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 12, 2002 10:01 AM
To: Php-General
Subject: RE: [PHP] tutorials


Well, it depends on how well you know the basics of programming. If
you're a total newbie, first of all learn how you use variables,
conditional statements and loops. Without these you're powerless! :)

One way is to just create a simple form on one page and then try
thingies you can do with the values sent from that form.

If you need a tutorial, try searching google with php tutorial.. :)


Niklas


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 12. kesäkuuta 2002 10:17
To: [EMAIL PROTECTED]
Subject: [PHP] tutorials


hi

i want to start learning this PHP, i've got the manual
but i need a kind of a starting point? any suggestions


Adriaan Putter

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

###
This message has been scanned by F-Secure Anti-Virus for Internet Mail.
For more information, connect to http://www.F-Secure.com/

###
This message has been scanned by F-Secure Anti-Virus for Internet Mail.
For more information, connect to http://www.F-Secure.com/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP] tutorials on good database design

2001-03-14 Thread Nold, Mark


- 
Disclaimer: The information contained in this email is intended only for the
use of the person(s) to whom it is addressed and may be confidential or
contain legally privileged information. If you are not the intended
recipient you are hereby notified that any perusal, use, distribution,
copying or disclosure is strictly prohibited. If you have received this
email in error please immediately advise us by return email at
[EMAIL PROTECTED] and delete the email document without making a
copy. 

-


Have a look at http://www.phpbuilder.com/columns/barry2731.php3 for an
overview of db design and http://www.phpbuilder.com/columns/joe20010104.php3

I havent read either in depth but they seem OK.

As a nice litle SQL overview i often recommended
http://w3.one.net/~jhoffman/sqltut.htm which is a nice handy overview of all
the various SQL commands.

Have fun.

(Funnily enough out of all my textbooks on DB design my favourite refresher
on Normalisation theory is a photocopy of a chapter from a "Visual Basic 3
and Databases" pretty embarrassing but i've helped several people with it ;)

mn


Mark Nold
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 
Senior Consultant

Change is inevitable, except from vending machines. 



-Original Message-
From: Justin French [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 14, 2001 10:45 AM
Cc: php
Subject: Re: [PHP] tutorials on good database design


Jason Murray wrote:

 True - I find the best way to explain database design to someone is by
 having them design a database (as with someone here last week whom I
 helped out with an office sports tipping database as a little how-to-SQL
 project) and help them out as they go.

First up, thanks to everyone for the quick replies!! Went out to lunch,
came back, lot's of replies -- thanks :)

I'll have to dig through the hard drive, and find the data stuff that i
was working on a while back, so that we can discuss a real world example.

I'll probably post it late today or tomorrow.


Justin

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP] tutorials on good database design

2001-03-13 Thread Michael Kimsal

H... while there are abstract ideas which are generally useful
and prudent to adhere to, I don't think most people understand them
too well as abstracts and need concrete examples to map them to.

Hence the employee contact database examples.  And simple shopping cart
examples.  :)

Do you have some real-life examples that you'd care to discuss in the open?
Using real-life examples (with the added realism of budgets, legacy code,
deadlines, etc.) may help everyone here.



Justin French wrote:

 hi,

 i'm looking for some good tutorials / articles / books on database
 design, no, i'm not talking about the classic employee contact database
 that nearly every site has lingering somewhere... i'm after the good stuff:

 smart data design
 smart data planning
 unique keys
 taking advantage of relational databases
 etc etc

 Justin French

 --
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]
 To contact the list administrators, e-mail: [EMAIL PROTECTED]


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP] tutorials on good database design

2001-03-13 Thread Jack Dempsey

As usual, O'Reilly did a great job with MySQL/mSQL by Randy Jay Yarger,
George Reese and Tim King

jack
Justin French wrote:
 
 hi,
 
 i'm looking for some good tutorials / articles / books on database
 design, no, i'm not talking about the classic employee contact database
 that nearly every site has lingering somewhere... i'm after the good stuff:
 
 smart data design
 smart data planning
 unique keys
 taking advantage of relational databases
 etc etc
 
 Justin French
 
 --
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]
 To contact the list administrators, e-mail: [EMAIL PROTECTED]

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP] tutorials on good database design

2001-03-13 Thread Philip Hallstrom

You could try the book SQL for Smarties by Joe Celko... I'm not through
it yet, but it's got some theory (but not enough to make your head hurt)
and goes over all the various SQL commands... in the TOC there's stuff
on how to implement directed graphs (such as the organizational path
from you to the CEO, etc..) and other crazy stuff...

-philip

In article [EMAIL PROTECTED] you write:
hi,

i'm looking for some good tutorials / articles / books on database
design, no, i'm not talking about the classic employee contact database
that nearly every site has lingering somewhere... i'm after the good stuff:

smart data design
smart data planning
unique keys
taking advantage of relational databases
etc etc

Justin French

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




RE: [PHP] tutorials on good database design

2001-03-13 Thread Jason Murray

 H... while there are abstract ideas which are generally useful
 and prudent to adhere to, I don't think most people understand them
 too well as abstracts and need concrete examples to map them to.
 
 Hence the employee contact database examples.  And simple 
 shopping cart examples.  :)

True - I find the best way to explain database design to someone is by
having them design a database (as with someone here last week whom I
helped out with an office sports tipping database as a little how-to-SQL
project) and help them out as they go.

 Do you have some real-life examples that you'd care to discuss in the 
 open? Using real-life examples (with the added realism of budgets, 
 legacy code, deadlines, etc.) may help everyone here.

I agree - throw us some examples of what you're thinking about, Justin.

Jason

-- 
Jason Murray
[EMAIL PROTECTED]
Web Design Team, Melbourne IT
Fetch the comfy chair!

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP] tutorials on good database design

2001-03-13 Thread Rick St Jean

One of my co-worker has a phenominal book on sql.  You will want something 
that covers the different
type of joins... when to use them, as well as database normalization, 
reinforcing data integrity with
foreign and primary keys.  You will also want some transact sql in there 
and some indexing.  There
are many tutorials in stuff like phpbuilder.com.  It is a good starting place.

Rick

At 12:37 PM 3/14/01 +1100, Justin French wrote:
hi,

i'm looking for some good tutorials / articles / books on database
design, no, i'm not talking about the classic employee contact database
that nearly every site has lingering somewhere... i'm after the good stuff:

smart data design
smart data planning
unique keys
taking advantage of relational databases
etc etc

Justin French

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

##
#  Rick St Jean,
#  [EMAIL PROTECTED]
#  President of Design Shark,
#  http://www.designshark.com/
#  Quick Contact:  http://www.designshark.com/messaging.ihtml
#  Tel: 905-684-2952
##


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




RE: [PHP] tutorials on good database design

2001-03-13 Thread Jeff Oien

 I agree - throw us some examples of what you're thinking about, Justin.
 
 Jason

I'm not Justin but I have a question. I would like to write a billing 
database to keep track of my hours for clients. I would like to 
keep track of what date I've been paid through and then create
a report for the hours that I haven't been paid for yet. How do I 
-best tell the database when I've been paid
  -there may be more than one entry for each day
-create a report for the dates since I was last paid

Jeff Oien

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP] tutorials on good database design

2001-03-13 Thread Andrew Halliday

It should be just as simple as understanding the following terms and when
they should be used:
- entity
- attribute
- relationship
- cardinality
- first normal form
- second normal form
- third normal form
- fourth normal form
- boyce-codd normal form (BCNF)
- fifth normal form (could ignore this one if not going hard-core :)

The normal forms are the most important - if you know and understand them,
they will basically build a wholesome relational database for you (up to
fourth normal form) ... the only decisions to be made beyond what fourth
normal form will 'make for you' is how far you want to go in splitting up
entities...

AndrewH

- Original Message -
From: "Jason Murray" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: "php" [EMAIL PROTECTED]
Sent: Wednesday, March 14, 2001 12:19 PM
Subject: RE: [PHP] tutorials on good database design


  H... while there are abstract ideas which are generally useful
  and prudent to adhere to, I don't think most people understand them
  too well as abstracts and need concrete examples to map them to.
 
  Hence the employee contact database examples.  And simple
  shopping cart examples.  :)

 True - I find the best way to explain database design to someone is by
 having them design a database (as with someone here last week whom I
 helped out with an office sports tipping database as a little how-to-SQL
 project) and help them out as they go.

  Do you have some real-life examples that you'd care to discuss in the
  open? Using real-life examples (with the added realism of budgets,
  legacy code, deadlines, etc.) may help everyone here.

 I agree - throw us some examples of what you're thinking about, Justin.

 Jason

 --
 Jason Murray
 [EMAIL PROTECTED]
 Web Design Team, Melbourne IT
 Fetch the comfy chair!

 --
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]
 To contact the list administrators, e-mail: [EMAIL PROTECTED]



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP] tutorials on good database design

2001-03-13 Thread Justin French

Jason Murray wrote:

 True - I find the best way to explain database design to someone is by
 having them design a database (as with someone here last week whom I
 helped out with an office sports tipping database as a little how-to-SQL
 project) and help them out as they go.

First up, thanks to everyone for the quick replies!! Went out to lunch,
came back, lot's of replies -- thanks :)

I'll have to dig through the hard drive, and find the data stuff that i
was working on a while back, so that we can discuss a real world example.

I'll probably post it late today or tomorrow.


Justin

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]