New Script.

fluppet

Hi, i've used php before, ive used B2, setup and edited my own forum, but i've never written from scratch.

I'd like to start - and for a first project i want to make an SQL driven Private Messenger.

The idea is you register, then you can log in, and it displays your messages, which you can then reply to or delete etc. I'm not bothered about adding anything fancy to it straight away.

Ive started development here. So far, ive created an install.php file, which connects to the database (fluppet123) and creates the tables Data and Users. I've also created a register(.php) file, which adds you to the database with a username and password (not encrypted.) I just can't figure out how to get it to log users in, or how to display the posts that have been send to them. Or for that matter how to send a message. Thanks.

Flp! 😃 😃

lobo235

You may want to log the users in by setting a cookie and then checking for it on each page or even using the built-in session functions of PHP.

As for the rest, if you have the right columns set up in your tables you should be able to do SELECT statements to get all the messages posted to a specific user ex:

SELECT * FROM Data WHERE to_user = 'username';

To send a message you would just get the input from a form and using an SQL statement you would INSERT it into your table.

fluppet

Thanks. Can you give me a brief idea of how to use either (or both) sessions and cookies. I'm completely new to all this and i need to start somewhere...

But thanks so far 😉

lobo235

These are some links to articles on the www.phpbuilder.com website that will help you on your quest:

http://www.phpbuilder.com/columns/tim20000505.php3

http://www.phpbuilder.com/columns/mattias20000312.php3

Hope this helps...