Thanks for your help,
How can I capture this information from a php form into a mysql table.
This is what I did:
1. I created the table and the user to access the database the table is in
create table staffs (
id int not null auto_increment primary key,
firstname varchar(20) not null,
lastname varchar(20) not null,
signin datetime not null
);
2. I created a php form to insert data into this table. The
form works but the datetime field isn't populated
<html>
<head>
<title>Staff Detail</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<?php
if(isset($_POST['add']))
{
include 'config.php';
include 'opendb.php';
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$signin = $_POST['signin'];
$query = "INSERT INTO staffs (firstname, lastname, signin) VALUES
('$firstname', '$lastname', '$signin')";
mysql_query($query) or die('Error, insert query failed');
include 'closedb.php';
echo "New staff detail added";
}
else
{
?>
<form method="post">
<table width="400" border="0" cellspacing="1" cellpadding="2">
<tr>
<td width="100">First Name</td>
<td><input name="firstname" type="text"></td>
</tr>
<tr>
<td width="100">Last Name</td>
<td><input name="lastname" type="text"></td>
</tr>
<tr>
<td width="100">Sign-In Time</td>
<td><input name="signin" type="text"></td>
</tr>
<tr>
<tr>
<td width="100"> </td>
<td> </td>
</tr>
<tr>
<td width="100"> </td>
<td><input name="add" type="submit" id="add" value="Submit"></td>
</tr>
</table>
</form>
<?php
}
?>
</body>
</html>
Am I doing something wrong?
You mentioned that I can insert the now() function into a regular datetime
field, how can I do that?
In the last episode (May 09), Alla-amin said:
> I am trying to capture my server time automatically using php and
> insert it in a mysql table.
>
> Can the timestamp or time data type capture this information
> automatically without having me code anything else?
You can use the 'timestamp' type to automatially insert the current
date/time when inserting or updating, or you can insert now() into a
regular 'datetime' field.
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-type-overview.html
http://dev.mysql.com/doc/refman/5.0/en/datetime.html
http://dev.mysql.com/doc/refman/5.0/en/timestamp-4-1.html
