[PHP]
session_start() ;
$connection = mysql_connect(" localhost", "xxxx", "xxxxxxx");
$select_db = mysql_select_db ("xxx", $connection);
$query = mysql_query ("SELECT username,passwo rd,id FROM members where id ='".$_SESSION["id"]."'", $connection);
$timestamp = time();
$activity = "Log in";
...
mankolele
Last Activity: Mar 10 '08, 02:28 PM
Joined: Sep 4 '06
Location:
-
What a relief all is well finally....Than k you with all your help. One more thing when capturing the LOG-IN data I see I get the previous entry not the present one I am at, what am I missing for me to get the last details not present username.Leave a comment:
-
Yeeee I finally managed to add all that up now one iusername has one access and every 15minutes are timed out from the table, which I am not sure if its good coz now the gap is opened I think.
Now my other concern is when they click on LOG-OUT , yes I need to DELETE from table WHERE user = "", yes this happens on the MySQL screen but I can not somehow pass that variable in PHP.Leave a comment:
-
Ooook I'm lost plain lost, I understand the theory myself but............ ............... ......... I don't know.Leave a comment:
-
I have a table where I am doing that but my block is that all user are taken as id 1 where I end up not being able to identify who is who.Leave a comment:
-
mankolele started a topic Preventing multiple Users from logging into the same account at the same timein PHPPreventing multiple Users from logging into the same account at the same time
Hi all,
users usually have usernames and passwords, and can log in to many maches at once withe same details. What I want to do is restrict them to only one machine if they have already LOGGED-ON on one machine, any attempt to LOG-IN again to another they get kicked out or have a Pop up telling them they already LOGGED-ON to another machine.
All help will be greatly appreciated.
Thanx -
Preventing the User from selecting an invalid date in a drop down menu
Hi all.
I am having a tough time trying to find a way I can use to make restrictions to drop dows for dates, like the following dates are invalid and cannot be allowed to select them, April 31,June 31, September 31, November 31 and february 29 if not leap year.
How can I put a script for the dates.
Thank you nin advance. -
Hi all
I changed my date to varchar in the database
[PHP]
$m1 = $_POST['m1'];
$d1 =$_POST['d1'];
$y1 = $_POST['y1'];
$date1 = $y1.$m1.$d1 ;
echo $date1."<br>";
$m2 = $_POST['m2'];
$d2 =$_POST['d2'];
$y2 = $_POST['y2'];
$date2 = $y2.$m2.$d2."<b r>";
echo $date2;
...Leave a comment:
-
Hi all
I do manage to get the sum of all the amounts and display it the amounts paid and out standing amount. Any bright idea I can use to only add amounts that are between two inputed dates. My date type in the database is DATE.
Thanks for any help offerdLeave a comment:
-
[PHP]
session_start() ;
$connection = mysql_connect(" localhost", "root", "issasql");
$select_db = mysql_select_db ("wca", $connection);
mysql_query("SE LECT dateinjury,amou nt FROM invoice WHERE persal = '".$_COOKIE["Persal"]."'")or die(mysql_error ());
//var = $total;
$dateinjury = strtotime ($_POST['date1']);...Leave a comment:
-
I have been trying to convert my date but I am comming up with more than what I have in my database now I am not sure what date is it returning and more.I dont clearly catch this strtotime can anyone pliz explian breifly how it works.I am trying to read about it also....Leave a comment:
-
Thanks
But I was just told that I can use a while loop to resolve this having if loops inside it to take what I need and skip those I do not need, I've never worked with a while loop I do not know where to start wi th that.Leave a comment:
-
Thanks for the reply but now I need to use PHP and mysql to get the sum of the amounts on a particular quater, using the loop.Leave a comment:
-
Calculating total amount per quater
Hi all
I need an idea on where to start when calculating a total amount betwee n two dates from a database like I want amount of money paid out from 30/03/2004 and 30/07/2004 ,but in the database these dates are not captured as they come they are mixed as some may come two years later to be captured. I have to go throught the database taking in those apropriate dates I need and add them up.
I belive I need to use a while loop... -
I see what you say I need to do, but that is where I get lost where , what , how do I put the script. Like when I go to the PC and switching it on saying I want to do the auto backuping of my database.
Thanks for the reply....Leave a comment:
-
automatically backup database
Hi all.
I am triying to figure out that when I have a server which has a mysql database, I want to auto update the database, iI understand there is a script I need to use but do not know where to start. Does anyone have a clear explanation for me on to where to start.
Thank you in advance for all the responces. -
track changes made to data
Hi all
Is there someway to track changes made to data in a mysql database?
Like someone changes a phone number in a record on a form -Is there a way to find out what changes were made to what fields for what records and when they were changed and what the record looked like before the change? And also record the logged in user that made the change? I know that there is supposed to be a seperate table for that.
... -
Thanks for the reply am still working on it will come back as soon as I get stuck somewhere.Leave a comment:
-
How do I make a table increase each time a new project is displayed on the interface like on the interface each time there is a project posted in by an administrator it appears in a small table the details so on a row I can fit four columns. when the first row is full continue to the next.
Where do I start the loop code for that kind of out put.
Thanks...Leave a comment:
-
Dynamic 2x2 growing table
Hi all I am working on a new project where it has to have a dynanically growing table I guess I am going to have to use loops or two array function . Every time a project is added it must appear in it table which must be growing horizontally. then jumping onto the next line when first line in full.
Thanks in advance for all replies.
No activity results to display
Leave a comment: