help pls! - database/log system

[johnoc]

hi,

im doing a simple php/sql project that is a log system for students to be able to log certain data to a database

i have the login system done, and the database created and connecting to php ok..- but i need to be able to do the following-

create logs, view logs, edit logs, delete logs etc
(and to view the logs in a nice html table!)

i know this is pretty simple but im new to php so can anybody help me out or give me some scripts that can help me out..

thanks, John

[toddmarx]

John,

Being new to php also, not exactly sure how the pros would do it, but I would try using cookies or something like that. I am not sure how to make the cookies, but from what I understand DreamweaverMX has a pretty simple cookie wizard that can help walk you through all that.

As for the editing and other stuff, not too sure how to go about that. You can set up the cookies to write to a text file, then set up a page that will view the cookie's txt file.

As I said, not too sure, but that is what I would try to do.

~Todd

[daphreeek]

Well - heres what I do:

Make a new file called logstuff.php (or whatever you want) and include this as the very first line of all your pages.

Next decide what you want logged (I'll use IP, login_name, page, time for this example - but add anything you want) and create a table with all these fields.

Then in logstuff.php just have it do a mysql_query(INSERT INTO log VALUES ('$ip','$login_name','$page')

So each page will look like this:

<?php
include("logstuff.php");
.......

And logstuff will look like this:

<?php
$page = $_SERVER['REQUEST_URI'];
$ip = ; //forgot this one - will get back to you with it later
$login_name = ; //value from cookie for login system

if ($login_name == "")
   $login_name = "Visitor";

mysql_query(INSERT INTO log VALUES ('$ip','$login_name','$page');
?>

If you set the time field in the database to the correct format (TIMEDATE I think its called) then it sets a timestamp for you 🙂

For the summary page simple request the data from the DB and also use COUNT() to see the number of times a page has been visited......

Hope that helps
- Matt

[toddmarx]

...and you make it sound so easy! 😉