Working with MySQL and PHP

[tissam]

I am making customer data entry GUI with PHP /HTML and transferring to MySQL table.
it is ok working fine. But this GUI is using deferent users login with their own user and password. Finally i don't know how to trace individuals user's logs what they transfered to the MySQL tables. pls help me with PHP coding.

[Crowly]

When a user logs in store the username in a session. Make sure all your database tables have a username field, so when you do an INSERT or UPDATE make sure that field is updated with the value from session.
Ex

// user logs in
$_SESSION['username']='Some username';

// ... more code

// insert ex
$insert=sprintf("INSERT INTO tabel (field1, field2, field3, username)
VALUES (value,value,value,'%s')",
$_SESSION['username']);

mysql_query($insert);

// update ex
$update=sprintf("UPDATE table
SET field1=value,
field2=value,
username='%s'",
$_SESSION['username']);

mysql_query($update);  

[bradgrafelman]

Crowly wrote:

Make sure all your database tables have a username field

Better yet would be to do some normalization and keep the user-specific data (e.g. username) in one single table and instead use a foreign key (e.g. an integer pointing to an AUTO_INCREMENT column) in other tables to reference that user's data.