keeping track of user login, con't.

I would like to keep track of who is logging in (cookie) and what pages they
go to, what files they download would be an added bonus. (php/MySQL)

I don't understand the code for how to insert the information into a
database table.

My tracking database table (userData) has the following fields: userID,
pageVisited, filesDownloaded

the pages these people will be using already has accessLevel code on each
page:

<?php
if(!isset($HTTP_COOKIE_VARS['levelCookie'])){
header("Location: secure.php");
} else {
if($HTTP_COOKIE_VARS['levelCookie'] < 2){
header("Location: secure.php");
}
}
?>

can someone help me with an example of how the code would work for inserting
this data into a table?

thanks!!

__________________________________________________ __
Specifically, what do want to track regarding user logins - last login
date/time? number of time user has logged in? something else?

To track who has downloaded what files, create a userDownloads table and
everytime some downloads a file write a record inserting the userID and
fileID.

"melissa" <melissa (AT) maddesignusa (DOT) com> wrote

yes, they are logged in that way, I am just not sure HOW to track them
with
that? how do i dump that info into a database? some sort of hidden input
record form?

change your tables:

userData:
UserID

visitData:
UserID
URL
DateTime

assuming that your login script stores the userid in a cookie or session
variable, change your php (pseudo-code):

<?php
if(!isset($HTTP_COOKIE_VARS['levelCookie'])){
header("Location: secure.php");
} else {
if($HTTP_COOKIE_VARS['levelCookie'] < 2){
header("Location: secure.php");
}
}
// connect to db;
// INSERT INTO visitData (UserID,URL,DateTime) VALUES
($userid,$_SERVER["PHP_SELF"],now());
// close db connection;
?>

more help:
http://dev.mysql.com/doc/mysql/en/INSERT.html
http://us2.php.net/manual/en/ref.mysql.php

joe







melissa wrote:

I would like to keep track of who is logging in (cookie) and what pages they
go to, what files they download would be an added bonus. (php/MySQL)

I don't understand the code for how to insert the information into a
database table.

My tracking database table (userData) has the following fields: userID,
pageVisited, filesDownloaded

the pages these people will be using already has accessLevel code on each
page:

?php
if(!isset($HTTP_COOKIE_VARS['levelCookie'])){
header("Location: secure.php");
} else {
if($HTTP_COOKIE_VARS['levelCookie'] < 2){
header("Location: secure.php");
}
}
?

can someone help me with an example of how the code would work for inserting
this data into a table?

thanks!!

__________________________________________________ __
Specifically, what do want to track regarding user logins - last login
date/time? number of time user has logged in? something else?

To track who has downloaded what files, create a userDownloads table and
everytime some downloads a file write a record inserting the userID and
fileID.

"melissa" <melissa (AT) maddesignusa (DOT) com> wrote in message
news:ce835b$j87$1 (AT) forums (DOT) macromedia.com...

yes, they are logged in that way, I am just not sure HOW to track them

with

that? how do i dump that info into a database? some sort of hidden input
record form?

ok.....here is what i have come up with.....if i echo the $user and the
$page, they show up, but nothing is being placed into the database..

i think that i need some kind of "execute this" statement, but haven't a
clue as to where it goes.

<?php require_once('../Connections/atricure.php'); ?>
<?php {
$user = $_COOKIE['acCookie']; //gets user name
$page = $_SERVER['SCRIPT_FILENAME']; // gets current url
$sql = "INSERT INTO visitData (userID, URL, DateTime) VALUES ($user, $page,
now())";
}
?>

"Joe {RoastHorse}" <joe (AT) roast-horse (DOT) commmmm> wrote

change your tables:

userData:
UserID

visitData:
UserID
URL
DateTime

// connect to db;
// INSERT INTO visitData (UserID,URL,DateTime) VALUES
($userid,$_SERVER["PHP_SELF"],now());
// close db connection;
?

more help:
http://dev.mysql.com/doc/mysql/en/INSERT.html
http://us2.php.net/manual/en/ref.mysql.php

joe







melissa wrote:

I would like to keep track of who is logging in (cookie) and what pages
they
go to, what files they download would be an added bonus. (php/MySQL)

I don't understand the code for how to insert the information into a
database table.

My tracking database table (userData) has the following fields: userID,
pageVisited, filesDownloaded

the pages these people will be using already has accessLevel code on
each
page:

?php
if(!isset($HTTP_COOKIE_VARS['levelCookie'])){
header("Location: secure.php");
} else {
if($HTTP_COOKIE_VARS['levelCookie'] < 2){
header("Location: secure.php");
}
}
?

can someone help me with an example of how the code would work for
inserting
this data into a table?

thanks!!

__________________________________________________ __
Specifically, what do want to track regarding user logins - last login
date/time? number of time user has logged in? something else?

To track who has downloaded what files, create a userDownloads table and
everytime some downloads a file write a record inserting the userID and
fileID.

"melissa" <melissa (AT) maddesignusa (DOT) com> wrote in message
news:ce835b$j87$1 (AT) forums (DOT) macromedia.com...

yes, they are logged in that way, I am just not sure HOW to track them

with

that? how do i dump that info into a database? some sort of hidden
input
record form?

ok, now i have the code working to put the information into the database,
but can't get the date/time to work

<?
$user = $_COOKIE['acCookie'];
$page = $_SERVER['SCRIPT_FILENAME']; // gets current url

mysql_query ("INSERT INTO visitData (userID, URL, DateTime) VALUES
('$user','$page','now()')");

?>

any ideas?

Nevermind...got it.

my final code is:

<?
$user = $_COOKIE['acCookie'];
$page = $_SERVER['SCRIPT_FILENAME']; // gets current url
$dateNow = date('Y-m-d H:i:s');
mysql_query ("INSERT INTO visitData (userID, URL, DateTime) VALUES
('$user','$page','$dateNow')");
?>

"melissa" <melissa (AT) maddesignusa (DOT) com> wrote

ok, now i have the code working to put the information into the database,
but can't get the date/time to work

?
$user = $_COOKIE['acCookie'];
$page = $_SERVER['SCRIPT_FILENAME']; // gets current url

mysql_query ("INSERT INTO visitData (userID, URL, DateTime) VALUES
('$user','$page','now()')");

?

any ideas?

now() is not a string (it's a mysql function). your query should be:

mysql_query ("INSERT INTO visitData (userID, URL, DateTime) VALUES
('$user','$page',now())");

but your solution (php date) works just as well.

joe




melissa wrote:

ok, now i have the code working to put the information into the database,
but can't get the date/time to work

?
$user = $_COOKIE['acCookie'];
$page = $_SERVER['SCRIPT_FILENAME']; // gets current url

mysql_query ("INSERT INTO visitData (userID, URL, DateTime) VALUES
('$user','$page','now()')");

?

any ideas?