I tried this, and cannot seem to get it too work. In my players field, I have a column called, "lastlogin, VARCHAR(25)"jpoisson wrote:I am not sure if this will help you but I have been working on my own date time functions, no suprise there. I use varchar(25) for my coloum settings. Why would i do this well in your authentication page you can creat a variable
called $datetime and the row can be called what ever.Code: Select all
$datetime = date("d/m/y h:i:s"); //create date time the date() function will grab the latest time and I am formatting it in a way so it is readable instead of a bunch of random numbers. xx/xx/xx/ xx:xx:xx will be the out put for that variable. then you update the column where you are storing the time with this variable.
Code: Select all
$datetime=date("d/m/y h:i:s"); //create date time
$sql="INSERT INTO tablename (lastlogin)VALUES('$datetime')";
$result=mysql_query($sql);
Its not giving an error...its not displaying the date in the database under lastlogin.jpoisson wrote:what is your query statement saying?
the resulting code should work. as long as you place your tables name where it says tablenameCode: Select all
$datetime=date("d/m/y h:i:s"); //create date time $sql="INSERT INTO tablename (lastlogin)VALUES('$datetime')"; $result=mysql_query($sql);
Code: Select all
<link href="style.css" rel="stylesheet" type="text/css" />
<STYLE type="text/css">
<!--
BODY { background-image:url(logoutFinish.png);
background-repeat:no-repeat;
background-position:center;
background-attachment:fixed }
-->
</STYLE>
<body bgcolor="black">
<body text="white">
<div id="return">
<?php
session_start();
$datetime=date("d/m/y h:i:s"); //create date time
$SQL="INSERT INTO players (lastlogin) VALUES ('$datetime')";
$result=mysql_query($SQL);
session_destroy();
?>
</div>
I seen curdate, but its a function, and it dont change, unless you have to set it up the first time you set up the field, in which case, I don't know how to setup the date function.hallsofvallhalla wrote:what are you using varchar? There is a data field called date made specifically for this.
Where the session_start() is located, is placed in the spot that Halls tells us in the tut videos. (The top part is for the background, and I don't seem to be having any issues with it, until now.) And there isn't anything between session_start() or session_destroy() in his video. I wanted to add the date save function in between these fields, so the date will not update until next logout. I am NOT getting any errors, it goes through just fine, but just doesn't place the date into the lastlogin field.jpoisson wrote:Umm, firstly you start_session is suppose to be placed at the top of every document before any code is to be written.
@ halls I use var char because I have had some poor instances with the mysql date variables. so it is a personal choice.
no back to your code what errors are you getting? for any method you try please post you error messages because this will allow us to understand what is actually going wrong.
Code: Select all
$result=mysql_query($SQL)or die('_'.mysql_error());