DaniWeb Forum Index > Web Development > PHP

need help in php

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Apr 2007

Posts: 3

Reputation: azharcs is an unknown quantity at this point

Solved Threads: 0

azharcs

Offline

Newbie Poster

need help in php

Apr 24th, 2007

<h3>In php how do you create accounts and let the user send messages to each other which cannot be viewed by other people .</code></h3>

<h2>The only thing i have come close to is by creating accounts by giving each one them an unique email id and let them send and recieve messages using smtp server.</h2>

Does php have anything better,or somebody can suggest something better.

•

Join Date: Mar 2004

Posts: 802

Reputation: Phaelax is on a distinguished road

Solved Threads: 40

Phaelax

Offline

Practically a Posting Shark

Re: need help in php

Apr 25th, 2007

Set up your database with a User table and a Mail table.

When a user logs in, have it query the Mail table for any entries assigned to them.

I'd set up my tables somewhat like this.

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
User
{
    id -> int
    name - varchar[128]
    email - varchar[256]
    md5(password)
}
 
Mail
{
    id -> int
    from -> int (references a User.id)
    to -> int (references a User.id)
    date -> datetime
    read -> boolean
    replied -> boolean
}
User
{
    id -> int
    name - varchar[128]
    email - varchar[256]
    md5(password)
}
 
Mail
{
    id -> int
    from -> int (references a User.id)
    to -> int (references a User.id)
    date -> datetime
    read -> boolean
    replied -> boolean
}